List Info

Thread: Problem with PostgresRDBMSAdapter




Problem with PostgresRDBMSAdapter
user name
2006-08-24 14:03:46
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.rd
bms.PostgresRDBMSAdapter</parameter>
            <parameter
name="driver">org.postgresql.Driver</param
eter>
            <parameter 
name="url">jdbc:postgresql://127.0.0.1:5432/s
lide</parameter>
            <parameter
name="user">slide</parameter>
            <parameter
name="dbcpPooling">true</parameter>
            <parameter
name="maxPooledConnections">10</parameter&
gt;
            <parameter
name="isolation">SERIALIZABLE</parameter&g
t;
            <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.JDBCStore63cea096
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.creat
eException(PostgresRDBMSAdapter.java:341)
        at 
org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.store
Object(StandardRDBMSAdapter.java:191)
        at 
org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.creat
eObject(StandardRDBMSAdapter.java:83)
        at 
org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.createO
bject(AbstractRDBMSStore.java:443)
        at 
org.apache.slide.store.AbstractStore.createObject(AbstractSt
ore.java:670)
        at 
org.apache.slide.store.ExtendedStore.createObject(ExtendedSt
ore.java:602)
        at 
org.apache.slide.common.Namespace.loadBaseData(Namespace.jav
a: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.jav
a:253)
        at
javax.servlet.GenericServlet.init(GenericServlet.java:211)
        at 
org.apache.slide.webdav.WebdavServlet.init(WebdavServlet.jav
a:195)
        at 
org.apache.catalina.core.StandardWrapper.loadServlet(Standar
dWrapper.java:1091)
        at 
org.apache.catalina.core.StandardWrapper.load(StandardWrappe
r.java:925)
        at 
org.apache.catalina.core.StandardContext.loadOnStartup(Stand
ardContext.java:3880)
        at 
org.apache.catalina.core.StandardContext.start(StandardConte
xt.java:4141)
        at 
org.apache.catalina.core.ContainerBase.start(ContainerBase.j
ava:1012)
        at 
org.apache.catalina.core.StandardHost.start(StandardHost.jav
a:718)
        at 
org.apache.catalina.core.ContainerBase.start(ContainerBase.j
ava:1012)
        at 
org.apache.catalina.core.StandardEngine.start(StandardEngine
.java:442)
        at 
org.apache.catalina.core.StandardService.start(StandardServi
ce.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-unsubscribejakarta.apache.org
For additional commands, e-mail: slide-user-helpjakarta.apache.org

[1]

about | contact  Other archives ( Real Estate discussion Medical topics )