java连接数据库问题

kelly0924 2010-04-05 12:21:01
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unable to connect. Invalid URL.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at JdbcConnect.getConnection(JdbcConnect.java:9)
at UserLogin.checkUser(UserLogin.java:68)
at UserLogin.actionPerformed(UserLogin.java:56)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:6216)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
at java.awt.Component.processEvent(Component.java:5981)
at java.awt.Container.processEvent(Container.java:2041)
at java.awt.Component.dispatchEventImpl(Component.java:4583)
at java.awt.Container.dispatchEventImpl(Container.java:2099)
at java.awt.Component.dispatchEvent(Component.java:4413)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4556)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4220)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4150)
at java.awt.Container.dispatchEventImpl(Container.java:2085)
at java.awt.Window.dispatchEventImpl(Window.java:2475)
at java.awt.Component.dispatchEvent(Component.java:4413)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
java.lang.NullPointerException
at UserLogin.checkUser(UserLogin.java:70)
at UserLogin.actionPerformed(UserLogin.java:56)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:6216)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3265)
at java.awt.Component.processEvent(Component.java:5981)
at java.awt.Container.processEvent(Container.java:2041)
at java.awt.Component.dispatchEventImpl(Component.java:4583)
at java.awt.Container.dispatchEventImpl(Container.java:2099)
at java.awt.Component.dispatchEvent(Component.java:4413)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4556)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4220)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4150)
at java.awt.Container.dispatchEventImpl(Container.java:2085)
at java.awt.Window.dispatchEventImpl(Window.java:2475)
at java.awt.Component.dispatchEvent(Component.java:4413)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
报了这样的错,我把三个jar放在C:\Program Files\Java\jdk1.6.0_13\jre\lib\ext这个路径下,也打了SP3补丁,以前这样做能连上,但后来重装系统后重装SQL2000就连不了了,请指教 ,谢谢
...全文
200 18 打赏 收藏 转发到动态 举报
写回复
用AI写文章
18 条回复
切换为时间正序
请发表友善的回复…
发表回复
yangweiqing2 2010-04-09
  • 打赏
  • 举报
回复
可能是补丁没打好吧,我以前也遇到过这样的问题,但后来重新安装下sql2000,并重新打补丁就好了,
「已注销」 2010-04-09
  • 打赏
  • 举报
回复
http://javas.5d6d.com/forum-8-1.html Java核心语法在线视频 很好很强大 强烈推荐 免费资源
rumlee 2010-04-09
  • 打赏
  • 举报
回复
连接字符串的问题,确保数据库是正常的,再确保驱动和连接串没有问题就肯定可以了。
jmi443 2010-04-09
  • 打赏
  • 举报
回复
url非法啊,加上数据库名字(确保该数据库存在),并且导入正确的jar
LZHLINZH 2010-04-06
  • 打赏
  • 举报
回复
该用odbc连接试试,记得配数据源
zliuzz 2010-04-06
  • 打赏
  • 举报
回复
莫不是2005用了2000的jar包?
kelly0924 2010-04-05
  • 打赏
  • 举报
回复
以前没有数据库名字一样能连接得上,现在加了数据库名也一样连不上
xiaohuanjie 2010-04-05
  • 打赏
  • 举报
回复
con = DriverManager
.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433",
"tom", "123");


这里漏了数据库的名字,没有数据库的名字,怎么能连接上呢

con = DriverManager
.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;Databasename=XXXXX",
"tom", "123");
kelly0924 2010-04-05
  • 打赏
  • 举报
回复
public class JdbcConnect {
public static Connection getConnection() {
Connection con = null;
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con = DriverManager
.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433",
"tom", "123");
} catch (Exception e) {
e.printStackTrace();
}
return con;
}
}
xiaohuanjie 2010-04-05
  • 打赏
  • 举报
回复
Unable to connect. Invalid URL.

无法连接。无效的URL


把连接数据库的代码贴出来看看
kelly0924 2010-04-05
  • 打赏
  • 举报
回复
数据库建好了,单用数据库能查询出来的。。。
zuoguodang 2010-04-05
  • 打赏
  • 举报
回复
URL不对啊,已经提示出来了
hxj1225 2010-04-05
  • 打赏
  • 举报
回复
jdbc:jtds:sqlserver://127.0.0.1:1433/dbname
我是这样的url
snowhite88 2010-04-05
  • 打赏
  • 举报
回复
MsSQL的驱动(JAR)文件放在LIB里面没有?
tongjm2009 2010-04-05
  • 打赏
  • 举报
回复
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unable to connect. Invalid URL.

楼主这个错误提示应该是你的连接串有问题。
panpanguo 2010-04-05
  • 打赏
  • 举报
回复
数据库名字··········
justlearn 2010-04-05
  • 打赏
  • 举报
回复
con=DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=数据库名称;user=tom;password=123");
xiaohuanjie 2010-04-05
  • 打赏
  • 举报
回复
[Quote=引用 4 楼 kelly0924 的回复:]
以前没有数据库名字一样能连接得上,现在加了数据库名也一样连不上
[/Quote]




在你的SQL SERVER 里建好数据库没有,

62,621

社区成员

发帖
与我相关
我的任务
社区描述
Java 2 Standard Edition
社区管理员
  • Java SE
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