1 Reply Latest reply on May 8, 2003 9:03 PM by David Jencks

    Problem configuring a datasource for Oracle 9i

    plarochefr Newbie

      Hello,

      I am trying to configure a datasource for Oracle 9i, but cannot succeed.

      I am using jBoss 3.2. jBoss uses the hypersonic DefaultDS datasource instead of mine. What I have seen in the server.log file is:

      2003-05-08 17:46:10,737 DEBUG [org.jboss.ejb.StatelessSessionContainer] Binding resource manager: java:/DefaultDS to JDNI ENC as: jdbc/AltitudeDB

      I don't know why it does that. I have attached my oracle-ds.xml file. Please note that I have tried many ways to name the datasource:

      - AltitudeDB
      - jdbc/AltitudeDB
      - comp/env/jdbc/AltitudeDB

      Could someone pleas help me ?
      Please don't hesitate to ask if you need more information to help.

      Thank you in advance.

      Pierre Laroche

        • 1. Re: Problem configuring a datasource for Oracle 9i
          David Jencks Master

          I think there are instructions in the quick start guide on how to set up local references.

          Name your ds AltitudeDS in the *-ds.xml file.

          Now you should be able to look it up anywhere in the jboss vm under java:/AltitudeDS

          If you want to look up java:/comp/env/jdbc/AltitudeDS you have to set up a resource reference in a jboss.xml file If you don't, I think jboss will attach the reference to DefaultDS as a default.

          Of course you could also remove the hsqldb-ds.xml and name your datasource DefaultDS.