I tried to use Oracle9i with JBoss 4 and faced some problems. This is what I've 
done:

- copied docs/examples/jca/oracle-xa-ds.xml to server/default/deploy. Changed 
the values of <xa-datasource-property name="URL">, <xa-datasource-property 
name="User">, <xa-datasource-property name="Password"> to the proper ones.

- in the ejb jar file of my application, I had the jbosscmp-jdbc.xml file like 
this:

  | <!DOCTYPE jbosscmp-jdbc PUBLIC
  |           "-//JBoss//DTD JBOSSCMP-JDBC 4.0//EN"
  |           "http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_4_0.dtd";>
  | <jbosscmp-jdbc>
  |     <defaults>
  |         <datasource>java:/XAOracleDS</datasource>
  |         <create-table>true</create-table>
  |         <alter-table>false</alter-table>
  |         <remove-table>false</remove-table>
  |     </defaults>
  |     <enterprise-beans>
  |         <entity>
  |             <ejb-name>CabinEJB</ejb-name>
  |             <table-name>Cabin_table</table-name>
  |             <cmp-field>
  |                 <field-name>id</field-name>
  |                 <column-name>cabin_id</column-name>
  |             </cmp-field>
  |             <cmp-field>
  |                 <field-name>name</field-name>
  |             </cmp-field>
  |         </entity>
  |     </enterprise-beans>
  | </jbosscmp-jdbc>
  | 

I'm sure that it won't work with only these 2 steps. So what should I do next? 
(for example, change anything in standardjaws.xml, standardjbosscmp-jdbc.xml, 
login-config.xml ...)

Or if you know any document showing how to do this, let me know please. I found 
one at http://www.onjava.com/lpt/a/4525, but it doesn't work with me :(

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

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


-------------------------------------------------------
This SF.Net email is sponsored by Oracle Space Sweepstakes
Want to be the first software developer in space?
Enter now for the Oracle Space Sweepstakes!
http://ads.osdn.com/?ad_id=7393&alloc_id=16281&op=click
_______________________________________________
JBoss-user mailing list
JBoss-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to