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

    Datasource creation for oracle in JBOSS

    bonthus
    bonthus Nov 30, 2004 12:12 AM

      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

      • 3250 Views
      • Tags:
        • 1. Re: Datasource creation for oracle in JBOSS
          joycewteng
          joycewteng Dec 1, 2004 4:03 PM (in response to 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

            • Actions
          • 2. Re: Datasource creation for oracle in JBOSS
            bonthus
            bonthus Dec 2, 2004 8:15 AM (in response to 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????



              • Actions
            • 3. Re: Datasource creation for oracle in JBOSS
              darranl
              darranl Dec 2, 2004 8:21 AM (in response to bonthus)

              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.

                • Actions
              • 4. Re: Datasource creation for oracle in JBOSS
                bonthus
                bonthus Dec 6, 2004 1:57 AM (in response to 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


                  • Actions