[opencms-dev] OAMP Webform Module: DB2 database?

[martin.rosenthal]

Hello,

we are using OpenCms 9.0.1 in Weblogic 12 with a DB2 database. Now im
trying to install the OAMP Webform Module but on startup i get the error


08:15:39,156 ERROR [CmsFormDataAccess]
java.lang.NullPointerException
at java.util.Properties.load(Unknown Source)
at
com.alkacon.opencms.v8.formgenerator.database.CmsFormDataAccess.loadQueryProperties
(CmsFormDataAccess.java:1049)
at
com.alkacon.opencms.v8.formgenerator.database.CmsFormDataAccess.<init>
(CmsFormDataAccess.java:175)
at
com.alkacon.opencms.v8.formgenerator.database.CmsFormDataAccess.getInstance
(CmsFormDataAccess.java:188)
at
com.alkacon.opencms.v8.formgenerator.database.CmsFormDatabaseModuleAction.initialize
(CmsFormDatabaseModuleAction.java:76)
......

In the module configuration i've got the follwing entries:

db-pool=default
db-provider=db2

Must there be added other entries or isn't be possible to get running the
OAMP Webform Module with DB2?

In documentation there are only examples with mySQL, mssql oralce an
postgres.

Thanks and regards,
Martin Rosenthal
_______________________________
IT-Anwendungen

Tel.: [phone]
Fax: [phone]
Email: Martin.Rosenthal at oerag.de
Internet: www.oerag.de

?RAG Rechtsschutzversicherungs-AG
Hansaallee 199, 40549 D?sseldorf
Vorstand: Klaus R. Hartung, Andreas Heinsen
Aufsichtsratsvorsitzender: Ulrich R?ther
Sitz der Gesellschaft: D?sseldorf, Registergericht D?sseldorf HRB 12073

Diese E-Mail enth?lt vertrauliche und/oder rechtlich gesch?tzte
Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail
irrt?mlich erhalten haben, informieren Sie bitte den Absender und
vernichten diese

[Schliemann, Kai]

Hi Martin,
It seems that there is no support for db2 by default.
I looked up https://github.com/alkacon/alkacon-oamp/tree/branch_9_0_x/com.alkacon.opencms.formgenerator/src/com/alkacon/opencms/formgenerator/database and could not find a DB2 properties file.

I hope this is leading you in the right direction.
Best regards
Kai

-----Urspr?ngliche Nachricht-----
Von: opencms-dev-bounces at opencms.org [mailto:opencms-dev-bounces at opencms.org] Im Auftrag von martin.rosenthal at oerag.de
Gesendet: Dienstag, 12. August 2014 08:38
An: opencms-dev at opencms.org
Betreff: [opencms-dev] OAMP Webform Module: DB2 database?


Hello,

we are using OpenCms 9.0.1 in Weblogic 12 with a DB2 database. Now im trying to install the OAMP Webform Module but on startup i get the error


08:15:39,156 ERROR [CmsFormDataAccess]
java.lang.NullPointerException
at java.util.Properties.load(Unknown Source)
at
com.alkacon.opencms.v8.formgenerator.database.CmsFormDataAccess.loadQueryProperties
(CmsFormDataAccess.java:1049)
at
com.alkacon.opencms.v8.formgenerator.database.CmsFormDataAccess.<init>
(CmsFormDataAccess.java:175)
at
com.alkacon.opencms.v8.formgenerator.database.CmsFormDataAccess.getInstance
(CmsFormDataAccess.java:188)
at
com.alkacon.opencms.v8.formgenerator.database.CmsFormDatabaseModuleAction.initialize
(CmsFormDatabaseModuleAction.java:76)
......

In the module configuration i've got the follwing entries:

db-pool=default
db-provider=db2

Must there be added other entries or isn't be possible to get running the OAMP Webform Module with DB2?

In documentation there are only examples with mySQL, mssql oralce an postgres.

Thanks and regards,
Martin Rosenthal
_______________________________
IT-Anwendungen

Tel.: [phone]
Fax: [phone]
Email: Martin.Rosenthal at oerag.de
Internet: www.oerag.de

