[opencms-dev] OAMP Webform with Oracle

[Tobias Herrmann]

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
>