Hi Sean,
XA transactions only works if your PGSQL version is 8.x. Check your version.
Moreover, you need install the JDBC driver and I think you have to
configure the Relation Service and the Compass plugin. You can see how
to do this in the Nuxeo Book:
http://doc.nuxeo.org/5.1/nuxeo-book/reference/html/administration.html#admin-database-configuration
Regards.
Tiry escribió:
Sean Radford a écrit :
Hi,
How do you define the schema to use for XA datasources in Nuxeo?
This should not have anything to do with Nuxeo : the datasources are
managed by JBoss.
Tests have been done with PGSQL in XA.
I don't have a example here.
Just check JBoss doc and check your PGSQL JDBC package.
Do you have this problem on all datasources or only on the jbpm db ?
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
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
--
Enrique Pérez Olivares.
Dpto I+D.
Yerbabuena Software.
[EMAIL PROTECTED]
http://www.yerbabuena.es
Tlf/Fax: 902 995 246
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