?RAG Rechtsschutzversicherungs-AG
Hansaallee 199, 40549 D?sseldorf
Vorstand: Klaus R. Hartung, Andreas Heinsen
Aufsichtsratsvorsitzender: Ulrich R?ther Sitz der Gesellschaft: D?sseldorf, Registergericht D?sseldorf HRB 12073

Diese E-Mail enth?lt vertrauliche und/oder rechtlich gesch?tzte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrt?mlich erhalten haben, informieren Sie bitte den Absender und vernichten diese

_______________________________________________
This mail is sent to you from the opencms-dev mailing list To change your list options, or to unsubscribe from the list, please visit http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev

[martin.rosenthal]

Hello Kai,

thanks for your quick reply.
Do you, if it is possible to define a diffirent database for the webform
module or must it write his data in same database in which the OpenCMS
system is running?

Regards,
Martin
_______________________________
IT-Anwendungen

Tel.: [phone]
Fax: [phone]
Email: Martin.Rosenthal at oerag.de
Internet: www.oerag.de

?RAG Rechtsschutzversicherungs-AG
Hansaallee 199, 40549 D?sseldorf
Vorstand: Klaus R. Hartung, Andreas Heinsen
Aufsichtsratsvorsitzender: Ulrich R?ther
Sitz der Gesellschaft: D?sseldorf, Registergericht D?sseldorf HRB 12073

Diese E-Mail enth?lt vertrauliche und/oder rechtlich gesch?tzte
Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail
irrt?mlich erhalten haben, informieren Sie bitte den Absender und
vernichten diese



"Schliemann, Kai"
<K.Schliemann at com
undus.com> An
Gesendet von: The OpenCms mailing list
opencms-dev-bounc <opencms-dev at opencms.org>,
es at opencms.org Kopie

Thema
12.08.2014 09:06 Re: [opencms-dev] OAMP Webform
Module: DB2 database?

Bitte antworten
an
The OpenCms
mailing list
<opencms-dev at open
cms.org>






Hi Martin,
It seems that there is no support for db2 by default.
I looked up
https://github.com/alkacon/alkacon-oamp/tree/branch_9_0_x/com.alkacon.opencms.formgenerator/src/com/alkacon/opencms/formgenerator/database
and could not find a DB2 properties file.

I hope this is leading you in the right direction.
Best regards
Kai

-----Urspr?ngliche Nachricht-----
Von: opencms-dev-bounces at opencms.org [
mailto:opencms-dev-bounces at opencms.org] Im Auftrag von
martin.rosenthal at oerag.de
Gesendet: Dienstag, 12. August 2014 08:38
An: opencms-dev at opencms.org
Betreff: [opencms-dev] OAMP Webform Module: DB2 database?


Hello,

we are using OpenCms 9.0.1 in Weblogic 12 with a DB2 database. Now im
trying to install the OAMP Webform Module but on startup i get the error


08:15:39,156 ERROR [CmsFormDataAccess]
java.lang.NullPointerException
at java.util.Properties.load(Unknown Source)
at
com.alkacon.opencms.v8.formgenerator.database.CmsFormDataAccess.loadQueryProperties

(CmsFormDataAccess.java:1049)
at
com.alkacon.opencms.v8.formgenerator.database.CmsFormDataAccess.<init>
(CmsFormDataAccess.java:175)
at
com.alkacon.opencms.v8.formgenerator.database.CmsFormDataAccess.getInstance
(CmsFormDataAccess.java:188)
at
com.alkacon.opencms.v8.formgenerator.database.CmsFormDatabaseModuleAction.initialize

(CmsFormDatabaseModuleAction.java:76)
......

In the module configuration i've got the follwing entries:

db-pool=default
db-provider=db2

Must there be added other entries or isn't be possible to get running the
OAMP Webform Module with DB2?

In documentation there are only examples with mySQL, mssql oralce an
postgres.

Thanks and regards,
Martin Rosenthal
_______________________________
IT-Anwendungen

Tel.: [phone]
Fax: [phone]
Email: Martin.Rosenthal at oerag.de
Internet: www.oerag.de

