大虾们过来帮帮忙啊,我是对着一视频配置oracle jdbc 驱动做的,他成功了,我却老报错。查了很久,还是不知道哪出问题啦!原Java代码如下,代码应该没问题!
package cc415.com;import java.sql.*;public class JDBCExample
{ public static void main(String[] args)
{
String driver = "oracle.jdbc.driver.OracleDrive";
String url = "jdbc:oracle:thin:@192.168.2.48:1521:ora92";
String username = "picservice";
String password = "gzepo";
String sql = "insert into users(username,password) values(?,?)";
try
{
Class.forName(driver);
// new oracle.jdbc.driver.OracleDriver();
Connection conn = DriverManager.getConnection(url, username,
password);
// Statement stat=conn.createStatement();
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, "cc");
pstmt.setString(2, "love77");
pstmt.executeUpdate(); pstmt.close();
conn.close(); } catch (ClassNotFoundException e)
{ e.printStackTrace();
} catch (SQLException e)
{ e.printStackTrace();
} }}报错如下:
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDrive
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:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:164)
at cc415.com.JDBCExample.main(JDBCExample.java:17)注:我在eclipse中加载了ojdbc6进去了,jodbc5也试过,都没用。
到网上查了下说什么加个classes12.jar /classes12.zip/ojdbc14.jar到classpath中,也试过。还是没用,
package cc415.com;import java.sql.*;public class JDBCExample
{ public static void main(String[] args)
{
String driver = "oracle.jdbc.driver.OracleDrive";
String url = "jdbc:oracle:thin:@192.168.2.48:1521:ora92";
String username = "picservice";
String password = "gzepo";
String sql = "insert into users(username,password) values(?,?)";
try
{
Class.forName(driver);
// new oracle.jdbc.driver.OracleDriver();
Connection conn = DriverManager.getConnection(url, username,
password);
// Statement stat=conn.createStatement();
PreparedStatement pstmt = conn.prepareStatement(sql);
pstmt.setString(1, "cc");
pstmt.setString(2, "love77");
pstmt.executeUpdate(); pstmt.close();
conn.close(); } catch (ClassNotFoundException e)
{ e.printStackTrace();
} catch (SQLException e)
{ e.printStackTrace();
} }}报错如下:
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDrive
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:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:164)
at cc415.com.JDBCExample.main(JDBCExample.java:17)注:我在eclipse中加载了ojdbc6进去了,jodbc5也试过,都没用。
到网上查了下说什么加个classes12.jar /classes12.zip/ojdbc14.jar到classpath中,也试过。还是没用,
解决方案 »
- oracle 中如何查看某个表所涉及的存储过程????
- 导入oracle备份数据dmp后序列翻倍增加了。。
- oracle 10g VC6 + OCCI 访问服务器发生ORA-24960: 属性 OCI_ATTR_USERNAME 的长度大于最大允许长度 255
- oracle 10g 的TNSListener无法启动
- 做查询时,如果字段a为空则显示“空值” 如果不为空则显示“有值”,请问要怎么写?谢谢!!!
- 关于oracle结构方面(50)
- 把整数分解成字符串的简单问题
- 哪里可以免费下载到oracle design和developper2000?
- 请教oracle数据库服务器分区规划,请各位兄弟姐姐赐教,万分感谢!给分必须的
- Oracle分页查询与解决方案
- oracle ora-12535 tns operation time out
- 怎样给非DBA用户授dba_user表的权限
<?xml version="1.0" encoding="UTF-8"?>
<classpath>
<classpathentry kind="src" path="src"/>
<classpathentry kind="con" path="org.eclipse.jdt.launching.JRE_CONTAINER"/>
<classpathentry kind="con" path="com.genuitec.eclipse.j2eedt.core.J2EE14_CONTAINER"/>
<classpathentry kind="con" path="melibrary.com.genuitec.eclipse.cross.easystruts.eclipse.STRUTS12_CONTAINER"/>
<classpathentry kind="lib" path="WebRoot/WEB-INF/lib/jstl.jar"/>
<classpathentry kind="lib" path="WebRoot/WEB-INF/lib/standard.jar"/>
<classpathentry kind="lib" path="lib/swing-layout-1.0.3.jar"/>
<classpathentry kind="lib" path="lib/AbsoluteLayout.jar"/>
<classpathentry kind="lib" path="F:/oracle/product/10.2.0/db_1/jdbc/lib/classes12.jar"/>
<classpathentry kind="output" path="WebRoot/WEB-INF/classes"/>
</classpath>
看下你的classpath文件里有没有]<classpathentry kind="lib" path="x:/classes12.jar"/>之类的东西 X是你class12.jar的路径
classpathentry kind 是什么,从没见过
x:/classes12.jar是放到path里吗,不是放到classpath啊我照你的试过,还是没用。
其实是“OracleDrive”少了个r而已,哎,编程要细心啊,不过其实一楼的也说到了我的问题,不过,说的太简单了,对我这个初学者当时还不知道说什么意思,呵呵。也谢谢一楼的啦,结贴楼。