| Subject | SQL execution doesn't return |
|---|---|
| Author | K. Kumakura |
| Post date | 2005-06-22T04:09:25Z |
Hello,
We are experiencing strange errors that Statement.executeQuery
or executeUpdate never return to a caller. We have this kind of
errors few times a day. The only way to recover from the error
is to restart the application.
Could anyone advise us how to locate what is wrong?
Two stack traces are attached. One is after SELECT, another
is after COMMIT.
Thanks,
K. Kumakura
-----Stack trace after SELECT -----
[org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Getting connection from pool org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@4e76b4[state=NORMAL mc=org.firebirdsql.jca.FBManagedConnection@1533b2c handles=0 lastUse=1119398688380 permit=true trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@151d6cb context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@1ecda50] [InUse/Available/Max]: [1/19/20]
[org.firebirdsql.jca.FBManagedConnection] start called: XidImpl[FormatId=257, GlobalId=yamato04/64, BranchQual=1, localId=64]
[org.firebirdsql.jgds.GDS_Impl] op_transaction
[org.firebirdsql.jgds.GDS_Impl] sent
[org.firebirdsql.jgds.GDS_Impl] op_response
[org.firebirdsql.jgds.GDS_Impl] op_response resp_object: 1
[org.firebirdsql.jgds.GDS_Impl] op_response resp_blob_id: 0
[org.firebirdsql.jgds.GDS_Impl] op_response resp_data size: 0
[org.firebirdsql.jgds.GDS_Impl] readStatusVector arg:isc_arg_gds int: 0
[org.firebirdsql.jgds.GDS_Impl] received
[STDOUT] SELECT ALL t0.PublisherCode,t0.PublisherName,t0.PublisherNameKana,t0.BusinessCode,t0.Zip,t0.Addr1,t0.Addr2,t0.Tel,t0.Fax,t0.EMail,t0.BankAccount,t0.TaxCnf,t0.RoundingModeBkSvc,t0.A2pNRow,t0.P2aNRow,t0.StdCnf,t0.OptCnf,t0.CSVOption FROM Config t0 WHERE (1=1)
[org.firebirdsql.jgds.GDS_Impl] op_allocate_statement
[org.firebirdsql.jgds.GDS_Impl] sent
[org.firebirdsql.jgds.GDS_Impl] op_response
[org.firebirdsql.jgds.GDS_Impl] op_response resp_object: 2
[org.firebirdsql.jgds.GDS_Impl] op_response resp_blob_id: 0
[org.firebirdsql.jgds.GDS_Impl] op_response resp_data size: 0
[org.firebirdsql.jgds.GDS_Impl] readStatusVector arg:isc_arg_gds int: 0
[org.firebirdsql.jgds.GDS_Impl] received
[org.firebirdsql.jca.FBManagedConnection] preparing sql: SELECT ALL t0.PublisherCode,t0.PublisherName,t0.PublisherNameKana,t0.BusinessCode,t0.Zip,t0.Addr1,t0.Addr2,t0.Tel,t0.Fax,t0.EMail,t0.BankAccount,t0.TaxCnf,t0.RoundingModeBkSvc,t0.A2pNRow,t0.P2aNRow,t0.StdCnf,t0.OptCnf,t0.CSVOption FROM Config t0 WHERE (1=1)
[org.firebirdsql.jgds.GDS_Impl] op_prepare_statement
[org.firebirdsql.jgds.GDS_Impl] sent
[org.firebirdsql.jgds.GDS_Impl] op_response
[org.firebirdsql.jgds.GDS_Impl] op_response resp_object: 0
[org.firebirdsql.jgds.GDS_Impl] op_response resp_blob_id: 0
[org.firebirdsql.jgds.GDS_Impl] op_response resp_data size: 1024
[org.firebirdsql.jgds.GDS_Impl] readStatusVector arg:isc_arg_gds int: 0
[org.firebirdsql.jgds.GDS_Impl] received
[org.firebirdsql.jgds.GDS_Impl] parseSqlInfo started
[org.firebirdsql.jgds.GDS_Impl] parseSqlInfo: first 2 bytes are 1796 or: 4, 7
[org.firebirdsql.jgds.GDS_Impl] xsqlda.sqln read as 18
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 448
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 5
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 64
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field PUBLISHERCODE
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation CONFIG
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner YUTO_NORASYOTEN
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias PUBLISHERCODE
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 1
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 448
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 5
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 160
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field PUBLISHERNAME
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation CONFIG
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner YUTO_NORASYOTEN
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias PUBLISHERNAME
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 2
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 449
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 5
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 80
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field PUBLISHERNAMEKANA
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation CONFIG
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner YUTO_NORASYOTEN
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias PUBLISHERNAMEKANA
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 3
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 448
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 5
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 64
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field BUSINESSCODE
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation CONFIG
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner YUTO_NORASYOTEN
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias BUSINESSCODE
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 4
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 448
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 5
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 14
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field ZIP
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation CONFIG
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner YUTO_NORASYOTEN
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias ZIP
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 5
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 448
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 5
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 200
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field ADDR1
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation CONFIG
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner YUTO_NORASYOTEN
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias ADDR1
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 6
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 449
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 5
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 200
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field ADDR2
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation CONFIG
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner YUTO_NORASYOTEN
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias ADDR2
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 7
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 448
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 5
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 26
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field TEL
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation CONFIG
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner YUTO_NORASYOTEN
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias TEL
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 8
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 449
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 5
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 24
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field FAX
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation CONFIG
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner YUTO_NORASYOTEN
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias FAX
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 9
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 449
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 5
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 120
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field EMAIL
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation CONFIG
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner YUTO_NORASYOTEN
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias EMAIL
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 10
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 449
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 5
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 120
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field BANKACCOUNT
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation CONFIG
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner YUTO_NORASYOTEN
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias BANKACCOUNT
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 11
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 500
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 1
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale -2
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 2
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field TAXCNF
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation CONFIG
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner YUTO_NORASYOTEN
[org.firebirdsql.jgds.GDS_Impl] isc_info_truncated
[org.firebirdsql.jgds.GDS_Impl] op_info_sql
[org.firebirdsql.jgds.GDS_Impl] sent
????? CONTROL NOT RETURNED ?????
-----Stack trace after COMMIT -----
[org.firebirdsql.jca.FBManagedConnection] preparing sql: UPDATE Warehouse SET Id=?,WarehouseCtg=?,Name=?,TakingDt=?,LossHdrId=?,InpDt=?,UpdDt=?,AcsBit=? WHERE (Id=?)
[org.firebirdsql.jgds.GDS_Impl] op_prepare_statement
[org.firebirdsql.jgds.GDS_Impl] sent
[org.firebirdsql.jgds.GDS_Impl] op_response
[org.firebirdsql.jgds.GDS_Impl] op_response resp_object: 0
[org.firebirdsql.jgds.GDS_Impl] op_response resp_blob_id: 0
[org.firebirdsql.jgds.GDS_Impl] op_response resp_data size: 1024
[org.firebirdsql.jgds.GDS_Impl] readStatusVector arg:isc_arg_gds int: 0
[org.firebirdsql.jgds.GDS_Impl] received
[org.firebirdsql.jgds.GDS_Impl] parseSqlInfo started
[org.firebirdsql.jgds.GDS_Impl] parseSqlInfo: first 2 bytes are 1796 or: 4, 7
[org.firebirdsql.jgds.GDS_Impl] xsqlda.sqln read as 0
[org.firebirdsql.jgds.GDS_Impl] parseSqlInfo ended
[org.firebirdsql.jgds.GDS_Impl] op_info_sql
[org.firebirdsql.jgds.GDS_Impl] sent
[org.firebirdsql.jgds.GDS_Impl] op_response
[org.firebirdsql.jgds.GDS_Impl] op_response resp_object: 2
[org.firebirdsql.jgds.GDS_Impl] op_response resp_blob_id: 0
[org.firebirdsql.jgds.GDS_Impl] op_response resp_data size: 1024
[org.firebirdsql.jgds.GDS_Impl] readStatusVector arg:isc_arg_gds int: 0
[org.firebirdsql.jgds.GDS_Impl] received
[org.firebirdsql.jgds.GDS_Impl] parseSqlInfo started
[org.firebirdsql.jgds.GDS_Impl] parseSqlInfo: first 2 bytes are 1797 or: 5, 7
[org.firebirdsql.jgds.GDS_Impl] xsqlda.sqln read as 9
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 500
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 2
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 1
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 500
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 2
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 2
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 449
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 5
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 40
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 3
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 571
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 4
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 4
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 497
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 4
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 5
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 580
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 1
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 8
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 6
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 580
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 1
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 8
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 7
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 500
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 2
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 8
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 500
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 2
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias
[org.firebirdsql.jgds.GDS_Impl] parseSqlInfo ended
[itj.dao.WarehouseDAO] WarehouseDAO(setValue):{[id]=2[warehouseCtg]=2[name]=Yuto(ret)[takingDt]=2005-06-20[lossHdrId]=null[inpDt]=0[updDt]=1119405641210[acsBit]=0[lastTakingDt]=null}
[org.firebirdsql.jgds.GDS_Impl] op_execute
[org.firebirdsql.gds.XdrOutputStream] sqldata null in writeSQLDatum: org.firebirdsql.gds.XSQLVAR@1dce46d
[org.firebirdsql.gds.XdrOutputStream] sqldata still null in writeSQLDatum: org.firebirdsql.gds.XSQLVAR@1dce46d
[org.firebirdsql.jgds.GDS_Impl] sent
[org.firebirdsql.jgds.GDS_Impl] op_response
[org.firebirdsql.jgds.GDS_Impl] op_response resp_object: 1
[org.firebirdsql.jgds.GDS_Impl] op_response resp_blob_id: 0
[org.firebirdsql.jgds.GDS_Impl] op_response resp_data size: 0
[org.firebirdsql.jgds.GDS_Impl] readStatusVector arg:isc_arg_gds int: 0
[org.firebirdsql.jgds.GDS_Impl] received
[org.firebirdsql.jgds.GDS_Impl] op_info_sql
[org.firebirdsql.jgds.GDS_Impl] sent
[org.firebirdsql.jgds.GDS_Impl] op_response
[org.firebirdsql.jgds.GDS_Impl] op_response resp_object: 2
[org.firebirdsql.jgds.GDS_Impl] op_response resp_blob_id: 0
[org.firebirdsql.jgds.GDS_Impl] op_response resp_data size: 128
[org.firebirdsql.jgds.GDS_Impl] readStatusVector arg:isc_arg_gds int: 0
[org.firebirdsql.jgds.GDS_Impl] received
[org.firebirdsql.jgds.GDS_Impl] op_free_statement
[org.firebirdsql.jgds.GDS_Impl] sent
[org.firebirdsql.jgds.GDS_Impl] op_response
[org.firebirdsql.jgds.GDS_Impl] op_response resp_object: -1
[org.firebirdsql.jgds.GDS_Impl] op_response resp_blob_id: 0
[org.firebirdsql.jgds.GDS_Impl] op_response resp_data size: 0
[org.firebirdsql.jgds.GDS_Impl] readStatusVector arg:isc_arg_gds int: 0
[org.firebirdsql.jgds.GDS_Impl] received
[org.firebirdsql.jca.FBManagedConnection] End called: XidImpl[FormatId=257, GlobalId=yamato04/242, BranchQual=1, localId=242]
[org.jboss.resource.connectionmanager.JBossManagedConnectionPool] putting ManagedConnection back into pool kill=false cl=org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@aed3a5[state=NORMAL mc=org.firebirdsql.jca.FBManagedConnection@1c9076d handles=0 lastUse=1119405619000 permit=true trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@106870c context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@18c2661]
[org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Returning connection to pool org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@aed3a5[state=NORMAL mc=org.firebirdsql.jca.FBManagedConnection@1c9076d handles=0 lastUse=1119405641708 permit=false trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@106870c context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@18c2661] [InUse/Available/Max]: [0/20/20]
[org.firebirdsql.jca.FBManagedConnection] End called: XidImpl[FormatId=257, GlobalId=yamato04/242, BranchQual=1, localId=242]
[org.firebirdsql.jca.FBManagedConnection] Commit called: XidImpl[FormatId=257, GlobalId=yamato04/242, BranchQual=1, localId=242]
[org.firebirdsql.jgds.GDS_Impl] op_commit
[org.firebirdsql.jgds.GDS_Impl] tr.rtr_id: 1
[org.firebirdsql.jgds.GDS_Impl] sent
[org.firebirdsql.jgds.GDS_Impl] op_response
[org.firebirdsql.jgds.GDS_Impl] op_response resp_object: 0
[org.firebirdsql.jgds.GDS_Impl] op_response resp_blob_id: 0
[org.firebirdsql.jgds.GDS_Impl] op_response resp_data size: 0
[org.firebirdsql.jgds.GDS_Impl] readStatusVector arg:isc_arg_gds int: 0
[org.firebirdsql.jgds.GDS_Impl] received
????? CONTROL NOT RETURNED ?????
We are experiencing strange errors that Statement.executeQuery
or executeUpdate never return to a caller. We have this kind of
errors few times a day. The only way to recover from the error
is to restart the application.
Could anyone advise us how to locate what is wrong?
Two stack traces are attached. One is after SELECT, another
is after COMMIT.
Thanks,
K. Kumakura
-----Stack trace after SELECT -----
[org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Getting connection from pool org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@4e76b4[state=NORMAL mc=org.firebirdsql.jca.FBManagedConnection@1533b2c handles=0 lastUse=1119398688380 permit=true trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@151d6cb context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@1ecda50] [InUse/Available/Max]: [1/19/20]
[org.firebirdsql.jca.FBManagedConnection] start called: XidImpl[FormatId=257, GlobalId=yamato04/64, BranchQual=1, localId=64]
[org.firebirdsql.jgds.GDS_Impl] op_transaction
[org.firebirdsql.jgds.GDS_Impl] sent
[org.firebirdsql.jgds.GDS_Impl] op_response
[org.firebirdsql.jgds.GDS_Impl] op_response resp_object: 1
[org.firebirdsql.jgds.GDS_Impl] op_response resp_blob_id: 0
[org.firebirdsql.jgds.GDS_Impl] op_response resp_data size: 0
[org.firebirdsql.jgds.GDS_Impl] readStatusVector arg:isc_arg_gds int: 0
[org.firebirdsql.jgds.GDS_Impl] received
[STDOUT] SELECT ALL t0.PublisherCode,t0.PublisherName,t0.PublisherNameKana,t0.BusinessCode,t0.Zip,t0.Addr1,t0.Addr2,t0.Tel,t0.Fax,t0.EMail,t0.BankAccount,t0.TaxCnf,t0.RoundingModeBkSvc,t0.A2pNRow,t0.P2aNRow,t0.StdCnf,t0.OptCnf,t0.CSVOption FROM Config t0 WHERE (1=1)
[org.firebirdsql.jgds.GDS_Impl] op_allocate_statement
[org.firebirdsql.jgds.GDS_Impl] sent
[org.firebirdsql.jgds.GDS_Impl] op_response
[org.firebirdsql.jgds.GDS_Impl] op_response resp_object: 2
[org.firebirdsql.jgds.GDS_Impl] op_response resp_blob_id: 0
[org.firebirdsql.jgds.GDS_Impl] op_response resp_data size: 0
[org.firebirdsql.jgds.GDS_Impl] readStatusVector arg:isc_arg_gds int: 0
[org.firebirdsql.jgds.GDS_Impl] received
[org.firebirdsql.jca.FBManagedConnection] preparing sql: SELECT ALL t0.PublisherCode,t0.PublisherName,t0.PublisherNameKana,t0.BusinessCode,t0.Zip,t0.Addr1,t0.Addr2,t0.Tel,t0.Fax,t0.EMail,t0.BankAccount,t0.TaxCnf,t0.RoundingModeBkSvc,t0.A2pNRow,t0.P2aNRow,t0.StdCnf,t0.OptCnf,t0.CSVOption FROM Config t0 WHERE (1=1)
[org.firebirdsql.jgds.GDS_Impl] op_prepare_statement
[org.firebirdsql.jgds.GDS_Impl] sent
[org.firebirdsql.jgds.GDS_Impl] op_response
[org.firebirdsql.jgds.GDS_Impl] op_response resp_object: 0
[org.firebirdsql.jgds.GDS_Impl] op_response resp_blob_id: 0
[org.firebirdsql.jgds.GDS_Impl] op_response resp_data size: 1024
[org.firebirdsql.jgds.GDS_Impl] readStatusVector arg:isc_arg_gds int: 0
[org.firebirdsql.jgds.GDS_Impl] received
[org.firebirdsql.jgds.GDS_Impl] parseSqlInfo started
[org.firebirdsql.jgds.GDS_Impl] parseSqlInfo: first 2 bytes are 1796 or: 4, 7
[org.firebirdsql.jgds.GDS_Impl] xsqlda.sqln read as 18
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 448
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 5
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 64
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field PUBLISHERCODE
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation CONFIG
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner YUTO_NORASYOTEN
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias PUBLISHERCODE
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 1
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 448
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 5
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 160
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field PUBLISHERNAME
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation CONFIG
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner YUTO_NORASYOTEN
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias PUBLISHERNAME
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 2
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 449
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 5
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 80
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field PUBLISHERNAMEKANA
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation CONFIG
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner YUTO_NORASYOTEN
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias PUBLISHERNAMEKANA
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 3
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 448
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 5
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 64
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field BUSINESSCODE
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation CONFIG
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner YUTO_NORASYOTEN
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias BUSINESSCODE
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 4
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 448
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 5
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 14
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field ZIP
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation CONFIG
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner YUTO_NORASYOTEN
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias ZIP
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 5
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 448
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 5
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 200
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field ADDR1
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation CONFIG
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner YUTO_NORASYOTEN
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias ADDR1
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 6
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 449
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 5
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 200
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field ADDR2
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation CONFIG
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner YUTO_NORASYOTEN
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias ADDR2
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 7
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 448
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 5
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 26
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field TEL
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation CONFIG
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner YUTO_NORASYOTEN
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias TEL
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 8
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 449
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 5
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 24
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field FAX
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation CONFIG
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner YUTO_NORASYOTEN
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias FAX
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 9
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 449
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 5
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 120
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field EMAIL
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation CONFIG
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner YUTO_NORASYOTEN
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias EMAIL
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 10
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 449
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 5
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 120
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field BANKACCOUNT
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation CONFIG
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner YUTO_NORASYOTEN
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias BANKACCOUNT
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 11
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 500
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 1
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale -2
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 2
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field TAXCNF
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation CONFIG
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner YUTO_NORASYOTEN
[org.firebirdsql.jgds.GDS_Impl] isc_info_truncated
[org.firebirdsql.jgds.GDS_Impl] op_info_sql
[org.firebirdsql.jgds.GDS_Impl] sent
????? CONTROL NOT RETURNED ?????
-----Stack trace after COMMIT -----
[org.firebirdsql.jca.FBManagedConnection] preparing sql: UPDATE Warehouse SET Id=?,WarehouseCtg=?,Name=?,TakingDt=?,LossHdrId=?,InpDt=?,UpdDt=?,AcsBit=? WHERE (Id=?)
[org.firebirdsql.jgds.GDS_Impl] op_prepare_statement
[org.firebirdsql.jgds.GDS_Impl] sent
[org.firebirdsql.jgds.GDS_Impl] op_response
[org.firebirdsql.jgds.GDS_Impl] op_response resp_object: 0
[org.firebirdsql.jgds.GDS_Impl] op_response resp_blob_id: 0
[org.firebirdsql.jgds.GDS_Impl] op_response resp_data size: 1024
[org.firebirdsql.jgds.GDS_Impl] readStatusVector arg:isc_arg_gds int: 0
[org.firebirdsql.jgds.GDS_Impl] received
[org.firebirdsql.jgds.GDS_Impl] parseSqlInfo started
[org.firebirdsql.jgds.GDS_Impl] parseSqlInfo: first 2 bytes are 1796 or: 4, 7
[org.firebirdsql.jgds.GDS_Impl] xsqlda.sqln read as 0
[org.firebirdsql.jgds.GDS_Impl] parseSqlInfo ended
[org.firebirdsql.jgds.GDS_Impl] op_info_sql
[org.firebirdsql.jgds.GDS_Impl] sent
[org.firebirdsql.jgds.GDS_Impl] op_response
[org.firebirdsql.jgds.GDS_Impl] op_response resp_object: 2
[org.firebirdsql.jgds.GDS_Impl] op_response resp_blob_id: 0
[org.firebirdsql.jgds.GDS_Impl] op_response resp_data size: 1024
[org.firebirdsql.jgds.GDS_Impl] readStatusVector arg:isc_arg_gds int: 0
[org.firebirdsql.jgds.GDS_Impl] received
[org.firebirdsql.jgds.GDS_Impl] parseSqlInfo started
[org.firebirdsql.jgds.GDS_Impl] parseSqlInfo: first 2 bytes are 1797 or: 5, 7
[org.firebirdsql.jgds.GDS_Impl] xsqlda.sqln read as 9
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 500
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 2
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 1
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 500
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 2
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 2
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 449
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 5
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 40
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 3
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 571
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 4
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 4
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 497
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 4
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 5
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 580
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 1
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 8
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 6
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 580
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 1
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 8
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 7
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 500
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 2
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias
[org.firebirdsql.jgds.GDS_Impl] new xsqlvar 8
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_type 500
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_sub_type 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_scale 0
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_length 2
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_field
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_relation
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_owner
[org.firebirdsql.jgds.GDS_Impl] isc_info_sql_alias
[org.firebirdsql.jgds.GDS_Impl] parseSqlInfo ended
[itj.dao.WarehouseDAO] WarehouseDAO(setValue):{[id]=2[warehouseCtg]=2[name]=Yuto(ret)[takingDt]=2005-06-20[lossHdrId]=null[inpDt]=0[updDt]=1119405641210[acsBit]=0[lastTakingDt]=null}
[org.firebirdsql.jgds.GDS_Impl] op_execute
[org.firebirdsql.gds.XdrOutputStream] sqldata null in writeSQLDatum: org.firebirdsql.gds.XSQLVAR@1dce46d
[org.firebirdsql.gds.XdrOutputStream] sqldata still null in writeSQLDatum: org.firebirdsql.gds.XSQLVAR@1dce46d
[org.firebirdsql.jgds.GDS_Impl] sent
[org.firebirdsql.jgds.GDS_Impl] op_response
[org.firebirdsql.jgds.GDS_Impl] op_response resp_object: 1
[org.firebirdsql.jgds.GDS_Impl] op_response resp_blob_id: 0
[org.firebirdsql.jgds.GDS_Impl] op_response resp_data size: 0
[org.firebirdsql.jgds.GDS_Impl] readStatusVector arg:isc_arg_gds int: 0
[org.firebirdsql.jgds.GDS_Impl] received
[org.firebirdsql.jgds.GDS_Impl] op_info_sql
[org.firebirdsql.jgds.GDS_Impl] sent
[org.firebirdsql.jgds.GDS_Impl] op_response
[org.firebirdsql.jgds.GDS_Impl] op_response resp_object: 2
[org.firebirdsql.jgds.GDS_Impl] op_response resp_blob_id: 0
[org.firebirdsql.jgds.GDS_Impl] op_response resp_data size: 128
[org.firebirdsql.jgds.GDS_Impl] readStatusVector arg:isc_arg_gds int: 0
[org.firebirdsql.jgds.GDS_Impl] received
[org.firebirdsql.jgds.GDS_Impl] op_free_statement
[org.firebirdsql.jgds.GDS_Impl] sent
[org.firebirdsql.jgds.GDS_Impl] op_response
[org.firebirdsql.jgds.GDS_Impl] op_response resp_object: -1
[org.firebirdsql.jgds.GDS_Impl] op_response resp_blob_id: 0
[org.firebirdsql.jgds.GDS_Impl] op_response resp_data size: 0
[org.firebirdsql.jgds.GDS_Impl] readStatusVector arg:isc_arg_gds int: 0
[org.firebirdsql.jgds.GDS_Impl] received
[org.firebirdsql.jca.FBManagedConnection] End called: XidImpl[FormatId=257, GlobalId=yamato04/242, BranchQual=1, localId=242]
[org.jboss.resource.connectionmanager.JBossManagedConnectionPool] putting ManagedConnection back into pool kill=false cl=org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@aed3a5[state=NORMAL mc=org.firebirdsql.jca.FBManagedConnection@1c9076d handles=0 lastUse=1119405619000 permit=true trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@106870c context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@18c2661]
[org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Returning connection to pool org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@aed3a5[state=NORMAL mc=org.firebirdsql.jca.FBManagedConnection@1c9076d handles=0 lastUse=1119405641708 permit=false trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@106870c context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@18c2661] [InUse/Available/Max]: [0/20/20]
[org.firebirdsql.jca.FBManagedConnection] End called: XidImpl[FormatId=257, GlobalId=yamato04/242, BranchQual=1, localId=242]
[org.firebirdsql.jca.FBManagedConnection] Commit called: XidImpl[FormatId=257, GlobalId=yamato04/242, BranchQual=1, localId=242]
[org.firebirdsql.jgds.GDS_Impl] op_commit
[org.firebirdsql.jgds.GDS_Impl] tr.rtr_id: 1
[org.firebirdsql.jgds.GDS_Impl] sent
[org.firebirdsql.jgds.GDS_Impl] op_response
[org.firebirdsql.jgds.GDS_Impl] op_response resp_object: 0
[org.firebirdsql.jgds.GDS_Impl] op_response resp_blob_id: 0
[org.firebirdsql.jgds.GDS_Impl] op_response resp_data size: 0
[org.firebirdsql.jgds.GDS_Impl] readStatusVector arg:isc_arg_gds int: 0
[org.firebirdsql.jgds.GDS_Impl] received
????? CONTROL NOT RETURNED ?????