?RAG Rechtsschutzversicherungs-AG
Hansaallee 199, 40549 D?sseldorf
Vorstand: Klaus R. Hartung, Andreas Heinsen
Aufsichtsratsvorsitzender: Ulrich R?ther Sitz der Gesellschaft: D?sseldorf,
Registergericht D?sseldorf HRB 12073

Diese E-Mail enth?lt vertrauliche und/oder rechtlich gesch?tzte
Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail
irrt?mlich erhalten haben, informieren Sie bitte den Absender und
vernichten diese

_______________________________________________
This mail is sent to you from the opencms-dev mailing list To change your
list options, or to unsubscribe from the list, please visit
http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev

[Schliemann, Kai]

Hi Martin,
yes, it is possible. At least according to chapter 4.1.1.2 of the webform pdf documentation: https://github.com/alkacon/alkacon-oamp/blob/branch_9_0_x/com.alkacon.opencms.formgenerator/Alkacon_OAMP_Webform.pdf
...
The db-pool parameter value references a database pool configured in <tomcathome>/
webapps/<webappname>/WEB-INF/config/opencms.properties. The value
"default" should be OK for most applications. If you need to collect your Webform data in a dedicated database you may configure another pool in the opencms.properties and refer to
it in this module parameter.
...
HTH
Best regards
Kai

-----Urspr?ngliche Nachricht-----
Von: opencms-dev-bounces at opencms.org [mailto:opencms-dev-bounces at opencms.org] Im Auftrag von martin.rosenthal at oerag.de
Gesendet: Dienstag, 12. August 2014 09:18
An: The OpenCms mailing list
Betreff: [opencms-dev] Antwort: Re: OAMP Webform Module: DB2 database?

Hello Kai,

thanks for your quick reply.
Do you, if it is possible to define a diffirent database for the webform module or must it write his data in same database in which the OpenCMS system is running?

Regards,
Martin
_______________________________
IT-Anwendungen

Tel.: [phone]
Fax: [phone]
Email: Martin.Rosenthal at oerag.de
Internet: www.oerag.de

?RAG Rechtsschutzversicherungs-AG
Hansaallee 199, 40549 D?sseldorf
Vorstand: Klaus R. Hartung, Andreas Heinsen
Aufsichtsratsvorsitzender: Ulrich R?ther Sitz der Gesellschaft: D?sseldorf, Registergericht D?sseldorf HRB 12073

Diese E-Mail enth?lt vertrauliche und/oder rechtlich gesch?tzte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrt?mlich erhalten haben, informieren Sie bitte den Absender und vernichten diese



"Schliemann, Kai"
<K.Schliemann at com
undus.com> An
Gesendet von: The OpenCms mailing list
opencms-dev-bounc <opencms-dev at opencms.org>,
es at opencms.org Kopie

Thema
12.08.2014 09:06 Re: [opencms-dev] OAMP Webform
Module: DB2 database?

Bitte antworten
an
The OpenCms
mailing list
<opencms-dev at open
cms.org>






Hi Martin,
It seems that there is no support for db2 by default.
I looked up
https://github.com/alkacon/alkacon-oamp/tree/branch_9_0_x/com.alkacon.opencms.formgenerator/src/com/alkacon/opencms/formgenerator/database
and could not find a DB2 properties file.

I hope this is leading you in the right direction.
Best regards
Kai

-----Urspr?ngliche Nachricht-----
Von: opencms-dev-bounces at opencms.org [
mailto:opencms-dev-bounces at opencms.org] Im Auftrag von martin.rosenthal at oerag.de
Gesendet: Dienstag, 12. August 2014 08:38
An: opencms-dev at opencms.org
Betreff: [opencms-dev] OAMP Webform Module: DB2 database?


Hello,

we are using OpenCms 9.0.1 in Weblogic 12 with a DB2 database. Now im trying to install the OAMP Webform Module but on startup i get the error


08:15:39,156 ERROR [CmsFormDataAccess]
java.lang.NullPointerException
at java.util.Properties.load(Unknown Source)
at
com.alkacon.opencms.v8.formgenerator.database.CmsFormDataAccess.loadQueryProperties

