Hi, guys...
I met a problem recently, that is, my
JSP file cannot connect to my localhost oracle XE 10g db.
below is part of my code:
Driver driver=null;
public Connection getConnect(){
if(driver==null)
Class.forName("oracle.jdbc.OracleDriver");
Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@//localhost:1521/XE","secret","secret");
return conn;
}
I started tomcat7.0.5, and then I tried to view that JSP file, but I get the problem.
An error occurred at line: 12 in the jsp file: /testJsp.jsp
Unhandled exception type ClassNotFoundException
9:
10: public Connection getConnect(){
11: if(driver==null)
12: Class.forName("oracle.jdbc.OracleDriver");
13: Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@//localhost:1521/XE","SYSTEM","z_blue1009");
14: return conn;
An error occurred at line: 13 in the jsp file: /testJsp.jsp
Unhandled exception type SQLException
10: public Connection getConnect(){
11: if(driver==null)
12: Class.forName("oracle.jdbc.OracleDriver");
13: Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@//localhost:1521/XE","SYSTEM","z_blue1009");
14: return conn;
15: }
I have tried many ways to solve the problem, yet I cannot solve the problem.
What I have tried:
1. Set the ClassPath (but my laptop is win7, and there is no ClassPath in the Environment Variables)
2. copy the ojdbc14.jar to WEB-INF/lib (but there is no lib folder in the WEB-INF, I create it and paste the jar file...not working)
3. copy the ojdbc14.jar to [JAVA-HOME]\jre\lib\ext\...not working
4. change the class path from oracle.jdbc.driver.OracleDriver to oracle.jdbc.OracleDriver...not working
5. change the URL from
jdbc:oracle:thin:@localhost:1521:xe to jdbc:oracle:thin:@//localhost:1521/XE...not working
But I didn't meet such problem before when I'm using the older version of XAMPP.
What is the problem actually and how to solve it? Thanks