3 Replies Latest reply on Aug 19, 2005 5:02 PM by Elias Ross

    New Oracle Application

    Wayne Painter Newbie

      I am tring to create my first application using JBoss and Oracle. When I depoly the simple application I get the following: java.lang.ClassNotFoundException: No ClassLoaders found for: oracle.jdbc.OracleDriver
      I have copied the classes12.jar into server/default/lib and modified the oracle-ds.xml, standardjaws.xml, jbosscmp-jdbc.xml, and the login-config.xml to use oracle with no change. I am doing a simple "SELECT * FROM database"
      Thanks a lot for your help.

        • 1. Re: New Oracle Application
          Alexandre Barbosa Newbie

          I think you need the ojdbc14.jar instead of the classes12.jar


          • 2. Re: New Oracle Application
            Wayne Painter Newbie

            I have copied the ojdbc14.jar in the JBoss lib directory and included it in the project build path. I now get just the java.lang.NoClassNotFoundException:No ClassLoaders found for: oracle.jdbc.driver.OracleDriver. I am the following code to try and connect:
            String driverName = "oracle.jdbc.driver.OracleDriver";

            String connectionURL "jdbc:oracle:thin:@****:1521:****";
            String uName = "****";
            String pWord = "****";
            String sqlStmt = "SELECT * FROM conn_info";
            con = DriverManager.getConnection(connectionURL, uName, pWord);
            }catch(Exception e){ e.printStackTrace();}
            Any idea as to why I'm getting this exception?
            Thanks for any help.

            • 3. Re: New Oracle Application
              Elias Ross Master

              If you're using a -ds.xml file, use JNDI to look up a javax.sql.DataSource object in the JNDI tree and connect using that.

              You should be able to check the conf. values from the JMX console.