× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. JAVA400-L
  3. October 2002

native DB/2 driver errors

This is a multi-part message in MIME format.
--

Hello everybody,

I've encountered following problems in IBM native DB/2 driver at AS/400..Our
customer is in France thus some messages are in French, but I hope the
picture is clear

I've shown this to our local IBM (Netherlands) but got no meaninful answer.

Also, all the latest PTFs were applied before, namely latest Java Group PTF
(SF99068) and it didn't help at all. The same software with same
configuration on a couple of another AS/400 machines runs without any
problems at all.

The problem machine is model 270, feature 22A5, processor group P10 with
OS400 V4R5.

I don't put much expectations on this post, but just if somebody have got
some ideas - why does it happen - please let me know.


Error 1. It happens when trying to open a connection with 50% probability

Java stack trace:
--------------------
com.ibm.db2.jdbc.app.DB2SQLException2: Erreur système SQL.
java/lang/Throwable.<init>(Ljava/lang/String;)V+4 (Throwable.java:94)
java/sql/SQLException.<init>(Ljava/lang/String;Ljava/lang/String;I)V+1
(SQLException.java:43)
com/ibm/db2/jdbc/app/DB2SQLException2.<init>(Ljava/lang/String;Ljava/lang/St
ring;I[B)V+1 (DB2SQLException2.java:281)
com/ibm/db2/jdbc/app/DB2ConnectionRuntimeImpl.connect(Ljava/lang/String;Ljav
a/lang/String;Ljava/lang/String;Ljava/lang/
ng;III)I+80 (DB2ConnectionRuntimeImpl.java:100)
com/ibm/db2/jdbc/app/DB2Connection.<init>(Ljava/lang/String;Ljava/util/Prope
rties;Z)V+177 (DB2Connection.java:216)
com/ibm/db2/jdbc/app/DB2Driver.handleURLProcessing(Ljava/lang/String;Ljava/u
til/Properties;Z)Z+792 (DB2Driver.java:952)
com/ibm/db2/jdbc/app/DB2Driver.connect(Ljava/lang/String;Ljava/util/Properti
es;)Ljava/sql/Connection;+67 (DB2Driver.java:154)

JDBC trace:
---------------
see attachment, jdbc_err1.txt

Error 1. It happens when running a select query, with ~20% probability.

Java stack trace:
---------------------
2002-10-21 16:34:47,480 [1035218083561] FATAL
com.vocognition.talkface.util.VocoException - java.lang.UnknownError
com/ibm/db2/jdbc/app/DB2PreparedStatementRuntimeImpl.execute(II)I+40
(DB2PreparedStatementRuntimeImpl.java:387)
com/ibm/db2/jdbc/app/DB2PreparedStatement.execute()Z+28
(DB2PreparedStatement.java:1386)
com/ibm/db2/jdbc/app/DB2PreparedStatement.executeQuery()Ljava/sql/ResultSet;
+12 (DB2PreparedStatement.java:239)
com/vocognition/talkface/database/Query.open()V+0 (Query.java:263)
com/vocognition/talkface/wms/infologold/gold/GoldPersistenceHandler.retrieve
AvailablePrinters()[Ljava/lang/String;+0 (GoldPersistenceHandler.java:273)
com/vocognition/talkface/wms/infologold/PrinterListHandler.service(Lcom/voco
gnition/talkface/pickmanager/TalkmanConnection;Lcom/vocognition/talkface/wms
/infologold/AbstractInfologoldPersistenceHandler;)V+0
(PrinterListHandler.java:19)
com/vocognition/talkface/wms/infologold/InfologoldRequestHandler.service(Lco
m/vocognition/talkface/pickmanager/TalkmanConnection;Lcom/vocognition/talkfa
ce/database/PersistenceHandler;)V+0 (InfologoldRequestHandler.java:15)
com/vocognition/talkface/pickmanager/PMRequestDispatcher.service(Ljava/net/S
ocket;)V+0 (PMRequestDispatcher.java:58)
com/vocognition/talkface/socketserver/Listener.handleRequest()V+0
(Listener.java:118)
com/vocognition/talkface/socketserver/Listener.run()V+0 (Listener.java:61)

Job log:
---------
Application error. MCH3601 unmonitored by QSQCLI at statement 0000004041,
instruction X'0000'.
Pointeur non défini pour position mémoire référencée.
Application error. MCH3601 unmonitored by QSQCLI at statement 0000004041,
instruction X'0000'.

JDBC trace:
---------------
see attachment, jdbc_err2.txt

Best regards,
Timur Evdokimov
VoCognition B.V.
Phone: +31-(0) 20-800-4060, Fax: +31-(0) 20-800-4079
--
Normal SELECT:

Jdbc: 1035459246.90240 0000003f: > 
DB2ConnectionRuntimeImpl@-2009258195.setConnectOption(4, 10003, 1)
Jdbc: 1035459252.627536 0000003a: > DB2Connection@721597960.setAutoCommit(false)
Jdbc: 1035459252.628208 0000003a: > 
DB2ConnectionRuntimeImpl@-2009258291.setConnectOption(5, 10003, 0)
Jdbc: 1035459252.629256 0000003a: > 
DB2Connection@721597960.prepareStatement(Select SSAMJ1 From GEPPARAM Where 
TABLEX = 'IME' and POSTEX is not null order by SSAMJ1

)
Jdbc: 1035459252.629720 0000003a: > 
DB2Connection@721597960.prepareStatement(Select SSAMJ1 From GEPPARAM Where 
TABLEX = 'IME' and POSTEX is not null order by SSAMJ1

, 1003, 1007)
Jdbc: 1035459252.630520 0000003a:   DB2Connection@721597960 prepareStatement(): 
Transactional=false
Jdbc: 1035459252.631472 0000003a: > DB2Connection@721597960.toString()
Jdbc: 1035459252.632024 0000003a: > 
DB2PreparedStatement@721670152.<init>(ASB20, 1003, 1007, false)
Jdbc: 1035459252.632608 0000003a: > 
DB2StatementRuntimeImpl@-2009113779.<init>(DB2PreparedStatement@721670152)
Jdbc: 1035459252.633328 0000003a: > 
DB2PreparedStatement@721670152.getResultSetType(1003, 1007)
Jdbc: 1035459252.633984 0000003a: > 
DB2StatementRuntimeImpl@-2009113779.allocStmt(5, 1026, 0, 0)
Jdbc: 1035459252.635064 0000003a: > 
DB2PreparedStatement@721670152.generateStatementName()
Jdbc: 1035459252.636240 0000003a: > 
DB2Connection@721597960.addStatement(STMT00059)
Jdbc: 1035459252.636728 0000003a: > 
DB2PreparedStatement@721670152.getStatementHandle()
Jdbc: 1035459252.637080 0000003a: < DB2PreparedStatement@721670152.<init>( 
hDbc=5, hStmt=59 )
Jdbc: 1035459252.637504 0000003a: > DB2Connection@721597960.toString()
Jdbc: 1035459252.637872 0000003a: > 
DB2PreparedStatement@721670152.<init>(Select SSAMJ1 From GEPPARAM Where TABLEX 
= 'IME' and POSTEX is not null order by SSAMJ1, ASB20, 1003, 1007, false)
Jdbc: 1035459252.638264 0000003a: > 
DB2PreparedStatementRuntimeImpl@-2009113843.<init>(DB2PreparedStatement@721670152)
Jdbc: 1035459252.638608 0000003a: > 
DB2PreparedStatementRuntimeImpl@-2009113843.<init>(DB2PreparedStatement@721670152)
Jdbc: 1035459252.638920 0000003a: > 
DB2PreparedStatement@721670152.determineBlockingUse()
Jdbc: 1035459252.639552 0000003a: > 
DB2PreparedStatementRuntimeImpl@-2009113843.prepare(59, Select SSAMJ1 >From 
GEPPARAM Where TABLEX = 'IME' and POSTEX is not null order by SSAMJ1, 3, null, 
null, 1, 32)
Jdbc: 1035459252.645800 0000003a: > 
DB2ResultSetMetaData@1692968895.<init>(STMT00059, null, false)
Jdbc: 1035459252.646544 0000003a: > 
DB2ResultSetMetaDataRuntimeImpl@-2009113939.<init>()
Jdbc: 1035459252.647016 0000003a: > 
DB2ResultSetMetaDataRuntimeImpl@-2009113939.getColumnCount(59)
Jdbc: 1035459252.648192 0000003a: > 
DB2PreparedStatement@721670152.executeQuery()
Jdbc: 1035459252.648712 0000003a: > DB2PreparedStatement@721670152.execute()
Jdbc: 1035459252.649192 0000003a: > 
DB2PreparedStatement@721670152.commonPreExec()
Jdbc: 1035459252.649776 0000003a: > 
DB2PreparedStatementRuntimeImpl@-2009113843.execute(59, 3)
Jdbc: 1035459252.676696 0000003a: > 
DB2PreparedStatement@721670152.commonPostExec(1)
Jdbc: 1035459252.677256 0000003a: > 
DB2PreparedStatement@721670152.setupResultSet(false)
Jdbc: 1035459252.677728 0000003a: > DB2ResultSet@55800721.<init>(STMT00059, 
true, false)
Jdbc: 1035459252.678256 0000003a: > 
DB2ResultSet@55800721.commonSetup(STMT00059, true, false, true)
Jdbc: 1035459252.678872 0000003a: > 
DB2ResultSetRuntimeImpl@-2009114355.<init>(DB2ResultSet@55800721)
Jdbc: 1035459252.679424 0000003a: > DB2ResultSet@55800721.toString()
Jdbc: 1035459252.679960 0000003a: > 
DB2ResultSetMetaData@1692968415.<init>(STMT00059, null, false)
Jdbc: 1035459252.680448 0000003a: > 
DB2ResultSetMetaDataRuntimeImpl@-2009114387.<init>()
Jdbc: 1035459252.680944 0000003a: > DB2ResultSet@55800721.handleFetch(1, 0)
Jdbc: 1035459252.681496 0000003a: > 
DB2ResultSetRuntimeImpl@-2009114355.extendedFetch(59)
Jdbc: 1035459252.685304 0000003a: > 
DB2PreparedStatement@721670152.getCursorName()
Jdbc: 1035459252.686088 0000003a: > 
DB2StatementRuntimeImpl@-2009113779.getCursorName(59)
Jdbc: 1035459252.687288 0000003a: > DB2ResultSet@55800721.next()
Jdbc: 1035459252.687936 0000003a: > 
DB2ResultSet@55800721.beforePositioning(false)
Jdbc: 1035459252.688528 0000003a: > DB2ResultSet@55800721.getInt(1)
Jdbc: 1035459252.689104 0000003a: > DB2ResultSet@55800721.beforeGetXxx(1)
Jdbc: 1035459252.689616 0000003a: > 
DB2ResultSetMetaData@1692968415.getColumnType(1)
Jdbc: 1035459252.690072 0000003a: > 
DB2ResultSetMetaData@1692968415.checkRSMDRequestForErrors(1)
Jdbc: 1035459252.690648 0000003a: > 
DB2ResultSetMetaDataRuntimeImpl@-2009114387.getColumnType(59, 1)
Jdbc: 1035459252.691152 0000003a: > DB2ResultSet@55800721.getValue(1,2)
Jdbc: 1035459252.691608 0000003a: > DB2ResultSet@55800721.getNumericOpt(1)
Jdbc: 1035459252.692144 0000003a: > 
DB2ResultSetRuntimeImpl@-2009114355.getNumeric(59, 1)
Jdbc: 1035459252.692920 0000003a: > DB2ResultSet@55800721.testDataTruncation(1, 
0)
Jdbc: 1035459252.693592 0000003a: > DB2ResultSet@55800721.next()
Jdbc: 1035459252.694128 0000003a: > 
DB2ResultSet@55800721.beforePositioning(false)
Jdbc: 1035459252.694640 0000003a: > DB2ResultSet@55800721.handleFetch(1, 0)
Jdbc: 1035459252.695256 0000003a: > 
DB2ResultSetRuntimeImpl@-2009114355.extendedFetch(59)
Jdbc: 1035459252.695864 0000003a: > DB2ResultSet@55800721.getInt(1)
Jdbc: 1035459252.696408 0000003a: > DB2ResultSet@55800721.beforeGetXxx(1)
Jdbc: 1035459252.696944 0000003a: > 
DB2ResultSetMetaData@1692968415.getColumnType(1)
Jdbc: 1035459252.697416 0000003a: > 
DB2ResultSetMetaData@1692968415.checkRSMDRequestForErrors(1)
Jdbc: 1035459252.697936 0000003a: > DB2ResultSet@55800721.getValue(1,2)
Jdbc: 1035459252.698456 0000003a: > DB2ResultSet@55800721.getNumericOpt(1)
Jdbc: 1035459252.698928 0000003a: > 
DB2ResultSetRuntimeImpl@-2009114355.getNumeric(59, 1)
Jdbc: 1035459252.699544 0000003a: > DB2ResultSet@55800721.testDataTruncation(1, 
0)
Jdbc: 1035459252.700096 0000003a: > DB2ResultSet@55800721.next()
Jdbc: 1035459252.700576 0000003a: > 
DB2ResultSet@55800721.beforePositioning(false)
Jdbc: 1035459252.701120 0000003a: > DB2ResultSet@55800721.handleFetch(1, 0)
Jdbc: 1035459252.701584 0000003a: > 
DB2ResultSetRuntimeImpl@-2009114355.extendedFetch(59)
Jdbc: 1035459252.702144 0000003a: > DB2ResultSet@55800721.getInt(1)
Jdbc: 1035459252.702696 0000003a: > DB2ResultSet@55800721.beforeGetXxx(1)
Jdbc: 1035459252.703176 0000003a: > 
DB2ResultSetMetaData@1692968415.getColumnType(1)
Jdbc: 1035459252.703624 0000003a: > 
DB2ResultSetMetaData@1692968415.checkRSMDRequestForErrors(1)
Jdbc: 1035459252.704152 0000003a: > DB2ResultSet@55800721.getValue(1,2)
Jdbc: 1035459252.704648 0000003a: > DB2ResultSet@55800721.getNumericOpt(1)
Jdbc: 1035459252.705136 0000003a: > 
DB2ResultSetRuntimeImpl@-2009114355.getNumeric(59, 1)
Jdbc: 1035459252.705728 0000003a: > DB2ResultSet@55800721.testDataTruncation(1, 
0)
Jdbc: 1035459252.706264 0000003a: > DB2ResultSet@55800721.next()
Jdbc: 1035459252.706728 0000003a: > 
DB2ResultSet@55800721.beforePositioning(false)
Jdbc: 1035459252.707208 0000003a: > DB2ResultSet@55800721.handleFetch(1, 0)
Jdbc: 1035459252.707680 0000003a: > 
DB2ResultSetRuntimeImpl@-2009114355.extendedFetch(59)
Jdbc: 1035459252.708264 0000003a: > DB2ResultSet@55800721.getInt(1)
Jdbc: 1035459252.708776 0000003a: > DB2ResultSet@55800721.beforeGetXxx(1)
Jdbc: 1035459252.709256 0000003a: > 
DB2ResultSetMetaData@1692968415.getColumnType(1)
Jdbc: 1035459252.709712 0000003a: > 
DB2ResultSetMetaData@1692968415.checkRSMDRequestForErrors(1)
Jdbc: 1035459252.710240 0000003a: > DB2ResultSet@55800721.getValue(1,2)
Jdbc: 1035459252.710744 0000003a: > DB2ResultSet@55800721.getNumericOpt(1)
Jdbc: 1035459252.711200 0000003a: > 
DB2ResultSetRuntimeImpl@-2009114355.getNumeric(59, 1)
Jdbc: 1035459252.711872 0000003a: > DB2ResultSet@55800721.testDataTruncation(1, 
0)
Jdbc: 1035459252.712464 0000003a: > DB2ResultSet@55800721.next()
Jdbc: 1035459252.713048 0000003a: > 
DB2ResultSet@55800721.beforePositioning(false)
Jdbc: 1035459252.713584 0000003a: > DB2ResultSet@55800721.handleFetch(1, 0)
Jdbc: 1035459252.714048 0000003a: > 
DB2ResultSetRuntimeImpl@-2009114355.extendedFetch(59)
Jdbc: 1035459252.714592 0000003a: > DB2ResultSet@55800721.getInt(1)
Jdbc: 1035459252.715104 0000003a: > DB2ResultSet@55800721.beforeGetXxx(1)
Jdbc: 1035459252.715656 0000003a: > 
DB2ResultSetMetaData@1692968415.getColumnType(1)
Jdbc: 1035459252.716264 0000003a: > 
DB2ResultSetMetaData@1692968415.checkRSMDRequestForErrors(1)
Jdbc: 1035459252.716848 0000003a: > DB2ResultSet@55800721.getValue(1,2)
Jdbc: 1035459252.717448 0000003a: > DB2ResultSet@55800721.getNumericOpt(1)
Jdbc: 1035459252.717992 0000003a: > 
DB2ResultSetRuntimeImpl@-2009114355.getNumeric(59, 1)
Jdbc: 1035459252.718576 0000003a: > DB2ResultSet@55800721.testDataTruncation(1, 
0)
Jdbc: 1035459252.719136 0000003a: > DB2ResultSet@55800721.next()
Jdbc: 1035459252.719688 0000003a: > 
DB2ResultSet@55800721.beforePositioning(false)
Jdbc: 1035459252.720200 0000003a: > DB2ResultSet@55800721.handleFetch(1, 0)
Jdbc: 1035459252.720712 0000003a: > 
DB2ResultSetRuntimeImpl@-2009114355.extendedFetch(59)
Jdbc: 1035459252.721240 0000003a: > DB2ResultSet@55800721.getInt(1)
Jdbc: 1035459252.721840 0000003a: > DB2ResultSet@55800721.beforeGetXxx(1)
Jdbc: 1035459252.722528 0000003a: > 
DB2ResultSetMetaData@1692968415.getColumnType(1)
Jdbc: 1035459252.723040 0000003a: > 
DB2ResultSetMetaData@1692968415.checkRSMDRequestForErrors(1)
Jdbc: 1035459252.723528 0000003a: > DB2ResultSet@55800721.getValue(1,2)
Jdbc: 1035459252.723976 0000003a: > DB2ResultSet@55800721.getNumericOpt(1)
Jdbc: 1035459252.724432 0000003a: > 
DB2ResultSetRuntimeImpl@-2009114355.getNumeric(59, 1)
Jdbc: 1035459252.725136 0000003a: > DB2ResultSet@55800721.testDataTruncation(1, 
0)
Jdbc: 1035459252.725728 0000003a: > DB2ResultSet@55800721.next()
Jdbc: 1035459252.726312 0000003a: > 
DB2ResultSet@55800721.beforePositioning(false)
Jdbc: 1035459252.726824 0000003a: > DB2ResultSet@55800721.handleFetch(1, 0)
Jdbc: 1035459252.727328 0000003a: > 
DB2ResultSetRuntimeImpl@-2009114355.extendedFetch(59)
Jdbc: 1035459252.727912 0000003a: > DB2ResultSet@55800721.getInt(1)
Jdbc: 1035459252.728400 0000003a: > DB2ResultSet@55800721.beforeGetXxx(1)
Jdbc: 1035459252.728904 0000003a: > 
DB2ResultSetMetaData@1692968415.getColumnType(1)
Jdbc: 1035459252.729488 0000003a: > 
DB2ResultSetMetaData@1692968415.checkRSMDRequestForErrors(1)
Jdbc: 1035459252.730128 0000003a: > DB2ResultSet@55800721.getValue(1,2)
Jdbc: 1035459252.730688 0000003a: > DB2ResultSet@55800721.getNumericOpt(1)
Jdbc: 1035459252.731168 0000003a: > 
DB2ResultSetRuntimeImpl@-2009114355.getNumeric(59, 1)
Jdbc: 1035459252.731928 0000003a: > DB2ResultSet@55800721.testDataTruncation(1, 
0)
Jdbc: 1035459252.732512 0000003a: > DB2ResultSet@55800721.next()
Jdbc: 1035459252.733584 0000003a: > 
DB2ResultSet@55800721.beforePositioning(false)
Jdbc: 1035459252.734192 0000003a: > DB2ResultSet@55800721.handleFetch(1, 0)
Jdbc: 1035459252.734664 0000003a: > 
DB2ResultSetRuntimeImpl@-2009114355.extendedFetch(59)
Jdbc: 1035459252.735240 0000003a: > DB2ResultSet@55800721.getInt(1)
Jdbc: 1035459252.735768 0000003a: > DB2ResultSet@55800721.beforeGetXxx(1)
Jdbc: 1035459252.736328 0000003a: > 
DB2ResultSetMetaData@1692968415.getColumnType(1)
Jdbc: 1035459252.736824 0000003a: > 
DB2ResultSetMetaData@1692968415.checkRSMDRequestForErrors(1)
Jdbc: 1035459252.737472 0000003a: > DB2ResultSet@55800721.getValue(1,2)
Jdbc: 1035459252.738008 0000003a: > DB2ResultSet@55800721.getNumericOpt(1)
Jdbc: 1035459252.738488 0000003a: > 
DB2ResultSetRuntimeImpl@-2009114355.getNumeric(59, 1)
Jdbc: 1035459252.739136 0000003a: > DB2ResultSet@55800721.testDataTruncation(1, 
0)
Jdbc: 1035459252.739744 0000003a: > DB2ResultSet@55800721.next()
Jdbc: 1035459252.740232 0000003a: > 
DB2ResultSet@55800721.beforePositioning(false)
Jdbc: 1035459252.740736 0000003a: > DB2ResultSet@55800721.handleFetch(1, 0)
Jdbc: 1035459252.741248 0000003a: > 
DB2ResultSetRuntimeImpl@-2009114355.extendedFetch(59)
Jdbc: 1035459252.741816 0000003a: > DB2ResultSet@55800721.getInt(1)
Jdbc: 1035459252.742192 0000003a: > DB2ResultSet@55800721.beforeGetXxx(1)
Jdbc: 1035459252.742528 0000003a: > 
DB2ResultSetMetaData@1692968415.getColumnType(1)
Jdbc: 1035459252.742920 0000003a: > 
DB2ResultSetMetaData@1692968415.checkRSMDRequestForErrors(1)
Jdbc: 1035459252.743344 0000003a: > DB2ResultSet@55800721.getValue(1,2)
Jdbc: 1035459252.743960 0000003a: > DB2ResultSet@55800721.getNumericOpt(1)
Jdbc: 1035459252.744576 0000003a: > 
DB2ResultSetRuntimeImpl@-2009114355.getNumeric(59, 1)
Jdbc: 1035459252.745248 0000003a: > DB2ResultSet@55800721.testDataTruncation(1, 
0)
Jdbc: 1035459252.745856 0000003a: > DB2ResultSet@55800721.next()
Jdbc: 1035459252.746392 0000003a: > 
DB2ResultSet@55800721.beforePositioning(false)
Jdbc: 1035459252.746864 0000003a: > DB2ResultSet@55800721.handleFetch(1, 0)
Jdbc: 1035459252.747560 0000003a: > 
DB2ResultSetRuntimeImpl@-2009114355.extendedFetch(59)
Jdbc: 1035459252.748088 0000003a: > DB2ResultSet@55800721.getInt(1)
Jdbc: 1035459252.748776 0000003a: > DB2ResultSet@55800721.beforeGetXxx(1)
Jdbc: 1035459252.749424 0000003a: > 
DB2ResultSetMetaData@1692968415.getColumnType(1)
Jdbc: 1035459252.749968 0000003a: > 
DB2ResultSetMetaData@1692968415.checkRSMDRequestForErrors(1)
Jdbc: 1035459252.750488 0000003a: > DB2ResultSet@55800721.getValue(1,2)
Jdbc: 1035459252.751064 0000003a: > DB2ResultSet@55800721.getNumericOpt(1)
Jdbc: 1035459252.751704 0000003a: > 
DB2ResultSetRuntimeImpl@-2009114355.getNumeric(59, 1)
Jdbc: 1035459252.752456 0000003a: > DB2ResultSet@55800721.testDataTruncation(1, 
0)
Jdbc: 1035459252.753064 0000003a: > DB2ResultSet@55800721.next()
Jdbc: 1035459252.753640 0000003a: > 
DB2ResultSet@55800721.beforePositioning(false)
Jdbc: 1035459252.754120 0000003a: > DB2ResultSet@55800721.handleFetch(1, 0)
Jdbc: 1035459252.754664 0000003a: > 
DB2ResultSetRuntimeImpl@-2009114355.extendedFetch(59)
Jdbc: 1035459252.755224 0000003a: > DB2ResultSet@55800721.getInt(1)
Jdbc: 1035459252.755704 0000003a: > DB2ResultSet@55800721.beforeGetXxx(1)
Jdbc: 1035459252.756216 0000003a: > 
DB2ResultSetMetaData@1692968415.getColumnType(1)
Jdbc: 1035459252.756776 0000003a: > 
DB2ResultSetMetaData@1692968415.checkRSMDRequestForErrors(1)
Jdbc: 1035459252.757328 0000003a: > DB2ResultSet@55800721.getValue(1,2)
Jdbc: 1035459252.757848 0000003a: > DB2ResultSet@55800721.getNumericOpt(1)
Jdbc: 1035459252.758424 0000003a: > 
DB2ResultSetRuntimeImpl@-2009114355.getNumeric(59, 1)
Jdbc: 1035459252.759072 0000003a: > DB2ResultSet@55800721.testDataTruncation(1, 
0)
Jdbc: 1035459252.759616 0000003a: > DB2ResultSet@55800721.next()
Jdbc: 1035459252.760104 0000003a: > 
DB2ResultSet@55800721.beforePositioning(false)
Jdbc: 1035459252.760624 0000003a: > DB2ResultSet@55800721.handleFetch(1, 0)
Jdbc: 1035459252.761144 0000003a: > 
DB2ResultSetRuntimeImpl@-2009114355.extendedFetch(59)
Jdbc: 1035459252.761704 0000003a: > DB2ResultSet@55800721.getInt(1)
Jdbc: 1035459252.762240 0000003a: > DB2ResultSet@55800721.beforeGetXxx(1)
Jdbc: 1035459252.762856 0000003a: > 
DB2ResultSetMetaData@1692968415.getColumnType(1)
Jdbc: 1035459252.763336 0000003a: > 
DB2ResultSetMetaData@1692968415.checkRSMDRequestForErrors(1)
Jdbc: 1035459252.763936 0000003a: > DB2ResultSet@55800721.getValue(1,2)
Jdbc: 1035459252.764424 0000003a: > DB2ResultSet@55800721.getNumericOpt(1)
Jdbc: 1035459252.764880 0000003a: > 
DB2ResultSetRuntimeImpl@-2009114355.getNumeric(59, 1)
Jdbc: 1035459252.765616 0000003a: > DB2ResultSet@55800721.testDataTruncation(1, 
15)
Jdbc: 1035459252.766200 0000003a: > DB2ResultSet@55800721.next()
Jdbc: 1035459252.766696 0000003a: > 
DB2ResultSet@55800721.beforePositioning(false)
Jdbc: 1035459252.767184 0000003a: > DB2ResultSet@55800721.handleFetch(1, 0)
Jdbc: 1035459252.767648 0000003a: > 
DB2ResultSetRuntimeImpl@-2009114355.extendedFetch(59)
Jdbc: 1035459252.768176 0000003a: > DB2ResultSet@55800721.getInt(1)
Jdbc: 1035459252.768640 0000003a: > DB2ResultSet@55800721.beforeGetXxx(1)
Jdbc: 1035459252.769104 0000003a: > 
DB2ResultSetMetaData@1692968415.getColumnType(1)
Jdbc: 1035459252.769592 0000003a: > 
DB2ResultSetMetaData@1692968415.checkRSMDRequestForErrors(1)
Jdbc: 1035459252.770104 0000003a: > DB2ResultSet@55800721.getValue(1,2)
Jdbc: 1035459252.770560 0000003a: > DB2ResultSet@55800721.getNumericOpt(1)
Jdbc: 1035459252.771024 0000003a: > 
DB2ResultSetRuntimeImpl@-2009114355.getNumeric(59, 1)
Jdbc: 1035459252.771672 0000003a: > DB2ResultSet@55800721.testDataTruncation(1, 
21)
Jdbc: 1035459252.772216 0000003a: > DB2ResultSet@55800721.next()
Jdbc: 1035459252.772712 0000003a: > 
DB2ResultSet@55800721.beforePositioning(false)
Jdbc: 1035459252.773192 0000003a: > DB2ResultSet@55800721.handleFetch(1, 0)
Jdbc: 1035459252.773656 0000003a: > 
DB2ResultSetRuntimeImpl@-2009114355.extendedFetch(59)
Jdbc: 1035459252.774160 0000003a: > DB2ResultSet@55800721.getInt(1)
Jdbc: 1035459252.774704 0000003a: > DB2ResultSet@55800721.beforeGetXxx(1)
Jdbc: 1035459252.775240 0000003a: > 
DB2ResultSetMetaData@1692968415.getColumnType(1)
Jdbc: 1035459252.775728 0000003a: > 
DB2ResultSetMetaData@1692968415.checkRSMDRequestForErrors(1)
Jdbc: 1035459252.776328 0000003a: > DB2ResultSet@55800721.getValue(1,2)
Jdbc: 1035459252.776952 0000003a: > DB2ResultSet@55800721.getNumericOpt(1)
Jdbc: 1035459252.779560 0000003a: > 
DB2ResultSetRuntimeImpl@-2009114355.getNumeric(59, 1)
Jdbc: 1035459252.780400 0000003a: > DB2ResultSet@55800721.testDataTruncation(1, 
22)
Jdbc: 1035459252.780992 0000003a: > DB2ResultSet@55800721.next()
Jdbc: 1035459252.781680 0000003a: > 
DB2ResultSet@55800721.beforePositioning(false)
Jdbc: 1035459252.782320 0000003a: > DB2ResultSet@55800721.handleFetch(1, 0)
Jdbc: 1035459252.782824 0000003a: > 
DB2ResultSetRuntimeImpl@-2009114355.extendedFetch(59)
Jdbc: 1035459252.783328 0000003a: > DB2ResultSet@55800721.getInt(1)
Jdbc: 1035459252.784152 0000003a: > DB2ResultSet@55800721.beforeGetXxx(1)
Jdbc: 1035459252.784496 0000003a: > 
DB2ResultSetMetaData@1692968415.getColumnType(1)
Jdbc: 1035459252.784808 0000003a: > 
DB2ResultSetMetaData@1692968415.checkRSMDRequestForErrors(1)
Jdbc: 1035459252.785120 0000003a: > DB2ResultSet@55800721.getValue(1,2)
Jdbc: 1035459252.785664 0000003a: > DB2ResultSet@55800721.getNumericOpt(1)
Jdbc: 1035459252.786352 0000003a: > 
DB2ResultSetRuntimeImpl@-2009114355.getNumeric(59, 1)
Jdbc: 1035459252.786960 0000003a: > DB2ResultSet@55800721.testDataTruncation(1, 
23)
Jdbc: 1035459252.787352 0000003a: > DB2ResultSet@55800721.next()
Jdbc: 1035459252.788136 0000003a: > 
DB2ResultSet@55800721.beforePositioning(false)
Jdbc: 1035459252.788760 0000003a: > DB2ResultSet@55800721.handleFetch(1, 0)
Jdbc: 1035459252.789344 0000003a: > 
DB2ResultSetRuntimeImpl@-2009114355.extendedFetch(59)
Jdbc: 1035459252.790240 0000003a: > DB2ResultSet@55800721.getInt(1)
Jdbc: 1035459252.791000 0000003a: > DB2ResultSet@55800721.beforeGetXxx(1)
Jdbc: 1035459252.791592 0000003a: > 
DB2ResultSetMetaData@1692968415.getColumnType(1)
Jdbc: 1035459252.792024 0000003a: > 
DB2ResultSetMetaData@1692968415.checkRSMDRequestForErrors(1)
Jdbc: 1035459252.793008 0000003a: > DB2ResultSet@55800721.getValue(1,2)
Jdbc: 1035459252.793608 0000003a: > DB2ResultSet@55800721.getNumericOpt(1)
Jdbc: 1035459252.793976 0000003a: > 
DB2ResultSetRuntimeImpl@-2009114355.getNumeric(59, 1)
Jdbc: 1035459252.794456 0000003a: > DB2ResultSet@55800721.testDataTruncation(1, 
32)
Jdbc: 1035459252.795064 0000003a: > DB2ResultSet@55800721.next()
Jdbc: 1035459252.795392 0000003a: > 
DB2ResultSet@55800721.beforePositioning(false)
Jdbc: 1035459252.795728 0000003a: > DB2ResultSet@55800721.handleFetch(1, 0)
Jdbc: 1035459252.796040 0000003a: > 
DB2ResultSetRuntimeImpl@-2009114355.extendedFetch(59)
Jdbc: 1035459252.798336 0000003a: > DB2ResultSet@55800721.close()
Jdbc: 1035459252.799144 0000003a: > 
DB2ResultSetRuntimeImpl@-2009114355.closeCursor(59)
Jdbc: 1035459252.801432 0000003a: > DB2PreparedStatement@721670152.close()
Jdbc: 1035459252.801992 0000003a: > DB2Connection@721597960.removeStatement(59)
Jdbc: 1035459252.802352 0000003a: > 
DB2StatementRuntimeImpl@-2009113779.freeStmt(59, 0)
Jdbc: 1035459252.804888 0000003a: > DB2Connection@721597960.commit()
Jdbc: 1035459252.805456 0000003a: > 
DB2ConnectionRuntimeImpl@-2009258291.commit(5, 1)
Jdbc: 1035459252.807344 0000003a: > DB2Connection@721597960.getAutoCommit()
Jdbc: 1035459252.807912 0000003a: > DB2Connection@721597960.clearWarnings()
Jdbc: 1035459252.808400 0000003a: > DB2Connection@721597960.setAutoCommit(true)
Jdbc: 1035459252.808840 0000003a: > DB2Connection@721597960.commit()
Jdbc: 1035459252.809320 0000003a: > 
DB2ConnectionRuntimeImpl@-2009258291.commit(5, 1)
Jdbc: 1035459252.811152 0000003a: > 
DB2Connection@721597960.addWarning(java.sql.SQLWarning: COMMIT called for any 
pending database work because of setAutoCommit(true) call.)


Select with error:

Jdbc: 1035459252.812120 0000003a: > 
DB2ConnectionRuntimeImpl@-2009258291.setConnectOption(5, 10003, 1)
Jdbc: 1035459258.868160 0000003c: > DB2Connection@721565960.setAutoCommit(false)
Jdbc: 1035459258.868768 0000003c: > 
DB2ConnectionRuntimeImpl@-2009258387.setConnectOption(6, 10003, 0)
Jdbc: 1035459258.869880 0000003c: > 
DB2Connection@721565960.prepareStatement(Select SSAMJ1 From GEPPARAM Where 
TABLEX = 'IME' and POSTEX is not null order by SSAMJ1

)
Jdbc: 1035459258.870416 0000003c: > 
DB2Connection@721565960.prepareStatement(Select SSAMJ1 From GEPPARAM Where 
TABLEX = 'IME' and POSTEX is not null order by SSAMJ1

, 1003, 1007)
Jdbc: 1035459258.871112 0000003c:   DB2Connection@721565960 prepareStatement(): 
Transactional=false
Jdbc: 1035459258.871608 0000003c: > DB2Connection@721565960.toString()
Jdbc: 1035459258.872304 0000003c: > 
DB2PreparedStatement@721564424.<init>(ASB20, 1003, 1007, false)
Jdbc: 1035459258.872808 0000003c: > 
DB2StatementRuntimeImpl@-2009077427.<init>(DB2PreparedStatement@721564424)
Jdbc: 1035459258.873256 0000003c: > 
DB2PreparedStatement@721564424.getResultSetType(1003, 1007)
Jdbc: 1035459258.873680 0000003c: > 
DB2StatementRuntimeImpl@-2009077427.allocStmt(6, 1026, 0, 0)
Jdbc: 1035459258.874208 0000003c: > 
DB2PreparedStatement@721564424.generateStatementName()
Jdbc: 1035459258.874680 0000003c: > 
DB2Connection@721565960.addStatement(STMT00063)
Jdbc: 1035459258.875088 0000003c: > 
DB2PreparedStatement@721564424.getStatementHandle()
Jdbc: 1035459258.875520 0000003c: < DB2PreparedStatement@721564424.<init>( 
hDbc=6, hStmt=63 )
Jdbc: 1035459258.875944 0000003c: > DB2Connection@721565960.toString()
Jdbc: 1035459258.876368 0000003c: > 
DB2PreparedStatement@721564424.<init>(Select SSAMJ1 From GEPPARAM Where TABLEX 
= 'IME' and POSTEX is not null order by SSAMJ1, ASB20, 1003, 1007, false)
Jdbc: 1035459258.876848 0000003c: > 
DB2PreparedStatementRuntimeImpl@-2009077491.<init>(DB2PreparedStatement@721564424)
Jdbc: 1035459258.877296 0000003c: > 
DB2PreparedStatementRuntimeImpl@-2009077491.<init>(DB2PreparedStatement@721564424)
Jdbc: 1035459258.877720 0000003c: > 
DB2PreparedStatement@721564424.determineBlockingUse()
Jdbc: 1035459258.878184 0000003c: > 
DB2PreparedStatementRuntimeImpl@-2009077491.prepare(63, Select SSAMJ1 >From 
GEPPARAM Where TABLEX = 'IME' and POSTEX is not null order by SSAMJ1, 3, null, 
null, 1, 32)
Jdbc: 1035459258.894816 0000003c: > 
DB2ResultSetMetaData@1693148511.<init>(STMT00063, null, false)
Jdbc: 1035459258.895400 0000003c: > 
DB2ResultSetMetaDataRuntimeImpl@-2009077587.<init>()
Jdbc: 1035459258.895824 0000003c: > 
DB2ResultSetMetaDataRuntimeImpl@-2009077587.getColumnCount(63)
Jdbc: 1035459258.896872 0000003c: > 
DB2PreparedStatement@721564424.executeQuery()
Jdbc: 1035459258.897320 0000003c: > DB2PreparedStatement@721564424.execute()
Jdbc: 1035459258.897696 0000003c: > 
DB2PreparedStatement@721564424.commonPreExec()
Jdbc: 1035459258.898104 0000003c: > 
DB2PreparedStatementRuntimeImpl@-2009077491.execute(63, 3)
Jdbc: 1035459259.401032 0000003c: > DB2PreparedStatement@721564424.close()
Jdbc: 1035459259.401552 0000003c: > DB2Connection@721565960.removeStatement(63)
Jdbc: 1035459259.401992 0000003c: > 
DB2StatementRuntimeImpl@-2009077427.freeStmt(63, 0)
Jdbc: 1035459259.403120 0000003c: > DB2Connection@721565960.commit()
Jdbc: 1035459259.403576 0000003c: > 
DB2ConnectionRuntimeImpl@-2009258387.commit(6, 1)
Jdbc: 1035459259.404624 0000003c: > DB2Connection@721565960.getAutoCommit()
Jdbc: 1035459259.405088 0000003c: > DB2Connection@721565960.clearWarnings()
Jdbc: 1035459259.405496 0000003c: > DB2Connection@721565960.setAutoCommit(true)
Jdbc: 1035459259.405872 0000003c: > DB2Connection@721565960.commit()
Jdbc: 1035459259.406240 0000003c: > 
DB2ConnectionRuntimeImpl@-2009258387.commit(6, 1)
Jdbc: 1035459259.418664 0000003c: > 
DB2Connection@721565960.addWarning(java.sql.SQLWarning: COMMIT called for any 
pending database work because of setAutoCommit(true) call.)
Jdbc: 1035459259.419280 0000003c: > 
DB2ConnectionRuntimeImpl@-2009258387.setConnectOption(6, 10003, 1)
--
Jdbc: 1035459032.566840 00000075: T.initTrace(): property jdbc.db2.trace is 
set, JDBC Tracing set to level 3
Jdbc: 1035459032.691072 00000075: > DB2Driver@-951466159.<init>
Jdbc: 1035459032.739568 00000075: < DB2Driver@-951466159.<init>: this
Jdbc: 1035459032.740792 00000075: > DB2Driver@-951466319.<init>
Jdbc: 1035459032.741496 00000075: < DB2Driver@-951466319.<init>: already 
initialized
Jdbc: 1035459032.742176 00000075: > DB2Driver@-951466351.<init>
Jdbc: 1035459032.742680 00000075: < DB2Driver@-951466351.<init>: already 
initialized
Jdbc: 1035459034.749760 00000075: > 
DB2Driver@-951466351.connect(jdbc:db2://ASB20/UNSDTA007T, {password=*****, 
user=vocal})
Jdbc: 1035459034.750488 00000075: > 
DB2Driver@-951466351.handleURLProcessing(jdbc:db2://ASB20/UNSDTA007T, 
{password=*****, user=vocal}, true)
Jdbc: 1035459034.750992 00000075: > DB2Driver@-951466351.indexOfEither()
Jdbc: 1035459034.751736 00000075: > DB2Connection@1741750860.<init>: ASB20
Jdbc: 1035459034.752168 00000075:   DB2Connection@1741750860 Not Transactional
Jdbc: 1035459034.752624 00000075: > 
DB2ConnectionRuntimeImpl@-951460335.<init>(DB2Connection@1741750860)
Jdbc: 1035459034.753160 00000075: > 
DB2Connection@1741750860.handleConnectionProperties({password=*****, 
user=vocal, libraries=UNSDTA007T})
Jdbc: 1035459034.753752 00000075:   DB2Connection@1741750860 Connection 
property settings:
Jdbc: 1035459034.754160 00000075:   DB2Connection@1741750860   'libraries' 
property:  UNSDTA007T
Jdbc: 1035459034.754536 00000075:   DB2Connection@1741750860   'naming' 
property:  SQL Naming Used:  Separator is:  .
Jdbc: 1035459034.754896 00000075:   DB2Connection@1741750860   'user' property: 
 VOCAL
Jdbc: 1035459034.755256 00000075:   DB2Connection@1741750860   'blocking 
enabled' property:  Blocking enabled.
Jdbc: 1035459034.755624 00000075:   DB2Connection@1741750860   'blocking size' 
property:  32
Jdbc: 1035459034.756072 00000075:   DB2Connection@1741750860   'transaction 
isolation' property: caused a tx level of 0
Jdbc: 1035459034.756480 00000075:   DB2Connection@1741750860   'transaction 
isolation' property: caused an autocommit setting of true
Jdbc: 1035459034.756872 00000075:   DB2Connection@1741750860   'access' 
property: caused the access level to be set to 0
Jdbc: 1035459034.757272 00000075:   DB2Connection@1741750860      and the 
readonly flag was set to false
Jdbc: 1035459034.757648 00000075:   DB2Connection@1741750860   'decimal 
separator' property: .
Jdbc: 1035459034.758016 00000075:   DB2Connection@1741750860   'date separator' 
property: -
Jdbc: 1035459034.758400 00000075:   DB2Connection@1741750860   'date format' 
property: 7
Jdbc: 1035459034.758776 00000075:   DB2Connection@1741750860   'time separator' 
property: :
Jdbc: 1035459034.994256 00000075:   DB2Connection@1741750860   'time format' 
property: 4
Jdbc: 1035459034.995184 00000075:   DB2Connection@1741750860   'translate 
binary' property: false
Jdbc: 1035459034.995592 00000075:   DB2Connection@1741750860   'do escape 
processing' property: true
Jdbc: 1035459034.995976 00000075:   DB2Connection@1741750860   'data 
truncation' property: true
Jdbc: 1035459034.996360 00000075:   DB2Connection@1741750860   'reuse object' 
property: true
Jdbc: 1035459034.997120 00000075:   DB2Connection@1741750860   'cursor hold' 
property: 1
Jdbc: 1035459034.997664 00000075:   DB2Connection@1741750860   'lob threshold' 
property: 0
Jdbc: 1035459034.998056 00000075:   DB2Connection@1741750860   'prefetch' 
property: true
Jdbc: 1035459034.998736 00000075: > 
DB2ConnectionRuntimeImpl@-951460335.connect(ASB20, VOCAL, <password>, 
UNSDTA007T, 1, 1, 0)
Jdbc: 1035459036.634656 00000075: < DB2Connection@1741750860.<init>( hDbc=2 )
Jdbc: 1035459036.635504 00000075: > DB2Connection@1741750860.toString()
Jdbc: 1035459036.636056 00000075: < DB2Driver@-951466351.connect(): ASB20
Jdbc: 1035459036.637496 00000075: > DB2Connection@1741750860.getCatalog()
Jdbc: 1035459036.652960 00000075: * null@0.java.sql.SQLException: [IBM][JDBC 
Driver][15093] Les méthodes ResultSet qui incluent des objets java.util.Map ne 
sont pas supportées actuellement.
Jdbc: 1035459036.716560 00000075: java.sql.SQLException: [IBM][JDBC 
Driver][15093] Les méthodes ResultSet qui incluent des objets java.util.Map ne 
sont pas supportées actuellement.
Jdbc: 1035459036.746792 00000075:       
java/lang/Throwable.<init>(Ljava/lang/String;)V+4 (Throwable.java:94)
Jdbc: 1035459036.747376 00000075:       
java/sql/SQLException.<init>(Ljava/lang/String;Ljava/lang/String;I)V+1 
(SQLException.java:43)
Jdbc: 1035459036.747816 00000075:       
com/ibm/db2/jdbc/app/DB2Exception.handleSpecificError(I)V+45 
(DB2Exception.java:92)
Jdbc: 1035459036.748208 00000075:       
com/ibm/db2/jdbc/app/DB2Connection.getTypeMap()Ljava/util/Map;+1 
(DB2Connection.java:899)
Jdbc: 1035459036.748648 00000075:       
com/protomatter/jdbc/pool/JdbcConnectionPoolConnection.init(Z)V+0 
(JdbcConnectionPoolConnection.java:159)
Jdbc: 1035459036.749056 00000075:       
com/protomatter/jdbc/pool/JdbcConnectionPoolConnection.<init>(Lcom/protomatter/jdbc/pool/JdbcConnectionPool;Ljava/lang/String;Ljava/util/Properties;)V+0
 (JdbcConnectionPoolConnection.java:104)
Jdbc: 1035459036.749464 00000075:       
com/protomatter/jdbc/pool/JdbcConnectionPool.createObjectPoolObject()Lcom/protomatter/pool/ObjectPoolObject;+0
 (JdbcConnectionPool.java:980)
Jdbc: 1035459036.749848 00000075:       
com/protomatter/pool/GrowingObjectPool.init(Ljava/util/Map;)V+0 
(GrowingObjectPool.java:250)
Jdbc: 1035459036.750240 00000075:       
com/protomatter/jdbc/pool/JdbcConnectionPool.init(Ljava/util/Map;)V+0 
(JdbcConnectionPool.java:778)
Jdbc: 1035459036.750640 00000075:       
com/protomatter/jdbc/pool/JdbcConnectionPool.<init>(Ljava/lang/String;Ljava/util/Map;)V+0
 (JdbcConnectionPool.java:229)
Jdbc: 1035459036.751056 00000075:       
com/vocognition/talkface/database/ProtomatterDataSourceProvider.createDataSource(Lcom/vocognition/talkface/util/config/ConfigurationNode;)Ljavax/sql/ConnectionPoolDataSource;+0
 (ProtomatterDataSourceProvider.java:24)
Jdbc: 1035459036.751496 00000075:       
com/vocognition/talkface/database/DataSourceProvider.getDataSource(Lcom/vocognition/talkface/util/config/ConfigurationNode;)Ljavax/sql/ConnectionPoolDataSource;+0
 (DataSourceProvider.java:24)
Jdbc: 1035459036.751920 00000075:       
com/vocognition/talkface/pickmanager/LocalApplication.initDatasource(Lcom/vocognition/talkface/util/config/ConfigurationNode;)V+0
 (LocalApplication.java:180)
Jdbc: 1035459036.752328 00000075:       
com/vocognition/talkface/pickmanager/LocalApplication.init(Lcom/vocognition/talkface/util/config/ConfigurationNode;)V+0
 (LocalApplication.java:198)
Jdbc: 1035459036.752744 00000075:       
com/vocognition/talkface/util/config/ConfigurationManager.addConfigurable(Lcom/vocognition/talkface/util/config/Configurable;)V+0
 (ConfigurationManager.java:78)
Jdbc: 1035459036.753160 00000075:       
com/vocognition/talkface/pickmanager/LocalApplication.<init>()V+0 
(LocalApplication.java:67)
Jdbc: 1035459036.753568 00000075:       
com/vocognition/talkface/pickmanager/PMRunner.main([Ljava/lang/String;)V+0 
(PMRunner.java:45)

--

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.