2 Replies Latest reply on Aug 30, 2004 11:43 PM by santhoshs13

    java.sql.SQLException: No suitable driver ( oracle)

    santhoshs13 Newbie

      Hi all,
      I am trying to deploy a java application on Jboss-3.2.5 with oracle database. I am getting this error, when i try to test the page that is trying to connect to the database. I am not a java professional, mainly a database architect. This is a adhoc requirement. I will list below the steps I have taken, maybe somebody can point out where I went wrong.

      1. The code snippets for connection are here.

      try{
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      conn=DriverManager.getConnection(jdbc:oracle:thin:@xxx.xxx.xxx.xxx:1521:usr,pwd,sid);

      }catch(Exception e1)
      {
      e1.printStackTrace();
      }

      2. Copy Oracle's JDBC driver .zip file /jdbc/lib/classes12.zip to the server/default/lib directory.
      3.modify the standardjbosscmp-jdbc.xml configuration file, setting the and <datasource-mapping> elements to use Oracle.
      4.modify login-config.xml to use Oracle.
      5. The DB is up and running.
      6. when compiled using ant, no error.
      7. when I start the jboss server, after copying the ear file, no error.
      8. But the follwing error comes up when i reach relevant page.
      .....................

      started notification, starting connectors
      2004-08-27 00:45:59,116 INFO [org.apache.coyote.http11.Http11Protocol] Starting Coyote HTTP/1.1 on http-0.0.0.0-8085
      2004-08-27 00:45:59,417 INFO [org.apache.jk.common.ChannelSocket] JK2: ajp13 listening on /0.0.0.0:8009
      2004-08-27 00:45:59,437 INFO [org.apache.jk.server.JkMain] Jk running ID=0 time=0/100 config=null
      <<ERROR starts here>>
      2004-08-27 00:46:00,228 INFO [STDOUT] java.sql.SQLException: No suitable driver
      2004-08-27 00:46:00,238 INFO [STDOUT] at java.sql.DriverManager.getConnection(DriverManager.java:532)
      2004-08-27 00:46:00,238 INFO [STDOUT] at java.sql.DriverManager.getConnection(DriverManager.java:193)
      2004-08-27 00:46:00,238 INFO [STDOUT] at com.e2e.ct.CTConnection.(CTConnection.java:27)
      2004-08-27 00:46:00,238 INFO [STDOUT] at com.e2e.ct.CTSecurity.verifyUser(CTSecurity.java:48)
      2004-08-27 00:46:00,238 INFO [STDOUT] at org.apache.jsp.verifyUser_jsp._jspService(verifyUser_jsp.java:74)
      2004-08-27 00:46:00,238 INFO [STDOUT] at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
      2004-08-27 00:46:00,238 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
      2004-08-27 00:46:00,238 INFO [STDOUT] at org.apache.jasper.servlet.
      .................


      Any advice is apreciated.Any steps to debug, to find where exactly is the problem. Is there a test methodology for this???