(CmsFormDataAccess.java:1049)
at
com.alkacon.opencms.v8.formgenerator.database.CmsFormDataAccess.<init>
(CmsFormDataAccess.java:175)
at
com.alkacon.opencms.v8.formgenerator.database.CmsFormDataAccess.getInstance
(CmsFormDataAccess.java:188)
at
com.alkacon.opencms.v8.formgenerator.database.CmsFormDatabaseModuleAction.initialize

(CmsFormDatabaseModuleAction.java:76)
......

In the module configuration i've got the follwing entries:

db-pool=default
db-provider=db2

Must there be added other entries or isn't be possible to get running the OAMP Webform Module with DB2?

In documentation there are only examples with mySQL, mssql oralce an postgres.

Thanks and regards,
Martin Rosenthal
_______________________________
IT-Anwendungen

Tel.: [phone]
Fax: [phone]
Email: Martin.Rosenthal at oerag.de
Internet: www.oerag.de

?RAG Rechtsschutzversicherungs-AG
Hansaallee 199, 40549 D?sseldorf
Vorstand: Klaus R. Hartung, Andreas Heinsen
Aufsichtsratsvorsitzender: Ulrich R?ther Sitz der Gesellschaft: D?sseldorf, Registergericht D?sseldorf HRB 12073

Diese E-Mail enth?lt vertrauliche und/oder rechtlich gesch?tzte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrt?mlich erhalten haben, informieren Sie bitte den Absender und vernichten diese

_______________________________________________
This mail is sent to you from the opencms-dev mailing list To change your list options, or to unsubscribe from the list, please visit http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev



_______________________________________________
This mail is sent to you from the opencms-dev mailing list To change your list options, or to unsubscribe from the list, please visit http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev





_______________________________________________
This mail is sent to you from the opencms-dev mailing list To change your list options, or to unsubscribe from the list, please visit http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev

[martin.rosenthal]

Hello Kai,

thanks for your help.

Best regards,
Martin
_______________________________
IT-Anwendungen

Tel.: [phone]
Fax: [phone]
Email: Martin.Rosenthal at oerag.de
Internet: www.oerag.de

?RAG Rechtsschutzversicherungs-AG
Hansaallee 199, 40549 D?sseldorf
Vorstand: Klaus R. Hartung, Andreas Heinsen
Aufsichtsratsvorsitzender: Ulrich R?ther
Sitz der Gesellschaft: D?sseldorf, Registergericht D?sseldorf HRB 12073

Diese E-Mail enth?lt vertrauliche und/oder rechtlich gesch?tzte
Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail
irrt?mlich erhalten haben, informieren Sie bitte den Absender und
vernichten diese



"Schliemann, Kai"
<K.Schliemann at com
undus.com> An
Gesendet von: The OpenCms mailing list
opencms-dev-bounc <opencms-dev at opencms.org>,
es at opencms.org Kopie

Thema
12.08.2014 09:38 Re: [opencms-dev] Antwort: Re:
OAMP Webform Module: DB2 database?

Bitte antworten
an
The OpenCms
mailing list
<opencms-dev at open
cms.org>






Hi Martin,
yes, it is possible. At least according to chapter 4.1.1.2 of the webform
pdf documentation:
https://github.com/alkacon/alkacon-oamp/blob/branch_9_0_x/com.alkacon.opencms.formgenerator/Alkacon_OAMP_Webform.pdf

...
The db-pool parameter value references a database pool configured in
<tomcathome>/
webapps/<webappname>/WEB-INF/config/opencms.properties. The value
"default" should be OK for most applications. If you need to collect your
Webform data in a dedicated database you may configure another pool in the
opencms.properties and refer to
it in this module parameter.
...
HTH
Best regards
Kai

-----Urspr?ngliche Nachricht-----
Von: opencms-dev-bounces at opencms.org [
mailto:opencms-dev-bounces at opencms.org] Im Auftrag von
martin.rosenthal at oerag.de
Gesendet: Dienstag, 12. August 2014 09:18
An: The OpenCms mailing list
Betreff: [opencms-dev] Antwort: Re: OAMP Webform Module: DB2 database?

Hello Kai,

thanks for your quick reply.
Do you, if it is possible to define a diffirent database for the webform
module or must it write his data in same database in which the OpenCMS
system is running?

Regards,
Martin
_______________________________
IT-Anwendungen

