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.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.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-unsubscribe jakarta.apache.org
For additional commands, e-mail: slide-user-help jakarta.apache.org
|