Re: Postgresql and XA Datasource

Sean Radford a écrit :
> Hi,
>
> I understand how to configure all the services for a particular db - have done
> so for both Postgres and MySQL.
>
> However, I need to use Postgres with XA and I want Nuxeo to use a particular
> database schema within the assigned database.
>
> I guess, this maybe more of a Postgres question, but thought that you guys would
> very likely know.
>   
We usually use a dedicated PGSQL DB and then we use the default schema 
(public).
Can't see anything in the PGSQL JDBC lib API to set the schema.
May be PGSQL guys may give you a more precise answer.
> Regards,
>
> Sean
>
>   
>> 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
>>> ECM@...
>>> http://lists.nuxeo.com/mailman/listinfo/ecm
>>>
>>>       
>> --
>> Enrique Pérez Olivares.
>> Dpto I+D.
>> Yerbabuena Software.
>> enriqueperez@...
>> http://www.yerbabuena.es
>> Tlf/Fax: 902 995 246
>>
>>
>>     
>
>
> --
> Dr. Sean Radford, MBBS MSc
> http://www.tacola.com
>
>