java.sql.SQLException: No suitable driver ( oracle)
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???
