Hi
Can you tell me how to bind or map XADatasource in EJB3 .
I am using JBoss server, I have no problem with DataSource.

Thanks

You set this in your -ds.xml file.



It is basically the same.
In EJB3 you are referencing to the JNDI bound DataSource.
If that DS is XA, JPA cares just about getting the connection and using JTA - it knows nothing about XA - that's JTA's job.

hi
you think alesj that , JTA knows nothing about XA? and if I want use XADataSource in my Serverside?
i am using Oracle10g
i am ds.xml configured in jboss 4.x and averything warks fine with DataSource when i am doing lookup, i'd like tu use XADataSource in EJB3
can you help me?

ds.xml

<datasources>
<xa-datasource>
<jndi-name>XAOracleDS</jndi-name>
<track-connection-by-tx>true</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">b1</xa-datasource-property>
<xa-datasource-property name="Password">b2</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>
<mbean code="org.jboss.jdbc.JdbcProvider" name="DefaultDomain:service=JdbcProvider">
<attribute name="Drivers">oracle.jdbc.driver.OracleDriver</attribute>
</mbean>


<mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=XAODS">
<attribute name="PoolName">XAODS</attribute>
<attribute name="DataSourceClass">XADataSource</attribute>
<attribute name="datasourceName">devnbtwo</attribute>
<attribute name="URL">jdbc:oracle:thin:@192.9.200.177:1521:devnbtwo</attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="MaxSize">10</attribute>
<attribute name="Password" />
<attribute name="GCEnabled">false</attribute>
<attribute name="InvalidateOnError">false</attribute>
<attribute name="TimestampUsed">false</attribute>
<attribute name="Blocking">true</attribute>
<attribute name="GCInterval">120000</attribute>
<attribute name="IdleTimeout">1800000</attribute>
<attribute name="IdleTimeoutEnabled">false</attribute>
<attribute name="LoggingEnabled">false</attribute>
<attribute name="MaxIdleTimeoutPercent">1.0</attribute>
<attribute name="MinSize">0</attribute>
</mbean>

</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>

No, EJB3 persistence doesn't know about XA.
JTA definitely knows :-).

There is an example.
Do the same thing as in <JBOSS_HOME>\docs\examples\jca\oracle-xa-ds.xml

btw: What is the problem??

hi
in EJB3 , in Session bean i am mapping dataSource , there is my code
@Resource(mappedName="java:/XAOracleDS") DataSource myTestDB;

with myTestDB datasource object i am doing operations
Connevtion con = myTestDB.getConnection(); and ect....

that works well, but when i am trying
@Resource(name="java:/XAOracleDS",type=javax.sql.XADataSource.class) XADataSource myTestDB; - do not .
Can you tell me how to bind XADataSource?

ds.xml

<datasources>
<xa-datasource>
<jndi-name>XAOracleDS</jndi-name>
<track-connection-by-tx>true</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">b1</xa-datasource-property>
<xa-datasource-property name="Password">b2</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>
<mbean code="org.jboss.jdbc.JdbcProvider" name="DefaultDomain:service=JdbcProvider">
<attribute name="Drivers">oracle.jdbc.driver.OracleDriver</attribute>
</mbean>
<mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=XAODS">
<attribute name="PoolName">XAODS</attribute>
<attribute name="DataSourceClass">XADataSource</attribute>
<attribute name="datasourceName">devnbtwo</attribute>
<attribute name="URL">jdbc:oracle:thin:@192.9.200.177:1521:devnbtwo</attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="MaxSize">10</attribute>
<attribute name="Password" />
<attribute name="GCEnabled">false</attribute>
<attribute name="InvalidateOnError">false</attribute>
<attribute name="TimestampUsed">false</attribute>
<attribute name="Blocking">true</attribute>
<attribute name="GCInterval">120000</attribute>
<attribute name="IdleTimeout">1800000</attribute>
<attribute name="IdleTimeoutEnabled">false</attribute>
<attribute name="LoggingEnabled">false</attribute>
<attribute name="MaxIdleTimeoutPercent">1.0</attribute>
<attribute name="MinSize">0</attribute>
</mbean>
</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>

Try using @JndiInject.

Or you can even use this: http://it.sys-con.com/read/180386.htm

As ales said, Hibernate EntityManager doesn't care at all on the XA or non XA behavior of a datasource. Same for 2PC and all trasnaction related protocol.
the transaction implementation (in JTA) is completly transparent for the persistence provider.