[opencms-dev] OAMP Webform with Oracle

[Henrik F. Gøtzsche]

Thanks. That did it, of course !

I should have RTFM, but as it worked out of the box with MySQL, 
I did not bother to check the configurations. 

Thanks again.

Regards 
Henrik

---
Henrik F. Gøtzsche
WebSektionen
Digital Infrastruktur og Service
Det Kongelige Bibliotek

e-mail: hfg at kb.dk
tlf: 33 47 48 48

-----Oprindelig meddelelse-----
Fra: opencms-dev-bounces at opencms.org [mailto:opencms-dev-bounces at opencms.org] På vegne af Tobias Herrmann
Sendt: 29. juli 2009 16:07
Til: The OpenCms mailing list
Emne: Re: [opencms-dev] OAMP Webform with Oracle

Hallo Henrik,

you have to set the module-parameter db-provider=oracle. To do that go 
to Administration View >  Module Management select the webform-module 
and click on Module Parameters, add the parameter db-provider=oracle. 
Restart Tomcat.

This should solve your problem.

Regards, Tobias

-------------------

Alkacon Software GmbH - The OpenCms Experts
Tobias Herrmann

http://www.alkacon.com
http://www.opencms.org





Henrik F. Gøtzsche schrieb:
> We are currently testing the QAMP survey and comments modules, both 
> of which require the webform module.
>
> However, when installing the webform module on our test platform 
> with Oracle db the two tables CMS_WEBFORM_DATA AND CMS_WEBFORM_ENTRIES 
> are not created in the database. Not even after restart of Tomcat.
>
> On a test installation using MySql 5.1 they are created without any 
> problems.
>
> Setup:
> OpenCms 7.0.5
> OAMP Webform Module 1.3.1
> Oracle db. 10.1.0.5
>
> A few lines from the stack trace:
>
> java.sql.SQLException: ORA-00907: missing right parenthesis
> ...
> at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
> at com.alkacon.opencms.formgenerator.database.CmsFormDataAccess.createDBTables(CmsFormDataAccess.java:736)
> at com.alkacon.opencms.formgenerator.database.CmsFormDataAccess.ensureDBTablesExistance(CmsFormDataAccess.java:285)
> ...
>
> We believe to have traced the problem to the m_db.equals(DB_ORACLE) 
> method in com.alkacon.opencms.formgenerator.database.CmsFormDataAccess, 
> lines 727 and 740, which seems to return false resulting in the
> SQL create statements from generic.properties being used instead of 
> those from oracle.properties.
>
> Is this a known problem or does anybody know of a workaround ?
>
> Best regards
> Henrik
>
>
> ---
> Henrik F. Gøtzsche
> WebSektionen
> Digital Infrastruktur og Service
> The Royal Library, Copenhagen
>
>
> _______________________________________________
> 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/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/mailman/listinfo/opencms-dev