4 Replies Latest reply on Dec 6, 2004 1:57 AM by Veeranjaneyulu Bonthu

    Datasource creation for oracle in JBOSS

    Veeranjaneyulu Bonthu Newbie

      Try if this works

      (1) modify xxx-ds.xml

      <local-tx-datasources>
      <jndi-name>yourOracleDS</jndi-name>
      <connection-url>jdbc:oracle:thin:@localhost:1521:EPS</connection-url>
      <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
      <user-name>yourUserName</user-name>
      yourPwd
      </local-tx-datasources>

      (2) modify your method:

      javax.sql.DataSource ds = (javax.sql.DataSource) ctx.lookup("java:/yourOracleDS");

      (3) ensure oracle driver (i.e. classes12.jar) in JBOSS lib directory