ok thanks u're rigth .... it works.... but what can i do when i wont work with multiple database ? i think that i need to xml datasourse file (for example : oracle-xa-ds.xml and postgres-ds.xml) both of them configured corectly : oracle ds file :
| <datasources> | <xa-datasource> | <jndi-name>XAOracleDS</jndi-name> | <track-connection-by-tx/> | <isSameRM-override-value>false</isSameRM-override-value> <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class> | <xa-datasource-property name="URL">jdbc:oracle:thin:@192.9.200.177:1521:devnbtwo</xa-datasource-property> | <xa-datasource-property name="User">paata</xa-datasource-property> | <xa-datasource-property name="Password">1982226</xa-datasource-property> <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name> | <no-tx-separate-pools/> | <metadata> | <type-mapping>Oracle9i</type-mapping> | </metadata> | </xa-datasource> | <mbean code="org.jboss.resource.adapter.jdbc.vendor.OracleXAExceptionFormatter" | name="jboss.jca:service=OracleXAExceptionFormatter"> | <depends optional-attribute-name="TransactionManagerService">jboss:service=TransactionManager</depends> | </mbean> | </datasources> | and postgres ds file: | <datasources> | <local-tx-datasource> | <jndi-name>PostgresDS</jndi-name> | <connection-url>jdbc:postgresql://localhost:5432/Test</connection-url> | <driver-class>org.postgresql.Driver</driver-class> | <user-name>postgres</user-name> | <password>1982226</password> | <new-connection-sql>select 1</new-connection-sql> | <metadata> | <type-mapping>PostgreSQL 7.2</type-mapping> | </metadata> | </local-tx-datasource> | </datasources> | and i want do operation wich inserts into one db and then into second db in one transaction .... how i can do it ? :( plz F1 :) [EMAIL PROTECTED] told me about JBossJCA but i didn't find any sample about it ... is there any simple example about distributed transactions ... View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3956565#3956565 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3956565 ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user
