ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeff Hibbs" <jhi...@bop.gov>
Subject Re: Idle Threads - Glassfish/DB2
Date Fri, 17 Apr 2009 15:26:06 GMT
Mario - 
 
I made the following changes to the GlassFish Connection pool:
 
"Initial and Minimum Pools Size": changed from 8 -> 0 
"Pool Resize Quantity": changed from 5 -> 1     (1 is the minimum that Glassfish allows)
 
Max Poll setting is 32 and hasn't changed....
 
Below is the log after making the change.  I've also included the same potion of the log before the change (which you've already seen).
 
Notice that after changing the connection pool settings, the log shows autoCommit being set to True, then the flush, etc?  Also, it's now reusing the connection for the next qry.  The only difference between the logs is the above connection pool settings.  Do you believe this is normal behavior?  
 
Before the changing the pool settings, it appears we get the "flush" only after we've run a number of queries that's equal to the "Initial and Minimum Pools Size" setting,   Then we started re-using connections.
 
Should the flush occur every time, regardless of these connection pool settings?  Possibly a problem with the Glassfish Pool implementation??
 
As stated on the original issue, we are never exhausting connections in the connection pool, and the queries are returning quickly.  The problem is that the DBA (DB2 Version 8, Zos) is seeing "IDLE Threads", which eventually time out and fill up his log. 
 
Again, thanks so much for you time.....Jeff
 
1.  After Changing GlassFish Connection Pool:  
 
