我的sql server实例名是MYPC\SQLEXPRESS,我正在尝试创建一个jTDS连接字符串来连接到数据库'Blog‘。有没有人能帮我完成这件事?
我试着这样做:
DriverManager.getConnection("jdbc:jtds:sqlserver://127.0.0.1:1433/Blog", "user", "password");
我得到了这个:
java.sql.SQLException: Network error IOException: Connection refused: connect
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:395)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at SqlConnection.Connect(SqlConnection.java:19)
at main.main(main.java:11)
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:305)
at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:255)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:323)
... 6 more
发布于 2009-12-08 03:29:47
jdbc:jtds:sqlserver://x.x.x.x/database
将x.x.x.x
替换为您的SQL Server计算机的IP或主机名。
jdbc:jtds:sqlserver://MYPC/Blog;instance=SQLEXPRESS
或
jdbc:jtds:sqlserver://MYPC:1433/Blog;instance=SQLEXPRESS
如果您希望在连接字符串中也设置用户名和密码,而不是单独针对连接对象设置用户名和密码:
jdbc:jtds:sqlserver://MYPC/Blog;instance=SQLEXPRESS;user=foo;password=bar
(更新了我的错误信息,并添加了对instance syntax的引用)
发布于 2009-12-08 04:05:11
这是偶然发现的,但从错误消息的外观来看,sqlserver实例似乎没有在端口1433上运行,或者有什么东西阻塞了对该端口的请求。
https://stackoverflow.com/questions/1862283
复制相似问题