You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by Edson Carlos Ericksson Richter <ed...@mgrinformatica.com.br> on 2003/05/12 17:12:41 UTC
Re: Complex transactions don't use same connection, OJB FREEZES! (NOT SOLVED)
I think that putting proxy="true" in reference will solve, but don't.
The transcript of my SapDB follow (look specially at the end of log).
User action:
1) Localize an object TB_PESSOA;
2) Asked for DELETE a contained object (that is persisted in TB_DOCUMENTO).
The object is removed from the LIST (I'm doing this in a step-by-step basis
debugging in NetBeans, so I really know that the object was deleted from the
list).
3) Stored PESSOA, so it should store fields in PESSOA (that occur - you will
find update in transcript), and then delete (that doesn't occur: SapDB
blocks access due to update lock above in transaction).
Log transcript:
---- Thread 149105b main Timestamp: 2003-05-12 11:50:03.379
==================================
package com.sap.dbtech.jdbc, SAP DB JDBC Driver, SAP AG, 7.4.4 Build
001-000-156-985 on Java 1.4.2-beta
new Connection 'jdbc:sapdb://SQLMGR/MGRDEV'
using com.sap.dbtech.rte.comm.SocketComm@6835fb on
Socket[addr=SQLMGR/10.10.10.9,port=7210,localport=4577]
=> com.sap.dbtech.jdbc.ConnectionSapDB@1c8efd1
com.sap.dbtech.jdbc.ConnectionSapDB@1c8efd1.setAutoCommit (true)
com.sap.dbtech.jdbc.ConnectionSapDB@1c8efd1.setReadOnly (false)
com.sap.dbtech.jdbc.ConnectionSapDB@1c8efd1.isClosed ()
=> false
com.sap.dbtech.jdbc.ConnectionSapDB@1c8efd1.getMetaData ()
=> com.sap.dbtech.jdbc.DatabaseMetaDataSapDB@4d76b4
com.sap.dbtech.jdbc.DatabaseMetaDataSapDB@4d76b4.supportsBatchUpdates ()
=> true
com.sap.dbtech.jdbc.ConnectionSapDB@1c8efd1.getAutoCommit ()
=> true
com.sap.dbtech.jdbc.ConnectionSapDB@1c8efd1.getAutoCommit ()
=> true
com.sap.dbtech.jdbc.ConnectionSapDB@1c8efd1.prepareStatement (SELECT
count(A0.CO_USUARIO) FROM MGR.TB_USUARIO A0 WHERE (A0.DS_USERNAME = ? ) AND
A0.DS_PASSWORD = ?, 1003, 1007)
=> com.sap.dbtech.jdbc.CallableStatementSapDB@6e1dec
com.sap.dbtech.jdbc.CallableStatementSapDB@6e1dec.setObject (1,
edson.richter, 12)
com.sap.dbtech.jdbc.CallableStatementSapDB@6e1dec.setObject (2, [C@2e323,
12)
com.sap.dbtech.jdbc.CallableStatementSapDB@6e1dec.executeQuery ()
=> com.sap.dbtech.jdbc.ResultSetSapDB@1e184cb
com.sap.dbtech.jdbc.ResultSetSapDB@1e184cb.getMetaData ()
=> com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@1f99eea
com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@1f99eea.getColumnCount ()
=> 1
com.sap.dbtech.jdbc.ResultSetSapDB@1e184cb.next ()
=> true
com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@1f99eea.getColumnType (1)
=> 3
com.sap.dbtech.jdbc.ResultSetSapDB@1e184cb.getBigDecimal (1)
=> 1
---- Thread e4245 Finalizer Timestamp: 2003-05-12 11:50:05.172
com.sap.dbtech.jdbc.ResultSetSapDB@1e184cb.close ()
com.sap.dbtech.jdbc.CallableStatementSapDB@6e1dec.clearParameters ()
---- Thread b2a2d8 AWT-EventQueue-0 Timestamp: 2003-05-12 11:53:21.123
com.sap.dbtech.jdbc.ConnectionSapDB@1c8efd1.prepareStatement (SELECT
A0.IM_FOTO,A0.NO_PESSOA,A0.CO_PESSOA,A0.DS_NOME_FANTASIA,A0.ST_FISICA_JURIDI
CA FROM MGR.TB_PESSOA A0 WHERE A0.CO_PESSOA IN (SELECT min(A0.CO_PESSOA)
FROM MGR.TB_PESSOA A0), 1003, 1007)
=> com.sap.dbtech.jdbc.CallableStatementSapDB@1875da7
com.sap.dbtech.jdbc.CallableStatementSapDB@1875da7.executeQuery ()
=> com.sap.dbtech.jdbc.ResultSetSapDB@1c2a1ed
com.sap.dbtech.jdbc.ResultSetSapDB@1c2a1ed.next ()
=> true
com.sap.dbtech.jdbc.ResultSetSapDB@1c2a1ed.getInt (CO_PESSOA)
=> 1
com.sap.dbtech.jdbc.ResultSetSapDB@1c2a1ed.wasNull ()
=> false
com.sap.dbtech.jdbc.ResultSetSapDB@1c2a1ed.next ()
=> false
com.sap.dbtech.jdbc.ResultSetSapDB@1c2a1ed.close ()
com.sap.dbtech.jdbc.CallableStatementSapDB@1875da7.clearParameters ()
==================================
package com.sap.dbtech.jdbc, SAP DB JDBC Driver, SAP AG, 7.4.4 Build
001-000-156-985 on Java 1.4.2-beta
new Connection 'jdbc:sapdb://SQLMGR/MGRDEV'
using com.sap.dbtech.rte.comm.SocketComm@87ad67 on
Socket[addr=SQLMGR/10.10.10.9,port=7210,localport=4582]
=> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc
com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.setAutoCommit (true)
com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.setReadOnly (false)
com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.isClosed ()
=> false
com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.getAutoCommit ()
=> true
com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.getAutoCommit ()
=> true
com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.prepareStatement (SELECT
IM_FOTO,NO_PESSOA,CO_PESSOA,DS_NOME_FANTASIA,ST_FISICA_JURIDICA FROM
MGR.TB_PESSOA WHERE CO_PESSOA = ?, 1003, 1007)
=> com.sap.dbtech.jdbc.CallableStatementSapDB@6147d9
com.sap.dbtech.jdbc.CallableStatementSapDB@6147d9.setObject (1, 1, 4)
com.sap.dbtech.jdbc.CallableStatementSapDB@6147d9.executeQuery ()
=> com.sap.dbtech.jdbc.ResultSetSapDB@b41166
com.sap.dbtech.jdbc.ResultSetSapDB@b41166.next ()
=> true
com.sap.dbtech.jdbc.ResultSetSapDB@b41166.getBlob (IM_FOTO)
=> null
com.sap.dbtech.jdbc.ResultSetSapDB@b41166.wasNull ()
=> true
com.sap.dbtech.jdbc.ResultSetSapDB@b41166.getString (NO_PESSOA)
=> BATALHAO DE ENG DE COMBATE
com.sap.dbtech.jdbc.ResultSetSapDB@b41166.getInt (CO_PESSOA)
=> 1
com.sap.dbtech.jdbc.ResultSetSapDB@b41166.wasNull ()
=> false
com.sap.dbtech.jdbc.ResultSetSapDB@b41166.getString (DS_NOME_FANTASIA)
=>
com.sap.dbtech.jdbc.ResultSetSapDB@b41166.getString (ST_FISICA_JURIDICA)
=> J
com.sap.dbtech.jdbc.ResultSetSapDB@b41166.close ()
com.sap.dbtech.jdbc.CallableStatementSapDB@6147d9.clearParameters ()
com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.prepareStatement (SELECT
count(A0.CO_PESSOA),count(A0.DS_NUMERO) FROM MGR.TB_DOCUMENTO A0 WHERE (
A0.CO_PESSOA = ? ) AND (A0.CL_INSTANCIA IN ( ? , ? , ? )), 1003, 1007)
=> com.sap.dbtech.jdbc.CallableStatementSapDB@e8f8c5
com.sap.dbtech.jdbc.CallableStatementSapDB@e8f8c5.setObject (1, 1, 4)
com.sap.dbtech.jdbc.CallableStatementSapDB@e8f8c5.setObject (2,
br.com.mgr.plugins.documentos.beans.DocumentoCnpjBean, 12)
com.sap.dbtech.jdbc.CallableStatementSapDB@e8f8c5.setObject (3,
br.com.mgr.plugins.documentos.beans.DocumentoCpfBean, 12)
com.sap.dbtech.jdbc.CallableStatementSapDB@e8f8c5.setObject (4,
br.com.mgr.plugins.documentos.beans.DocumentoRgBean, 12)
com.sap.dbtech.jdbc.CallableStatementSapDB@e8f8c5.executeQuery ()
=> com.sap.dbtech.jdbc.ResultSetSapDB@1248979
com.sap.dbtech.jdbc.ResultSetSapDB@1248979.getMetaData ()
=> com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@1bd9de3
com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@1bd9de3.getColumnCount ()
=> 2
com.sap.dbtech.jdbc.ResultSetSapDB@1248979.next ()
=> true
com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@1bd9de3.getColumnType (1)
=> 3
com.sap.dbtech.jdbc.ResultSetSapDB@1248979.getBigDecimal (1)
=> 3
com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@1bd9de3.getColumnType (2)
=> 3
com.sap.dbtech.jdbc.ResultSetSapDB@1248979.getBigDecimal (2)
=> 3
com.sap.dbtech.jdbc.ResultSetSapDB@1248979.next ()
=> false
com.sap.dbtech.jdbc.ResultSetSapDB@1248979.close ()
com.sap.dbtech.jdbc.CallableStatementSapDB@e8f8c5.clearParameters ()
com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.prepareStatement (SELECT
A0.CO_PESSOA,A0.DS_INFO_ADIC_7,A0.DS_INFO_ADIC_3,A0.DS_INFO_ADIC_1,A0.DS_INF
O_ADIC_4,A0.DS_INFO_ADIC_8,A0.CL_INSTANCIA,A0.DS_INFO_ADIC_0,A0.DS_INFO_ADIC
_5,A0.DS_INFO_ADIC_9,A0.DS_NUMERO,A0.DS_INFO_ADIC_6,A0.DS_INFO_ADIC_2 FROM
MGR.TB_DOCUMENTO A0 WHERE ( A0.CO_PESSOA = ? ) AND (A0.CL_INSTANCIA IN ( ?
, ? , ? )), 1003, 1007)
=> com.sap.dbtech.jdbc.CallableStatementSapDB@c9f997
com.sap.dbtech.jdbc.CallableStatementSapDB@c9f997.setObject (1, 1, 4)
com.sap.dbtech.jdbc.CallableStatementSapDB@c9f997.setObject (2,
br.com.mgr.plugins.documentos.beans.DocumentoCnpjBean, 12)
com.sap.dbtech.jdbc.CallableStatementSapDB@c9f997.setObject (3,
br.com.mgr.plugins.documentos.beans.DocumentoCpfBean, 12)
com.sap.dbtech.jdbc.CallableStatementSapDB@c9f997.setObject (4,
br.com.mgr.plugins.documentos.beans.DocumentoRgBean, 12)
com.sap.dbtech.jdbc.CallableStatementSapDB@c9f997.executeQuery ()
=> com.sap.dbtech.jdbc.ResultSetSapDB@2153fe
com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.next ()
=> true
com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.getInt (CO_PESSOA)
=> 1
com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.wasNull ()
=> false
com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.getString (DS_NUMERO)
=> 1050338175
com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.next ()
=> true
com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.getInt (CO_PESSOA)
=> 1
com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.wasNull ()
=> false
com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.getString (DS_NUMERO)
=> 71436677068
com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.next ()
=> true
com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.getInt (CO_PESSOA)
=> 1
com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.wasNull ()
=> false
com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.getString (DS_NUMERO)
=> 95135075000196
com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.next ()
=> false
com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.close ()
com.sap.dbtech.jdbc.CallableStatementSapDB@c9f997.clearParameters ()
com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.prepareStatement (SELECT
count(A0.CO_PESSOA),count(A0.DS_NUMERO) FROM MGR.TB_TELEFONE A0 WHERE
A0.CO_PESSOA = ?, 1003, 1007)
=> com.sap.dbtech.jdbc.CallableStatementSapDB@1ce5e7a
com.sap.dbtech.jdbc.CallableStatementSapDB@1ce5e7a.setObject (1, 1, 4)
com.sap.dbtech.jdbc.CallableStatementSapDB@1ce5e7a.executeQuery ()
=> com.sap.dbtech.jdbc.ResultSetSapDB@19cd5f5
com.sap.dbtech.jdbc.ResultSetSapDB@19cd5f5.getMetaData ()
=> com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@1a2da17
com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@1a2da17.getColumnCount ()
=> 2
com.sap.dbtech.jdbc.ResultSetSapDB@19cd5f5.next ()
=> true
com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@1a2da17.getColumnType (1)
=> 3
com.sap.dbtech.jdbc.ResultSetSapDB@19cd5f5.getBigDecimal (1)
=> 2
com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@1a2da17.getColumnType (2)
=> 3
com.sap.dbtech.jdbc.ResultSetSapDB@19cd5f5.getBigDecimal (2)
=> 2
com.sap.dbtech.jdbc.ResultSetSapDB@19cd5f5.next ()
=> false
com.sap.dbtech.jdbc.ResultSetSapDB@19cd5f5.close ()
com.sap.dbtech.jdbc.CallableStatementSapDB@1ce5e7a.clearParameters ()
com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.prepareStatement (SELECT
A0.DS_CODIGO_AREA,A0.DS_TIPO,A0.CO_PESSOA,A0.DS_OBSERVACOES,A0.DS_CODIGO_PAI
S,A0.DS_NUMERO FROM MGR.TB_TELEFONE A0 WHERE A0.CO_PESSOA = ?, 1003, 1007)
=> com.sap.dbtech.jdbc.CallableStatementSapDB@bdb375
com.sap.dbtech.jdbc.CallableStatementSapDB@bdb375.setObject (1, 1, 4)
com.sap.dbtech.jdbc.CallableStatementSapDB@bdb375.executeQuery ()
=> com.sap.dbtech.jdbc.ResultSetSapDB@174f02c
com.sap.dbtech.jdbc.ResultSetSapDB@174f02c.next ()
=> true
com.sap.dbtech.jdbc.ResultSetSapDB@174f02c.getInt (CO_PESSOA)
=> 1
com.sap.dbtech.jdbc.ResultSetSapDB@174f02c.wasNull ()
=> false
com.sap.dbtech.jdbc.ResultSetSapDB@174f02c.getString (DS_NUMERO)
=> 33470441
com.sap.dbtech.jdbc.ResultSetSapDB@174f02c.next ()
=> true
com.sap.dbtech.jdbc.ResultSetSapDB@174f02c.getInt (CO_PESSOA)
=> 1
com.sap.dbtech.jdbc.ResultSetSapDB@174f02c.wasNull ()
=> false
com.sap.dbtech.jdbc.ResultSetSapDB@174f02c.getString (DS_NUMERO)
=> 33470446
com.sap.dbtech.jdbc.ResultSetSapDB@174f02c.next ()
=> false
com.sap.dbtech.jdbc.ResultSetSapDB@174f02c.close ()
com.sap.dbtech.jdbc.CallableStatementSapDB@bdb375.clearParameters ()
com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.isClosed ()
=> false
com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.getAutoCommit ()
=> true
com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.setAutoCommit (true)
com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.setReadOnly (false)
com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.isClosed ()
=> false
com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.getAutoCommit ()
=> true
com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.getAutoCommit ()
=> true
com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.prepareStatement (SELECT
DS_CODIGO_AREA,DS_TIPO,CO_PESSOA,DS_OBSERVACOES,DS_CODIGO_PAIS,DS_NUMERO
FROM MGR.TB_TELEFONE WHERE CO_PESSOA = ? AND DS_NUMERO = ?, 1003, 1007)
=> com.sap.dbtech.jdbc.CallableStatementSapDB@178efd8
com.sap.dbtech.jdbc.CallableStatementSapDB@178efd8.setObject (1, 1, 4)
com.sap.dbtech.jdbc.CallableStatementSapDB@178efd8.setObject (2, 33470441,
12)
com.sap.dbtech.jdbc.CallableStatementSapDB@178efd8.executeQuery ()
=> com.sap.dbtech.jdbc.ResultSetSapDB@ca5bff
com.sap.dbtech.jdbc.ResultSetSapDB@ca5bff.next ()
=> true
com.sap.dbtech.jdbc.ResultSetSapDB@ca5bff.getString (DS_CODIGO_AREA)
=> 51
com.sap.dbtech.jdbc.ResultSetSapDB@ca5bff.getString (DS_TIPO)
=> Comercial
com.sap.dbtech.jdbc.ResultSetSapDB@ca5bff.getInt (CO_PESSOA)
=> 1
com.sap.dbtech.jdbc.ResultSetSapDB@ca5bff.wasNull ()
=> false
com.sap.dbtech.jdbc.ResultSetSapDB@ca5bff.getString (DS_OBSERVACOES)
=>
com.sap.dbtech.jdbc.ResultSetSapDB@ca5bff.getString (DS_CODIGO_PAIS)
=> 055
com.sap.dbtech.jdbc.ResultSetSapDB@ca5bff.getString (DS_NUMERO)
=> 33470441
com.sap.dbtech.jdbc.ResultSetSapDB@ca5bff.close ()
com.sap.dbtech.jdbc.CallableStatementSapDB@178efd8.clearParameters ()
com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.isClosed ()
=> false
com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.getAutoCommit ()
=> true
com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.setAutoCommit (true)
com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.setReadOnly (false)
com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.isClosed ()
=> false
com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.getAutoCommit ()
=> true
com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.getAutoCommit ()
=> true
com.sap.dbtech.jdbc.CallableStatementSapDB@178efd8.setObject (1, 1, 4)
com.sap.dbtech.jdbc.CallableStatementSapDB@178efd8.setObject (2, 33470446,
12)
com.sap.dbtech.jdbc.CallableStatementSapDB@178efd8.executeQuery ()
=> com.sap.dbtech.jdbc.ResultSetSapDB@16721bd
com.sap.dbtech.jdbc.ResultSetSapDB@16721bd.next ()
=> true
com.sap.dbtech.jdbc.ResultSetSapDB@16721bd.getString (DS_CODIGO_AREA)
=> 51
com.sap.dbtech.jdbc.ResultSetSapDB@16721bd.getString (DS_TIPO)
=> Comercial
com.sap.dbtech.jdbc.ResultSetSapDB@16721bd.getInt (CO_PESSOA)
=> 1
com.sap.dbtech.jdbc.ResultSetSapDB@16721bd.wasNull ()
=> false
com.sap.dbtech.jdbc.ResultSetSapDB@16721bd.getString (DS_OBSERVACOES)
=>
com.sap.dbtech.jdbc.ResultSetSapDB@16721bd.getString (DS_CODIGO_PAIS)
=> 055
com.sap.dbtech.jdbc.ResultSetSapDB@16721bd.getString (DS_NUMERO)
=> 33470446
com.sap.dbtech.jdbc.ResultSetSapDB@16721bd.close ()
com.sap.dbtech.jdbc.CallableStatementSapDB@178efd8.clearParameters ()
com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.isClosed ()
=> false
com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.getAutoCommit ()
=> true
com.sap.dbtech.jdbc.ConnectionSapDB@1c8efd1.setAutoCommit (false)
com.sap.dbtech.jdbc.ConnectionSapDB@1c8efd1.prepareStatement (SELECT
IM_FOTO,NO_PESSOA,CO_PESSOA,DS_NOME_FANTASIA,ST_FISICA_JURIDICA FROM
MGR.TB_PESSOA WHERE CO_PESSOA = ?, 1003, 1007)
=> com.sap.dbtech.jdbc.CallableStatementSapDB@f01d52
com.sap.dbtech.jdbc.CallableStatementSapDB@f01d52.setObject (1, 1, 4)
com.sap.dbtech.jdbc.CallableStatementSapDB@f01d52.executeQuery ()
=> com.sap.dbtech.jdbc.ResultSetSapDB@152643
com.sap.dbtech.jdbc.ResultSetSapDB@152643.next ()
=> true
com.sap.dbtech.jdbc.ResultSetSapDB@152643.getBlob (IM_FOTO)
=> null
com.sap.dbtech.jdbc.ResultSetSapDB@152643.wasNull ()
=> true
com.sap.dbtech.jdbc.ResultSetSapDB@152643.getString (NO_PESSOA)
=> BATALHAO DE ENG DE COMBATE
com.sap.dbtech.jdbc.ResultSetSapDB@152643.getInt (CO_PESSOA)
=> 1
com.sap.dbtech.jdbc.ResultSetSapDB@152643.wasNull ()
=> false
com.sap.dbtech.jdbc.ResultSetSapDB@152643.getString (DS_NOME_FANTASIA)
=>
com.sap.dbtech.jdbc.ResultSetSapDB@152643.getString (ST_FISICA_JURIDICA)
=> J
com.sap.dbtech.jdbc.ResultSetSapDB@152643.close ()
com.sap.dbtech.jdbc.CallableStatementSapDB@f01d52.clearParameters ()
com.sap.dbtech.jdbc.ConnectionSapDB@1c8efd1.prepareStatement (UPDATE
MGR.TB_PESSOA SET
NO_PESSOA=?,ST_FISICA_JURIDICA=?,DS_NOME_FANTASIA=?,IM_FOTO=? WHERE
CO_PESSOA = ?, 1003, 1007)
=> com.sap.dbtech.jdbc.CallableStatementSapDB@11ee017
com.sap.dbtech.jdbc.CallableStatementSapDB@11ee017.setObject (1, BATALHAO DE
ENG DE COMBATE, 12)
com.sap.dbtech.jdbc.CallableStatementSapDB@11ee017.setObject (2, J, 1)
com.sap.dbtech.jdbc.CallableStatementSapDB@11ee017.setObject (3, , 12)
com.sap.dbtech.jdbc.CallableStatementSapDB@11ee017.setNull (4, 2004)
com.sap.dbtech.jdbc.CallableStatementSapDB@11ee017.setObject (5, 1, 4)
com.sap.dbtech.jdbc.CallableStatementSapDB@11ee017.executeUpdate ()
=> 1
com.sap.dbtech.jdbc.CallableStatementSapDB@11ee017.clearParameters ()
com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.setAutoCommit (true)
com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.setReadOnly (false)
com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.isClosed ()
=> false
com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.getAutoCommit ()
=> true
com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.getAutoCommit ()
=> true
com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.prepareStatement (SELECT
CO_PESSOA,DS_INFO_ADIC_7,DS_INFO_ADIC_3,DS_INFO_ADIC_1,DS_INFO_ADIC_4,DS_INF
O_ADIC_8,CL_INSTANCIA,DS_INFO_ADIC_0,DS_INFO_ADIC_5,DS_INFO_ADIC_9,DS_NUMERO
,DS_INFO_ADIC_6,DS_INFO_ADIC_2 FROM MGR.TB_DOCUMENTO WHERE CO_PESSOA = ?
AND DS_NUMERO = ?, 1003, 1007)
=> com.sap.dbtech.jdbc.CallableStatementSapDB@15d45d9
com.sap.dbtech.jdbc.CallableStatementSapDB@15d45d9.setObject (1, 1, 4)
com.sap.dbtech.jdbc.CallableStatementSapDB@15d45d9.setObject (2, 1050338175,
12)
com.sap.dbtech.jdbc.CallableStatementSapDB@15d45d9.executeQuery ()
=> com.sap.dbtech.jdbc.ResultSetSapDB@94aa42
com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.next ()
=> true
com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getInt (CO_PESSOA)
=> 1
com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.wasNull ()
=> false
com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getString (DS_INFO_ADIC_7)
=> null
com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getString (DS_INFO_ADIC_3)
=> null
com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getString (DS_INFO_ADIC_1)
=> 469249200000
com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getString (DS_INFO_ADIC_4)
=> null
com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getString (DS_INFO_ADIC_8)
=> null
com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getString (CL_INSTANCIA)
=> br.com.mgr.plugins.documentos.beans.DocumentoRgBean
com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getString (DS_INFO_ADIC_0)
=> SSP/RS
com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getString (DS_INFO_ADIC_5)
=> null
com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getString (DS_INFO_ADIC_9)
=> null
com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getString (DS_NUMERO)
=> 1050338175
com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getString (DS_INFO_ADIC_6)
=> null
com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getString (DS_INFO_ADIC_2)
=> null
com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.close ()
com.sap.dbtech.jdbc.CallableStatementSapDB@15d45d9.clearParameters ()
com.sap.dbtech.jdbc.CallableStatementSapDB@6147d9.setObject (1, 1, 4)
com.sap.dbtech.jdbc.CallableStatementSapDB@6147d9.executeQuery ()
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.478 / Virus Database: 275 - Release Date: 6/5/2003
Re: Complex transactions don't use same connection, SOLVED finally
Posted by Edson Carlos Ericksson Richter <ed...@mgrinformatica.com.br>.
Thanks Armin. All the things works now. You suggestion to create a testcase
was wonderful! I get the track to main problem: Thread Management in Swing.
My fault was that I'm using one unique instance of PersistenceBroker to all
activities for my Swing components. So, in one frame I have 4 JList and was
filled by OJB... All of them using same instance of PersistenceBroker.
Corrected this (each activity is using own broker), all turn to work.
Thanks.
----- Original Message -----
From: "Armin Waibel" <ar...@code-au-lait.de>
To: "OJB Users List" <oj...@db.apache.org>
Sent: Monday, May 12, 2003 12:17 PM
Subject: Re: Complex transactions don't use same connection, OJB FREEZES!
(NOT SOLVED)
Hi Edson,
again, could you post a 'small' test case
(or add a new test method to one of the existing
test cases) to reproduce your problem.
This makes things easier for the developers and
help us to prevent doing same things again.
regards,
Armin
----- Original Message -----
From: "Edson Carlos Ericksson Richter"
<ed...@mgrinformatica.com.br>
To: "OJB Users List" <oj...@db.apache.org>
Sent: Monday, May 12, 2003 5:12 PM
Subject: Re: Complex transactions don't use same connection, OJB
FREEZES! (NOT SOLVED)
> I think that putting proxy="true" in reference will solve, but don't.
>
> The transcript of my SapDB follow (look specially at the end of log).
>
> User action:
>
> 1) Localize an object TB_PESSOA;
> 2) Asked for DELETE a contained object (that is persisted in
TB_DOCUMENTO).
> The object is removed from the LIST (I'm doing this in a step-by-step
basis
> debugging in NetBeans, so I really know that the object was deleted
from the
> list).
> 3) Stored PESSOA, so it should store fields in PESSOA (that occur -
you will
> find update in transcript), and then delete (that doesn't occur: SapDB
> blocks access due to update lock above in transaction).
>
> Log transcript:
>
> ---- Thread 149105b main Timestamp: 2003-05-12 11:50:03.379
> ==================================
> package com.sap.dbtech.jdbc, SAP DB JDBC Driver, SAP AG, 7.4.4
Build
> 001-000-156-985 on Java 1.4.2-beta
> new Connection 'jdbc:sapdb://SQLMGR/MGRDEV'
> using com.sap.dbtech.rte.comm.SocketComm@6835fb on
> Socket[addr=SQLMGR/10.10.10.9,port=7210,localport=4577]
> => com.sap.dbtech.jdbc.ConnectionSapDB@1c8efd1
> com.sap.dbtech.jdbc.ConnectionSapDB@1c8efd1.setAutoCommit (true)
> com.sap.dbtech.jdbc.ConnectionSapDB@1c8efd1.setReadOnly (false)
> com.sap.dbtech.jdbc.ConnectionSapDB@1c8efd1.isClosed ()
> => false
> com.sap.dbtech.jdbc.ConnectionSapDB@1c8efd1.getMetaData ()
> => com.sap.dbtech.jdbc.DatabaseMetaDataSapDB@4d76b4
> com.sap.dbtech.jdbc.DatabaseMetaDataSapDB@4d76b4.supportsBatchUpdates
()
> => true
> com.sap.dbtech.jdbc.ConnectionSapDB@1c8efd1.getAutoCommit ()
> => true
> com.sap.dbtech.jdbc.ConnectionSapDB@1c8efd1.getAutoCommit ()
> => true
> com.sap.dbtech.jdbc.ConnectionSapDB@1c8efd1.prepareStatement (SELECT
> count(A0.CO_USUARIO) FROM MGR.TB_USUARIO A0 WHERE (A0.DS_USERNAME =
? ) AND
> A0.DS_PASSWORD = ?, 1003, 1007)
> => com.sap.dbtech.jdbc.CallableStatementSapDB@6e1dec
> com.sap.dbtech.jdbc.CallableStatementSapDB@6e1dec.setObject (1,
> edson.richter, 12)
> com.sap.dbtech.jdbc.CallableStatementSapDB@6e1dec.setObject (2,
[C@2e323,
> 12)
> com.sap.dbtech.jdbc.CallableStatementSapDB@6e1dec.executeQuery ()
> => com.sap.dbtech.jdbc.ResultSetSapDB@1e184cb
> com.sap.dbtech.jdbc.ResultSetSapDB@1e184cb.getMetaData ()
> => com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@1f99eea
> com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@1f99eea.getColumnCount ()
> => 1
> com.sap.dbtech.jdbc.ResultSetSapDB@1e184cb.next ()
> => true
> com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@1f99eea.getColumnType (1)
> => 3
> com.sap.dbtech.jdbc.ResultSetSapDB@1e184cb.getBigDecimal (1)
> => 1
>
> ---- Thread e4245 Finalizer Timestamp: 2003-05-12 11:50:05.172
> com.sap.dbtech.jdbc.ResultSetSapDB@1e184cb.close ()
> com.sap.dbtech.jdbc.CallableStatementSapDB@6e1dec.clearParameters ()
>
> ---- Thread b2a2d8 AWT-EventQueue-0 Timestamp: 2003-05-12 11:53:21.123
> com.sap.dbtech.jdbc.ConnectionSapDB@1c8efd1.prepareStatement (SELECT
>
A0.IM_FOTO,A0.NO_PESSOA,A0.CO_PESSOA,A0.DS_NOME_FANTASIA,A0.ST_FISICA_JU
RIDI
> CA FROM MGR.TB_PESSOA A0 WHERE A0.CO_PESSOA IN (SELECT
min(A0.CO_PESSOA)
> FROM MGR.TB_PESSOA A0), 1003, 1007)
> => com.sap.dbtech.jdbc.CallableStatementSapDB@1875da7
> com.sap.dbtech.jdbc.CallableStatementSapDB@1875da7.executeQuery ()
> => com.sap.dbtech.jdbc.ResultSetSapDB@1c2a1ed
> com.sap.dbtech.jdbc.ResultSetSapDB@1c2a1ed.next ()
> => true
> com.sap.dbtech.jdbc.ResultSetSapDB@1c2a1ed.getInt (CO_PESSOA)
> => 1
> com.sap.dbtech.jdbc.ResultSetSapDB@1c2a1ed.wasNull ()
> => false
> com.sap.dbtech.jdbc.ResultSetSapDB@1c2a1ed.next ()
> => false
> com.sap.dbtech.jdbc.ResultSetSapDB@1c2a1ed.close ()
> com.sap.dbtech.jdbc.CallableStatementSapDB@1875da7.clearParameters ()
> ==================================
> package com.sap.dbtech.jdbc, SAP DB JDBC Driver, SAP AG, 7.4.4
Build
> 001-000-156-985 on Java 1.4.2-beta
> new Connection 'jdbc:sapdb://SQLMGR/MGRDEV'
> using com.sap.dbtech.rte.comm.SocketComm@87ad67 on
> Socket[addr=SQLMGR/10.10.10.9,port=7210,localport=4582]
> => com.sap.dbtech.jdbc.ConnectionSapDB@18952cc
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.setAutoCommit (true)
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.setReadOnly (false)
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.isClosed ()
> => false
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.getAutoCommit ()
> => true
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.getAutoCommit ()
> => true
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.prepareStatement (SELECT
> IM_FOTO,NO_PESSOA,CO_PESSOA,DS_NOME_FANTASIA,ST_FISICA_JURIDICA FROM
> MGR.TB_PESSOA WHERE CO_PESSOA = ?, 1003, 1007)
> => com.sap.dbtech.jdbc.CallableStatementSapDB@6147d9
> com.sap.dbtech.jdbc.CallableStatementSapDB@6147d9.setObject (1, 1, 4)
> com.sap.dbtech.jdbc.CallableStatementSapDB@6147d9.executeQuery ()
> => com.sap.dbtech.jdbc.ResultSetSapDB@b41166
> com.sap.dbtech.jdbc.ResultSetSapDB@b41166.next ()
> => true
> com.sap.dbtech.jdbc.ResultSetSapDB@b41166.getBlob (IM_FOTO)
> => null
> com.sap.dbtech.jdbc.ResultSetSapDB@b41166.wasNull ()
> => true
> com.sap.dbtech.jdbc.ResultSetSapDB@b41166.getString (NO_PESSOA)
> => BATALHAO DE ENG DE COMBATE
> com.sap.dbtech.jdbc.ResultSetSapDB@b41166.getInt (CO_PESSOA)
> => 1
> com.sap.dbtech.jdbc.ResultSetSapDB@b41166.wasNull ()
> => false
> com.sap.dbtech.jdbc.ResultSetSapDB@b41166.getString (DS_NOME_FANTASIA)
> =>
> com.sap.dbtech.jdbc.ResultSetSapDB@b41166.getString
(ST_FISICA_JURIDICA)
> => J
> com.sap.dbtech.jdbc.ResultSetSapDB@b41166.close ()
> com.sap.dbtech.jdbc.CallableStatementSapDB@6147d9.clearParameters ()
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.prepareStatement (SELECT
> count(A0.CO_PESSOA),count(A0.DS_NUMERO) FROM MGR.TB_DOCUMENTO A0 WHERE
(
> A0.CO_PESSOA = ? ) AND (A0.CL_INSTANCIA IN ( ? , ? , ? )), 1003,
1007)
> => com.sap.dbtech.jdbc.CallableStatementSapDB@e8f8c5
> com.sap.dbtech.jdbc.CallableStatementSapDB@e8f8c5.setObject (1, 1, 4)
> com.sap.dbtech.jdbc.CallableStatementSapDB@e8f8c5.setObject (2,
> br.com.mgr.plugins.documentos.beans.DocumentoCnpjBean, 12)
> com.sap.dbtech.jdbc.CallableStatementSapDB@e8f8c5.setObject (3,
> br.com.mgr.plugins.documentos.beans.DocumentoCpfBean, 12)
> com.sap.dbtech.jdbc.CallableStatementSapDB@e8f8c5.setObject (4,
> br.com.mgr.plugins.documentos.beans.DocumentoRgBean, 12)
> com.sap.dbtech.jdbc.CallableStatementSapDB@e8f8c5.executeQuery ()
> => com.sap.dbtech.jdbc.ResultSetSapDB@1248979
> com.sap.dbtech.jdbc.ResultSetSapDB@1248979.getMetaData ()
> => com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@1bd9de3
> com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@1bd9de3.getColumnCount ()
> => 2
> com.sap.dbtech.jdbc.ResultSetSapDB@1248979.next ()
> => true
> com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@1bd9de3.getColumnType (1)
> => 3
> com.sap.dbtech.jdbc.ResultSetSapDB@1248979.getBigDecimal (1)
> => 3
> com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@1bd9de3.getColumnType (2)
> => 3
> com.sap.dbtech.jdbc.ResultSetSapDB@1248979.getBigDecimal (2)
> => 3
> com.sap.dbtech.jdbc.ResultSetSapDB@1248979.next ()
> => false
> com.sap.dbtech.jdbc.ResultSetSapDB@1248979.close ()
> com.sap.dbtech.jdbc.CallableStatementSapDB@e8f8c5.clearParameters ()
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.prepareStatement (SELECT
>
A0.CO_PESSOA,A0.DS_INFO_ADIC_7,A0.DS_INFO_ADIC_3,A0.DS_INFO_ADIC_1,A0.DS
_INF
>
O_ADIC_4,A0.DS_INFO_ADIC_8,A0.CL_INSTANCIA,A0.DS_INFO_ADIC_0,A0.DS_INFO_
ADIC
> _5,A0.DS_INFO_ADIC_9,A0.DS_NUMERO,A0.DS_INFO_ADIC_6,A0.DS_INFO_ADIC_2
FROM
> MGR.TB_DOCUMENTO A0 WHERE ( A0.CO_PESSOA = ? ) AND (A0.CL_INSTANCIA
IN ( ?
> , ? , ? )), 1003, 1007)
> => com.sap.dbtech.jdbc.CallableStatementSapDB@c9f997
> com.sap.dbtech.jdbc.CallableStatementSapDB@c9f997.setObject (1, 1, 4)
> com.sap.dbtech.jdbc.CallableStatementSapDB@c9f997.setObject (2,
> br.com.mgr.plugins.documentos.beans.DocumentoCnpjBean, 12)
> com.sap.dbtech.jdbc.CallableStatementSapDB@c9f997.setObject (3,
> br.com.mgr.plugins.documentos.beans.DocumentoCpfBean, 12)
> com.sap.dbtech.jdbc.CallableStatementSapDB@c9f997.setObject (4,
> br.com.mgr.plugins.documentos.beans.DocumentoRgBean, 12)
> com.sap.dbtech.jdbc.CallableStatementSapDB@c9f997.executeQuery ()
> => com.sap.dbtech.jdbc.ResultSetSapDB@2153fe
> com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.next ()
> => true
> com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.getInt (CO_PESSOA)
> => 1
> com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.wasNull ()
> => false
> com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.getString (DS_NUMERO)
> => 1050338175
> com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.next ()
> => true
> com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.getInt (CO_PESSOA)
> => 1
> com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.wasNull ()
> => false
> com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.getString (DS_NUMERO)
> => 71436677068
> com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.next ()
> => true
> com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.getInt (CO_PESSOA)
> => 1
> com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.wasNull ()
> => false
> com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.getString (DS_NUMERO)
> => 95135075000196
> com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.next ()
> => false
> com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.close ()
> com.sap.dbtech.jdbc.CallableStatementSapDB@c9f997.clearParameters ()
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.prepareStatement (SELECT
> count(A0.CO_PESSOA),count(A0.DS_NUMERO) FROM MGR.TB_TELEFONE A0 WHERE
> A0.CO_PESSOA = ?, 1003, 1007)
> => com.sap.dbtech.jdbc.CallableStatementSapDB@1ce5e7a
> com.sap.dbtech.jdbc.CallableStatementSapDB@1ce5e7a.setObject (1, 1, 4)
> com.sap.dbtech.jdbc.CallableStatementSapDB@1ce5e7a.executeQuery ()
> => com.sap.dbtech.jdbc.ResultSetSapDB@19cd5f5
> com.sap.dbtech.jdbc.ResultSetSapDB@19cd5f5.getMetaData ()
> => com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@1a2da17
> com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@1a2da17.getColumnCount ()
> => 2
> com.sap.dbtech.jdbc.ResultSetSapDB@19cd5f5.next ()
> => true
> com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@1a2da17.getColumnType (1)
> => 3
> com.sap.dbtech.jdbc.ResultSetSapDB@19cd5f5.getBigDecimal (1)
> => 2
> com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@1a2da17.getColumnType (2)
> => 3
> com.sap.dbtech.jdbc.ResultSetSapDB@19cd5f5.getBigDecimal (2)
> => 2
> com.sap.dbtech.jdbc.ResultSetSapDB@19cd5f5.next ()
> => false
> com.sap.dbtech.jdbc.ResultSetSapDB@19cd5f5.close ()
> com.sap.dbtech.jdbc.CallableStatementSapDB@1ce5e7a.clearParameters ()
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.prepareStatement (SELECT
>
A0.DS_CODIGO_AREA,A0.DS_TIPO,A0.CO_PESSOA,A0.DS_OBSERVACOES,A0.DS_CODIGO
_PAI
> S,A0.DS_NUMERO FROM MGR.TB_TELEFONE A0 WHERE A0.CO_PESSOA = ?, 1003,
1007)
> => com.sap.dbtech.jdbc.CallableStatementSapDB@bdb375
> com.sap.dbtech.jdbc.CallableStatementSapDB@bdb375.setObject (1, 1, 4)
> com.sap.dbtech.jdbc.CallableStatementSapDB@bdb375.executeQuery ()
> => com.sap.dbtech.jdbc.ResultSetSapDB@174f02c
> com.sap.dbtech.jdbc.ResultSetSapDB@174f02c.next ()
> => true
> com.sap.dbtech.jdbc.ResultSetSapDB@174f02c.getInt (CO_PESSOA)
> => 1
> com.sap.dbtech.jdbc.ResultSetSapDB@174f02c.wasNull ()
> => false
> com.sap.dbtech.jdbc.ResultSetSapDB@174f02c.getString (DS_NUMERO)
> => 33470441
> com.sap.dbtech.jdbc.ResultSetSapDB@174f02c.next ()
> => true
> com.sap.dbtech.jdbc.ResultSetSapDB@174f02c.getInt (CO_PESSOA)
> => 1
> com.sap.dbtech.jdbc.ResultSetSapDB@174f02c.wasNull ()
> => false
> com.sap.dbtech.jdbc.ResultSetSapDB@174f02c.getString (DS_NUMERO)
> => 33470446
> com.sap.dbtech.jdbc.ResultSetSapDB@174f02c.next ()
> => false
> com.sap.dbtech.jdbc.ResultSetSapDB@174f02c.close ()
> com.sap.dbtech.jdbc.CallableStatementSapDB@bdb375.clearParameters ()
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.isClosed ()
> => false
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.getAutoCommit ()
> => true
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.setAutoCommit (true)
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.setReadOnly (false)
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.isClosed ()
> => false
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.getAutoCommit ()
> => true
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.getAutoCommit ()
> => true
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.prepareStatement (SELECT
>
DS_CODIGO_AREA,DS_TIPO,CO_PESSOA,DS_OBSERVACOES,DS_CODIGO_PAIS,DS_NUMERO
> FROM MGR.TB_TELEFONE WHERE CO_PESSOA = ? AND DS_NUMERO = ?, 1003,
1007)
> => com.sap.dbtech.jdbc.CallableStatementSapDB@178efd8
> com.sap.dbtech.jdbc.CallableStatementSapDB@178efd8.setObject (1, 1, 4)
> com.sap.dbtech.jdbc.CallableStatementSapDB@178efd8.setObject (2,
33470441,
> 12)
> com.sap.dbtech.jdbc.CallableStatementSapDB@178efd8.executeQuery ()
> => com.sap.dbtech.jdbc.ResultSetSapDB@ca5bff
> com.sap.dbtech.jdbc.ResultSetSapDB@ca5bff.next ()
> => true
> com.sap.dbtech.jdbc.ResultSetSapDB@ca5bff.getString (DS_CODIGO_AREA)
> => 51
> com.sap.dbtech.jdbc.ResultSetSapDB@ca5bff.getString (DS_TIPO)
> => Comercial
> com.sap.dbtech.jdbc.ResultSetSapDB@ca5bff.getInt (CO_PESSOA)
> => 1
> com.sap.dbtech.jdbc.ResultSetSapDB@ca5bff.wasNull ()
> => false
> com.sap.dbtech.jdbc.ResultSetSapDB@ca5bff.getString (DS_OBSERVACOES)
> =>
> com.sap.dbtech.jdbc.ResultSetSapDB@ca5bff.getString (DS_CODIGO_PAIS)
> => 055
> com.sap.dbtech.jdbc.ResultSetSapDB@ca5bff.getString (DS_NUMERO)
> => 33470441
> com.sap.dbtech.jdbc.ResultSetSapDB@ca5bff.close ()
> com.sap.dbtech.jdbc.CallableStatementSapDB@178efd8.clearParameters ()
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.isClosed ()
> => false
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.getAutoCommit ()
> => true
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.setAutoCommit (true)
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.setReadOnly (false)
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.isClosed ()
> => false
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.getAutoCommit ()
> => true
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.getAutoCommit ()
> => true
> com.sap.dbtech.jdbc.CallableStatementSapDB@178efd8.setObject (1, 1, 4)
> com.sap.dbtech.jdbc.CallableStatementSapDB@178efd8.setObject (2,
33470446,
> 12)
> com.sap.dbtech.jdbc.CallableStatementSapDB@178efd8.executeQuery ()
> => com.sap.dbtech.jdbc.ResultSetSapDB@16721bd
> com.sap.dbtech.jdbc.ResultSetSapDB@16721bd.next ()
> => true
> com.sap.dbtech.jdbc.ResultSetSapDB@16721bd.getString (DS_CODIGO_AREA)
> => 51
> com.sap.dbtech.jdbc.ResultSetSapDB@16721bd.getString (DS_TIPO)
> => Comercial
> com.sap.dbtech.jdbc.ResultSetSapDB@16721bd.getInt (CO_PESSOA)
> => 1
> com.sap.dbtech.jdbc.ResultSetSapDB@16721bd.wasNull ()
> => false
> com.sap.dbtech.jdbc.ResultSetSapDB@16721bd.getString (DS_OBSERVACOES)
> =>
> com.sap.dbtech.jdbc.ResultSetSapDB@16721bd.getString (DS_CODIGO_PAIS)
> => 055
> com.sap.dbtech.jdbc.ResultSetSapDB@16721bd.getString (DS_NUMERO)
> => 33470446
> com.sap.dbtech.jdbc.ResultSetSapDB@16721bd.close ()
> com.sap.dbtech.jdbc.CallableStatementSapDB@178efd8.clearParameters ()
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.isClosed ()
> => false
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.getAutoCommit ()
> => true
> com.sap.dbtech.jdbc.ConnectionSapDB@1c8efd1.setAutoCommit (false)
> com.sap.dbtech.jdbc.ConnectionSapDB@1c8efd1.prepareStatement (SELECT
> IM_FOTO,NO_PESSOA,CO_PESSOA,DS_NOME_FANTASIA,ST_FISICA_JURIDICA FROM
> MGR.TB_PESSOA WHERE CO_PESSOA = ?, 1003, 1007)
> => com.sap.dbtech.jdbc.CallableStatementSapDB@f01d52
> com.sap.dbtech.jdbc.CallableStatementSapDB@f01d52.setObject (1, 1, 4)
> com.sap.dbtech.jdbc.CallableStatementSapDB@f01d52.executeQuery ()
> => com.sap.dbtech.jdbc.ResultSetSapDB@152643
> com.sap.dbtech.jdbc.ResultSetSapDB@152643.next ()
> => true
> com.sap.dbtech.jdbc.ResultSetSapDB@152643.getBlob (IM_FOTO)
> => null
> com.sap.dbtech.jdbc.ResultSetSapDB@152643.wasNull ()
> => true
> com.sap.dbtech.jdbc.ResultSetSapDB@152643.getString (NO_PESSOA)
> => BATALHAO DE ENG DE COMBATE
> com.sap.dbtech.jdbc.ResultSetSapDB@152643.getInt (CO_PESSOA)
> => 1
> com.sap.dbtech.jdbc.ResultSetSapDB@152643.wasNull ()
> => false
> com.sap.dbtech.jdbc.ResultSetSapDB@152643.getString (DS_NOME_FANTASIA)
> =>
> com.sap.dbtech.jdbc.ResultSetSapDB@152643.getString
(ST_FISICA_JURIDICA)
> => J
> com.sap.dbtech.jdbc.ResultSetSapDB@152643.close ()
> com.sap.dbtech.jdbc.CallableStatementSapDB@f01d52.clearParameters ()
> com.sap.dbtech.jdbc.ConnectionSapDB@1c8efd1.prepareStatement (UPDATE
> MGR.TB_PESSOA SET
> NO_PESSOA=?,ST_FISICA_JURIDICA=?,DS_NOME_FANTASIA=?,IM_FOTO=? WHERE
> CO_PESSOA = ?, 1003, 1007)
> => com.sap.dbtech.jdbc.CallableStatementSapDB@11ee017
> com.sap.dbtech.jdbc.CallableStatementSapDB@11ee017.setObject (1,
BATALHAO DE
> ENG DE COMBATE, 12)
> com.sap.dbtech.jdbc.CallableStatementSapDB@11ee017.setObject (2, J, 1)
> com.sap.dbtech.jdbc.CallableStatementSapDB@11ee017.setObject (3, , 12)
> com.sap.dbtech.jdbc.CallableStatementSapDB@11ee017.setNull (4, 2004)
> com.sap.dbtech.jdbc.CallableStatementSapDB@11ee017.setObject (5, 1, 4)
> com.sap.dbtech.jdbc.CallableStatementSapDB@11ee017.executeUpdate ()
> => 1
> com.sap.dbtech.jdbc.CallableStatementSapDB@11ee017.clearParameters ()
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.setAutoCommit (true)
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.setReadOnly (false)
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.isClosed ()
> => false
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.getAutoCommit ()
> => true
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.getAutoCommit ()
> => true
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.prepareStatement (SELECT
>
CO_PESSOA,DS_INFO_ADIC_7,DS_INFO_ADIC_3,DS_INFO_ADIC_1,DS_INFO_ADIC_4,DS
_INF
>
O_ADIC_8,CL_INSTANCIA,DS_INFO_ADIC_0,DS_INFO_ADIC_5,DS_INFO_ADIC_9,DS_NU
MERO
> ,DS_INFO_ADIC_6,DS_INFO_ADIC_2 FROM MGR.TB_DOCUMENTO WHERE CO_PESSOA =
?
> AND DS_NUMERO = ?, 1003, 1007)
> => com.sap.dbtech.jdbc.CallableStatementSapDB@15d45d9
> com.sap.dbtech.jdbc.CallableStatementSapDB@15d45d9.setObject (1, 1, 4)
> com.sap.dbtech.jdbc.CallableStatementSapDB@15d45d9.setObject (2,
1050338175,
> 12)
> com.sap.dbtech.jdbc.CallableStatementSapDB@15d45d9.executeQuery ()
> => com.sap.dbtech.jdbc.ResultSetSapDB@94aa42
> com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.next ()
> => true
> com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getInt (CO_PESSOA)
> => 1
> com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.wasNull ()
> => false
> com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getString (DS_INFO_ADIC_7)
> => null
> com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getString (DS_INFO_ADIC_3)
> => null
> com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getString (DS_INFO_ADIC_1)
> => 469249200000
> com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getString (DS_INFO_ADIC_4)
> => null
> com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getString (DS_INFO_ADIC_8)
> => null
> com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getString (CL_INSTANCIA)
> => br.com.mgr.plugins.documentos.beans.DocumentoRgBean
> com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getString (DS_INFO_ADIC_0)
> => SSP/RS
> com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getString (DS_INFO_ADIC_5)
> => null
> com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getString (DS_INFO_ADIC_9)
> => null
> com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getString (DS_NUMERO)
> => 1050338175
> com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getString (DS_INFO_ADIC_6)
> => null
> com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getString (DS_INFO_ADIC_2)
> => null
> com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.close ()
> com.sap.dbtech.jdbc.CallableStatementSapDB@15d45d9.clearParameters ()
> com.sap.dbtech.jdbc.CallableStatementSapDB@6147d9.setObject (1, 1, 4)
> com.sap.dbtech.jdbc.CallableStatementSapDB@6147d9.executeQuery ()
>
>
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.478 / Virus Database: 275 - Release Date: 6/5/2003
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.480 / Virus Database: 276 - Release Date: 12/5/2003
Re: Complex transactions don't use same connection, OJB FREEZES! (NOT SOLVED)
Posted by Armin Waibel <ar...@code-au-lait.de>.
Hi Edson,
again, could you post a 'small' test case
(or add a new test method to one of the existing
test cases) to reproduce your problem.
This makes things easier for the developers and
help us to prevent doing same things again.
regards,
Armin
----- Original Message -----
From: "Edson Carlos Ericksson Richter"
<ed...@mgrinformatica.com.br>
To: "OJB Users List" <oj...@db.apache.org>
Sent: Monday, May 12, 2003 5:12 PM
Subject: Re: Complex transactions don't use same connection, OJB
FREEZES! (NOT SOLVED)
> I think that putting proxy="true" in reference will solve, but don't.
>
> The transcript of my SapDB follow (look specially at the end of log).
>
> User action:
>
> 1) Localize an object TB_PESSOA;
> 2) Asked for DELETE a contained object (that is persisted in
TB_DOCUMENTO).
> The object is removed from the LIST (I'm doing this in a step-by-step
basis
> debugging in NetBeans, so I really know that the object was deleted
from the
> list).
> 3) Stored PESSOA, so it should store fields in PESSOA (that occur -
you will
> find update in transcript), and then delete (that doesn't occur: SapDB
> blocks access due to update lock above in transaction).
>
> Log transcript:
>
> ---- Thread 149105b main Timestamp: 2003-05-12 11:50:03.379
> ==================================
> package com.sap.dbtech.jdbc, SAP DB JDBC Driver, SAP AG, 7.4.4
Build
> 001-000-156-985 on Java 1.4.2-beta
> new Connection 'jdbc:sapdb://SQLMGR/MGRDEV'
> using com.sap.dbtech.rte.comm.SocketComm@6835fb on
> Socket[addr=SQLMGR/10.10.10.9,port=7210,localport=4577]
> => com.sap.dbtech.jdbc.ConnectionSapDB@1c8efd1
> com.sap.dbtech.jdbc.ConnectionSapDB@1c8efd1.setAutoCommit (true)
> com.sap.dbtech.jdbc.ConnectionSapDB@1c8efd1.setReadOnly (false)
> com.sap.dbtech.jdbc.ConnectionSapDB@1c8efd1.isClosed ()
> => false
> com.sap.dbtech.jdbc.ConnectionSapDB@1c8efd1.getMetaData ()
> => com.sap.dbtech.jdbc.DatabaseMetaDataSapDB@4d76b4
> com.sap.dbtech.jdbc.DatabaseMetaDataSapDB@4d76b4.supportsBatchUpdates
()
> => true
> com.sap.dbtech.jdbc.ConnectionSapDB@1c8efd1.getAutoCommit ()
> => true
> com.sap.dbtech.jdbc.ConnectionSapDB@1c8efd1.getAutoCommit ()
> => true
> com.sap.dbtech.jdbc.ConnectionSapDB@1c8efd1.prepareStatement (SELECT
> count(A0.CO_USUARIO) FROM MGR.TB_USUARIO A0 WHERE (A0.DS_USERNAME =
? ) AND
> A0.DS_PASSWORD = ?, 1003, 1007)
> => com.sap.dbtech.jdbc.CallableStatementSapDB@6e1dec
> com.sap.dbtech.jdbc.CallableStatementSapDB@6e1dec.setObject (1,
> edson.richter, 12)
> com.sap.dbtech.jdbc.CallableStatementSapDB@6e1dec.setObject (2,
[C@2e323,
> 12)
> com.sap.dbtech.jdbc.CallableStatementSapDB@6e1dec.executeQuery ()
> => com.sap.dbtech.jdbc.ResultSetSapDB@1e184cb
> com.sap.dbtech.jdbc.ResultSetSapDB@1e184cb.getMetaData ()
> => com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@1f99eea
> com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@1f99eea.getColumnCount ()
> => 1
> com.sap.dbtech.jdbc.ResultSetSapDB@1e184cb.next ()
> => true
> com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@1f99eea.getColumnType (1)
> => 3
> com.sap.dbtech.jdbc.ResultSetSapDB@1e184cb.getBigDecimal (1)
> => 1
>
> ---- Thread e4245 Finalizer Timestamp: 2003-05-12 11:50:05.172
> com.sap.dbtech.jdbc.ResultSetSapDB@1e184cb.close ()
> com.sap.dbtech.jdbc.CallableStatementSapDB@6e1dec.clearParameters ()
>
> ---- Thread b2a2d8 AWT-EventQueue-0 Timestamp: 2003-05-12 11:53:21.123
> com.sap.dbtech.jdbc.ConnectionSapDB@1c8efd1.prepareStatement (SELECT
>
A0.IM_FOTO,A0.NO_PESSOA,A0.CO_PESSOA,A0.DS_NOME_FANTASIA,A0.ST_FISICA_JU
RIDI
> CA FROM MGR.TB_PESSOA A0 WHERE A0.CO_PESSOA IN (SELECT
min(A0.CO_PESSOA)
> FROM MGR.TB_PESSOA A0), 1003, 1007)
> => com.sap.dbtech.jdbc.CallableStatementSapDB@1875da7
> com.sap.dbtech.jdbc.CallableStatementSapDB@1875da7.executeQuery ()
> => com.sap.dbtech.jdbc.ResultSetSapDB@1c2a1ed
> com.sap.dbtech.jdbc.ResultSetSapDB@1c2a1ed.next ()
> => true
> com.sap.dbtech.jdbc.ResultSetSapDB@1c2a1ed.getInt (CO_PESSOA)
> => 1
> com.sap.dbtech.jdbc.ResultSetSapDB@1c2a1ed.wasNull ()
> => false
> com.sap.dbtech.jdbc.ResultSetSapDB@1c2a1ed.next ()
> => false
> com.sap.dbtech.jdbc.ResultSetSapDB@1c2a1ed.close ()
> com.sap.dbtech.jdbc.CallableStatementSapDB@1875da7.clearParameters ()
> ==================================
> package com.sap.dbtech.jdbc, SAP DB JDBC Driver, SAP AG, 7.4.4
Build
> 001-000-156-985 on Java 1.4.2-beta
> new Connection 'jdbc:sapdb://SQLMGR/MGRDEV'
> using com.sap.dbtech.rte.comm.SocketComm@87ad67 on
> Socket[addr=SQLMGR/10.10.10.9,port=7210,localport=4582]
> => com.sap.dbtech.jdbc.ConnectionSapDB@18952cc
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.setAutoCommit (true)
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.setReadOnly (false)
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.isClosed ()
> => false
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.getAutoCommit ()
> => true
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.getAutoCommit ()
> => true
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.prepareStatement (SELECT
> IM_FOTO,NO_PESSOA,CO_PESSOA,DS_NOME_FANTASIA,ST_FISICA_JURIDICA FROM
> MGR.TB_PESSOA WHERE CO_PESSOA = ?, 1003, 1007)
> => com.sap.dbtech.jdbc.CallableStatementSapDB@6147d9
> com.sap.dbtech.jdbc.CallableStatementSapDB@6147d9.setObject (1, 1, 4)
> com.sap.dbtech.jdbc.CallableStatementSapDB@6147d9.executeQuery ()
> => com.sap.dbtech.jdbc.ResultSetSapDB@b41166
> com.sap.dbtech.jdbc.ResultSetSapDB@b41166.next ()
> => true
> com.sap.dbtech.jdbc.ResultSetSapDB@b41166.getBlob (IM_FOTO)
> => null
> com.sap.dbtech.jdbc.ResultSetSapDB@b41166.wasNull ()
> => true
> com.sap.dbtech.jdbc.ResultSetSapDB@b41166.getString (NO_PESSOA)
> => BATALHAO DE ENG DE COMBATE
> com.sap.dbtech.jdbc.ResultSetSapDB@b41166.getInt (CO_PESSOA)
> => 1
> com.sap.dbtech.jdbc.ResultSetSapDB@b41166.wasNull ()
> => false
> com.sap.dbtech.jdbc.ResultSetSapDB@b41166.getString (DS_NOME_FANTASIA)
> =>
> com.sap.dbtech.jdbc.ResultSetSapDB@b41166.getString
(ST_FISICA_JURIDICA)
> => J
> com.sap.dbtech.jdbc.ResultSetSapDB@b41166.close ()
> com.sap.dbtech.jdbc.CallableStatementSapDB@6147d9.clearParameters ()
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.prepareStatement (SELECT
> count(A0.CO_PESSOA),count(A0.DS_NUMERO) FROM MGR.TB_DOCUMENTO A0 WHERE
(
> A0.CO_PESSOA = ? ) AND (A0.CL_INSTANCIA IN ( ? , ? , ? )), 1003,
1007)
> => com.sap.dbtech.jdbc.CallableStatementSapDB@e8f8c5
> com.sap.dbtech.jdbc.CallableStatementSapDB@e8f8c5.setObject (1, 1, 4)
> com.sap.dbtech.jdbc.CallableStatementSapDB@e8f8c5.setObject (2,
> br.com.mgr.plugins.documentos.beans.DocumentoCnpjBean, 12)
> com.sap.dbtech.jdbc.CallableStatementSapDB@e8f8c5.setObject (3,
> br.com.mgr.plugins.documentos.beans.DocumentoCpfBean, 12)
> com.sap.dbtech.jdbc.CallableStatementSapDB@e8f8c5.setObject (4,
> br.com.mgr.plugins.documentos.beans.DocumentoRgBean, 12)
> com.sap.dbtech.jdbc.CallableStatementSapDB@e8f8c5.executeQuery ()
> => com.sap.dbtech.jdbc.ResultSetSapDB@1248979
> com.sap.dbtech.jdbc.ResultSetSapDB@1248979.getMetaData ()
> => com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@1bd9de3
> com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@1bd9de3.getColumnCount ()
> => 2
> com.sap.dbtech.jdbc.ResultSetSapDB@1248979.next ()
> => true
> com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@1bd9de3.getColumnType (1)
> => 3
> com.sap.dbtech.jdbc.ResultSetSapDB@1248979.getBigDecimal (1)
> => 3
> com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@1bd9de3.getColumnType (2)
> => 3
> com.sap.dbtech.jdbc.ResultSetSapDB@1248979.getBigDecimal (2)
> => 3
> com.sap.dbtech.jdbc.ResultSetSapDB@1248979.next ()
> => false
> com.sap.dbtech.jdbc.ResultSetSapDB@1248979.close ()
> com.sap.dbtech.jdbc.CallableStatementSapDB@e8f8c5.clearParameters ()
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.prepareStatement (SELECT
>
A0.CO_PESSOA,A0.DS_INFO_ADIC_7,A0.DS_INFO_ADIC_3,A0.DS_INFO_ADIC_1,A0.DS
_INF
>
O_ADIC_4,A0.DS_INFO_ADIC_8,A0.CL_INSTANCIA,A0.DS_INFO_ADIC_0,A0.DS_INFO_
ADIC
> _5,A0.DS_INFO_ADIC_9,A0.DS_NUMERO,A0.DS_INFO_ADIC_6,A0.DS_INFO_ADIC_2
FROM
> MGR.TB_DOCUMENTO A0 WHERE ( A0.CO_PESSOA = ? ) AND (A0.CL_INSTANCIA
IN ( ?
> , ? , ? )), 1003, 1007)
> => com.sap.dbtech.jdbc.CallableStatementSapDB@c9f997
> com.sap.dbtech.jdbc.CallableStatementSapDB@c9f997.setObject (1, 1, 4)
> com.sap.dbtech.jdbc.CallableStatementSapDB@c9f997.setObject (2,
> br.com.mgr.plugins.documentos.beans.DocumentoCnpjBean, 12)
> com.sap.dbtech.jdbc.CallableStatementSapDB@c9f997.setObject (3,
> br.com.mgr.plugins.documentos.beans.DocumentoCpfBean, 12)
> com.sap.dbtech.jdbc.CallableStatementSapDB@c9f997.setObject (4,
> br.com.mgr.plugins.documentos.beans.DocumentoRgBean, 12)
> com.sap.dbtech.jdbc.CallableStatementSapDB@c9f997.executeQuery ()
> => com.sap.dbtech.jdbc.ResultSetSapDB@2153fe
> com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.next ()
> => true
> com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.getInt (CO_PESSOA)
> => 1
> com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.wasNull ()
> => false
> com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.getString (DS_NUMERO)
> => 1050338175
> com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.next ()
> => true
> com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.getInt (CO_PESSOA)
> => 1
> com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.wasNull ()
> => false
> com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.getString (DS_NUMERO)
> => 71436677068
> com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.next ()
> => true
> com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.getInt (CO_PESSOA)
> => 1
> com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.wasNull ()
> => false
> com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.getString (DS_NUMERO)
> => 95135075000196
> com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.next ()
> => false
> com.sap.dbtech.jdbc.ResultSetSapDB@2153fe.close ()
> com.sap.dbtech.jdbc.CallableStatementSapDB@c9f997.clearParameters ()
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.prepareStatement (SELECT
> count(A0.CO_PESSOA),count(A0.DS_NUMERO) FROM MGR.TB_TELEFONE A0 WHERE
> A0.CO_PESSOA = ?, 1003, 1007)
> => com.sap.dbtech.jdbc.CallableStatementSapDB@1ce5e7a
> com.sap.dbtech.jdbc.CallableStatementSapDB@1ce5e7a.setObject (1, 1, 4)
> com.sap.dbtech.jdbc.CallableStatementSapDB@1ce5e7a.executeQuery ()
> => com.sap.dbtech.jdbc.ResultSetSapDB@19cd5f5
> com.sap.dbtech.jdbc.ResultSetSapDB@19cd5f5.getMetaData ()
> => com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@1a2da17
> com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@1a2da17.getColumnCount ()
> => 2
> com.sap.dbtech.jdbc.ResultSetSapDB@19cd5f5.next ()
> => true
> com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@1a2da17.getColumnType (1)
> => 3
> com.sap.dbtech.jdbc.ResultSetSapDB@19cd5f5.getBigDecimal (1)
> => 2
> com.sap.dbtech.jdbc.ResultSetMetaDataSapDB@1a2da17.getColumnType (2)
> => 3
> com.sap.dbtech.jdbc.ResultSetSapDB@19cd5f5.getBigDecimal (2)
> => 2
> com.sap.dbtech.jdbc.ResultSetSapDB@19cd5f5.next ()
> => false
> com.sap.dbtech.jdbc.ResultSetSapDB@19cd5f5.close ()
> com.sap.dbtech.jdbc.CallableStatementSapDB@1ce5e7a.clearParameters ()
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.prepareStatement (SELECT
>
A0.DS_CODIGO_AREA,A0.DS_TIPO,A0.CO_PESSOA,A0.DS_OBSERVACOES,A0.DS_CODIGO
_PAI
> S,A0.DS_NUMERO FROM MGR.TB_TELEFONE A0 WHERE A0.CO_PESSOA = ?, 1003,
1007)
> => com.sap.dbtech.jdbc.CallableStatementSapDB@bdb375
> com.sap.dbtech.jdbc.CallableStatementSapDB@bdb375.setObject (1, 1, 4)
> com.sap.dbtech.jdbc.CallableStatementSapDB@bdb375.executeQuery ()
> => com.sap.dbtech.jdbc.ResultSetSapDB@174f02c
> com.sap.dbtech.jdbc.ResultSetSapDB@174f02c.next ()
> => true
> com.sap.dbtech.jdbc.ResultSetSapDB@174f02c.getInt (CO_PESSOA)
> => 1
> com.sap.dbtech.jdbc.ResultSetSapDB@174f02c.wasNull ()
> => false
> com.sap.dbtech.jdbc.ResultSetSapDB@174f02c.getString (DS_NUMERO)
> => 33470441
> com.sap.dbtech.jdbc.ResultSetSapDB@174f02c.next ()
> => true
> com.sap.dbtech.jdbc.ResultSetSapDB@174f02c.getInt (CO_PESSOA)
> => 1
> com.sap.dbtech.jdbc.ResultSetSapDB@174f02c.wasNull ()
> => false
> com.sap.dbtech.jdbc.ResultSetSapDB@174f02c.getString (DS_NUMERO)
> => 33470446
> com.sap.dbtech.jdbc.ResultSetSapDB@174f02c.next ()
> => false
> com.sap.dbtech.jdbc.ResultSetSapDB@174f02c.close ()
> com.sap.dbtech.jdbc.CallableStatementSapDB@bdb375.clearParameters ()
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.isClosed ()
> => false
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.getAutoCommit ()
> => true
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.setAutoCommit (true)
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.setReadOnly (false)
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.isClosed ()
> => false
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.getAutoCommit ()
> => true
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.getAutoCommit ()
> => true
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.prepareStatement (SELECT
>
DS_CODIGO_AREA,DS_TIPO,CO_PESSOA,DS_OBSERVACOES,DS_CODIGO_PAIS,DS_NUMERO
> FROM MGR.TB_TELEFONE WHERE CO_PESSOA = ? AND DS_NUMERO = ?, 1003,
1007)
> => com.sap.dbtech.jdbc.CallableStatementSapDB@178efd8
> com.sap.dbtech.jdbc.CallableStatementSapDB@178efd8.setObject (1, 1, 4)
> com.sap.dbtech.jdbc.CallableStatementSapDB@178efd8.setObject (2,
33470441,
> 12)
> com.sap.dbtech.jdbc.CallableStatementSapDB@178efd8.executeQuery ()
> => com.sap.dbtech.jdbc.ResultSetSapDB@ca5bff
> com.sap.dbtech.jdbc.ResultSetSapDB@ca5bff.next ()
> => true
> com.sap.dbtech.jdbc.ResultSetSapDB@ca5bff.getString (DS_CODIGO_AREA)
> => 51
> com.sap.dbtech.jdbc.ResultSetSapDB@ca5bff.getString (DS_TIPO)
> => Comercial
> com.sap.dbtech.jdbc.ResultSetSapDB@ca5bff.getInt (CO_PESSOA)
> => 1
> com.sap.dbtech.jdbc.ResultSetSapDB@ca5bff.wasNull ()
> => false
> com.sap.dbtech.jdbc.ResultSetSapDB@ca5bff.getString (DS_OBSERVACOES)
> =>
> com.sap.dbtech.jdbc.ResultSetSapDB@ca5bff.getString (DS_CODIGO_PAIS)
> => 055
> com.sap.dbtech.jdbc.ResultSetSapDB@ca5bff.getString (DS_NUMERO)
> => 33470441
> com.sap.dbtech.jdbc.ResultSetSapDB@ca5bff.close ()
> com.sap.dbtech.jdbc.CallableStatementSapDB@178efd8.clearParameters ()
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.isClosed ()
> => false
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.getAutoCommit ()
> => true
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.setAutoCommit (true)
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.setReadOnly (false)
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.isClosed ()
> => false
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.getAutoCommit ()
> => true
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.getAutoCommit ()
> => true
> com.sap.dbtech.jdbc.CallableStatementSapDB@178efd8.setObject (1, 1, 4)
> com.sap.dbtech.jdbc.CallableStatementSapDB@178efd8.setObject (2,
33470446,
> 12)
> com.sap.dbtech.jdbc.CallableStatementSapDB@178efd8.executeQuery ()
> => com.sap.dbtech.jdbc.ResultSetSapDB@16721bd
> com.sap.dbtech.jdbc.ResultSetSapDB@16721bd.next ()
> => true
> com.sap.dbtech.jdbc.ResultSetSapDB@16721bd.getString (DS_CODIGO_AREA)
> => 51
> com.sap.dbtech.jdbc.ResultSetSapDB@16721bd.getString (DS_TIPO)
> => Comercial
> com.sap.dbtech.jdbc.ResultSetSapDB@16721bd.getInt (CO_PESSOA)
> => 1
> com.sap.dbtech.jdbc.ResultSetSapDB@16721bd.wasNull ()
> => false
> com.sap.dbtech.jdbc.ResultSetSapDB@16721bd.getString (DS_OBSERVACOES)
> =>
> com.sap.dbtech.jdbc.ResultSetSapDB@16721bd.getString (DS_CODIGO_PAIS)
> => 055
> com.sap.dbtech.jdbc.ResultSetSapDB@16721bd.getString (DS_NUMERO)
> => 33470446
> com.sap.dbtech.jdbc.ResultSetSapDB@16721bd.close ()
> com.sap.dbtech.jdbc.CallableStatementSapDB@178efd8.clearParameters ()
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.isClosed ()
> => false
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.getAutoCommit ()
> => true
> com.sap.dbtech.jdbc.ConnectionSapDB@1c8efd1.setAutoCommit (false)
> com.sap.dbtech.jdbc.ConnectionSapDB@1c8efd1.prepareStatement (SELECT
> IM_FOTO,NO_PESSOA,CO_PESSOA,DS_NOME_FANTASIA,ST_FISICA_JURIDICA FROM
> MGR.TB_PESSOA WHERE CO_PESSOA = ?, 1003, 1007)
> => com.sap.dbtech.jdbc.CallableStatementSapDB@f01d52
> com.sap.dbtech.jdbc.CallableStatementSapDB@f01d52.setObject (1, 1, 4)
> com.sap.dbtech.jdbc.CallableStatementSapDB@f01d52.executeQuery ()
> => com.sap.dbtech.jdbc.ResultSetSapDB@152643
> com.sap.dbtech.jdbc.ResultSetSapDB@152643.next ()
> => true
> com.sap.dbtech.jdbc.ResultSetSapDB@152643.getBlob (IM_FOTO)
> => null
> com.sap.dbtech.jdbc.ResultSetSapDB@152643.wasNull ()
> => true
> com.sap.dbtech.jdbc.ResultSetSapDB@152643.getString (NO_PESSOA)
> => BATALHAO DE ENG DE COMBATE
> com.sap.dbtech.jdbc.ResultSetSapDB@152643.getInt (CO_PESSOA)
> => 1
> com.sap.dbtech.jdbc.ResultSetSapDB@152643.wasNull ()
> => false
> com.sap.dbtech.jdbc.ResultSetSapDB@152643.getString (DS_NOME_FANTASIA)
> =>
> com.sap.dbtech.jdbc.ResultSetSapDB@152643.getString
(ST_FISICA_JURIDICA)
> => J
> com.sap.dbtech.jdbc.ResultSetSapDB@152643.close ()
> com.sap.dbtech.jdbc.CallableStatementSapDB@f01d52.clearParameters ()
> com.sap.dbtech.jdbc.ConnectionSapDB@1c8efd1.prepareStatement (UPDATE
> MGR.TB_PESSOA SET
> NO_PESSOA=?,ST_FISICA_JURIDICA=?,DS_NOME_FANTASIA=?,IM_FOTO=? WHERE
> CO_PESSOA = ?, 1003, 1007)
> => com.sap.dbtech.jdbc.CallableStatementSapDB@11ee017
> com.sap.dbtech.jdbc.CallableStatementSapDB@11ee017.setObject (1,
BATALHAO DE
> ENG DE COMBATE, 12)
> com.sap.dbtech.jdbc.CallableStatementSapDB@11ee017.setObject (2, J, 1)
> com.sap.dbtech.jdbc.CallableStatementSapDB@11ee017.setObject (3, , 12)
> com.sap.dbtech.jdbc.CallableStatementSapDB@11ee017.setNull (4, 2004)
> com.sap.dbtech.jdbc.CallableStatementSapDB@11ee017.setObject (5, 1, 4)
> com.sap.dbtech.jdbc.CallableStatementSapDB@11ee017.executeUpdate ()
> => 1
> com.sap.dbtech.jdbc.CallableStatementSapDB@11ee017.clearParameters ()
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.setAutoCommit (true)
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.setReadOnly (false)
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.isClosed ()
> => false
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.getAutoCommit ()
> => true
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.getAutoCommit ()
> => true
> com.sap.dbtech.jdbc.ConnectionSapDB@18952cc.prepareStatement (SELECT
>
CO_PESSOA,DS_INFO_ADIC_7,DS_INFO_ADIC_3,DS_INFO_ADIC_1,DS_INFO_ADIC_4,DS
_INF
>
O_ADIC_8,CL_INSTANCIA,DS_INFO_ADIC_0,DS_INFO_ADIC_5,DS_INFO_ADIC_9,DS_NU
MERO
> ,DS_INFO_ADIC_6,DS_INFO_ADIC_2 FROM MGR.TB_DOCUMENTO WHERE CO_PESSOA =
?
> AND DS_NUMERO = ?, 1003, 1007)
> => com.sap.dbtech.jdbc.CallableStatementSapDB@15d45d9
> com.sap.dbtech.jdbc.CallableStatementSapDB@15d45d9.setObject (1, 1, 4)
> com.sap.dbtech.jdbc.CallableStatementSapDB@15d45d9.setObject (2,
1050338175,
> 12)
> com.sap.dbtech.jdbc.CallableStatementSapDB@15d45d9.executeQuery ()
> => com.sap.dbtech.jdbc.ResultSetSapDB@94aa42
> com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.next ()
> => true
> com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getInt (CO_PESSOA)
> => 1
> com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.wasNull ()
> => false
> com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getString (DS_INFO_ADIC_7)
> => null
> com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getString (DS_INFO_ADIC_3)
> => null
> com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getString (DS_INFO_ADIC_1)
> => 469249200000
> com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getString (DS_INFO_ADIC_4)
> => null
> com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getString (DS_INFO_ADIC_8)
> => null
> com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getString (CL_INSTANCIA)
> => br.com.mgr.plugins.documentos.beans.DocumentoRgBean
> com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getString (DS_INFO_ADIC_0)
> => SSP/RS
> com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getString (DS_INFO_ADIC_5)
> => null
> com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getString (DS_INFO_ADIC_9)
> => null
> com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getString (DS_NUMERO)
> => 1050338175
> com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getString (DS_INFO_ADIC_6)
> => null
> com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.getString (DS_INFO_ADIC_2)
> => null
> com.sap.dbtech.jdbc.ResultSetSapDB@94aa42.close ()
> com.sap.dbtech.jdbc.CallableStatementSapDB@15d45d9.clearParameters ()
> com.sap.dbtech.jdbc.CallableStatementSapDB@6147d9.setObject (1, 1, 4)
> com.sap.dbtech.jdbc.CallableStatementSapDB@6147d9.executeQuery ()
>
>
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.478 / Virus Database: 275 - Release Date: 6/5/2003
>