java连接数据库问题

[复制链接]
查看11 | 回复4 | 2010-6-9 02:04:11 | 显示全部楼层 |阅读模式
com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed. Error: Connection refused: connect. Please verify the connection properties and check that a SQL Server instance is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:130)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1195)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(SQLServerConnection.java:1054)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:758)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:842)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at lgcsgwxt.DBAccess.getConnection(DBAccess.java:17)
at lgcsgwxt.means.Select_Means.Select_User(Select_Means.java:224)
at lgcsgwxt.dialog.Admin.jButton1_actionPerformed(Admin.java:91)
at lgcsgwxt.dialog.Admin_jButton1_actionAdapter.actionPerformed(Admin.java:132)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
java.lang.NullPointerException
。。。。。。

回复

使用道具 举报

千问 | 2010-6-9 02:04:11 | 显示全部楼层
import java.sql.*;public class Connection_DB {public static void getDriver() {String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";try { Class.forName(driver);} catch (ClassNotFoundException e1) { System.out.println(e1.getMessage());} } public static Connection getcon() throws SQ
回复

使用道具 举报

千问 | 2010-6-9 02:04:11 | 显示全部楼层
看到一大堆异常就不想看,大概看了一下,连接端口失败,给你几个参考1.sqlserver正常启动没有2.采用的是直连还是桥梁,直连包引入没有,桥梁数据源配置正确否3.连接数据库代码是否写错
回复

使用道具 举报

千问 | 2010-6-9 02:04:11 | 显示全部楼层
貌似是数据库连接端口有问题,你百度下改SQLServer的端口号.
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行