[opencms-dev] Does the OAMP Webform Module support Postgresql?

[Mario Jäger]

Hi Ronen,

At the moment supported database providers for the OAMP Webform Module are only MySql and 
Oracle. So PostgreSQL is not supported at the moment. Being MySql the default. If you are 
using Oracle as database provider you have to set following module parameters:

db-provider=oracle and index-tablespace=<your tablespace>, here the default is
"users". After changing these parameters you will have to restart your servlet container.

-- 
Kind Regards,
Mario.
 
-------------------
Mario Jäger
 
Alkacon Software GmbH  - The OpenCms Experts                    
http://www.alkacon.com - http://www.opencms.org


Ronen schrieb:
> If yes, I get the following exception:
>
> 08 Nov 2009 13:26:59,482 INFO [pencms.module.CmsModuleManager: 798] . 
> Module configuration : initializing module class 
> com.alkacon.opencms.formgenerator.database.CmsFormDatabaseModuleAction
> 08 Nov 2009 13:26:59,513 ERROR [se.CmsFormDatabaseModuleAction: 79] 
> ERROR: syntax error at or near "("
> org.postgresql.util.PSQLException: ERROR: syntax error at or near "("
> at 
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
> at 
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
> at 
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
> at 
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
> at 
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
> at 
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:304)
> at 
> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
> 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)
> at 
> com.alkacon.opencms.formgenerator.database.CmsFormDatabaseModuleAction.initialize(CmsFormDatabaseModuleAction.java:76)
> at 
> org.opencms.module.CmsModuleManager.initialize(CmsModuleManager.java:807)
> at org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1181)
> at org.opencms.main.OpenCmsCore.initContext(OpenCmsCore.java:1323)
> at org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1770)
> at 
> org.opencms.main.OpenCmsListener.contextInitialized(OpenCmsListener.java:87)
> at 
> org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3843)
> at 
> org.apache.catalina.core.StandardContext.start(StandardContext.java:4350)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
> at org.apache.catalina.core.StandardHost.start(StandardHost.java:719)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
> at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
>
> Thanks,
> Ronen
> ------------------------------------------------------------------------
>
>
> _______________________________________________
> 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