Tel.: [phone]
Fax: [phone]
Email: Martin.Rosenthal at oerag.de
Internet: www.oerag.de

?RAG Rechtsschutzversicherungs-AG
Hansaallee 199, 40549 D?sseldorf
Vorstand: Klaus R. Hartung, Andreas Heinsen
Aufsichtsratsvorsitzender: Ulrich R?ther Sitz der Gesellschaft: D?sseldorf,
Registergericht D?sseldorf HRB 12073

Diese E-Mail enth?lt vertrauliche und/oder rechtlich gesch?tzte
Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail
irrt?mlich erhalten haben, informieren Sie bitte den Absender und
vernichten diese



"Schliemann, Kai"
<K.Schliemann at com
undus.com> An
Gesendet von: The OpenCms mailing list
opencms-dev-bounc <opencms-dev at opencms.org>,
es at opencms.org Kopie

Thema
12.08.2014 09:06 Re: [opencms-dev] OAMP Webform
Module: DB2 database?

Bitte antworten
an
The OpenCms
mailing list
<opencms-dev at open
cms.org>






Hi Martin,
It seems that there is no support for db2 by default.
I looked up
https://github.com/alkacon/alkacon-oamp/tree/branch_9_0_x/com.alkacon.opencms.formgenerator/src/com/alkacon/opencms/formgenerator/database

and could not find a DB2 properties file.

I hope this is leading you in the right direction.
Best regards
Kai

-----Urspr?ngliche Nachricht-----
Von: opencms-dev-bounces at opencms.org [
mailto:opencms-dev-bounces at opencms.org] Im Auftrag von
martin.rosenthal at oerag.de
Gesendet: Dienstag, 12. August 2014 08:38
An: opencms-dev at opencms.org
Betreff: [opencms-dev] OAMP Webform Module: DB2 database?


Hello,

we are using OpenCms 9.0.1 in Weblogic 12 with a DB2 database. Now im
trying to install the OAMP Webform Module but on startup i get the error


08:15:39,156 ERROR [CmsFormDataAccess]
java.lang.NullPointerException
at java.util.Properties.load(Unknown Source)
at
com.alkacon.opencms.v8.formgenerator.database.CmsFormDataAccess.loadQueryProperties


(CmsFormDataAccess.java:1049)
at
com.alkacon.opencms.v8.formgenerator.database.CmsFormDataAccess.<init>
(CmsFormDataAccess.java:175)
at
com.alkacon.opencms.v8.formgenerator.database.CmsFormDataAccess.getInstance
(CmsFormDataAccess.java:188)
at
com.alkacon.opencms.v8.formgenerator.database.CmsFormDatabaseModuleAction.initialize


(CmsFormDatabaseModuleAction.java:76)
......

In the module configuration i've got the follwing entries:

db-pool=default
db-provider=db2

Must there be added other entries or isn't be possible to get running the
OAMP Webform Module with DB2?

In documentation there are only examples with mySQL, mssql oralce an
postgres.

Thanks and regards,
Martin Rosenthal
_______________________________
IT-Anwendungen

Tel.: [phone]
Fax: [phone]
Email: Martin.Rosenthal at oerag.de
Internet: www.oerag.de

?RAG Rechtsschutzversicherungs-AG
Hansaallee 199, 40549 D?sseldorf
Vorstand: Klaus R. Hartung, Andreas Heinsen
Aufsichtsratsvorsitzender: Ulrich R?ther Sitz der Gesellschaft: D?sseldorf,
Registergericht D?sseldorf HRB 12073

Diese E-Mail enth?lt vertrauliche und/oder rechtlich gesch?tzte
Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail
irrt?mlich erhalten haben, informieren Sie bitte den Absender und
vernichten diese

_______________________________________________
This mail is sent to you from the opencms-dev mailing list To change your
list options, or to unsubscribe from the list, please visit
http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev



_______________________________________________
This mail is sent to you from the opencms-dev mailing list To change your
list options, or to unsubscribe from the list, please visit
http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev





_______________________________________________
This mail is sent to you from the opencms-dev mailing list To change your
list options, or to unsubscribe from the list, please visit
http://lists.opencms.org/cgi-bin/mailman/listinfo/opencms-dev