[ibm][db2][jcc][Time:1239976589109][Thread:httpSSLWorkerThread-8080-0][Connection@1c3b761] setTransactionIsolation (1) called
[ibm][db2][jcc][Time:1239976589109][Thread:httpSSLWorkerThread-8080-0][Connection@1c3b761] getTransactionIsolation () returned 1
[ibm][db2][jcc][Time:1239976589109][Thread:httpSSLWorkerThread-8080-0][Connection@1c3b761] getAutoCommit () returned true
[ibm][db2][jcc][Time:1239976589109][Thread:httpSSLWorkerThread-8080-0][Connection@1c3b761] setAutoCommit (false) called
[ibm][db2][jcc][Time:1239976589125][Thread:httpSSLWorkerThread-8080-0][Connection@1c3b761] prepareStatement (          SELECT b.INTKEY_EMPL, b.TYPE_EMPL, b.NAME_FIRST, b.NAME_MIDDLE, b.NAME_LAST         FROM J3TEST.ENUM a, J3TEST.EMPL b         WHERE a.NBR_ENUM = ? AND a.CODE_TNUM = 'UID' AND a.INTKEY_EMPL = b.INTKEY_EMPL     ) called
[ibm][db2][jcc][Time:1239976589140][Thread:httpSSLWorkerThread-8080-0][Connection@1c3b761] prepareStatement () returned com.ibm.db2.jcc.a.lg@cfbe92
[ibm][db2][jcc][Time:1239976589515][Thread:httpSSLWorkerThread-8080-0][PreparedStatement@cfbe92] setString (1, BOP1339) called
[ibm][db2][jcc][Time:1239976589515][Thread:httpSSLWorkerThread-8080-0][PreparedStatement@cfbe92] execute () called
[ibm][db2][jcc] [t4][time:1239976589515][thread:httpSSLWorkerThread-8080-0][tracepoint:5][Request.flush]
[ibm][db2][jcc][t4]        SEND BUFFER: PRPSQLSTT              (ASCII)           (EBCDIC)
[ibm][db2][jcc][t4]        0 1 2 3 4 5 6 7   8 9 A B C D E F   0123456789ABCDEF  0123456789ABCDEF
[ibm][db2][jcc][t4] 0000   0058D05100010052  200D00442113D1F3  .X.Q...R ..D!...  ..}...........J3
[ibm][db2][jcc][t4] 0010   E3F1404040404040  4040404040404040  ..@@@@@@@@@@@@@@  T1              
[ibm][db2][jcc][t4] 0020   D5E4D3D3C9C44040  4040404040404040  ......@@@@@@@@@@  NULLID          
[ibm][db2][jcc][t4] 0030   4040E2E8E2D3D5F1  F0F0404040404040  @@........@@@@@@    SYSLN100      
[ibm][db2][jcc][t4] 0040   404040405359534C  564C303100010005  @@@@SYSLVL01....      ...<.<......
[ibm][db2][jcc][t4] 0050   2116F10005214604                    !....!F.          ..1.....        
[ibm][db2][jcc][t4] 
[ibm][db2][jcc][t4]        SEND BUFFER: SQLATTR                (ASCII)           (EBCDIC)
[ibm][db2][jcc][t4] 0000   001ED05300010018  2450000000000E46  ...S....$P.....F  ..}......&......
[ibm][db2][jcc][t4] 0010   4F52205245414420  4F4E4C5920FF      OR READ ONLY .    |.......|+<...  
[ibm][db2][jcc][t4] 
[ibm][db2][jcc][t4]        SEND BUFFER: SQLSTT                 (ASCII)           (EBCDIC)
[ibm][db2][jcc][t4] 0000   00EBD043000100E5  241400000000DB20  ...C....$......   ..}....V........
[ibm][db2][jcc][t4] 0010   2020202020202020  2053454C45435420           SELECT   ...........<....
[ibm][db2][jcc][t4] 0020   622E494E544B4559  5F454D504C2C2062  b.INTKEY_EMPL, b  ...+......(&<...
[ibm][db2][jcc][t4] 0030   2E545950455F454D  504C2C20622E4E41  .TYPE_EMPL, b.NA  ...&...(&<....+.
[ibm][db2][jcc][t4] 0040   4D455F4649525354  2C20622E4E414D45  ME_FIRST, b.NAME  (...........+.(.
[ibm][db2][jcc][t4] 0050   5F4D4944444C452C  20622E4E414D455F  _MIDDLE, b.NAME_  .(...<.....+.(..
[ibm][db2][jcc][t4] 0060   4C41535420202020  202020202046524F  LAST         FRO  <..............|
[ibm][db2][jcc][t4] 0070   4D204A3354455354  2E454E554D20612C  M J3TEST.ENUM a,  (.........+.(./.
[ibm][db2][jcc][t4] 0080   204A33544553542E  454D504C20622020   J3TEST.EMPL b    .........(&<....
[ibm][db2][jcc][t4] 0090   2020202020202057  4845524520612E4E         WHERE a.N  ............./.+
[ibm][db2][jcc][t4] 00A0   42525F454E554D20  3D203F20414E4420  BR_ENUM = ? AND   ....+.(......+..
[ibm][db2][jcc][t4] 00B0   612E434F44455F54  4E554D203D202755  a.CODE_TNUM = 'U  /..|....+.(.....
[ibm][db2][jcc][t4] 00C0   49442720414E4420  612E494E544B4559  ID' AND a.INTKEY  .....+../..+....
[ibm][db2][jcc][t4] 00D0   5F454D504C203D20  622E494E544B4559  _EMPL = b.INTKEY  ..(&<......+....
[ibm][db2][jcc][t4] 00E0   5F454D504C202020  2020FF            _EMPL     .       ..(&<......     
[ibm][db2][jcc][t4] 
[ibm][db2][jcc][t4]        SEND BUFFER: DSCSQLSTT              (ASCII)           (EBCDIC)
[ibm][db2][jcc][t4] 0000   0053D0410002004D  200800442113D1F3  .S.A...M ..D!...  ..}....(......J3
[ibm][db2][jcc][t4] 0010   E3F1404040404040  4040404040404040  ..@@@@@@@@@@@@@@  T1              
[ibm][db2][jcc][t4] 0020   D5E4D3D3C9C44040  4040404040404040  ......@@@@@@@@@@  NULLID          
[ibm][db2][jcc][t4] 0030   4040E2E8E2D3D5F1  F0F0404040404040  @@........@@@@@@    SYSLN100      
[ibm][db2][jcc][t4] 0040   404040405359534C  564C303100010005  @@@@SYSLVL01....      ...<.<......
[ibm][db2][jcc][t4] 0050   214601                              !F.               ...             
[ibm][db2][jcc][t4] 
[ibm][db2][jcc][t4]        SEND BUFFER: OPNQRY                 (ASCII)           (EBCDIC)
[ibm][db2][jcc][t4] 0000   005BD05100030055  200C00442113D1F3  .[.Q...U ..D!...  .$}...........J3
[ibm][db2][jcc][t4] 0010   E3F1404040404040  4040404040404040  ..@@@@@@@@@@@@@@  T1              
[ibm][db2][jcc][t4] 0020   D5E4D3D3C9C44040  4040404040404040  ......@@@@@@@@@@  NULLID          
[ibm][db2][jcc][t4] 0030   4040E2E8E2D3D5F1  F0F0404040404040  @@........@@@@@@    SYSLN100      
[ibm][db2][jcc][t4] 0040   404040405359534C  564C303100010008  @@@@SYSLVL01....      ...<.<......
[ibm][db2][jcc][t4] 0050   211400007FFF0005  215D01            !.......!].       ...."....).     
[ibm][db2][jcc][t4] 
[ibm][db2][jcc][t4]        SEND BUFFER: SQLDTA                 (ASCII)           (EBCDIC)
[ibm][db2][jcc][t4] 0000   0029D00300030023  2412001000100676  .).....#$......v  ..}.............
[ibm][db2][jcc][t4] 0010   D03F7FFF0671E4D0  0001000F147A0000  .?...q.......z..  }."...U}.....:..
[ibm][db2][jcc][t4] 0020   0007424F50313333  39                ..BOP1339         ...|&....       
[ibm][db2][jcc][t4] 
[ibm][db2][jcc] [t4][time:1239976589562][thread:httpSSLWorkerThread-8080-0][tracepoint:2][Reply.fill]
[ibm][db2][jcc][t4]        RECEIVE BUFFER: SQLDARD             (ASCII)           (EBCDIC)
[ibm][db2][jcc][t4]        0 1 2 3 4 5 6 7   8 9 A B C D E F   0123456789ABCDEF  0123456789ABCDEF
[ibm][db2][jcc][t4] 0000   0241D0430001023B  2411000000000030  .A.C...;$......0  ..}.............
[ibm][db2][jcc][t4] 0010   3030303044534E20  2020202000000000  0000DSN     ....  ......+.........
[ibm][db2][jcc][t4] 0020   0000000000000000  0141B473B4000000  .........A.s....  ................
[ibm][db2][jcc][t4] 0030   0000000000202020  2020202020202020  .....             ................
[ibm][db2][jcc][t4] 0040   00104A3354312020  2020202020202020  ..J3T1            ................
[ibm][db2][jcc][t4] 0050   202000000000FF00  0000000000000000    ..............  ................
[ibm][db2][jcc][t4] 0060   0000000000044A33  5431000000000005  ......J3T1......  ................
[ibm][db2][jcc][t4] 0070   0000000000000000  0000000401F00000  ................  .............0..
[ibm][db2][jcc][t4] 0080   0000000000000B49  4E544B45595F454D  .......INTKEY_EM  ........+......(
[ibm][db2][jcc][t4] 0090   504C000000000000  0000FF0000000000  PL..............  &<..............
[ibm][db2][jcc][t4] 00A0   0002000000044A33  5431000000000000  ......J3T1......  ................
[ibm][db2][jcc][t4] 00B0   0004454D504C0000  00064A3354455354  ..EMPL....J3TEST  ...(&<..........
[ibm][db2][jcc][t4] 00C0   0000000B494E544B  45595F454D504C00  ....INTKEY_EMPL.  .....+......(&<.
[ibm][db2][jcc][t4] 00D0   0000000000000000  00000301C4002500  ..............%.  ............D...
[ibm][db2][jcc][t4] 00E0   0000000000095459  50455F454D504C00  ......TYPE_EMPL.  ........&...(&<.
[ibm][db2][jcc][t4] 00F0   00000000000000FF  0000000000000000  ................  ................
[ibm][db2][jcc][t4] 0100   0000044A33543100  0000000000000445  ...J3T1........E  ................
[ibm][db2][jcc][t4] 0110   4D504C000000064A  3354455354000000  MPL....J3TEST...  (&<.............
[ibm][db2][jcc][t4] 0120   09545950455F454D  504C000000000000  .TYPE_EMPL......  ...&...(&<......
[ibm][db2][jcc][t4] 0130   00000000000C01C4  0025000000000000  .........%......  .......D........
[ibm][db2][jcc][t4] 0140   0A4E414D455F4649  5253540000000000  .NAME_FIRST.....  .+.(............
[ibm][db2][jcc][t4] 0150   000000FF00000000  000000000000044A  ...............J  ................
[ibm][db2][jcc][t4] 0160   3354310000000000  000004454D504C00  3T1........EMPL.  ............(&<.
[ibm][db2][jcc][t4] 0170   0000064A33544553  540000000A4E414D  ...J3TEST....NAM  .............+.(
[ibm][db2][jcc][t4] 0180   455F464952535400  0000000000000000  E_FIRST.........  ................
[ibm][db2][jcc][t4] 0190   00000801C4002500  00000000000B4E41  ......%.......NA  ....D.........+.
[ibm][db2][jcc][t4] 01A0   4D455F4D4944444C  4500000000000000  ME_MIDDLE.......  (..(...<........
[ibm][db2][jcc][t4] 01B0   00FF000000000000  00000000044A3354  .............J3T  ................
[ibm][db2][jcc][t4] 01C0   3100000000000000  04454D504C000000  1........EMPL...  ..........(&<...
[ibm][db2][jcc][t4] 01D0   064A335445535400  00000B4E414D455F  .J3TEST....NAME_  ...........+.(..
[ibm][db2][jcc][t4] 01E0   4D4944444C450000  0000000000000000  MIDDLE..........  (...<...........
[ibm][db2][jcc][t4] 01F0   001801C400250000  00000000094E414D  .....%.......NAM  ...D.........+.(
[ibm][db2][jcc][t4] 0200   455F4C4153540000  000000000000FF00  E_LAST..........  ..<.............
[ibm][db2][jcc][t4] 0210   0000000000000000  00044A3354310000  ..........J3T1..  ................
[ibm][db2][jcc][t4] 0220   000000000004454D  504C000000064A33  ......EMPL....J3  .......(&<......
[ibm][db2][jcc][t4] 0230   5445535400000009  4E414D455F4C4153  TEST....NAME_LAS  ........+.(..<..
[ibm][db2][jcc][t4] 0240   54                                  T                 .               
[ibm][db2][jcc][t4] 
[ibm][db2][jcc][t4]        RECEIVE BUFFER: SQLDARD             (ASCII)           (EBCDIC)
[ibm][db2][jcc][t4] 0000   002FD04300020029  2411FFFF00010000  ./.C...)$.......  ..}.............
[ibm][db2][jcc][t4] 0010   0000000000000000  001401C500250000  .............%..  ...........E....
[ibm][db2][jcc][t4] 0020   0000000000000000  0000000000FFFF    ...............   ............... 
[ibm][db2][jcc][t4] 
[ibm][db2][jcc][t4]        RECEIVE BUFFER: OPNQRYRM            (ASCII)           (EBCDIC)
[ibm][db2][jcc][t4] 0000   002FD05200030029  2205000611490000  ./.R...)"....I..  ..}.............
[ibm][db2][jcc][t4] 0010   0006210224170005  215001000C215B00  ..!.$...!P...![.  .........&....$.
[ibm][db2][jcc][t4] 0020   00000077FBE2C800  08215F00000000    ...w.....!_....   .....SH........ 
[ibm][db2][jcc][t4] 
[ibm][db2][jcc][t4]        RECEIVE BUFFER: QRYDSC              (ASCII)           (EBCDIC)
[ibm][db2][jcc][t4] 0000   0053D0530003004D  241A077800050101  .S.S...M$..x....  ..}....(........
[ibm][db2][jcc][t4] 0010   300C705010000000  2501007FFF077800  0.pP....%.....x.  ...&......."....
[ibm][db2][jcc][t4] 0020   050201D01276D002  000450000350000C  .....v....P..P..  ...}..}...&..&..
[ibm][db2][jcc][t4] 0030   5000085000180778  00050301E00971E0  P..P...x......q.  &..&........\..\
[ibm][db2][jcc][t4] 0040   540001D000010778  00050401F00671F0  T......x......q.  ...}........0..0
[ibm][db2][jcc][t4] 0050   E00000                              ...               \..             
[ibm][db2][jcc][t4] 
[ibm][db2][jcc][t4]        RECEIVE BUFFER: QRYDTA              (ASCII)           (EBCDIC)
[ibm][db2][jcc][t4] 0000   0043D05300038008  241B00000035FF00  .C.S....$....5..  ..}.............
[ibm][db2][jcc][t4] 0010   0000003D404040E3  C1D4D4E840404040  ...=@@@.....@@@@  ....   XYZ   
[ibm][db2][jcc][t4] 0020   4040404040404040  404040D1C5E2D2C5  @@@@@@@@@@@.....             XYZ
[ibm][db2][jcc][t4] 0030   4040404040404040  4040404040404040  @@@@@@@@@@@@@@@@                  
[ibm][db2][jcc][t4] 0040   404040                              @@@                               
[ibm][db2][jcc][t4] 
[ibm][db2][jcc][t4]        RECEIVE BUFFER: ENDQRYRM            (ASCII)           (EBCDIC)
[ibm][db2][jcc][t4] 0000   0026D05200030020  220B000611490004  .&.R... "....I..  ..}.............
[ibm][db2][jcc][t4] 0010   00162110D1F3E3F1  4040404040404040  ..!.....@@@@@@@@  ....J3T1        
[ibm][db2][jcc][t4] 0020   404040404040                        @@@@@@                            
[ibm][db2][jcc][t4] 
[ibm][db2][jcc][t4]        RECEIVE BUFFER: SQLCARD             (ASCII)           (EBCDIC)
[ibm][db2][jcc][t4] 0000   0057D00300030051  2408000000006430  .W.....Q$.....d0  ..}.............
[ibm][db2][jcc][t4] 0010   3230303044534E58  52464E2000FFFFFF  2000DSNXRFN ....  ......+...+.....
[ibm][db2][jcc][t4] 0020   9200000000000000  00FFFFFFFF000000  ................  k...............
[ibm][db2][jcc][t4] 0030   0000000000202020  2020202020202020  .....             ................
[ibm][db2][jcc][t4] 0040   00104A3354312020  2020202020202020  ..J3T1            ................
[ibm][db2][jcc][t4] 0050   202000000000FF                        .....           .......         
[ibm][db2][jcc][t4] 
[ibm][db2][jcc][ResultSetMetaData@164d2b3] BEGIN TRACE_RESULT_SET_META_DATA
[ibm][db2][jcc][ResultSetMetaData@164d2b3] Result set meta data for statement Statement@cfbe92
[ibm][db2][jcc][ResultSetMetaData@164d2b3] Number of result set columns: 5
isDescribed=true[ibm][db2][jcc][ResultSetMetaData@164d2b3] Column 1: { label=INTKEY_EMPL, name=INTKEY_EMPL, type name=INTEGER, type=4, nullable=0, precision=10, scale=0, schema name=J3TEST, table name=EMPL, writable=false, sqlPrecision=0, sqlScale=0, sqlLength=4, sqlType=496, sqlCcsid=0, sqlName=INTKEY_EMPL, sqlLabel=null, sqlUnnamed=0, sqlComment=null, sqludtxType=<null>, sqludtRdb=<null>, sqludtSchema=<null>, sqludtName=<null>, sqlxKeymem=0, sqlxGenerated=2, sqlxParmmode=0, sqlxCorname=null, sqlxName=INTKEY_EMPL, sqlxBasename=EMPL, sqlxUpdatable=0, sqlxSchema=J3TEST, sqlxRdbnam=J3T1, internal type=4, is locator parameter=false }
[ibm][db2][jcc][ResultSetMetaData@164d2b3] Column 2: { label=TYPE_EMPL, name=TYPE_EMPL, type name=CHAR, type=1, nullable=0, precision=3, scale=0, schema name=J3TEST, table name=EMPL, writable=false, sqlPrecision=0, sqlScale=0, sqlLength=3, sqlType=452, sqlCcsid=37, sqlName=TYPE_EMPL, sqlLabel=null, sqlUnnamed=0, sqlComment=null, sqludtxType=<null>, sqludtRdb=<null>, sqludtSchema=<null>, sqludtName=<null>, sqlxKeymem=0, sqlxGenerated=0, sqlxParmmode=0, sqlxCorname=null, sqlxName=TYPE_EMPL, sqlxBasename=EMPL, sqlxUpdatable=0, sqlxSchema=J3TEST, sqlxRdbnam=J3T1, internal type=1, is locator parameter=false }
[ibm][db2][jcc][ResultSetMetaData@164d2b3] Column 3: { label=NAME_FIRST, name=NAME_FIRST, type name=CHAR, type=1, nullable=0, precision=12, scale=0, schema name=J3TEST, table name=EMPL, writable=false, sqlPrecision=0, sqlScale=0, sqlLength=12, sqlType=452, sqlCcsid=37, sqlName=NAME_FIRST, sqlLabel=null, sqlUnnamed=0, sqlComment=null, sqludtxType=<null>, sqludtRdb=<null>, sqludtSchema=<null>, sqludtName=<null>, sqlxKeymem=0, sqlxGenerated=0, sqlxParmmode=0, sqlxCorname=null, sqlxName=NAME_FIRST, sqlxBasename=EMPL, sqlxUpdatable=0, sqlxSchema=J3TEST, sqlxRdbnam=J3T1, internal type=1, is locator parameter=false }
[ibm][db2][jcc][ResultSetMetaData@164d2b3] Column 4: { label=NAME_MIDDLE, name=NAME_MIDDLE, type name=CHAR, type=1, nullable=0, precision=8, scale=0, schema name=J3TEST, table name=EMPL, writable=false, sqlPrecision=0, sqlScale=0, sqlLength=8, sqlType=452, sqlCcsid=37, sqlName=NAME_MIDDLE, sqlLabel=null, sqlUnnamed=0, sqlComment=null, sqludtxType=<null>, sqludtRdb=<null>, sqludtSchema=<null>, sqludtName=<null>, sqlxKeymem=0, sqlxGenerated=0, sqlxParmmode=0, sqlxCorname=null, sqlxName=NAME_MIDDLE, sqlxBasename=EMPL, sqlxUpdatable=0, sqlxSchema=J3TEST, sqlxRdbnam=J3T1, internal type=1, is locator parameter=false }
[ibm][db2][jcc][ResultSetMetaData@164d2b3] Column 5: { label=NAME_LAST, name=NAME_LAST, type name=CHAR, type=1, nullable=0, precision=24, scale=0, schema name=J3TEST, table name=EMPL, writable=false, sqlPrecision=0, sqlScale=0, sqlLength=24, sqlType=452, sqlCcsid=37, sqlName=NAME_LAST, sqlLabel=null, sqlUnnamed=0, sqlComment=null, sqludtxType=<null>, sqludtRdb=<null>, sqludtSchema=<null>, sqludtName=<null>, sqlxKeymem=0, sqlxGenerated=0, sqlxParmmode=0, sqlxCorname=null, sqlxName=NAME_LAST, sqlxBasename=EMPL, sqlxUpdatable=0, sqlxSchema=J3TEST, sqlxRdbnam=J3T1, internal type=1, is locator parameter=false }
[ibm][db2][jcc][ResultSetMetaData@164d2b3] { sqldHold=0, sqldReturn=0, sqldScroll=0, sqldSensitive=0, sqldFcode=0, sqldKeytype=0, sqldRdbnam=J3T1, sqldSchema=null }
[ibm][db2][jcc][ResultSetMetaData@164d2b3] END TRACE_RESULT_SET_META_DATA
[ibm][db2][jcc][ParameterMetaData@451fee] BEGIN TRACE_PARAMETER_META_DATA
[ibm][db2][jcc][ParameterMetaData@451fee] Parameter meta data for statement Statement@cfbe92
[ibm][db2][jcc][ParameterMetaData@451fee] Number of parameter columns: 1
isDescribed=true[ibm][db2][jcc][ParameterMetaData@451fee] Column 1: { label=1, name=1, type name=CHAR, type=1, nullable=1, precision=20, scale=0, schema name=, table name=, writable=false, sqlPrecision=0, sqlScale=0, sqlLength=20, sqlType=453, sqlCcsid=37, sqlName=1, sqlLabel=null, sqlUnnamed=0, sqlComment=null, sqludtxType=<null>, sqludtRdb=<null>, sqludtSchema=<null>, sqludtName=<null>, sqlxKeymem=<null>, sqlxGenerated=<null>, sqlxParmmode=1, sqlxCorname=<null>, sqlxName=<null>, sqlxBasename=<null>, sqlxUpdatable=<null>, sqlxSchema=<null>, sqlxRdbnam=<null>, internal type=1, is locator parameter=false }
[ibm][db2][jcc][ParameterMetaData@451fee] { sqldHold=0, sqldReturn=0, sqldScroll=0, sqldSensitive=0, sqldFcode=0, sqldKeytype=0, sqldRdbnam=null, sqldSchema=null }
[ibm][db2][jcc][ParameterMetaData@451fee] END TRACE_PARAMETER_META_DATA
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][PreparedStatement@cfbe92] execute () returned true
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][PreparedStatement@cfbe92] getResultSet () called
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][PreparedStatement@cfbe92] getResultSet () returned ResultSet@1022eb0
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][ResultSet@1022eb0] getType () returned 1003
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][ResultSet@1022eb0] next () called
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][ResultSet@1022eb0] next () returned true
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][ResultSet@1022eb0] getInt (INTKEY_EMPL) called
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][ResultSet@1022eb0] getInt (1) called
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][ResultSet@1022eb0] getInt () returned 61
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][ResultSet@1022eb0] wasNull () called
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][ResultSet@1022eb0] wasNull () returned false
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][ResultSet@1022eb0] getString (TYPE_EMPL) called
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][ResultSet@1022eb0] getString (2) called
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][ResultSet@1022eb0] getString () returned    
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][ResultSet@1022eb0] wasNull () called
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][ResultSet@1022eb0] wasNull () returned false
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][ResultSet@1022eb0] getString (NAME_FIRST) called
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][ResultSet@1022eb0] getString (3) called
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][ResultSet@1022eb0] getString () returned XYZ       
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][ResultSet@1022eb0] wasNull () called
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][ResultSet@1022eb0] wasNull () returned false
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][ResultSet@1022eb0] getString (NAME_MIDDLE) called
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][ResultSet@1022eb0] getString (4) called
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][ResultSet@1022eb0] getString () returned         
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][ResultSet@1022eb0] wasNull () called
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][ResultSet@1022eb0] wasNull () returned false
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][ResultSet@1022eb0] getString (NAME_LAST) called
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][ResultSet@1022eb0] getString (5) called
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][ResultSet@1022eb0] getString () returned XYZ                   
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][ResultSet@1022eb0] wasNull () called
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][ResultSet@1022eb0] wasNull () returned false
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][ResultSet@1022eb0] next () called
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][ResultSet@1022eb0] next () returned false
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][PreparedStatement@cfbe92] getMoreResults () called
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][PreparedStatement@cfbe92] getMoreResults () returned false
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][ResultSet@1022eb0] close () called
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][PreparedStatement@cfbe92] close () called
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][Connection@1c3b761] getTransactionIsolation () returned 1
[ibm][db2][jcc][Time:1239976589593][Thread:httpSSLWorkerThread-8080-0][Connection@1c3b761] setAutoCommit (true) called
[ibm][db2][jcc] [t4][time:1239976589593][thread:httpSSLWorkerThread-8080-0][tracepoint:5][Request.flush]
[ibm][db2][jcc][t4]        SEND BUFFER: RDBCMM                 (ASCII)           (EBCDIC)
[ibm][db2][jcc][t4]        0 1 2 3 4 5 6 7   8 9 A B C D E F   0123456789ABCDEF  0123456789ABCDEF
[ibm][db2][jcc][t4] 0000   000AD00100010004  200E              ........ .        ..}.......      
[ibm][db2][jcc][t4] 
[ibm][db2][jcc] [t4][time:1239976589640][thread:httpSSLWorkerThread-8080-0][tracepoint:2][Reply.fill]
[ibm][db2][jcc][t4]        RECEIVE BUFFER: ENDUOWRM            (ASCII)           (EBCDIC)
[ibm][db2][jcc][t4]        0 1 2 3 4 5 6 7   8 9 A B C D E F   0123456789ABCDEF  0123456789ABCDEF
[ibm][db2][jcc][t4] 0000   002BD05200010025  220C000611490004  .+.R...%"....I..  ..}.............
[ibm][db2][jcc][t4] 0010   00162110D1F3E3F1  4040404040404040  ..!.....@@@@@@@@  ....J3T1        
[ibm][db2][jcc][t4] 0020   4040404040400005  211501            @@@@@@..!..             .....     
[ibm][db2][jcc][t4] 
[ibm][db2][jcc][t4]        RECEIVE BUFFER: SQLCARD             (ASCII)           (EBCDIC)
[ibm][db2][jcc][t4] 0000   000BD00300010005  2408FF            ........$..       ..}........     
[ibm][db2][jcc][t4] 
[ibm][db2][jcc][Connection@1c3b761] DB2 LUWID: GA101042.C011.01AC87135629.0001
[ibm][db2][jcc][Time:1239976589640][Thread:httpSSLWorkerThread-8080-0][Connection@1c3b761] getAutoCommit () returned true
[ibm][db2][jcc][Time:1239976589640][Thread:httpSSLWorkerThread-8080-0][Connection@1c3b761] setAutoCommit (false) called
[ibm][db2][jcc][Time:1239976589640][Thread:httpSSLWorkerThread-8080-0][Connection@1c3b761] prepareStatement (          SELECT DISTINCT CODE_REGN AS regions         FROM J3TEST.REGN         WHERE REGN_FK_AGEN = ?     ) called
[ibm][db2][jcc][Time:1239976589640][Thread:httpSSLWorkerThread-8080-0][Connection@1c3b761] prepareStatement () returned com.ibm.db2.jcc.a.lg@44e906
[ibm][db2][jcc][Time:1239976589640][Thread:httpSSLWorkerThread-8080-0][PreparedStatement@44e906] setString (1, BOP) called
[ibm][db2][jcc][Time:
 
 
********************END OF SNIPPET*****************************
 
 
2.  Before Change to Connection Pool (You've already seen this:
 
[ibm][db2][jcc][t4]   DRDA manager levels: { SQLAM=7, AGENT=7, CMNTCPIP=5, RDB=7, SECMGR=7, XAMGR=0, SYNCPTMGR=0, RSYNCMGR=0 }
[ibm][db2][jcc][Time:1239883478953][Thread:httpSSLWorkerThread-8080-0][Connection@25e068] setTransactionIsolation (1) called
[ibm][db2][jcc][Time:1239883478953][Thread:httpSSLWorkerThread-8080-0][Connection@669c84] getTransactionIsolation () returned 1
[ibm][db2][jcc][Time:1239883478953][Thread:httpSSLWorkerThread-8080-0][Connection@669c84] getAutoCommit () returned true
[ibm][db2][jcc][Time:1239883478953][Thread:httpSSLWorkerThread-8080-0][Connection@669c84] setAutoCommit (false) called
[ibm][db2][jcc][Time:1239883478968][Thread:httpSSLWorkerThread-8080-0][Connection@669c84] prepareStatement (          SELECT b.INTKEY_EMPL, b.TYPE_EMPL, b.NAME_FIRST, b.NAME_MIDDLE, b.NAME_LAST         FROM J3TEST.ENUM a, J3TEST.EMPL b         WHERE a.NBR_ENUM = ? AND a.CODE_TNUM = 'UID' AND a.INTKEY_EMPL = b.INTKEY_EMPL     ) called
[ibm][db2][jcc][Time:1239883478984][Thread:httpSSLWorkerThread-8080-0][Connection@669c84] prepareStatement () returned com.ibm.db2.jcc.a.lg@1ff1855
[ibm][db2][jcc][Time:1239883479000][Thread:httpSSLWorkerThread-8080-0][PreparedStatement@1ff1855] setString (1, BOP1339) called
[ibm][db2][jcc][Time:1239883479000][Thread:httpSSLWorkerThread-8080-0][PreparedStatement@1ff1855] execute () called
[ibm][db2][jcc] [t4][time:1239883479015][thread:httpSSLWorkerThread-8080-0][tracepoint:5][Request.flush]
[ibm][db2][jcc][t4]        SEND BUFFER: PRPSQLSTT              (ASCII)           (EBCDIC)
[ibm][db2][jcc][t4]        0 1 2 3 4 5 6 7   8 9 A B C D E F   0123456789ABCDEF  0123456789ABCDEF
[ibm][db2][jcc][t4] 0000   0058D05100010052  200D00442113D1F3  .X.Q...R ..D!...  ..}...........J3
[ibm][db2][jcc][t4] 0010   E3F1404040404040  4040404040404040  ..@@@@@@@@@@@@@@  T1              
[ibm][db2][jcc][t4] 0020   D5E4D3D3C9C44040  4040404040404040  ......@@@@@@@@@@  NULLID          
[ibm][db2][jcc][t4] 0030   4040E2E8E2D3D5F1  F0F0404040404040  @@........@@@@@@    SYSLN100      
[ibm][db2][jcc][t4] 0040   404040405359534C  564C303100010005  @@@@SYSLVL01....      ...<.<......
[ibm][db2][jcc][t4] 0050   2116F10005214604                    !....!F.          ..1.....        
[ibm][db2][jcc][t4] 
[ibm][db2][jcc][t4]        SEND BUFFER: SQLATTR                (ASCII)           (EBCDIC)
[ibm][db2][jcc][t4] 0000   001ED05300010018  2450000000000E46  ...S....$P.....F  ..}......&......
[ibm][db2][jcc][t4] 0010   4F52205245414420  4F4E4C5920FF      OR READ ONLY .    |.......|+<...  
[ibm][db2][jcc][t4] 
[ibm][db2][jcc][t4]        SEND BUFFER: SQLSTT                 (ASCII)           (EBCDIC)
[ibm][db2][jcc][t4] 0000   00EBD043000100E5  241400000000DB20  ...C....$......   ..}....V........
[ibm][db2][jcc][t4] 0010   2020202020202020  2053454C45435420           SELECT   ...........<....
[ibm][db2][jcc][t4] 0020   622E494E544B4559  5F454D504C2C2062  b.INTKEY_EMPL, b  ...+......(&<...
[ibm][db2][jcc][t4] 0030   2E545950455F454D  504C2C20622E4E41  .TYPE_EMPL, b.NA  ...&...(&<....+.
[ibm][db2][jcc][t4] 0040   4D455F4649525354  2C20622E4E414D45  ME_FIRST, b.NAME  (...........+.(.
[ibm][db2][jcc][t4] 0050   5F4D4944444C452C  20622E4E414D455F  _MIDDLE, b.NAME_  .(...<.....+.(..
[ibm][db2][jcc][t4] 0060   4C41535420202020  202020202046524F  LAST         FRO  <..............|
[ibm][db2][jcc][t4] 0070   4D204A3354455354  2E454E554D20612C  M J3TEST.ENUM a,  (.........+.(./.
[ibm][db2][jcc][t4] 0080   204A33544553542E  454D504C20622020   J3TEST.EMPL b    .........(&<....
[ibm][db2][jcc][t4] 0090   2020202020202057  4845524520612E4E         WHERE a.N  ............./.+
[ibm][db2][jcc][t4] 00A0   42525F454E554D20  3D203F20414E4420  BR_ENUM = ? AND   ....+.(......+..
[ibm][db2][jcc][t4] 00B0   612E434F44455F54  4E554D203D202755  a.CODE_TNUM = 'U  /..|....+.(.....
[ibm][db2][jcc][t4] 00C0   49442720414E4420  612E494E544B4559  ID' AND a.INTKEY  .....+../..+....
[ibm][db2][jcc][t4] 00D0   5F454D504C203D20  622E494E544B4559  _EMPL = b.INTKEY  ..(&<......+....
[ibm][db2][jcc][t4] 00E0   5F454D504C202020  2020FF            _EMPL     .       ..(&<......     
[ibm][db2][jcc][t4] 
[ibm][db2][jcc][t4]        SEND BUFFER: DSCSQLSTT              (ASCII)           (EBCDIC)
[ibm][db2][jcc][t4] 0000   0053D0410002004D  200800442113D1F3  .S.A...M ..D!...  ..}....(......J3
[ibm][db2][jcc][t4] 0010   E3F1404040404040  4040404040404040  ..@@@@@@@@@@@@@@  T1              
[ibm][db2][jcc][t4] 0020   D5E4D3D3C9C44040  4040404040404040  ......@@@@@@@@@@  NULLID          
[ibm][db2][jcc][t4] 0030   4040E2E8E2D3D5F1  F0F0404040404040  @@........@@@@@@    SYSLN100      
[ibm][db2][jcc][t4] 0040   404040405359534C  564C303100010005  @@@@SYSLVL01....      ...<.<......
[ibm][db2][jcc][t4] 0050   214601                              !F.               ...             
[ibm][db2][jcc][t4] 
[ibm][db2][jcc][t4]        SEND BUFFER: OPNQRY                 (ASCII)           (EBCDIC)
[ibm][db2][jcc][t4] 0000   005BD05100030055  200C00442113D1F3  .[.Q...U ..D!...  .$}...........J3
[ibm][db2][jcc][t4] 0010   E3F1404040404040  4040404040404040  ..@@@@@@@@@@@@@@  T1              
[ibm][db2][jcc][t4] 0020   D5E4D3D3C9C44040  4040404040404040  ......@@@@@@@@@@  NULLID          
[ibm][db2][jcc][t4] 0030   4040E2E8E2D3D5F1  F0F0404040404040  @@........@@@@@@    SYSLN100      
[ibm][db2][jcc][t4] 0040   404040405359534C  564C303100010008  @@@@SYSLVL01....      ...<.<......
[ibm][db2][jcc][t4] 0050   211400007FFF0005  215D01            !.......!].       ...."....).     
[ibm][db2][jcc][t4] 
[ibm][db2][jcc][t4]        SEND BUFFER: SQLDTA                 (ASCII)           (EBCDIC)
[ibm][db2][jcc][t4] 0000   0029D00300030023  2412001000100676  .).....#$......v  ..}.............
[ibm][db2][jcc][t4] 0010   D03F7FFF0671E4D0  0001000F147A0000  .?...q.......z..  }."...U}.....:..
[ibm][db2][jcc][t4] 0020   0007424F50313333  39                ..BOP1339         ...|&....       
[ibm][db2][jcc][t4] 
[ibm][db2][jcc] [t4][time:1239883479078][thread:httpSSLWorkerThread-8080-0][tracepoint:2][Reply.fill]
[ibm][db2][jcc][t4]        RECEIVE BUFFER: SQLDARD             (ASCII)           (EBCDIC)
[ibm][db2][jcc][t4]        0 1 2 3 4 5 6 7   8 9 A B C D E F   0123456789ABCDEF  0123456789ABCDEF
[ibm][db2][jcc][t4] 0000   0241D0430001023B  2411000000000030  .A.C...;$......0  ..}.............
[ibm][db2][jcc][t4] 0010   3030303044534E20  2020202000000000  0000DSN     ....  ......+.........
[ibm][db2][jcc][t4] 0020   0000000000000000  0041B473B4000000  .........A.s....  ................
[ibm][db2][jcc][t4] 0030   0000000000202020  2020202020202020  .....             ................
[ibm][db2][jcc][t4] 0040   00104A3354312020  2020202020202020  ..J3T1            ................
[ibm][db2][jcc][t4] 0050   202000000000FF00  0000000000000000    ..............  ................
[ibm][db2][jcc][t4] 0060   0000000000044A33  5431000000000005  ......J3T1......  ................
[ibm][db2][jcc][t4] 0070   0000000000000000  0000000401F00000  ................  .............0..
[ibm][db2][jcc][t4] 0080   0000000000000B49  4E544B45595F454D  .......INTKEY_EM  ........+......(
[ibm][db2][jcc][t4] 0090   504C000000000000  0000FF0000000000  PL..............  &<..............
[ibm][db2][jcc][t4] 00A0   0002000000044A33  5431000000000000  ......J3T1......  ................
[ibm][db2][jcc][t4] 00B0   0004454D504C0000  00064A3354455354  ..EMPL....J3TEST  ...(&<..........
[ibm][db2][jcc][t4] 00C0   0000000B494E544B  45595F454D504C00  ....INTKEY_EMPL.  .....+......(&<.
[ibm][db2][jcc][t4] 00D0   0000000000000000  00000301C4002500  ..............%.  ............D...
[ibm][db2][jcc][t4] 00E0   0000000000095459  50455F454D504C00  ......TYPE_EMPL.  ........&...(&<.
[ibm][db2][jcc][t4] 00F0   00000000000000FF  0000000000000000  ................  ................
[ibm][db2][jcc][t4] 0100   0000044A33543100  0000000000000445  ...J3T1........E  ................
[ibm][db2][jcc][t4] 0110   4D504C000000064A  3354455354000000  MPL....J3TEST...  (&<.............
[ibm][db2][jcc][t4] 0120   09545950455F454D  504C000000000000  .TYPE_EMPL......  ...&...(&<......
[ibm][db2][jcc][t4] 0130   00000000000C01C4  0025000000000000  .........%......  .......D........
[ibm][db2][jcc][t4] 0140   0A4E414D455F4649  5253540000000000  .NAME_FIRST.....  .+.(............
[ibm][db2][jcc][t4] 0150   000000FF00000000  000000000000044A  ...............J  ................
[ibm][db2][jcc][t4] 0160   3354310000000000  000004454D504C00  3T1........EMPL.  ............(&<.
[ibm][db2][jcc][t4] 0170   0000064A33544553  540000000A4E414D  ...J3TEST....NAM  .............+.(
[ibm][db2][jcc][t4] 0180   455F464952535400  0000000000000000  E_FIRST.........  ................
[ibm][db2][jcc][t4] 0190   00000801C4002500  00000000000B4E41  ......%.......NA  ....D.........+.
[ibm][db2][jcc][t4] 01A0   4D455F4D4944444C  4500000000000000  ME_MIDDLE.......  (..(...<........
[ibm][db2][jcc][t4] 01B0   00FF000000000000  00000000044A3354  .............J3T  ................
[ibm][db2][jcc][t4] 01C0   3100000000000000  04454D504C000000  1........EMPL...  ..........(&<...
[ibm][db2][jcc][t4] 01D0   064A335445535400  00000B4E414D455F  .J3TEST....NAME_  ...........+.(..
[ibm][db2][jcc][t4] 01E0   4D4944444C450000  0000000000000000  MIDDLE..........  (...<...........
[ibm][db2][jcc][t4] 01F0   001801C400250000  00000000094E414D  .....%.......NAM  ...D.........+.(
[ibm][db2][jcc][t4] 0200   455F4C4153540000  000000000000FF00  E_LAST..........  ..<.............
[ibm][db2][jcc][t4] 0210   0000000000000000  00044A3354310000  ..........J3T1..  ................
[ibm][db2][jcc][t4] 0220   000000000004454D  504C000000064A33  ......EMPL....J3  .......(&<......
[ibm][db2][jcc][t4] 0230   5445535400000009  4E414D455F4C4153  TEST....NAME_LAS  ........+.(..<..
[ibm][db2][jcc][t4] 0240   54                                  T                 .               
[ibm][db2][jcc][t4] 
[ibm][db2][jcc][t4]        RECEIVE BUFFER: SQLDARD             (ASCII)           (EBCDIC)
[ibm][db2][jcc][t4] 0000   002FD04300020029  2411FFFF00010000  ./.C...)$.......  ..}.............
[ibm][db2][jcc][t4] 0010   0000000000000000  001401C500250000  .............%..  ...........E....
[ibm][db2][jcc][t4] 0020   0000000000000000  0000000000FFFF    ...............   ............... 
[ibm][db2][jcc][t4] 
[ibm][db2][jcc][t4]        RECEIVE BUFFER: OPNQRYRM            (ASCII)           (EBCDIC)
[ibm][db2][jcc][t4] 0000   002FD05200030029  2205000611490000  ./.R...)"....I..  ..}.............
[ibm][db2][jcc][t4] 0010   0006210224170005  215001000C215B00  ..!.$...!P...![.  .........&....$.
[ibm][db2][jcc][t4] 0020   000000789482C800  08215F00000000    ...x.....!_....   ....mbH........ 
[ibm][db2][jcc][t4] 
[ibm][db2][jcc][t4]        RECEIVE BUFFER: QRYDSC              (ASCII)           (EBCDIC)
[ibm][db2][jcc][t4] 0000   0053D0530003004D  241A077800050101  .S.S...M$..x....  ..}....(........
[ibm][db2][jcc][t4] 0010   300C705010000000  2501007FFF077800  0.pP....%.....x.  ...&......."....
[ibm][db2][jcc][t4] 0020   050201D01276D002  000450000350000C  .....v....P..P..  ...}..}...&..&..
[ibm][db2][jcc][t4] 0030   5000085000180778  00050301E00971E0  P..P...x......q.  &..&........\..\
[ibm][db2][jcc][t4] 0040   540001D000010778  00050401F00671F0  T......x......q.  ...}........0..0
[ibm][db2][jcc][t4] 0050   E00000                              ...               \..             
[ibm][db2][jcc][t4] 
[ibm][db2][jcc][t4]        RECEIVE BUFFER: QRYDTA              (ASCII)           (EBCDIC)
[ibm][db2][jcc][t4] 0000   0043D05300038008  241B00000035FF00  .C.S....$....5..  ..}.............
[ibm][db2][jcc][t4] 0010   0000003D404040E3  C1D4D4E840404040  ...=@@@.....@@@@  ....   XYZ    
[ibm][db2][jcc][t4] 0020   4040404040404040  404040D1C5E2D2C5  @@@@@@@@@@@.....             XYZ
[ibm][db2][jcc][t4] 0030   4040404040404040  4040404040404040  @@@@@@@@@@@@@@@@                  
[ibm][db2][jcc][t4] 0040   404040                              @@@                               
[ibm][db2][jcc][t4] 
[ibm][db2][jcc][t4]        RECEIVE BUFFER: ENDQRYRM            (ASCII)           (EBCDIC)
[ibm][db2][jcc][t4] 0000   0026D05200030020  220B000611490004  .&.R... "....I..  ..}.............
[ibm][db2][jcc][t4] 0010   00162110D1F3E3F1  4040404040404040  ..!.....@@@@@@@@  ....J3T1        
[ibm][db2][jcc][t4] 0020   404040404040                        @@@@@@                            
[ibm][db2][jcc][t4] 
[ibm][db2][jcc][t4]        RECEIVE BUFFER: SQLCARD             (ASCII)           (EBCDIC)
[ibm][db2][jcc][t4] 0000   0057D00300030051  2408000000006430  .W.....Q$.....d0  ..}.............
[ibm][db2][jcc][t4] 0010   3230303044534E58  52464E2000FFFFFF  2000DSNXRFN ....  ......+...+.....
[ibm][db2][jcc][t4] 0020   9200000000000000  00FFFFFFFF000000  ................  k...............
[ibm][db2][jcc][t4] 0030   0000000000202020  2020202020202020  .....             ................
[ibm][db2][jcc][t4] 0040   00104A3354312020  2020202020202020  ..J3T1            ................
[ibm][db2][jcc][t4] 0050   202000000000FF                        .....           .......         
[ibm][db2][jcc][t4] 
[ibm][db2][jcc][ResultSetMetaData@121b1f2] BEGIN TRACE_RESULT_SET_META_DATA
[ibm][db2][jcc][ResultSetMetaData@121b1f2] Result set meta data for statement Statement@1ff1855
[ibm][db2][jcc][ResultSetMetaData@121b1f2] Number of result set columns: 5
isDescribed=true[ibm][db2][jcc][ResultSetMetaData@121b1f2] Column 1: { label=INTKEY_EMPL, name=INTKEY_EMPL, type name=INTEGER, type=4, nullable=0, precision=10, scale=0, schema name=J3TEST, table name=EMPL, writable=false, sqlPrecision=0, sqlScale=0, sqlLength=4, sqlType=496, sqlCcsid=0, sqlName=INTKEY_EMPL, sqlLabel=null, sqlUnnamed=0, sqlComment=null, sqludtxType=<null>, sqludtRdb=<null>, sqludtSchema=<null>, sqludtName=<null>, sqlxKeymem=0, sqlxGenerated=2, sqlxParmmode=0, sqlxCorname=null, sqlxName=INTKEY_EMPL, sqlxBasename=EMPL, sqlxUpdatable=0, sqlxSchema=J3TEST, sqlxRdbnam=J3T1, internal type=4, is locator parameter=false }
[ibm][db2][jcc][ResultSetMetaData@121b1f2] Column 2: { label=TYPE_EMPL, name=TYPE_EMPL, type name=CHAR, type=1, nullable=0, precision=3, scale=0, schema name=J3TEST, table name=EMPL, writable=false, sqlPrecision=0, sqlScale=0, sqlLength=3, sqlType=452, sqlCcsid=37, sqlName=TYPE_EMPL, sqlLabel=null, sqlUnnamed=0, sqlComment=null, sqludtxType=<null>, sqludtRdb=<null>, sqludtSchema=<null>, sqludtName=<null>, sqlxKeymem=0, sqlxGenerated=0, sqlxParmmode=0, sqlxCorname=null, sqlxName=TYPE_EMPL, sqlxBasename=EMPL, sqlxUpdatable=0, sqlxSchema=J3TEST, sqlxRdbnam=J3T1, internal type=1, is locator parameter=false }
[ibm][db2][jcc][ResultSetMetaData@121b1f2] Column 3: { label=NAME_FIRST, name=NAME_FIRST, type name=CHAR, type=1, nullable=0, precision=12, scale=0, schema name=J3TEST, table name=EMPL, writable=false, sqlPrecision=0, sqlScale=0, sqlLength=12, sqlType=452, sqlCcsid=37, sqlName=NAME_FIRST, sqlLabel=null, sqlUnnamed=0, sqlComment=null, sqludtxType=<null>, sqludtRdb=<null>, sqludtSchema=<null>, sqludtName=<null>, sqlxKeymem=0, sqlxGenerated=0, sqlxParmmode=0, sqlxCorname=null, sqlxName=NAME_FIRST, sqlxBasename=EMPL, sqlxUpdatable=0, sqlxSchema=J3TEST, sqlxRdbnam=J3T1, internal type=1, is locator parameter=false }
[ibm][db2][jcc][ResultSetMetaData@121b1f2] Column 4: { label=NAME_MIDDLE, name=NAME_MIDDLE, type name=CHAR, type=1, nullable=0, precision=8, scale=0, schema name=J3TEST, table name=EMPL, writable=false, sqlPrecision=0, sqlScale=0, sqlLength=8, sqlType=452, sqlCcsid=37, sqlName=NAME_MIDDLE, sqlLabel=null, sqlUnnamed=0, sqlComment=null, sqludtxType=<null>, sqludtRdb=<null>, sqludtSchema=<null>, sqludtName=<null>, sqlxKeymem=0, sqlxGenerated=0, sqlxParmmode=0, sqlxCorname=null, sqlxName=NAME_MIDDLE, sqlxBasename=EMPL, sqlxUpdatable=0, sqlxSchema=J3TEST, sqlxRdbnam=J3T1, internal type=1, is locator parameter=false }
[ibm][db2][jcc][ResultSetMetaData@121b1f2] Column 5: { label=NAME_LAST, name=NAME_LAST, type name=CHAR, type=1, nullable=0, precision=24, scale=0, schema name=J3TEST, table name=EMPL, writable=false, sqlPrecision=0, sqlScale=0, sqlLength=24, sqlType=452, sqlCcsid=37, sqlName=NAME_LAST, sqlLabel=null, sqlUnnamed=0, sqlComment=null, sqludtxType=<null>, sqludtRdb=<null>, sqludtSchema=<null>, sqludtName=<null>, sqlxKeymem=0, sqlxGenerated=0, sqlxParmmode=0, sqlxCorname=null, sqlxName=NAME_LAST, sqlxBasename=EMPL, sqlxUpdatable=0, sqlxSchema=J3TEST, sqlxRdbnam=J3T1, internal type=1, is locator parameter=false }
[ibm][db2][jcc][ResultSetMetaData@121b1f2] { sqldHold=0, sqldReturn=0, sqldScroll=0, sqldSensitive=0, sqldFcode=0, sqldKeytype=0, sqldRdbnam=J3T1, sqldSchema=null }
[ibm][db2][jcc][ResultSetMetaData@121b1f2] END TRACE_RESULT_SET_META_DATA
[ibm][db2][jcc][ParameterMetaData@1299f0a] BEGIN TRACE_PARAMETER_META_DATA
[ibm][db2][jcc][ParameterMetaData@1299f0a] Parameter meta data for statement Statement@1ff1855
[ibm][db2][jcc][ParameterMetaData@1299f0a] Number of parameter columns: 1
isDescribed=true[ibm][db2][jcc][ParameterMetaData@1299f0a] Column 1: { label=1, name=1, type name=CHAR, type=1, nullable=1, precision=20, scale=0, schema name=, table name=, writable=false, sqlPrecision=0, sqlScale=0, sqlLength=20, sqlType=453, sqlCcsid=37, sqlName=1, sqlLabel=null, sqlUnnamed=0, sqlComment=null, sqludtxType=<null>, sqludtRdb=<null>, sqludtSchema=<null>, sqludtName=<null>, sqlxKeymem=<null>, sqlxGenerated=<null>, sqlxParmmode=1, sqlxCorname=<null>, sqlxName=<null>, sqlxBasename=<null>, sqlxUpdatable=<null>, sqlxSchema=<null>, sqlxRdbnam=<null>, internal type=1, is locator parameter=false }
[ibm][db2][jcc][ParameterMetaData@1299f0a] { sqldHold=0, sqldReturn=0, sqldScroll=0, sqldSensitive=0, sqldFcode=0, sqldKeytype=0, sqldRdbnam=null, sqldSchema=null }
[ibm][db2][jcc][ParameterMetaData@1299f0a] END TRACE_PARAMETER_META_DATA
[ibm][db2][jcc][Time:1239883479156][Thread:httpSSLWorkerThread-8080-0][PreparedStatement@1ff1855] execute () returned true
[ibm][db2][jcc][Time:1239883479156][Thread:httpSSLWorkerThread-8080-0][PreparedStatement@1ff1855] getResultSet () called
[ibm][db2][jcc][Time:1239883479156][Thread:httpSSLWorkerThread-8080-0][PreparedStatement@1ff1855] getResultSet () returned ResultSet@372f43
[ibm][db2][jcc][Time:1239883479156][Thread:httpSSLWorkerThread-8080-0][ResultSet@372f43] getType () returned 1003
[ibm][db2][jcc][Time:1239883479156][Thread:httpSSLWorkerThread-8080-0][ResultSet@372f43] next () called
[ibm][db2][jcc][Time:1239883479156][Thread:httpSSLWorkerThread-8080-0][ResultSet@372f43] next () returned true
[ibm][db2][jcc][Time:1239883479156][Thread:httpSSLWorkerThread-8080-0][ResultSet@372f43] getInt (INTKEY_EMPL) called
[ibm][db2][jcc][Time:1239883479156][Thread:httpSSLWorkerThread-8080-0][ResultSet@372f43] getInt (1) called
[ibm][db2][jcc][Time:1239883479156][Thread:httpSSLWorkerThread-8080-0][ResultSet@372f43] getInt () returned 61
[ibm][db2][jcc][Time:1239883479156][Thread:httpSSLWorkerThread-8080-0][ResultSet@372f43] wasNull () called
[ibm][db2][jcc][Time:1239883479156][Thread:httpSSLWorkerThread-8080-0][ResultSet@372f43] wasNull () returned false
[ibm][db2][jcc][Time:1239883479156][Thread:httpSSLWorkerThread-8080-0][ResultSet@372f43] getString (TYPE_EMPL) called
[ibm][db2][jcc][Time:1239883479156][Thread:httpSSLWorkerThread-8080-0][ResultSet@372f43] getString (2) called
[ibm][db2][jcc][Time:1239883479156][Thread:httpSSLWorkerThread-8080-0][ResultSet@372f43] getString () returned    
[ibm][db2][jcc][Time:1239883479156][Thread:httpSSLWorkerThread-8080-0][ResultSet@372f43] wasNull () called
[ibm][db2][jcc][Time:1239883479156][Thread:httpSSLWorkerThread-8080-0][ResultSet@372f43] wasNull () returned false
[ibm][db2][jcc][Time:1239883479156][Thread:httpSSLWorkerThread-8080-0][ResultSet@372f43] getString (NAME_FIRST) called
[ibm][db2][jcc][Time:1239883479156][Thread:httpSSLWorkerThread-8080-0][ResultSet@372f43] getString (3) called
[ibm][db2][jcc][Time:1239883479156][Thread:httpSSLWorkerThread-8080-0][ResultSet@372f43] getString () returned XYZ      
[ibm][db2][jcc][Time:1239883479156][Thread:httpSSLWorkerThread-8080-0][ResultSet@372f43] wasNull () called
[ibm][db2][jcc][Time:1239883479156][Thread:httpSSLWorkerThread-8080-0][ResultSet@372f43] wasNull () returned false
[ibm][db2][jcc][Time:1239883479156][Thread:httpSSLWorkerThread-8080-0][ResultSet@372f43] getString (NAME_MIDDLE) called
[ibm][db2][jcc][Time:1239883479156][Thread:httpSSLWorkerThread-8080-0][ResultSet@372f43] getString (4) called
[ibm][db2][jcc][Time:1239883479156][Thread:httpSSLWorkerThread-8080-0][ResultSet@372f43] getString () returned         
[ibm][db2][jcc][Time:1239883479156][Thread:httpSSLWorkerThread-8080-0][ResultSet@372f43] wasNull () called
[ibm][db2][jcc][Time:1239883479156][Thread:httpSSLWorkerThread-8080-0][ResultSet@372f43] wasNull () returned false
[ibm][db2][jcc][Time:1239883479156][Thread:httpSSLWorkerThread-8080-0][ResultSet@372f43] getString (NAME_LAST) called
[ibm][db2][jcc][Time:1239883479156][Thread:httpSSLWorkerThread-8080-0][ResultSet@372f43] getString (5) called
[ibm][db2][jcc][Time:1239883479156][Thread:httpSSLWorkerThread-8080-0][ResultSet@372f43] getString () returned XYZ                   
[ibm][db2][jcc][Time:1239883479156][Thread:httpSSLWorkerThread-8080-0][ResultSet@372f43] wasNull () called
[ibm][db2][jcc][Time:1239883479156][Thread:httpSSLWorkerThread-8080-0][ResultSet@372f43] wasNull () returned false
[ibm][db2][jcc][Time:1239883479171][Thread:httpSSLWorkerThread-8080-0][ResultSet@372f43] next () called
[ibm][db2][jcc][Time:1239883479171][Thread:httpSSLWorkerThread-8080-0][ResultSet@372f43] next () returned false
[ibm][db2][jcc][Time:1239883479171][Thread:httpSSLWorkerThread-8080-0][PreparedStatement@1ff1855] getMoreResults () called
[ibm][db2][jcc][Time:1239883479171][Thread:httpSSLWorkerThread-8080-0][PreparedStatement@1ff1855] getMoreResults () returned false
[ibm][db2][jcc][Time:1239883479171][Thread:httpSSLWorkerThread-8080-0][ResultSet@372f43] close () called
[ibm][db2][jcc][Time:1239883479171][Thread:httpSSLWorkerThread-8080-0][PreparedStatement@1ff1855] close () called
[ibm][db2][jcc][Time:1239883479187][Thread:httpSSLWorkerThread-8080-0][Connection@1331ce6] getTransactionIsolation () returned 1
[ibm][db2][jcc][Time:1239883479187][Thread:httpSSLWorkerThread-8080-0][Connection@1331ce6] getAutoCommit () returned true
[ibm][db2][jcc][Time:1239883479187][Thread:httpSSLWorkerThread-8080-0][Connection@1331ce6] setAutoCommit (false) called
[ibm][db2][jcc][Time:1239883479187][Thread:httpSSLWorkerThread-8080-0][Connection@1331ce6] prepareStatement (          SELECT DISTINCT CODE_REGN AS regions         FROM J3TEST.REGN         WHERE REGN_FK_AGEN = ?     ) called
[ibm][db2][jcc][Time:1239883479187][Thread:httpSSLWorkerThread-8080-0][Connection@1331ce6] prepareStatement () returned com.ibm.db2.jcc.a.lg@255d
[ibm][db2][jcc][Time:
 
 
********************END OF SNIPPET*****************************

>>> Mario Ds Briggs <mario.briggs@in.ibm.com> 4/17/2009 9:24 AM >>>
Jeff,

The autocommit is not the issue here - sorry to have confused you by
raising that, i wanted to highlight another point, but lets ignore that to
keep it simple.

The issue is that with Glassfish, the commit or rollback is not coming to
the JDBC driver, whereas with Simple/DBCP there is a rollback call. You
might want to look at how your is the txn management configured ? Becuase
this is a big diff to say the least :-) Are each of these queries intended
to be a separate txn ?

Thus my belief is that you are leaking connections here (given what proof
you have laid out) , which is why the you are seeing the idle connections
on the DB server.
Notice that in the case of glassfish, each query is executed using a
different connection (reason being the prev connection was not committed)

Connection@669c84 -  SELECT b.INTKEY_EMPL, b.TYPE_EMPL, b.NAME_FIRST,
b.NAME_MIDDLE, b.NAME_LAST         FROM J3TEST.ENUM a, J3TEST.EMPL b
WHERE a.NBR_ENUM = ? AND a.CODE_TNUM = 'UID' AND a.INTKEY_EMPL =
b.INTKEY_EMPL

[Connection@1331ce6] prepareStatement (          SELECT DISTINCT CODE_REGN
AS regions         FROM J3TEST.REGN         WHERE REGN_FK_AGEN = ?

Whereas with DBCP/Simple, the same connection is reused for the 2nd query
too.

Connection@1f68572   SELECT b.INTKEY_EMPL, b.TYPE_EMPL, b.NAME_FIRST,
b.NAME_MIDDLE, b.NAME_LAST         FROM J3TEST.ENUM a, J3TEST.EMPL b
WHERE a.NBR_ENUM = ? AND a.CODE_TNUM = 'UID' AND a.INTKEY_EMPL =
b.INTKEY_EMPL

Connection@1f68572] prepareStatement (          SELECT DISTINCT CODE_REGN
AS regions         FROM J3TEST.REGN         WHERE REGN_FK_AGEN = ?     )

Mario



                                                                           
 

Mime
View raw message