[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Re: XAException XAER_DUPID in CMP EJB finder invoked from a

torf do-not-reply at jboss.com
Tue Jan 20 10:46:57 EST 2009


Hi,

yes, it was solved somehow, but unfortunately i don't know how. 

It is still running on JBoss 4.0.4GA. Maybe it works due to a newer Informix JDBC driver (we are using 3.00 JC3 now)?

Or maybe the datasource config was changed. It currently looks like this:
<?xml version="1.0" encoding="UTF-8"?>
  | <datasources>
  |   <xa-datasource>
  |     <jndi-name>SystemDefaultDS</jndi-name>
  |     <xa-datasource-class>com.informix.jdbcx.IfxXADataSource</xa-datasource-class>
  |     <xa-datasource-property name="IfxIFXHOST">...</xa-datasource-property>
  |     <xa-datasource-property name="PortNumber">1723</xa-datasource-property>
  |     <xa-datasource-property name="DatabaseName">system_default_02</xa-datasource-property>
  |     <xa-datasource-property name="ServerName">zap_db_net</xa-datasource-property>
  |     <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
  |     <user-name>...</user-name>
  |     <password>...</password>
  |     <track-connection-by-tx>true</track-connection-by-tx>
  |     <prepared-statement-cache-size>100</prepared-statement-cache-size>
  |     <isSameRM-override-value>false</isSameRM-override-value>
  |     <no-tx-separate-pools/>
  |     <new-connection-sql>set lock mode to wait</new-connection-sql>
  |     <check-valid-connection-sql>set lock mode to wait</check-valid-connection-sql>
  |     <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.InformixExceptionSorter</exception-sorter-class-name>
  |     <!--pooling parameters-->
  |     <min-pool-size>1</min-pool-size>
  |     <max-pool-size>50</max-pool-size>
  |     <blocking-timeout-millis>5000</blocking-timeout-millis>
  |     <idle-timeout-minutes>5</idle-timeout-minutes>
  |       <metadata>
  |         <type-mapping>InformixDB</type-mapping>
  |       </metadata>
  |   </xa-datasource>
  | </datasources>
  | 

I'm sorry that i cannot be more helpful.

Christoph

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4203329#4203329

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4203329



More information about the jboss-user mailing list