Hi,
How do you define the schema to use for XA datasources in Nuxeo?
For example I've tried:
<xa-datasource>
<jndi-name>nxworkflowjbpm</jndi-name>
<xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class>
<xa-datasource-property
name="ServerName">localhost</xa-datasource-property>
<xa-datasource-property name="PortNumber">5432</xa-datasource-property>
<xa-datasource-property name="DatabaseName">MY_DB</xa-datasource-property>
<xa-datasource-property name="Schema">my_schema</xa-datasource-property>
<xa-datasource-property name="User">my_user</xa-datasource-property>
<xa-datasource-property name="Password">password</xa-datasource-property>
<track-connection-by-tx/>
</xa-datasource>
But this fails with:
2008-05-06 21:53:45,117 WARN
[org.jboss.resource.connectionmanager.JBossManagedConnectionPool]
Throwable while attempting to get a new connection: null
org.jboss.resource.JBossResourceException: Could not create connection;
- nested throwable: (org.jboss.resource.JBossResourceException: Could
not find accessor on XADataSou
rce: ; - nested throwable: (java.lang.NoSuchMethodException:
org.postgresql.xa.PGXADataSource.setSchema(java.lang.String)))
at
org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.createManagedConnection(XAManagedConnectionFactory.java:164)
at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:565)
at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:250)
Any ideas?
Thanks in advance.
Sean
--
Dr. Sean Radford, MBBS, MSc
http://www.tacola.com/
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
