3 Replies Latest reply on Nov 12, 2007 3:36 PM by Ethan Stein

    Utilizing Non-Default Datsource With JBOSS 4

    Ethan Stein Newbie

      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:


      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.