Hi Serge,
what am I doing wrong?
Connect string:jdbc:db2://hector:6789/dbhec
Error:dbAccess:setConnection()::
Description=>com.ibm.db2.jcc.a.DisconnectException : A communication error
has been detected. Comm
unication protocol being used: Reply.fill(). Communication API being used:
InputStream.read(). Location where the error was detect
ed: Connection reset. Communication function detecting the error: *.
Protocol specific error codes(s) TCP/IP SOCKETS
com.ibm.db2.jcc.a.DisconnectException: A communication error has been
detected. Communication protocol being used: Reply.fill(). C
ommunication API being used: InputStream.read(). Location where the error
was detected: Connection reset. Communication function d
etecting the error: *. Protocol specific error codes(s) TCP/IP SOCKETS
at com.ibm.db2.jcc.c.a.a(a.java:417)
at com.ibm.db2.jcc.c.ab.b(ab.java:173)
at com.ibm.db2.jcc.c.ab.c(ab.java:219)
at com.ibm.db2.jcc.c.ab.c(ab.java:333)
at com.ibm.db2.jcc.c.ab.v(ab.java:1434)
at com.ibm.db2.jcc.c.bb.a(bb.java:37)
at com.ibm.db2.jcc.c.b.d(b.java:1096)
at com.ibm.db2.jcc.c.b.b(b.java:1011)
at com.ibm.db2.jcc.c.b.m(b.java:795)
at com.ibm.db2.jcc.c.b.a(b.java:565)
at com.ibm.db2.jcc.c.b.<init>(b.java:288)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:1 62)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at db.DbConnection.setConnection(DbConnection.java:87 )
at gui.Script.connectActionPerformed(Script.java:1208 )
at gui.Script$1.actionPerformed(Script.java:166)
at javax.swing.AbstractButton.fireActionPerformed(Unk nown 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.mouseRe leased(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(U nknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unkno wn 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.pumpOneEventForHierar chy(Unknown
Source)
at java.awt.EventDispatchThread.pumpEventsForHierarch y(Unknown
Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
Error:dbAccess:setConnection()::
Description=>com.ibm.db2.jcc.a.DisconnectException : A communication error
has been detected. Comm
unication protocol being used: Reply.fill(). Communication API being used:
InputStream.read(). Location where the error was detect
ed: Connection reset. Communication function detecting the error: *.
Protocol specific error codes(s) TCP/IP SOCKETS
com.ibm.db2.jcc.a.DisconnectException: A communication error has been
detected. Communication protocol being used: Reply.fill(). C
ommunication API being used: InputStream.read(). Location where the error
was detected: Connection reset. Communication function d
etecting the error: *. Protocol specific error codes(s) TCP/IP SOCKETS
at com.ibm.db2.jcc.c.a.a(a.java:417)
at com.ibm.db2.jcc.c.ab.b(ab.java:173)
at com.ibm.db2.jcc.c.ab.c(ab.java:219)
at com.ibm.db2.jcc.c.ab.c(ab.java:333)
at com.ibm.db2.jcc.c.ab.v(ab.java:1434)
at com.ibm.db2.jcc.c.bb.a(bb.java:37)
at com.ibm.db2.jcc.c.b.d(b.java:1096)
at com.ibm.db2.jcc.c.b.b(b.java:1011)
at com.ibm.db2.jcc.c.b.m(b.java:795)
at com.ibm.db2.jcc.c.b.a(b.java:565)
at com.ibm.db2.jcc.c.b.<init>(b.java:288)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:1 62)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at db.DbConnection.setConnection(DbConnection.java:87 )
at gui.Script.connectActionPerformed(Script.java:1210 )
at gui.Script$1.actionPerformed(Script.java:166)
at javax.swing.AbstractButton.fireActionPerformed(Unk nown 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.mouseRe leased(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(U nknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unkno wn 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.pumpOneEventForHierar chy(Unknown
Source)
at java.awt.EventDispatchThread.pumpEventsForHierarch y(Unknown
Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
For those of you playing with SQL Procedures, here's useful toy - I hope.
http://www-106.ibm.com/developerwork...dm-0406rielau/
Enjoy
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab