You are viewing a plain text version of this content. The canonical link for it is here.
Posted to slide-user@jakarta.apache.org by Martin Petras <pe...@skms.sk> on 2006/08/24 16:03:46 UTC
Problem with PostgresRDBMSAdapter
Hi all,
I am using Slide 2.1 and trying to create store in PostgreSQL server 8.1.
Domain.xml:
<definition>
<store name="PostgresStore">
<nodestore
classname="org.apache.slide.store.impl.rdbms.JDBCStore">
<parameter
name="adapter">org.apache.slide.store.impl.rdbms.PostgresRDBMSAdapter</parameter>
<parameter name="driver">org.postgresql.Driver</parameter>
<parameter
name="url">jdbc:postgresql://127.0.0.1:5432/slide</parameter>
<parameter name="user">slide</parameter>
<parameter name="dbcpPooling">true</parameter>
<parameter name="maxPooledConnections">10</parameter>
<parameter name="isolation">SERIALIZABLE</parameter>
<parameter name="compress">false</parameter>
</nodestore>
<contentstore>
<reference store="nodestore" />
</contentstore>
<securitystore>
<reference store="nodestore" />
</securitystore>
<lockstore>
<reference store="nodestore" />
</lockstore>
<revisiondescriptorsstore>
<reference store="nodestore" />
</revisiondescriptorsstore>
<revisiondescriptorstore>
<reference store="nodestore" />
</revisiondescriptorstore>
</store>
<scope match="/" store="PostgresStore"/>
</definition>
web.xml:
<web-app>
<filter>
...
<resource-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/slide</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
...
When starting Tomcat 5.5.12 I always get this exception:
org.apache.slide.common.ServiceAccessException: Service
org.apache.slide.store.impl.rdbms.JDBCStore@63cea096 access error :
CHYBA: chybajuci zaznam v klauzuli FROM pre tabulku "uri" (translated:
ERROR: Missing entry in clause FROM for the table "uri")
at
org.apache.slide.store.impl.rdbms.PostgresRDBMSAdapter.createException(PostgresRDBMSAdapter.java:341)
at
org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeObject(StandardRDBMSAdapter.java:191)
at
org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.createObject(StandardRDBMSAdapter.java:83)
at
org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.createObject(AbstractRDBMSStore.java:443)
at
org.apache.slide.store.AbstractStore.createObject(AbstractStore.java:670)
at
org.apache.slide.store.ExtendedStore.createObject(ExtendedStore.java:602)
at
org.apache.slide.common.Namespace.loadBaseData(Namespace.java:785)
at org.apache.slide.common.Domain.initNamespace(Domain.java:845)
at org.apache.slide.common.Domain.init(Domain.java:432)
at org.apache.slide.common.Domain.init(Domain.java:366)
at org.apache.slide.common.Domain.init(Domain.java:329)
at
org.apache.slide.webdav.WebdavServlet.init(WebdavServlet.java:253)
at javax.servlet.GenericServlet.init(GenericServlet.java:211)
at
org.apache.slide.webdav.WebdavServlet.init(WebdavServlet.java:195)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1091)
at
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:925)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3880)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4141)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
at
org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1012)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
at
org.apache.catalina.core.StandardService.start(StandardService.java:450)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:680)
There might be a problem in PostreSQL version because
PostgresRDBMSAdapter is for Postgres 7.3/7.4. (as documentation says)
Could anyone help?
Thanks.
---------------------------------------------------------------------
To unsubscribe, e-mail: slide-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: slide-user-help@jakarta.apache.org