blackhorse_zou
发贴: 17
积分: 1
|
于 2005-10-14 10:21
请尽量使用准确的文字描述作为标题 若新帖再無恰当标题,可能会被刪除
Original subject : 求助
我下载了一个sql server 2000 driver for jdbc,按照上面的步骤安装。 程序运行后,控制台结果出现了以下的错误提示:
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver at sun.applet.AppletClassLoader.findClass(AppletClassLoader.java:162) at java.lang.ClassLoader.loadClass(ClassLoader.java:289) at sun.applet.AppletClassLoader.loadClass(AppletClassLoader.java:123) at java.lang.ClassLoader.loadClass(ClassLoader.java:235) at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Class.java:141) at MyInquireApplet.actionPerformed(MyInquireApplet.java:55) at java.awt.Button.processActionEvent(Button.java:382) at java.awt.Button.processEvent(Button.java:350) at java.awt.Component.dispatchEventImpl(Component.java:3615) at java.awt.Component.dispatchEvent(Component.java:3477) at java.awt.EventQueue.dispatchEvent(EventQueue.java:456) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137) at java.awt.EventDispatchThread.run(EventDispatchThread.java:100) Caused by: java.io.FileNotFoundException: C:\Documents and Settings\Administrator\桌面\com\microsoft\jdbc\sqlserver\SQLServerDriver.class (系统找不到指定的文件。) at java.io.FileInputStream.open(Native Method) at java.io.FileInputStream.<init>(FileInputStream.java:106) at java.io.FileInputStream.<init>(FileInputStream.java:66) at sun.net.www.protocol.file.FileURLConnection.connect(FileURLConnection.java:69) at sun.net.www.protocol.file.FileURLConnection.getInputStream(FileURLConnection.java:156) at sun.applet.AppletClassLoader.getBytes(AppletClassLoader.java:274) at sun.applet.AppletClassLoader.access$100(AppletClassLoader.java:4) at sun.applet.AppletClassLoader$1.run(AppletClassLoader.java:152) at java.security.AccessController.doPrivileged(Native Method) at sun.applet.AppletClassLoader.findClass(AppletClassLoader.java:149) ... 17 more
从错误提示看是因为:classpath的设置没有对! 可是我进入我电脑的环境变量设置里面没有classpath这一项,我自己添加了一个,按照说明输入了变量:安装路径+lib\msbase.jar lib\msutil.jar lib\mssqlserver.jar 但是仍然不行!后来我进入注册表找到了jvm的classpath,不知该如何添加,于是直接把路径添加在后面!可是还是不行! 那位前辈帮帮我!!!! (注:我编译的是一个applet,是不是applet不能这样连接数据库?新手,请不要笑话我这么简单的问题都不懂!部分代码:
ta.append('\n'+"OBJECTID"+" "+"Id"+" "+"名称"+" "+"Z值"+" "+"T值"+" "+"X坐标"+" "+"Y坐标"+" "+"XYD"+" "+"MD"+" "+"01"+" "+"02"+" "+"图形属性"+'\n'); String connectionURL="jdbc:microsoft:sqlserver://hostname:5151;DatabaseName=sde"; String name,zchar,tchar,mdchar,charxyd,char01,char02; int objid,id,shape; float x,y; ta.append("准备执行数据库查询命令"+'\n'); try{ ta.append("开始建立数据库连接"+'\n'); Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); ta.append("建立数据库连接成功"+'\n'); ........................................................... ...........................................................
catch(Exception ee){ ee.printStackTrace(); ta.append("数据库连接失败");
执行结果为:
OBJECTID Id 名称 Z值 T值 X坐标 Y坐标 XYD MD 01 02 图形属性 准备执行数据库查询命令 开始建立数据库连接 数据库连接失败
why edited on 2005-10-14 20:01
|