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

[Yves Glodt]

As of 7.5.2, what is the state of oamp modules support for postgresql-based
setups?

Do webform and survey work ?

best regards,
yves

On 2 December 2009 09:49, Mario Jäger <m.jaeger at alkacon.com> wrote:

> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20100202/41836516/attachment.htm>