1 Reply Latest reply on Sep 1, 2004 1:14 PM by adrian.brock

    Datasource configuration problems

    brettparsons81

      Hello All,

      I hope I'm posting this to the correct forum, as I really need some assistance. I am using the JBoss+Tomcat bundle and I'm trying to configure 3 JNDI datasources. To do this, I added an "oracle-ds.xml" to my JBoss deploy directory (since I use an Oracle DB). The oracle-ds.xml file contains the following entries:

      <datasources>
       <local-tx-datasource>
       <jndi-name>webDBConnectInfo</jndi-name>
       <connection- url>jdbc:oracle:thin:@neo:1521:neo</connection-url>
       <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
       <user-name>test</user-name>
       <password>test</password>
       <min-pool-size>0</min-pool-size>
       </local-tx-datasource>
      
       <local-tx-datasource>
       <jndi-name>EPSG</jndi-name>
       <connection-url>jdbc:oracle:thin:@neo:1521:neo</connection-url>
       <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
       <user-name>test</user-name>
       <password>test</password>
       <min-pool-size>0</min-pool-size>
       </local-tx-datasource>
      
       <local-tx-datasource>
       <jndi-name>serviceManagerDBConnectInfo</jndi-name>
       <connection-url>jdbc:oracle:thin:@neo:1521:neo</connection-url>
       <driver-class>com.liferay.jdbc.LiferayDriver</driver-class>
       <user-name>test</user-name>
       <password>test</password>
       <min-pool-size>0</min-pool-size>
       </local-tx-datasource>
      </datasources>
      


      I then start JBoss and log into the jmx-console, go to the "JNDIView" page, and then list the JNDI namespace. Under the list, the "EPSG" datasource entry appears in the "java: namespace" context, however, the other two do not. I have checked to ensure all database connection info is correct and that my tnsnames has the correct entries. Anyone have any suggestions on why the other 2 datasources aren't showing up in the list?

      Thanks,

      Brett