[jboss-user] [JNDI/Naming/Network] - Utilizing Non-Default Datsource With JBOSS 4

estein do-not-reply at jboss.com
Sat Nov 10 16:48:57 EST 2007

I am using JBOSS 4.0.5 on Microsoft Windows XP with a default datasource of MS SQL.  I wish to be able to interact with another datasource that is Oracle 10g.  However, the only documentation/posts I have found deal with setting up the default datasource to be Oracle.  I want to keep my MS SQL default DB and just pull data from the oracle database.  What sort of configurations do I have to do?

I tried simply adding the oracle-ds.xml file from \jboss\docs\examples\jca to the \jboss\server\default\deploy directory and also adding the oracle jdbc drivers to the CLASSPATH of my startup script (i.e. CLASSPATH=...;%ORACLE_HOME%\db_2\jdbc\lib\classes12.zip)

However, when I start up JBOSS and try to interact with the oracle database, it says the jndi is not valid.  Am I forgetting something?

Do I need to add the ojdbc14.jar file as well or use the classes12.jar file instead?

My oracle-ds.xml file looks like this:

  |   <local-tx-datasource>
  |     <jndi-name>jdbc/OracleDS</jndi-name>
  |     <connection-url>jdbc:oracle:thin:@test2:1521:orcl</connection-url>
  |     <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
  |     <user-name>hr</user-name>
  |     <password>hr</password>
  |     <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
  |       <metadata>
  |          <type-mapping>Oracle8</type-mapping>
  |       </metadata>
  |   </local-tx-datasource>
  | </datasources>

I am using all of the default configurations for the login-config.xml, standardjbosscmp-jdbc.xml, and standardjaws.xml

Any help would be greatly appreciated.  Thanks.

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

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

More information about the jboss-user mailing list