myeclipse连接oracle时出现:java.lang.ClassNotFoundException: sun.jdbc.driver.OracleDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at htmlBox.test1.main(test1.java:12)Oracle10G中提供classes12.jar和ojdbe14.jar这两驱动包都引入了,为什么还不行啊?测试代码如下:
package htmlBox;
import java.sql.*;
public class test1{
public static void main(String[] args)
{
try{
Class.forName("sun.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:myoracle", "scott", "tiger");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM scott.emp");
while(rs.next()){
System.out.println(rs.getInt(1) + "\t" + rs.getString(2));
}
}catch(Exception err){
System.out.println(err.toString());
}
}
}oracleoracle10g
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:252)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at htmlBox.test1.main(test1.java:12)Oracle10G中提供classes12.jar和ojdbe14.jar这两驱动包都引入了,为什么还不行啊?测试代码如下:
package htmlBox;
import java.sql.*;
public class test1{
public static void main(String[] args)
{
try{
Class.forName("sun.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:myoracle", "scott", "tiger");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM scott.emp");
while(rs.next()){
System.out.println(rs.getInt(1) + "\t" + rs.getString(2));
}
}catch(Exception err){
System.out.println(err.toString());
}
}
}oracleoracle10g
改为Class.forName("oracle.jdbc.driver.OracleDriver");
2、检查下看都对不dbc:oracle:thin:@localhost:1521:myoracle ?
3、引入ojdbc14.jar文件
远程给你看看
远程给你看看问题解决了,主要是我刚才引入了一个ojbdc6.jar包有问题,没有删除彻底所致。还是很谢谢你啊!
谢谢给我帮助的大侠们,谢谢你们