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

    Datasource creation for oracle in JBOSS

    bonthus

      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

        • 1. Re: Datasource creation for oracle in JBOSS
          joycewteng

          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

          • 2. Re: Datasource creation for oracle in JBOSS
            bonthus

            thanks joy

            i have tried ur option also but it was not working now also

            every thing i have given was fine but i dont know y it was not working

            while starting itself it is showing that no resource manager found for OracleDS i think datasource was not created yet

            how can i do at this stage????



            • 3. Re: Datasource creation for oracle in JBOSS
              darranl

              Try starting JBoss without your application or -ds.xml deployed.

              Put the -ds.xml in the deploy folder, look at any messages on the console to see if it deployed.

              Use JNDI View in jmx-console to check that the connection bound.

              Only when you know that the connection has been bound correctly then deploy your session bean and see if you can make use of the connection.

              • 4. Re: Datasource creation for oracle in JBOSS
                bonthus

                thnk you all for helping me

                finally i was got the reason why it was not deployed

                the reason was small mistake in oracle-ds.xml

                in place of

                <local-tx-datasource>
                i have given
                <local-tx-datasources>


                that was only mistake i was commited

                by replacing it with proper word now it is working fine

                thank you