Postgresql and XA Datasource

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/