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

Tue Aug 12 09:38:31 CEST 2014

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.: 0211 529 5775
Fax: 0211 529 59775
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.: 0211 529 5775
Fax: 0211 529 59775
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