The Postgres port has been tested with 7.3 and 7.4, not with 7.2, maybe
this is the problem...
Oliver
Jean-Baptiste Li�vremont wrote:
Hi,
I'm using the slide 2.0/tomcat 5.0.19 bundle with a Postgres 7.2.1 DB
server. I do not use JNDI. The JDBC Jar file is in
$CATALINA_HOME/common/lib.
I have created the tables Slide requires to use the DB as a store. The
database is accessed by a user named 'tomcat' which has all permissions
on the 'slide' DB.
My Domain.xml contains:
<store name="patrouille1_pgsql">
<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:pgsql://patrouille1:5432/slide</parameter>
<parameter name="user">tomcat</parameter>
<parameter name="password">********</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="patrouille1_pgsql"/>
As I launch Tomcat, I have the following trace. It seems that the JDBC
Driver can not be used by Slide, but I cannot find out why.
Regards.
Using CATALINA_BASE: /root/jakarta-slide-2.0-tomcat-5.0.19
Using CATALINA_HOME: /root/jakarta-slide-2.0-tomcat-5.0.19
Using CATALINA_TMPDIR: /root/jakarta-slide-2.0-tomcat-5.0.19/temp
Using JAVA_HOME: /opt/java
Jun 25, 2004 5:49:41 PM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on port 8080
Jun 25, 2004 5:49:41 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 6931 ms
Jun 25, 2004 5:49:42 PM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
Jun 25, 2004 5:49:42 PM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.0.19
25 Jun 2004 17:49:42 - org.apache.slide.common.Domain - INFO -
Auto-Initializing Domain
25 Jun 2004 17:49:42 - org.apache.slide.common.Domain - INFO - Domain
configuration : {org.apache.slide.lock=true,
org.apache.slide.versioncontrol=true, org.apache.slide.debug=false,
org.apache.slide.search=true, org.apache.slide.security=true,
org.apache.slide.urlEncoding=UTF-8,
org.apache.slide.domain=../slide/Domain.xml}
25 Jun 2004 17:49:42 - org.apache.slide.common.Domain - INFO -
Initializing Domain
25 Jun 2004 17:49:42 - org.apache.slide.common.Domain - INFO - Domain
configuration : {org.apache.slide.lock=true,
org.apache.slide.versioncontrol=true, org.apache.slide.debug=false,
org.apache.slide.search=true, org.apache.slide.security=true,
org.apache.slide.urlEncoding=UTF-8,
org.apache.slide.domain=../slide/Domain.xml}
25 Jun 2004 17:49:42 - org.apache.slide.common.Domain - INFO - Domain
parameters: {logger-level=6, versioncontrol-exclude=,
auto-version=checkout-checkin, historypath=/history,
checkin-fork=forbidden, workingresourcepath=/workingresource,
workspacepath=/workspace, default=slide, auto-version-control=false,
logger=org.apache.slide.util.logger.SimpleLogger, checkout-fork=forbidden}
25 Jun 2004 17:49:42 - org.apache.slide.common.Domain - INFO -
Initializing namespace : slide
25 Jun 2004 17:49:42 - org.apache.slide.common.Namespace - INFO -
Loading namespace slide parameters
25 Jun 2004 17:49:43 - org.apache.slide.common.Namespace - INFO -
Loading namespace definition
25 Jun 2004 17:49:43 - org.apache.slide.common.Namespace - INFO - Node
store: org.apache.slide.store.impl.rdbms.JDBCStore
25 Jun 2004 17:49:43 - org.apache.slide.store.impl.rdbms.JDBCStore -
INFO - Loading and registering driver 'org.postgresql.Driver'
25 Jun 2004 17:49:43 - org.apache.slide.store.impl.rdbms.JDBCStore -
INFO - Setting isolation level 'SERIALIZABLE'
25 Jun 2004 17:49:43 - org.apache.slide.store.impl.rdbms.JDBCStore -
INFO - Using DBCP pooling
25 Jun 2004 17:49:43 - org.apache.slide.store.impl.rdbms.JDBCStore -
INFO - Number of connections set to 10
25 Jun 2004 17:49:43 - org.apache.slide.common.Namespace - INFO -
Security store references nodestore
25 Jun 2004 17:49:43 - org.apache.slide.common.Namespace - INFO - Lock
store store references nodestore
25 Jun 2004 17:49:43 - org.apache.slide.common.Namespace - INFO -
Revision descriptors store references nodestore
25 Jun 2004 17:49:43 - org.apache.slide.common.Namespace - INFO -
Revision descriptor store references nodestore
25 Jun 2004 17:49:43 - org.apache.slide.common.Namespace - INFO -
Content store references nodestore
25 Jun 2004 17:49:43 - INFO - Setting object cache size for store
patrouille1_pgsql to 10000
25 Jun 2004 17:49:43 - org.apache.slide.store.ExtendedStore - INFO -
Setting permission cache size for store patrouille1_pgsql to 10000
25 Jun 2004 17:49:43 - org.apache.slide.store.ExtendedStore - INFO -
Setting lock cache size for store patrouille1_pgsql to 100
25 Jun 2004 17:49:43 - org.apache.slide.store.ExtendedStore - INFO -
Setting descriptors cache size for store patrouille1_pgsql to 10000
25 Jun 2004 17:49:43 - org.apache.slide.store.ExtendedStore - INFO -
Setting descriptor cache size for store patrouille1_pgsql to 10000
25 Jun 2004 17:49:43 - org.apache.slide.store.ExtendedStore - INFO -
Setting content caching for store patrouille1_pgsql to false
25 Jun 2004 17:49:43 - org.apache.slide.store.ExtendedStore - INFO -
Setting content cache size for store patrouille1_pgsql to 10000
25 Jun 2004 17:49:43 - org.apache.slide.store.ExtendedStore - INFO -
Setting content cache byte size for store patrouille1_pgsql to 10000000
25 Jun 2004 17:49:43 - org.apache.slide.store.ExtendedStore - INFO -
Setting transaction content cache size for store patrouille1_pgsql to 1000
25 Jun 2004 17:49:43 - org.apache.slide.store.ExtendedStore - INFO -
Setting transaction content cache byte size for store patrouille1_pgsql
to 1000000
25 Jun 2004 17:49:43 - org.apache.slide.store.ExtendedStore - INFO -
Setting maximum byte size for content cache entry for store
patrouille1_pgsql to 50000
25 Jun 2004 17:49:43 - org.apache.slide.common.Namespace - INFO -
Registering Store patrouille1_pgsql (class
org.apache.slide.store.ExtendedStore) with parameters {} on scope
/
25 Jun 2004 17:49:43 - org.apache.slide.common.Namespace - INFO -
Initializing Store patrouille1_pgsql(org.apache.slide.store.ExtendedStore)
25 Jun 2004 17:49:43 - org.apache.slide.store.impl.rdbms.JDBCStore -
EMERGENCY - Could not create connection. Reason: java.sql.SQLException:
No suitable driver
25 Jun 2004 17:49:43 - org.apache.slide.common.Namespace - INFO -
Loading namespace slide base data
25 Jun 2004 17:49:43 - org.apache.slide.store.impl.rdbms.JDBCStore -
EMERGENCY - Could not create connection. Reason: java.sql.SQLException:
No suitable driver
25 Jun 2004 17:49:43 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
[EMAIL PROTECTED] Error code
XAER_RMFAIL in Transaction 1 xid main-1088178583949-1- in thread main
25 Jun 2004 17:49:44 - org.apache.slide.store.impl.rdbms.JDBCStore -
EMERGENCY - Could not create connection. Reason: java.sql.SQLException:
No suitable driver
25 Jun 2004 17:49:44 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
[EMAIL PROTECTED] Error code
XAER_RMFAIL in Transaction 1 xid main-1088178583949-1- in thread main
25 Jun 2004 17:49:44 - org.apache.slide.store.impl.rdbms.JDBCStore -
EMERGENCY - Could not create connection. Reason: java.sql.SQLException:
No suitable driver
25 Jun 2004 17:49:44 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
[EMAIL PROTECTED] Error code
XAER_RMFAIL in Transaction 1 xid main-1088178583949-1- in thread main
25 Jun 2004 17:49:44 - org.apache.slide.store.impl.rdbms.JDBCStore -
EMERGENCY - Could not create connection. Reason: java.sql.SQLException:
No suitable driver
25 Jun 2004 17:49:44 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
[EMAIL PROTECTED] Error code
XAER_RMFAIL in Transaction 1 xid main-1088178583949-1- in thread main
25 Jun 2004 17:49:44 - org.apache.slide.store.impl.rdbms.JDBCStore -
EMERGENCY - Could not create connection. Reason: java.sql.SQLException:
No suitable driver
25 Jun 2004 17:49:44 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
[EMAIL PROTECTED] Error code
XAER_RMFAIL in Transaction 1 xid main-1088178583949-1- in thread main
25 Jun 2004 17:49:45 - org.apache.slide.store.impl.rdbms.JDBCStore -
EMERGENCY - Could not create connection. Reason: java.sql.SQLException:
No suitable driver
25 Jun 2004 17:49:45 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
[EMAIL PROTECTED] Error code
XAER_RMFAIL in Transaction 1 xid main-1088178583949-1- in thread main
25 Jun 2004 17:49:45 - org.apache.slide.store.impl.rdbms.JDBCStore -
EMERGENCY - Could not create connection. Reason: java.sql.SQLException:
No suitable driver
25 Jun 2004 17:49:45 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
[EMAIL PROTECTED] Error code
XAER_RMFAIL in Transaction 1 xid main-1088178583949-1- in thread main
25 Jun 2004 17:49:45 - org.apache.slide.store.impl.rdbms.JDBCStore -
EMERGENCY - Could not create connection. Reason: java.sql.SQLException:
No suitable driver
25 Jun 2004 17:49:45 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
[EMAIL PROTECTED] Error code
XAER_RMFAIL in Transaction 1 xid main-1088178583949-1- in thread main
25 Jun 2004 17:49:45 - org.apache.slide.store.impl.rdbms.JDBCStore -
EMERGENCY - Could not create connection. Reason: java.sql.SQLException:
No suitable driver
25 Jun 2004 17:49:45 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
[EMAIL PROTECTED] Error code
XAER_RMFAIL in Transaction 1 xid main-1088178583949-1- in thread main
25 Jun 2004 17:49:45 - org.apache.slide.store.impl.rdbms.JDBCStore -
EMERGENCY - Could not create connection. Reason: java.sql.SQLException:
No suitable driver
25 Jun 2004 17:49:45 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
[EMAIL PROTECTED] Error code
XAER_RMFAIL in Transaction 1 xid main-1088178583949-1- in thread main
25 Jun 2004 17:49:46 - org.apache.slide.store.impl.rdbms.JDBCStore -
EMERGENCY - Could not create connection. Reason: java.sql.SQLException:
No suitable driver
25 Jun 2004 17:49:46 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
[EMAIL PROTECTED] Error code
XAER_RMFAIL in Transaction 1 xid main-1088178583949-1- in thread main
25 Jun 2004 17:49:46 - org.apache.slide.store.impl.rdbms.JDBCStore -
EMERGENCY - Could not create connection. Reason: java.sql.SQLException:
No suitable driver
25 Jun 2004 17:49:46 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
[EMAIL PROTECTED] Error code
XAER_RMFAIL in Transaction 1 xid main-1088178583949-1- in thread main
25 Jun 2004 17:49:46 - org.apache.slide.store.impl.rdbms.JDBCStore -
EMERGENCY - Could not create connection. Reason: java.sql.SQLException:
No suitable driver
25 Jun 2004 17:49:46 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
[EMAIL PROTECTED] Error code
XAER_RMFAIL in Transaction 1 xid main-1088178583949-1- in thread main
25 Jun 2004 17:49:46 - org.apache.slide.store.impl.rdbms.JDBCStore -
EMERGENCY - Could not create connection. Reason: java.sql.SQLException:
No suitable driver
25 Jun 2004 17:49:46 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
[EMAIL PROTECTED] Error code
XAER_RMFAIL in Transaction 1 xid main-1088178583949-1- in thread main
25 Jun 2004 17:49:46 - org.apache.slide.store.impl.rdbms.JDBCStore -
EMERGENCY - Could not create connection. Reason: java.sql.SQLException:
No suitable driver
25 Jun 2004 17:49:46 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
[EMAIL PROTECTED] Error code
XAER_RMFAIL in Transaction 1 xid main-1088178583949-1- in thread main
25 Jun 2004 17:49:47 - org.apache.slide.store.impl.rdbms.JDBCStore -
EMERGENCY - Could not create connection. Reason: java.sql.SQLException:
No suitable driver
25 Jun 2004 17:49:47 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
[EMAIL PROTECTED] Error code
XAER_RMFAIL in Transaction 1 xid main-1088178583949-1- in thread main
25 Jun 2004 17:49:47 - org.apache.slide.store.impl.rdbms.JDBCStore -
EMERGENCY - Could not create connection. Reason: java.sql.SQLException:
No suitable driver
25 Jun 2004 17:49:47 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
[EMAIL PROTECTED] Error code
XAER_RMFAIL in Transaction 1 xid main-1088178583949-1- in thread main
25 Jun 2004 17:49:47 - org.apache.slide.store.impl.rdbms.JDBCStore -
EMERGENCY - Could not create connection. Reason: java.sql.SQLException:
No suitable driver
25 Jun 2004 17:49:47 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
[EMAIL PROTECTED] Error code
XAER_RMFAIL in Transaction 1 xid main-1088178583949-1- in thread main
25 Jun 2004 17:49:47 - org.apache.slide.store.impl.rdbms.JDBCStore -
EMERGENCY - Could not create connection. Reason: java.sql.SQLException:
No suitable driver
25 Jun 2004 17:49:47 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
[EMAIL PROTECTED] Error code
XAER_RMFAIL in Transaction 1 xid main-1088178583949-1- in thread main
25 Jun 2004 17:49:47 - org.apache.slide.store.impl.rdbms.JDBCStore -
EMERGENCY - Could not create connection. Reason: java.sql.SQLException:
No suitable driver
25 Jun 2004 17:49:47 - org.apache.slide.transaction.SlideTransaction -
WARNING - Enlist failure: Resource manager
[EMAIL PROTECTED] Error code
XAER_RMFAIL in Transaction 1 xid main-1088178583949-1- in thread main
org.apache.slide.common.ServiceAccessException: Service
patrouille1_pgsql(org.apache.slide.store.ExtendedStore) access error :
Failed to enlist service
[EMAIL PROTECTED] in active transaction
at
org.apache.slide.store.AbstractStore.enlist(AbstractStore.java:1369)
at
org.apache.slide.store.AbstractStore.createObject(AbstractStore.java:555)
at
org.apache.slide.store.ExtendedStore.createObject(ExtendedStore.java:436)
at
org.apache.slide.common.Namespace.loadBaseData(Namespace.java:752)
at org.apache.slide.common.Domain.initNamespace(Domain.java:814)
at org.apache.slide.common.Domain.init(Domain.java:433)
at org.apache.slide.common.Domain.selfInit(Domain.java:747)
at org.apache.slide.common.Domain.accessNamespace(Domain.java:235)
at wrappers.catalina.SlideRealm.start(SlideRealm.java:178)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1118)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:521)
at
org.apache.catalina.core.StandardService.start(StandardService.java:519)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:2345)
at org.apache.catalina.startup.Catalina.start(Catalina.java:594)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:297)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:398)
25 Jun 2004 17:49:48 - org.apache.slide.common.Namespace - INFO -
Namespace base configuration was already done before
25 Jun 2004 17:49:48 - org.apache.slide.common.Namespace - INFO -
Loading namespace slide configuration
25 Jun 2004 17:49:48 - org.apache.slide.store.impl.rdbms.JDBCStore -
EMERGENCY - Could not create connection. Reason: java.sql.SQLException:
No suitable driver
25 Jun 2004 17:49:48 - org.apache.slide.common.Domain - ERROR -
org.apache.slide.common.ServiceAccessException: Service
[EMAIL PROTECTED] access error : No
suitable driver
org.apache.slide.common.ServiceAccessException: Service
[EMAIL PROTECTED] access error : No
suitable driver
at
org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.retrieveObject(AbstractRDBMSStore.java:438)
at
org.apache.slide.store.AbstractStore.retrieveObject(AbstractStore.java:498)
at
org.apache.slide.store.ExtendedStore.retrieveObject(ExtendedStore.java:408)
at
org.apache.slide.common.NamespaceConfig.getActionNode(NamespaceConfig.java:1057)
at
org.apache.slide.common.NamespaceConfig.getConfiguredNode(NamespaceConfig.java:805)
at
org.apache.slide.common.NamespaceConfig.initializeNamespaceConfig(NamespaceConfig.java:675)
at
org.apache.slide.common.Namespace.loadConfiguration(Namespace.java:836)
at org.apache.slide.common.Domain.initNamespace(Domain.java:819)
at org.apache.slide.common.Domain.init(Domain.java:433)
at org.apache.slide.common.Domain.selfInit(Domain.java:747)
at org.apache.slide.common.Domain.accessNamespace(Domain.java:235)
at wrappers.catalina.SlideRealm.start(SlideRealm.java:178)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1118)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:521)
at
org.apache.catalina.core.StandardService.start(StandardService.java:519)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:2345)
at org.apache.catalina.startup.Catalina.start(Catalina.java:594)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:297)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:398)
25 Jun 2004 17:49:48 - org.apache.slide.common.Domain - INFO - Domain
initialization complete
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:297)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:398)
Caused by: java.lang.NullPointerException
at
org.apache.slide.common.NamespaceConfig.getParameter(NamespaceConfig.java:569)
at
org.apache.slide.common.NamespaceAccessTokenImpl.<init>(NamespaceAccessTokenImpl.java:83)
at org.apache.slide.common.Domain.accessNamespace(Domain.java:244)
at wrappers.catalina.SlideRealm.start(SlideRealm.java:178)
at
org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1118)
at
org.apache.catalina.core.StandardEngine.start(StandardEngine.java:521)
at
org.apache.catalina.core.StandardService.start(StandardService.java:519)
at
org.apache.catalina.core.StandardServer.start(StandardServer.java:2345)
at org.apache.catalina.startup.Catalina.start(Catalina.java:594)
... 6 more
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
