db2连接数据库异常"com.ibm.db2.jcc.c.DisconnectException"

最近没事搞搞db2的数据，首先安装。下载了一个数据库的客户端。squirrel-sql这个客户端还是比较好用的。是一个免费的客户端。地址我就不贴了。

好了，进入正题。

 

db2和squirrel-sql都安装好之后，遇到一个让我郁闷了两天的问题。在用客户端连接db2数据库的时候出现异常。异常信息是：

com.ibm.db2.jcc.c.DisconnectException: [ibm][db2][jcc][t4][2030][11211] A communication error has been detected. Communication protocol being used: TCP/IP.
Communication API being used: SOCKETS.  Location where the error was detected: Reply.fill().
Communication function detecting the error: InputStream.read().  Protocol specific error codes Insufficient data, * , 0.  Message: null
	at com.ibm.db2.jcc.a.a.a(a.java:366)
	at com.ibm.db2.jcc.a.ab.b(ab.java:219)
	at com.ibm.db2.jcc.a.ab.c(ab.java:237)
	at com.ibm.db2.jcc.a.ab.c(ab.java:348)
	at com.ibm.db2.jcc.a.ab.v(ab.java:1134)
	at com.ibm.db2.jcc.a.bb.a(bb.java:42)
	at com.ibm.db2.jcc.a.b.j(b.java:1254)
	at com.ibm.db2.jcc.a.b.b(b.java:1128)
	at com.ibm.db2.jcc.a.b.b(b.java:711)
	at com.ibm.db2.jcc.a.b.a(b.java:697)
	at com.ibm.db2.jcc.a.b.a(b.java:378)
	at com.ibm.db2.jcc.a.b.<init>(b.java:316)
	at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:174)
	at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)
	at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.execute(OpenConnectionCommand.java:97)
	at net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.run(ConnectToAliasCommand.java:281)
	at net.sourceforge.squirrel_sql.client.mainframe.action.ConnectToAliasCommand$SheetHandler.performOK(ConnectToAliasCommand.java:238)
	at net.sourceforge.squirrel_sql.client.gui.db.ConnectionInternalFrame.connect(ConnectionInternalFrame.java:311)
	at net.sourceforge.squirrel_sql.client.gui.db.ConnectionInternalFrame.access$300(ConnectionInternalFrame.java:56)
	at net.sourceforge.squirrel_sql.client.gui.db.ConnectionInternalFrame$MyOkClosePanelListener.okPressed(ConnectionInternalFrame.java:461)
	at net.sourceforge.squirrel_sql.client.gui.OkClosePanel.fireButtonPressed(OkClosePanel.java:148)
	at net.sourceforge.squirrel_sql.client.gui.OkClosePanel.access$100(OkClosePanel.java:33)
	at net.sourceforge.squirrel_sql.client.gui.OkClosePanel$1.actionPerformed(OkClosePanel.java:174)
	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.dispatchEventImpl(Unknown Source)
	at java.awt.EventQueue.access$200(Unknown Source)
	at java.awt.EventQueue$3.run(Unknown Source)
	at java.awt.EventQueue$3.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
	at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
	at java.awt.EventQueue$4.run(Unknown Source)
	at java.awt.EventQueue$4.run(Unknown Source)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source)
	at java.awt.EventQueue.dispatchEvent(Unknown Source)
	at net.sourceforge.squirrel_sql.client.Main$1.dispatchEvent(Main.java:93)
	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)

 当时我就郁闷了，带着沉重的心情上了百度、谷歌，实验了n种方法，最终没能解决这个问题。

后来发怒了，我写了一个jdbc连接数据库，出现另外一个问题：

连接失败！
com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2030][11211][4.16.53] 在对连接的底层 socket、socket input stream 或 socket output stream 执行操作期间
发生通信错误。错误位置：Reply.fill() - insufficient data (-1)。消息：数据不足。 ERRORCODE=-4499, SQLSTATE=08001
	at com.ibm.db2.jcc.am.fd.a(fd.java:320)
	at com.ibm.db2.jcc.t4.a.a(a.java:526)
	at com.ibm.db2.jcc.t4.a.a(a.java:510)
	at com.ibm.db2.jcc.t4.a.a(a.java:505)
	at com.ibm.db2.jcc.t4.x.b(x.java:294)
	at com.ibm.db2.jcc.t4.x.c(x.java:320)
	at com.ibm.db2.jcc.t4.x.c(x.java:433)
	at com.ibm.db2.jcc.t4.x.v(x.java:1201)
	at com.ibm.db2.jcc.t4.y.a(y.java:51)
	at com.ibm.db2.jcc.t4.b.c(b.java:1353)
	at com.ibm.db2.jcc.t4.b.b(b.java:1225)
	at com.ibm.db2.jcc.t4.b.b(b.java:793)
	at com.ibm.db2.jcc.t4.b.a(b.java:765)
	at com.ibm.db2.jcc.t4.b.a(b.java:423)
	at com.ibm.db2.jcc.t4.b.a(b.java:398)
	at com.ibm.db2.jcc.t4.b.<init>(b.java:336)
	at com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:233)
	at com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:199)
	at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:474)
	at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:115)
	at java.sql.DriverManager.getConnection(DriverManager.java:582)
	at java.sql.DriverManager.getConnection(DriverManager.java:185)
	at com.DBconn.DBconnect.getConnection(DBconnect.java:36)
	at com.DBconn.DBconnect.main(DBconnect.java:49)
Exception in thread "main" java.lang.NullPointerException
	at com.DBconn.DBconnect.main(DBconnect.java:51)

 这就让我更加的郁闷了。一个错误还没有解决，新的错误又来了。然后我就死马当活马医。一个个用户名、密码实验，一个个ip实现。黄天不负有心人，最后让我试出来了。不过我也吐血了。

我丢：竟然最终原因就是ip有问题。不能用127.0.01、localhost访问。最终我改成本机的ip后，解决了。我也吐血了。

 

推荐一个db2的配置：http://publib.boulder.ibm.com/tividd/td/ITMFTP/GC23-4801-00/zh_CN/HTML/WTPImst30.htm

配置查询：http://iamwave.iteye.com/blog/649730
db2数据库的学习中心：http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/index.jsp

 

评论

2 楼 zhengyongqianluck 2014-10-01  

确实改为本地ip连接就可以了

1 楼 feihumingyue 2013-09-11  

very good.找了好几天，没找到解决方法，楼主好样的！