Problem with PostgresRDBMSAdapter

Martin Petras <[email protected]>
Newsgroups gmane.comp.jakarta.slide.user
Message-ID <[email protected]>
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.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.