I've set the debug option against Oracle driver that I'm using I've got a
whole raft of messages from the time oracle enters the store method in the
JamesJDBCMailRepository class to setup the parameters to insert incoming
mail attachment mail into the inbox table within Oracle until the time it
throws the IOException message explained below. These are the results I got
out from Oracle JDBC driver:
Inside JDBCMailRepository.store() method
Step1...
Step2...
Step3...
Step4...
Step5...
Step5ii...
Step6...
Step7...
Step8...
Step9...
Step10...
Step11...
Step12...
Step13...
Step14...
Step15...
Step16...
6 0d 0a
20 20 20 20 20 20 20 20 20 20 66 6f 72 20 3c 73 61 6d 75 65
... last 626 bytes were not printed to limit the output size
DBDataSetImpl.m_last_bind_values has size of 4
DBDataSetImpl.m_tmp_first_row_items is null
DBDataSetImpl.m_tmp_first_row_types is null
DRVR FUNC OracleStatement.cleanupForBatching()
DRVR DBG1 End of doExecuteWithTimeout(): m_currentRank=0
DRVR FUNC OracleStatement.getLongValue(getColumn=false, index=2)
DRVR FUNC OracleStatement.getBytesInternal(getColumn=false, index=2)
DBAC FUNC DBDataSetImpl.isStreamType(index= 1)
DRVR FUNC OracleStatement.getBytesValue(getColumn=false, index=4)
DRVR FUNC OracleStatement.getBytesInternal(getColumn=false, index=4)
DBAC FUNC DBDataSetImpl.isStreamType(index= 3)
DRVR OPER OraclePreparedStatement.close()
DRVR OPER OracleCallableStatement.sendBatch()
DRVR OPER OracleStatement.close()
DBAC FUNC DBDataSetImpl.cleanup()
m_dataSetType= 0
DBAC FUNC DBDataSetImpl.cleanTypes()
m_dataSetType= 0
DBAC FUNC DBDataSetImpl.cleanData()
m_dataSetType= 0
DRVR FUNC OracleResultSetImpl.internal_close()
DRVR FUNC OracleResultSetImpl.internal_close()
DRVR OPER OraclePreparedStatement.close()
DRVR OPER OraclePreparedStatement.sendBatch()
DRVR DBG1 Send batch: batch=1, m_currentRank=0
DRVR OPER OracleStatement.close()
DBAC FUNC DBDataSetImpl.cleanup()
m_dataSetType= 0
DBAC FUNC DBDataSetImpl.cleanTypes()
m_dataSetType= 0
DBAC FUNC DBDataSetImpl.cleanData()
m_dataSetType= 0
DBAC FUNC DBData.cleanup()
DRVR OPER OracleConnection.getWarnings()
DRVR OPER OracleConnection.clearWarnings()
DRVR FUNC OracleConnection.isClosed() returned false
DRVR OPER OracleConnection.getWarnings()
DRVR OPER OracleConnection.clearWarnings()
DRVR OPER OracleConnection.prepareStatement(sql)
DRVR DBG1 SQL: "SELECT message_body FROM inbox WHERE message_name = ? AND
repository_name = ?"
DRVR FUNC OracleStatement.OracleStatement(conn, batchValue=1,
rowPrefetchValue=10)
DBAC FUNC DBDataSetImpl.DBDataSetImpl(conn, nrows=0 ,dataSetType= 0)
DRVR FUNC OraclePreparedStatement.OraclePreparedStatement(conn, sql,
batchValue, rowPrefetchValue)
DBAC FUNC DBDataSetImpl.DBDataSetImpl(conn, nrows=1 ,dataSetType= 1)
DRVR FUNC OracleConnection.nativeSQL(sql)
DRVR DBG1 Input SQL: "SELECT message_body FROM inbox WHERE message_name = ?
AND repository_name = ?"
DRVR DBG1 Output SQL: "SELECT message_body FROM inbox WHERE message_name =
:1 AND repository_name = :2"
DBCV FUNC DBConversion.StringToCharBytes(str)
DBCV FUNC DBConversion.stringToAcessCharBytes(str, charset=31)
DBCV DBG2 UCS-2 bytes (158 bytes):
00 53 00 45 00 4c 00 45 00 43 00 54 00 20 00 6d 00 65 00 73
00 73 00 61 00 67 00 65 00 5f 00 62 00 6f 00 64 00 79 00 20
00 46 00 52 00 4f 00 4d 00 20 00 69 00 6e 00 62 00 6f 00 78
00 20 00 57 00 48 00 45 00 52 00 45 00 20 00 6d 00 65 00 73
00 73 00 61 00 67 00 65 00 5f 00 6e 00 61 00 6d 00 65 00 20
00 3d 00 20 00 3a 00 31 00 20 00 41 00 4e 00 44 00 20 00 72
00 65 00 70 00 6f 00 73 00 69 00 74 00 6f 00 72 00 79 00 5f
00 6e 00 61 00 6d 00 65 00 20 00 3d 00 20 00 3a 00 32
DBCV FUNC DBConversion.stringToAsciiBytes(str)
DBCV DBG2 DBAccess bytes (79 bytes):
53 45 4c 45 43 54 20 6d 65 73 73 61 67 65 5f 62 6f 64 79 20
46 52 4f 4d 20 69 6e 62 6f 78 20 57 48 45 52 45 20 6d 65 73
73 61 67 65 5f 6e 61 6d 65 20 3d 20 3a 31 20 41 4e 44 20 72
65 70 6f 73 69 74 6f 72 79 5f 6e 61 6d 65 20 3d 20 3a 32
DRVR OPER OraclePreparedStatement.setString(paramIndex=1,
x=Mail1014679360718-1)
DBCV FUNC DBConversion.StringToCharBytes(str)
DBCV FUNC DBConversion.stringToAcessCharBytes(str, charset=31)
DBCV DBG2 UCS-2 bytes (38 bytes):
00 4d 00 61 00 69 00 6c 00 31 00 30 00 31 00 34 00 36 00 37
00 39 00 33 00 36 00 30 00 37 00 31 00 38 00 2d 00 31
DBCV FUNC DBConversion.stringToAsciiBytes(str)
DBCV DBG2 DBAccess bytes (19 bytes):
4d 61 69 6c 31 30 31 34 36 37 39 33 36 30 37 31 38 2d 31
DRVR FUNC OraclePreparedStatement.setItem(index=0, type=1, array)
DBAC FUNC DBDataSetImpl._createOrGetBindDBType(index= 0, type= 1)
DBAC FUNC DBDataSetImpl._alloc_tmp_binds(index=0 isInBind=true)
DRVR OPER OraclePreparedStatement.setString(paramIndex=2, x=samuel)
DBCV FUNC DBConversion.StringToCharBytes(str)
DBCV FUNC DBConversion.stringToAcessCharBytes(str, charset=31)
DBCV DBG2 UCS-2 bytes (12 bytes):
00 73 00 61 00 6d 00 75 00 65 00 6c
DBCV FUNC DBConversion.stringToAsciiBytes(str)
DBCV DBG2 DBAccess bytes (6 bytes):
73 61 6d 75 65 6c
DRVR FUNC OraclePreparedStatement.setItem(index=1, type=1, array)
DBAC FUNC DBDataSetImpl._createOrGetBindDBType(index= 1, type= 1)
DBAC FUNC DBDataSetImpl._alloc_tmp_binds(index=1 isInBind=true)
DRVR OPER OraclePreparedStatement.executeQuery()
DRVR OPER OraclePreparedStatement.executeUpdate()
DRVR FUNC OraclePreparedStatement.get_data_for_columns()
DBAC FUNC DBDataSetImpl.rowCompleted()
DBAC FUNC DBDataSetImpl._bindRowCompleted(rank= 0)
DBAC FUNC DBDataSetImpl._bindRowCompleted m_dataSetType is 1 ,m_noOfArgs is
2 m_first_row is true m_cleanedData is false
DBAC FUNC DBData.DBData(nItems=1)
DBAC FUNC DBData.DBData(nItems=1)
DRVR FUNC OracleStatement.doExecuteWithTimeout()
DRVR FUNC OracleStatement.doExecuteQuery()
DRVR DBG1 Before query: sql_kind=0, row_prefetch=10, need_to_parse=true,
need_to_prepare_define_buffer=true, columns_defined_by_user=false
DRVR DBG2 array_sql:
53 45 4c 45 43 54 20 6d 65 73 73 61 67 65 5f 62 6f 64 79 20
46 52 4f 4d 20 69 6e 62 6f 78 20 57 48 45 52 45 20 6d 65 73
73 61 67 65 5f 6e 61 6d 65 20 3d 20 3a 31 20 41 4e 44 20 72
65 70 6f 73 69 74 6f 72 79 5f 6e 61 6d 65 20 3d 20 3a 32
DRVR DBG2 binds_in: oracle.jdbc.dbaccess.DBDataSetImpl@37ec5d
DBDataSetImpl.m_dynamic=false
DBDataSetImpl.m_arrayDepth=1 (valid only when m_dynamic=false)
DBDataSetImpl.m_dataSetType=1
DBDataSetImpl.m_noOfArgs=2
DBDataSetImpl.types.length=2
types[0].type= VARCHAR (max_length=4000)
types[1].type= VARCHAR (max_length=4000)
DBDataSetImpl.data.length=2
data[0].items[0] has 19 bytes:
data[0].items[0] has 19 bytes allocated
4d 61 69 6c 31 30 31 34 36 37 39 33 36 30 37 31 38 2d 31
data[1].items[0] has 6 bytes:
data[1].items[0] has 6 bytes allocated
73 61 6d 75 65 6c DBDataSetImpl.m_last_bind_values has size of 2
DBDataSetImpl.m_tmp_first_row_items is null
DBDataSetImpl.m_tmp_first_row_types is null
DRVR DBG2 defines: oracle.jdbc.dbaccess.DBDataSetImpl@7efe3f
DBDataSetImpl.m_dynamic=false
DBDataSetImpl.m_arrayDepth=0 (valid only when m_dynamic=false)
DBDataSetImpl.m_dataSetType=0
DBDataSetImpl.m_noOfArgs=0
DBDataSetImpl.types is null
DBDataSetImpl.data is null DBDataSetImpl.m_last_bind_values is null
DBDataSetImpl.m_tmp_first_row_items is null
DBDataSetImpl.m_tmp_first_row_types is null
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=0)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=0, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 4d
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=0, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 4d
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=1)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=1, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 45
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=1, chars[],
charIndex=1)
DBCV DBG2 DBAccess byte: 45
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=2)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=2, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 53
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=2, chars[],
charIndex=2)
DBCV DBG2 DBAccess byte: 53
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=3)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=3, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 53
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=3, chars[],
charIndex=3)
DBCV DBG2 DBAccess byte: 53
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=4)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=4, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 41
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=4, chars[],
charIndex=4)
DBCV DBG2 DBAccess byte: 41
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=5)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=5, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 47
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=5, chars[],
charIndex=5)
DBCV DBG2 DBAccess byte: 47
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=6)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=6, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 45
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=6, chars[],
charIndex=6)
DBCV DBG2 DBAccess byte: 45
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=7)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=7, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 5f
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=7, chars[],
charIndex=7)
DBCV DBG2 DBAccess byte: 5f
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=8)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=8, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 42
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=8, chars[],
charIndex=8)
DBCV DBG2 DBAccess byte: 42
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=9)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=9, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 4f
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=9, chars[],
charIndex=9)
DBCV DBG2 DBAccess byte: 4f
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=10)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=10, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 44
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=10, chars[],
charIndex=10)
DBCV DBG2 DBAccess byte: 44
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=11)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=11, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 59
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=11, chars[],
charIndex=11)
DBCV DBG2 DBAccess byte: 59
DBCV DBG2 UCS-2 character byte: 00
PIKL DBG1 OracleTypeADT (., null)
PIKL DBG1 OracleTypeADT ([B@661a35, 0, 0, 0, .)
DBAC FUNC DBDataSetImpl.setNoOfDefineCol(noOfArgs= 1)
DBAC FUNC DBDataSetImpl.setTypes(index= 0 ,internalType= 113 , externalType=
0 ,maxLength= 86)
m_dataSetType= 0
DBAC FUNC DBDataSetImpl.hasStreamType()
DBAC FUNC DBDataSetImpl.setBatchSize(newBatchSize=10)
DBAC DBG1 DBDataSetImpl.setBatchSize: original batch size was 0, dataset
was=
oracle.jdbc.dbaccess.DBDataSetImpl@7efe3f
DBDataSetImpl.m_dynamic=false
DBDataSetImpl.m_arrayDepth=0 (valid only when m_dynamic=false)
DBDataSetImpl.m_dataSetType=0
DBDataSetImpl.m_noOfArgs=1
DBDataSetImpl.types.length=1
types[0].type= BLOB (max_length=86)
DBDataSetImpl.data is null DBDataSetImpl.m_last_bind_values is null
DBDataSetImpl.m_tmp_first_row_items is null
DBDataSetImpl.m_tmp_first_row_types is null
DBAC FUNC DBDataSetImpl.hasStreamType()
DBAC FUNC DBDataSetImpl.setBatchSize(newBatchSize=10)
DBAC DBG1 DBDataSetImpl.setBatchSize: original batch size was 10, dataset
was=
oracle.jdbc.dbaccess.DBDataSetImpl@7efe3f
DBDataSetImpl.m_dynamic=false
DBDataSetImpl.m_arrayDepth=10 (valid only when m_dynamic=false)
DBDataSetImpl.m_dataSetType=0
DBDataSetImpl.m_noOfArgs=1
DBDataSetImpl.types.length=1
types[0].type= BLOB (max_length=86)
DBDataSetImpl.data is null DBDataSetImpl.m_last_bind_values is null
DBDataSetImpl.m_tmp_first_row_items is null
DBDataSetImpl.m_tmp_first_row_types is null
DBAC FUNC DBDataSetImpl.rowCompleted()
DBAC FUNC DBDataSetImpl._definesRowCompleted()
DBAC DBG1 DBDataSetImpl._definesRowCompleted m_noOfArgs= 1
DBAC FUNC DBData.DBData(nItems=10)
DBAC FUNC DBDataSetImpl._setRowItems(colIndex= 0, item=
oracle.jdbc.ttc7.TTCItem@42b2f6)
DBAC FUNC DBDataSetImpl.isStreamType(index= 0)
DRVR DBG1 After execute: valid_rows=1
DRVR DBG2 defines: oracle.jdbc.dbaccess.DBDataSetImpl@7efe3f
DBDataSetImpl.m_dynamic=false
DBDataSetImpl.m_arrayDepth=10 (valid only when m_dynamic=false)
DBDataSetImpl.m_dataSetType=0
DBDataSetImpl.m_noOfArgs=1
DBDataSetImpl.types.length=1
types[0].type= BLOB (max_length=86)
DBDataSetImpl.data.length=1
data[0].items[0] has 86 bytes:
data[0].items[0] has 86 bytes allocated
00 54 00 01 01 0c 00 00 00 01 00 00 00 01 00 00 00 00 10 39
00 00 0f 2f 00 00 0f 2e 00 09 00 09 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 10 c6 3f 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0f 2e
00 40 2d 8c 00 04
data[0].items[1] has 0 bytes:
data[0].items[1] has 86 bytes allocated
data[0].items[2] has 0 bytes:
data[0].items[2] has 86 bytes allocated
data[0].items[3] has 0 bytes:
data[0].items[3] has 86 bytes allocated
data[0].items[4] has 0 bytes:
data[0].items[4] has 86 bytes allocated
data[0].items[5] has 0 bytes:
data[0].items[5] has 86 bytes allocated
data[0].items[6] has 0 bytes:
data[0].items[6] has 86 bytes allocated
data[0].items[7] has 0 bytes:
data[0].items[7] has 86 bytes allocated
data[0].items[8] has 0 bytes:
data[0].items[8] has 86 bytes allocated
data[0].items[9] has 0 bytes:
data[0].items[9] has 86 bytes allocated
DBDataSetImpl.m_last_bind_values is null
DBDataSetImpl.m_tmp_first_row_items is null
DBDataSetImpl.m_tmp_first_row_types is null
DRVR FUNC OracleResultSetImpl.next(): closed=false
DRVR DBG1 closed=false, statement.current_row=-1,
statement.total_rows_visited=0, statement.max_rows=0,
statement.valid_rows=1, statement.got_last_batch=true
DRVR FUNC OracleStatement.getBLOBValue(getColumn=true, index=1)
DRVR FUNC OracleConnection.prepareCall(sql)
DRVR DBG1 SQL: "begin ? := dbms_lob.getLength (?); end;"
DRVR FUNC OracleStatement.OracleStatement(conn, batchValue=1,
rowPrefetchValue=10)
DBAC FUNC DBDataSetImpl.DBDataSetImpl(conn, nrows=0 ,dataSetType= 0)
DRVR FUNC OraclePreparedStatement.OraclePreparedStatement(conn, sql,
batchValue, rowPrefetchValue)
DBAC FUNC DBDataSetImpl.DBDataSetImpl(conn, nrows=1 ,dataSetType= 1)
DRVR FUNC OracleConnection.nativeSQL(sql)
DRVR DBG1 Input SQL: "begin ? := dbms_lob.getLength (?); end;"
DRVR DBG1 Output SQL: "begin :1 := dbms_lob.getLength (:2); end;"
DBCV FUNC DBConversion.StringToCharBytes(str)
DBCV FUNC DBConversion.stringToAcessCharBytes(str, charset=31)
DBCV DBG2 UCS-2 bytes (82 bytes):
00 62 00 65 00 67 00 69 00 6e 00 20 00 3a 00 31 00 20 00 3a
00 3d 00 20 00 64 00 62 00 6d 00 73 00 5f 00 6c 00 6f 00 62
00 2e 00 67 00 65 00 74 00 4c 00 65 00 6e 00 67 00 74 00 68
00 20 00 28 00 3a 00 32 00 29 00 3b 00 20 00 65 00 6e 00 64
00 3b
DBCV FUNC DBConversion.stringToAsciiBytes(str)
DBCV DBG2 DBAccess bytes (41 bytes):
62 65 67 69 6e 20 3a 31 20 3a 3d 20 64 62 6d 73 5f 6c 6f 62
2e 67 65 74 4c 65 6e 67 74 68 20 28 3a 32 29 3b 20 65 6e 64
3b
DRVR FUNC OracleCallableStatement.OracleCallableStatement(conn, sql,
batchValue, rowPrefetchValue) returned
DRVR FUNC OracleConnection.nativeSQL(sql)
DRVR DBG1 Input SQL: "begin ? := dbms_lob.getLength (?); end;"
DRVR DBG1 Output SQL: "begin :1 := dbms_lob.getLength (:2); end;"
DBCV FUNC DBConversion.StringToCharBytes(str)
DBCV FUNC DBConversion.stringToAcessCharBytes(str, charset=31)
DBCV DBG2 UCS-2 bytes (82 bytes):
00 62 00 65 00 67 00 69 00 6e 00 20 00 3a 00 31 00 20 00 3a
00 3d 00 20 00 64 00 62 00 6d 00 73 00 5f 00 6c 00 6f 00 62
00 2e 00 67 00 65 00 74 00 4c 00 65 00 6e 00 67 00 74 00 68
00 20 00 28 00 3a 00 32 00 29 00 3b 00 20 00 65 00 6e 00 64
00 3b
DBCV FUNC DBConversion.stringToAsciiBytes(str)
DBCV DBG2 DBAccess bytes (41 bytes):
62 65 67 69 6e 20 3a 31 20 3a 3d 20 64 62 6d 73 5f 6c 6f 62
2e 67 65 74 4c 65 6e 67 74 68 20 28 3a 32 29 3b 20 65 6e 64
3b
DBAC FUNC DBDataSetImpl.DBDataSetImpl(conn, nrows=1 ,dataSetType= 2)
DRVR OPER OraclePreparedStatement.setObject(paramIndex=2, object,
targetSqlType=2004, scale=0)
DRVR OPER OraclePreparedStatement.setBLOB(paramIndex=2, lob)
DRVR FUNC OraclePreparedStatement.setDatum(index=1, type=113, datum)
DRVR FUNC OraclePreparedStatement.setItem(index=1, type=113, array)
DBAC FUNC DBDataSetImpl._createOrGetBindDBType(index= 1, type= 113)
DBAC FUNC DBDataSetImpl._alloc_tmp_binds(index=1 isInBind=true)
DRVR OPER OracleCallableStatement.registerOutParameter(paramIndex=1,
sqlType=2, scale=0, maxLength=-1)
DBAC FUNC DBDataSetImpl.setTypes(index= 0 ,internalType= 6 , externalType= 0
,maxLength= 0)
m_dataSetType= 2
DBAC FUNC DBDataSetImpl._createOrGetBindDBType(index= 0, type= 6)
DBAC FUNC DBDataSetImpl._alloc_tmp_binds(index=0 isInBind=true)
DRVR OPER OraclePreparedStatement.execute()
DRVR OPER OraclePreparedStatement.executeUpdate()
DRVR FUNC OraclePreparedStatement.get_data_for_columns()
DBAC FUNC DBDataSetImpl.rowCompleted()
DBAC FUNC DBDataSetImpl._bindRowCompleted(rank= 0)
DBAC FUNC DBDataSetImpl._bindRowCompleted m_dataSetType is 1 ,m_noOfArgs is
2 m_first_row is true m_cleanedData is false
DBAC FUNC DBData.DBData(nItems=1)
DBAC FUNC DBDataSetImpl.rowCompleted()
DBAC FUNC DBDataSetImpl._bindRowCompleted(rank= 0)
DBAC FUNC DBDataSetImpl._bindRowCompleted m_dataSetType is 2 ,m_noOfArgs is
1 m_first_row is true m_cleanedData is false
DBAC FUNC DBData.DBData(nItems=1)
DRVR FUNC OracleStatement.doExecuteWithTimeout()
DRVR FUNC OracleStatement.doExecuteOther(batchForPlsql=false)
DRVR DBG1 Before execute: m_currentRank=1, sql_kind=1, need_to_parse=true
DRVR DBG2 binds_in: oracle.jdbc.dbaccess.DBDataSetImpl@2001ff
DBDataSetImpl.m_dynamic=false
DBDataSetImpl.m_arrayDepth=1 (valid only when m_dynamic=false)
DBDataSetImpl.m_dataSetType=1
DBDataSetImpl.m_noOfArgs=2
DBDataSetImpl.types.length=2
types[0]=null
types[1].type= BLOB (max_length=86)
DBDataSetImpl.data.length=2
data[0]=null
data[1].items[0] has 86 bytes:
data[1].items[0] has 86 bytes allocated
00 54 00 01 01 0c 00 00 00 01 00 00 00 01 00 00 00 00 10 39
00 00 0f 2f 00 00 0f 2e 00 09 00 09 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 10 c6 3f 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0f 2e
00 40 2d 8c 00 04 DBDataSetImpl.m_last_bind_values has size of 2
DBDataSetImpl.m_tmp_first_row_items is null
DBDataSetImpl.m_tmp_first_row_types is null
DRVR DBG2 binds_out: oracle.jdbc.dbaccess.DBDataSetImpl@6328e0
DBDataSetImpl.m_dynamic=false
DBDataSetImpl.m_arrayDepth=1 (valid only when m_dynamic=false)
DBDataSetImpl.m_dataSetType=2
DBDataSetImpl.m_noOfArgs=1
DBDataSetImpl.types.length=1
types[0].type= VARNUM (max_length=22)
DBDataSetImpl.data.length=1
data[0].items[0] has 0 bytes:
data[0].items[0] has 22 bytes allocated
DBDataSetImpl.m_last_bind_values has size of 1
DBDataSetImpl.m_tmp_first_row_items is null
DBDataSetImpl.m_tmp_first_row_types is null
DRVR FUNC OracleStatement.executeNonQuery(batchForPlsql=false)
DBAC FUNC DBDataSetImpl.isStreamType(index= 0)
DRVR DBG1 After execute: valid_rows=1
DRVR DBG2 binds_out: oracle.jdbc.dbaccess.DBDataSetImpl@6328e0
DBDataSetImpl.m_dynamic=false
DBDataSetImpl.m_arrayDepth=1 (valid only when m_dynamic=false)
DBDataSetImpl.m_dataSetType=2
DBDataSetImpl.m_noOfArgs=1
DBDataSetImpl.types.length=1
types[0].type= VARNUM (max_length=22)
DBDataSetImpl.data.length=1
data[0].items[0] has 3 bytes:
data[0].items[0] has 22 bytes allocated
c2 09 1b DBDataSetImpl.m_last_bind_values has size of 1
DBDataSetImpl.m_tmp_first_row_items is null
DBDataSetImpl.m_tmp_first_row_types is null
DRVR FUNC OracleStatement.cleanupForBatching()
DRVR DBG1 End of doExecuteWithTimeout(): m_currentRank=0
DRVR FUNC OracleStatement.getLongValue(getColumn=false, index=1)
DRVR FUNC OracleStatement.getBytesInternal(getColumn=false, index=1)
DBAC FUNC DBDataSetImpl.isStreamType(index= 0)
DRVR OPER OraclePreparedStatement.close()
DRVR OPER OracleCallableStatement.sendBatch()
DRVR OPER OracleStatement.close()
DBAC FUNC DBDataSetImpl.cleanup()
m_dataSetType= 0
DBAC FUNC DBDataSetImpl.cleanTypes()
m_dataSetType= 0
DBAC FUNC DBDataSetImpl.cleanData()
m_dataSetType= 0
DRVR FUNC OracleConnection.prepareCall(sql)
DRVR DBG1 SQL: "begin dbms_lob.read (?, ?, ?, ?); end;"
DRVR FUNC OracleStatement.OracleStatement(conn, batchValue=1,
rowPrefetchValue=10)
DBAC FUNC DBDataSetImpl.DBDataSetImpl(conn, nrows=0 ,dataSetType= 0)
DRVR FUNC OraclePreparedStatement.OraclePreparedStatement(conn, sql,
batchValue, rowPrefetchValue)
DBAC FUNC DBDataSetImpl.DBDataSetImpl(conn, nrows=1 ,dataSetType= 1)
DRVR FUNC OracleConnection.nativeSQL(sql)
DRVR DBG1 Input SQL: "begin dbms_lob.read (?, ?, ?, ?); end;"
DRVR DBG1 Output SQL: "begin dbms_lob.read (:1, :2, :3, :4); end;"
DBCV FUNC DBConversion.StringToCharBytes(str)
DBCV FUNC DBConversion.stringToAcessCharBytes(str, charset=31)
DBCV DBG2 UCS-2 bytes (84 bytes):
00 62 00 65 00 67 00 69 00 6e 00 20 00 64 00 62 00 6d 00 73
00 5f 00 6c 00 6f 00 62 00 2e 00 72 00 65 00 61 00 64 00 20
00 28 00 3a 00 31 00 2c 00 20 00 3a 00 32 00 2c 00 20 00 3a
00 33 00 2c 00 20 00 3a 00 34 00 29 00 3b 00 20 00 65 00 6e
00 64 00 3b
DBCV FUNC DBConversion.stringToAsciiBytes(str)
DBCV DBG2 DBAccess bytes (42 bytes):
62 65 67 69 6e 20 64 62 6d 73 5f 6c 6f 62 2e 72 65 61 64 20
28 3a 31 2c 20 3a 32 2c 20 3a 33 2c 20 3a 34 29 3b 20 65 6e
64 3b
DRVR FUNC OracleCallableStatement.OracleCallableStatement(conn, sql,
batchValue, rowPrefetchValue) returned
DRVR FUNC OracleConnection.nativeSQL(sql)
DRVR DBG1 Input SQL: "begin dbms_lob.read (?, ?, ?, ?); end;"
DRVR DBG1 Output SQL: "begin dbms_lob.read (:1, :2, :3, :4); end;"
DBCV FUNC DBConversion.StringToCharBytes(str)
DBCV FUNC DBConversion.stringToAcessCharBytes(str, charset=31)
DBCV DBG2 UCS-2 bytes (84 bytes):
00 62 00 65 00 67 00 69 00 6e 00 20 00 64 00 62 00 6d 00 73
00 5f 00 6c 00 6f 00 62 00 2e 00 72 00 65 00 61 00 64 00 20
00 28 00 3a 00 31 00 2c 00 20 00 3a 00 32 00 2c 00 20 00 3a
00 33 00 2c 00 20 00 3a 00 34 00 29 00 3b 00 20 00 65 00 6e
00 64 00 3b
DBCV FUNC DBConversion.stringToAsciiBytes(str)
DBCV DBG2 DBAccess bytes (42 bytes):
62 65 67 69 6e 20 64 62 6d 73 5f 6c 6f 62 2e 72 65 61 64 20
28 3a 31 2c 20 3a 32 2c 20 3a 33 2c 20 3a 34 29 3b 20 65 6e
64 3b
DBAC FUNC DBDataSetImpl.DBDataSetImpl(conn, nrows=1 ,dataSetType= 2)
DRVR OPER OraclePreparedStatement.setObject(paramIndex=1, object,
targetSqlType=2004, scale=0)
DRVR OPER OraclePreparedStatement.setBLOB(paramIndex=1, lob)
DRVR FUNC OraclePreparedStatement.setDatum(index=0, type=113, datum)
DRVR FUNC OraclePreparedStatement.setItem(index=0, type=113, array)
DBAC FUNC DBDataSetImpl._createOrGetBindDBType(index= 0, type= 113)
DBAC FUNC DBDataSetImpl._alloc_tmp_binds(index=0 isInBind=true)
DRVR OPER OracleCallableStatement.registerOutParameter(paramIndex=2,
sqlType=2, scale=0, maxLength=-1)
DBAC FUNC DBDataSetImpl.setTypes(index= 1 ,internalType= 6 , externalType= 0
,maxLength= 0)
m_dataSetType= 2
DBAC FUNC DBDataSetImpl._createOrGetBindDBType(index= 1, type= 6)
DBAC FUNC DBDataSetImpl._alloc_tmp_binds(index=1 isInBind=true)
DRVR OPER OracleCallableStatement.registerOutParameter(paramIndex=4,
sqlType=-3, scale=0, maxLength=-1)
DBAC FUNC DBDataSetImpl.setTypes(index= 3 ,internalType= 23 , externalType=
0 ,maxLength= 0)
m_dataSetType= 2
DBAC FUNC DBDataSetImpl._createOrGetBindDBType(index= 3, type= 23)
DBAC FUNC DBDataSetImpl._alloc_tmp_binds(index=3 isInBind=true)
DRVR OPER OraclePreparedStatement.setInt(paramIndex=2, x=826)
DRVR FUNC OraclePreparedStatement.setItem(index=1, type=6, array)
DBAC FUNC DBDataSetImpl._createOrGetBindDBType(index= 1, type= 6)
DBAC FUNC DBDataSetImpl._alloc_tmp_binds(index=1 isInBind=true)
DRVR OPER OraclePreparedStatement.setInt(paramIndex=3, x=1)
DRVR FUNC OraclePreparedStatement.setItem(index=2, type=6, array)
DBAC FUNC DBDataSetImpl._createOrGetBindDBType(index= 2, type= 6)
DBAC FUNC DBDataSetImpl._alloc_tmp_binds(index=2 isInBind=true)
DRVR OPER OraclePreparedStatement.execute()
DRVR OPER OraclePreparedStatement.executeUpdate()
DRVR FUNC OraclePreparedStatement.get_data_for_columns()
DBAC FUNC DBDataSetImpl.rowCompleted()
DBAC FUNC DBDataSetImpl._bindRowCompleted(rank= 0)
DBAC FUNC DBDataSetImpl._bindRowCompleted m_dataSetType is 1 ,m_noOfArgs is
3 m_first_row is true m_cleanedData is false
DBAC FUNC DBData.DBData(nItems=1)
DBAC FUNC DBData.DBData(nItems=1)
DBAC FUNC DBData.DBData(nItems=1)
DBAC FUNC DBDataSetImpl.rowCompleted()
DBAC FUNC DBDataSetImpl._bindRowCompleted(rank= 0)
DBAC FUNC DBDataSetImpl._bindRowCompleted m_dataSetType is 2 ,m_noOfArgs is
4 m_first_row is true m_cleanedData is false
DBAC FUNC DBData.DBData(nItems=1)
DBAC FUNC DBData.DBData(nItems=1)
DRVR FUNC OracleStatement.doExecuteWithTimeout()
DRVR FUNC OracleStatement.doExecuteOther(batchForPlsql=false)
DRVR DBG1 Before execute: m_currentRank=1, sql_kind=1, need_to_parse=true
DRVR DBG2 binds_in: oracle.jdbc.dbaccess.DBDataSetImpl@49d886
DBDataSetImpl.m_dynamic=false
DBDataSetImpl.m_arrayDepth=1 (valid only when m_dynamic=false)
DBDataSetImpl.m_dataSetType=1
DBDataSetImpl.m_noOfArgs=3
DBDataSetImpl.types.length=3
types[0].type= BLOB (max_length=86)
types[1].type= VARNUM (max_length=22)
types[2].type= VARNUM (max_length=22)
DBDataSetImpl.data.length=3
data[0].items[0] has 86 bytes:
data[0].items[0] has 86 bytes allocated
00 54 00 01 01 0c 00 00 00 01 00 00 00 01 00 00 00 00 10 39
00 00 0f 2f 00 00 0f 2e 00 09 00 09 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 10 c6 3f 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 0f 2e
00 40 2d 8c 00 04
data[1].items[0] has 3 bytes:
data[1].items[0] has 3 bytes allocated
c2 09 1b
data[2].items[0] has 2 bytes:
data[2].items[0] has 2 bytes allocated
c1 02 DBDataSetImpl.m_last_bind_values has size of 3
DBDataSetImpl.m_tmp_first_row_items is null
DBDataSetImpl.m_tmp_first_row_types is null
DRVR DBG2 binds_out: oracle.jdbc.dbaccess.DBDataSetImpl@267649
DBDataSetImpl.m_dynamic=false
DBDataSetImpl.m_arrayDepth=1 (valid only when m_dynamic=false)
DBDataSetImpl.m_dataSetType=2
DBDataSetImpl.m_noOfArgs=4
DBDataSetImpl.types.length=4
types[0]=null
types[1].type= VARNUM (max_length=22)
types[2]=null
types[3].type= RAW (max_length=32767)
DBDataSetImpl.data.length=4
data[0]=null
data[1].items[0] has 0 bytes:
data[1].items[0] has 22 bytes allocated
data[2]=null
data[3].items[0] has 0 bytes:
data[3].items[0] has 32767 bytes allocated
DBDataSetImpl.m_last_bind_values has size of 4
DBDataSetImpl.m_tmp_first_row_items is null
DBDataSetImpl.m_tmp_first_row_types is null
DRVR FUNC OracleStatement.executeNonQuery(batchForPlsql=false)
DBAC FUNC DBDataSetImpl.isStreamType(index= 0)
DBAC FUNC DBDataSetImpl.isStreamType(index= 1)
DBAC FUNC DBDataSetImpl.isStreamType(index= 2)
DBAC FUNC DBDataSetImpl.isStreamType(index= 3)
DRVR DBG1 After execute: valid_rows=1
DRVR DBG2 binds_out: oracle.jdbc.dbaccess.DBDataSetImpl@267649
DBDataSetImpl.m_dynamic=false
DBDataSetImpl.m_arrayDepth=1 (valid only when m_dynamic=false)
DBDataSetImpl.m_dataSetType=2
DBDataSetImpl.m_noOfArgs=4
DBDataSetImpl.types.length=4
types[0]=null
types[1].type= VARNUM (max_length=22)
types[2]=null
types[3].type= RAW (max_length=32767)
DBDataSetImpl.data.length=4
data[0]=null
data[1].items[0] has 3 bytes:
data[1].items[0] has 22 bytes allocated
c2 09 1b
data[2]=null
data[3].items[0] has 826 bytes:
data[3].items[0] has 32767 bytes allocated
52 65 74 75 72 6e 2d 50 61 74 68 3a 20 3c 6d 6f 6e 69 63 61
40 73 65 63 65 6d 61 69 6c 2e 64 6e 73 61 6c 69 61 73 2e 63
6f 6d 3e 0d 0a 52 65 63 65 69 76 65 64 3a 20 66 72 6f 6d 20
72 68 65 6e 69 75 6d 2e 62 74 69 6e 74 65 72 6e 65 74 2e 63
6f 6d 20 28 5b 31 39 34 2e 37 33 2e 37 33 2e 39 33 5d 29 0d
0a 20 20 20 20 20 20 20 20 20 20 62 79 20 73 65 63 65 6d 61
69 6c 2e 64 6e 73 61 6c 69 61 73 2e 63 6f 6d 20 28 4a 41 4d
45 53 20 53 4d 54 50 20 53 65 72 76 65 72 20 32 2e 30 61 32
29 20 77 69 74 68 20 53 4d 54 50 20 49 44 20 36 33 36 0d 0a
20 20 20 20 20 20 20 20 20 20 66 6f 72 20 3c 73 61 6d 75 65
... last 626 bytes were not printed to limit the output size
DBDataSetImpl.m_last_bind_values has size of 4
DBDataSetImpl.m_tmp_first_row_items is null
DBDataSetImpl.m_tmp_first_row_types is null
DRVR FUNC OracleStatement.cleanupForBatching()
DRVR DBG1 End of doExecuteWithTimeout(): m_currentRank=0
DRVR FUNC OracleStatement.getLongValue(getColumn=false, index=2)
DRVR FUNC OracleStatement.getBytesInternal(getColumn=false, index=2)
DBAC FUNC DBDataSetImpl.isStreamType(index= 1)
DRVR FUNC OracleStatement.getBytesValue(getColumn=false, index=4)
DRVR FUNC OracleStatement.getBytesInternal(getColumn=false, index=4)
DBAC FUNC DBDataSetImpl.isStreamType(index= 3)
DRVR OPER OraclePreparedStatement.close()
DRVR OPER OracleCallableStatement.sendBatch()
DRVR OPER OracleStatement.close()
DBAC FUNC DBDataSetImpl.cleanup()
m_dataSetType= 0
DBAC FUNC DBDataSetImpl.cleanTypes()
m_dataSetType= 0
DBAC FUNC DBDataSetImpl.cleanData()
m_dataSetType= 0
DRVR FUNC OracleResultSetImpl.internal_close()
DRVR FUNC OracleResultSetImpl.internal_close()
DRVR OPER OraclePreparedStatement.close()
DRVR OPER OraclePreparedStatement.sendBatch()
DRVR DBG1 Send batch: batch=1, m_currentRank=0
DRVR OPER OracleStatement.close()
DBAC FUNC DBDataSetImpl.cleanup()
m_dataSetType= 0
DBAC FUNC DBDataSetImpl.cleanTypes()
m_dataSetType= 0
DBAC FUNC DBDataSetImpl.cleanData()
m_dataSetType= 0
DBAC FUNC DBData.cleanup()
DRVR OPER OracleConnection.getWarnings()
DRVR OPER OracleConnection.clearWarnings()
DRVR FUNC OracleConnection.isClosed() returned false
DRVR OPER OracleConnection.getWarnings()
DRVR OPER OracleConnection.clearWarnings()
DRVR OPER OracleConnection.prepareStatement(sql)
DRVR DBG1 SQL: "SELECT message_name, message_state, last_updated FROM
message WHERE repository_name = ? ORDER BY last_updated ASC"
DRVR FUNC OracleStatement.OracleStatement(conn, batchValue=1,
rowPrefetchValue=10)
DBAC FUNC DBDataSetImpl.DBDataSetImpl(conn, nrows=0 ,dataSetType= 0)
DRVR FUNC OraclePreparedStatement.OraclePreparedStatement(conn, sql,
batchValue, rowPrefetchValue)
DBAC FUNC DBDataSetImpl.DBDataSetImpl(conn, nrows=1 ,dataSetType= 1)
DRVR FUNC OracleConnection.nativeSQL(sql)
DRVR DBG1 Input SQL: "SELECT message_name, message_state, last_updated FROM
message WHERE repository_name = ? ORDER BY last_updated ASC"
DRVR DBG1 Output SQL: "SELECT message_name, message_state, last_updated FROM
message WHERE repository_name = :1 ORDER BY last_updated ASC"
DBCV FUNC DBConversion.StringToCharBytes(str)
DBCV FUNC DBConversion.stringToAcessCharBytes(str, charset=31)
DBCV DBG2 UCS-2 bytes (228 bytes):
00 53 00 45 00 4c 00 45 00 43 00 54 00 20 00 6d 00 65 00 73
00 73 00 61 00 67 00 65 00 5f 00 6e 00 61 00 6d 00 65 00 2c
00 20 00 6d 00 65 00 73 00 73 00 61 00 67 00 65 00 5f 00 73
00 74 00 61 00 74 00 65 00 2c 00 20 00 6c 00 61 00 73 00 74
00 5f 00 75 00 70 00 64 00 61 00 74 00 65 00 64 00 20 00 46
00 52 00 4f 00 4d 00 20 00 6d 00 65 00 73 00 73 00 61 00 67
00 65 00 20 00 57 00 48 00 45 00 52 00 45 00 20 00 72 00 65
00 70 00 6f 00 73 00 69 00 74 00 6f 00 72 00 79 00 5f 00 6e
00 61 00 6d 00 65 00 20 00 3d 00 20 00 3a 00 31 00 20 00 4f
00 52 00 44 00 45 00 52 00 20 00 42 00 59 00 20 00 6c 00 61
... last 28 bytes were not printed to limit the output size
DBCV FUNC DBConversion.stringToAsciiBytes(str)
DBCV DBG2 DBAccess bytes (114 bytes):
53 45 4c 45 43 54 20 6d 65 73 73 61 67 65 5f 6e 61 6d 65 2c
20 6d 65 73 73 61 67 65 5f 73 74 61 74 65 2c 20 6c 61 73 74
5f 75 70 64 61 74 65 64 20 46 52 4f 4d 20 6d 65 73 73 61 67
65 20 57 48 45 52 45 20 72 65 70 6f 73 69 74 6f 72 79 5f 6e
61 6d 65 20 3d 20 3a 31 20 4f 52 44 45 52 20 42 59 20 6c 61
73 74 5f 75 70 64 61 74 65 64 20 41 53 43
DRVR OPER OraclePreparedStatement.setString(paramIndex=1, x=spool)
DBCV FUNC DBConversion.StringToCharBytes(str)
DBCV FUNC DBConversion.stringToAcessCharBytes(str, charset=31)
DBCV DBG2 UCS-2 bytes (10 bytes):
00 73 00 70 00 6f 00 6f 00 6c
DBCV FUNC DBConversion.stringToAsciiBytes(str)
DBCV DBG2 DBAccess bytes (5 bytes):
73 70 6f 6f 6c
DRVR FUNC OraclePreparedStatement.setItem(index=0, type=1, array)
DBAC FUNC DBDataSetImpl._createOrGetBindDBType(index= 0, type= 1)
DBAC FUNC DBDataSetImpl._alloc_tmp_binds(index=0 isInBind=true)
DRVR OPER OraclePreparedStatement.executeQuery()
DRVR OPER OraclePreparedStatement.executeUpdate()
DRVR FUNC OraclePreparedStatement.get_data_for_columns()
DBAC FUNC DBDataSetImpl.rowCompleted()
DBAC FUNC DBDataSetImpl._bindRowCompleted(rank= 0)
DBAC FUNC DBDataSetImpl._bindRowCompleted m_dataSetType is 1 ,m_noOfArgs is
1 m_first_row is true m_cleanedData is false
DBAC FUNC DBData.DBData(nItems=1)
DRVR FUNC OracleStatement.doExecuteWithTimeout()
DRVR FUNC OracleStatement.doExecuteQuery()
DRVR DBG1 Before query: sql_kind=0, row_prefetch=10, need_to_parse=true,
need_to_prepare_define_buffer=true, columns_defined_by_user=false
DRVR DBG2 array_sql:
53 45 4c 45 43 54 20 6d 65 73 73 61 67 65 5f 6e 61 6d 65 2c
20 6d 65 73 73 61 67 65 5f 73 74 61 74 65 2c 20 6c 61 73 74
5f 75 70 64 61 74 65 64 20 46 52 4f 4d 20 6d 65 73 73 61 67
65 20 57 48 45 52 45 20 72 65 70 6f 73 69 74 6f 72 79 5f 6e
61 6d 65 20 3d 20 3a 31 20 4f 52 44 45 52 20 42 59 20 6c 61
73 74 5f 75 70 64 61 74 65 64 20 41 53 43
DRVR DBG2 binds_in: oracle.jdbc.dbaccess.DBDataSetImpl@6fa9fc
DBDataSetImpl.m_dynamic=false
DBDataSetImpl.m_arrayDepth=1 (valid only when m_dynamic=false)
DBDataSetImpl.m_dataSetType=1
DBDataSetImpl.m_noOfArgs=1
DBDataSetImpl.types.length=1
types[0].type= VARCHAR (max_length=4000)
DBDataSetImpl.data.length=1
data[0].items[0] has 5 bytes:
data[0].items[0] has 5 bytes allocated
73 70 6f 6f 6c DBDataSetImpl.m_last_bind_values has size of 1
DBDataSetImpl.m_tmp_first_row_items is null
DBDataSetImpl.m_tmp_first_row_types is null
DRVR DBG2 defines: oracle.jdbc.dbaccess.DBDataSetImpl@ebec
DBDataSetImpl.m_dynamic=false
DBDataSetImpl.m_arrayDepth=0 (valid only when m_dynamic=false)
DBDataSetImpl.m_dataSetType=0
DBDataSetImpl.m_noOfArgs=0
DBDataSetImpl.types is null
DBDataSetImpl.data is null DBDataSetImpl.m_last_bind_values is null
DBDataSetImpl.m_tmp_first_row_items is null
DBDataSetImpl.m_tmp_first_row_types is null
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=0)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=0, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 4d
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=0, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 4d
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=1)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=1, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 45
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=1, chars[],
charIndex=1)
DBCV DBG2 DBAccess byte: 45
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=2)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=2, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 53
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=2, chars[],
charIndex=2)
DBCV DBG2 DBAccess byte: 53
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=3)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=3, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 53
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=3, chars[],
charIndex=3)
DBCV DBG2 DBAccess byte: 53
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=4)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=4, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 41
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=4, chars[],
charIndex=4)
DBCV DBG2 DBAccess byte: 41
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=5)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=5, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 47
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=5, chars[],
charIndex=5)
DBCV DBG2 DBAccess byte: 47
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=6)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=6, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 45
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=6, chars[],
charIndex=6)
DBCV DBG2 DBAccess byte: 45
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=7)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=7, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 5f
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=7, chars[],
charIndex=7)
DBCV DBG2 DBAccess byte: 5f
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=8)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=8, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 4e
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=8, chars[],
charIndex=8)
DBCV DBG2 DBAccess byte: 4e
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=9)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=9, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 41
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=9, chars[],
charIndex=9)
DBCV DBG2 DBAccess byte: 41
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=10)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=10, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 4d
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=10, chars[],
charIndex=10)
DBCV DBG2 DBAccess byte: 4d
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=11)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=11, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 45
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=11, chars[],
charIndex=11)
DBCV DBG2 DBAccess byte: 45
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=0)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=0, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 4d
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=0, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 4d
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=1)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=1, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 45
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=1, chars[],
charIndex=1)
DBCV DBG2 DBAccess byte: 45
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=2)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=2, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 53
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=2, chars[],
charIndex=2)
DBCV DBG2 DBAccess byte: 53
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=3)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=3, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 53
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=3, chars[],
charIndex=3)
DBCV DBG2 DBAccess byte: 53
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=4)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=4, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 41
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=4, chars[],
charIndex=4)
DBCV DBG2 DBAccess byte: 41
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=5)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=5, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 47
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=5, chars[],
charIndex=5)
DBCV DBG2 DBAccess byte: 47
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=6)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=6, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 45
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=6, chars[],
charIndex=6)
DBCV DBG2 DBAccess byte: 45
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=7)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=7, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 5f
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=7, chars[],
charIndex=7)
DBCV DBG2 DBAccess byte: 5f
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=8)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=8, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 53
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=8, chars[],
charIndex=8)
DBCV DBG2 DBAccess byte: 53
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=9)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=9, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 54
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=9, chars[],
charIndex=9)
DBCV DBG2 DBAccess byte: 54
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=10)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=10, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 41
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=10, chars[],
charIndex=10)
DBCV DBG2 DBAccess byte: 41
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=11)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=11, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 54
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=11, chars[],
charIndex=11)
DBCV DBG2 DBAccess byte: 54
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=12)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=12, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 45
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=12, chars[],
charIndex=12)
DBCV DBG2 DBAccess byte: 45
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=0)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=0, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 4c
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=0, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 4c
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=1)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=1, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 41
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=1, chars[],
charIndex=1)
DBCV DBG2 DBAccess byte: 41
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=2)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=2, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 53
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=2, chars[],
charIndex=2)
DBCV DBG2 DBAccess byte: 53
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=3)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=3, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 54
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=3, chars[],
charIndex=3)
DBCV DBG2 DBAccess byte: 54
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=4)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=4, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 5f
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=4, chars[],
charIndex=4)
DBCV DBG2 DBAccess byte: 5f
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=5)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=5, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 55
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=5, chars[],
charIndex=5)
DBCV DBG2 DBAccess byte: 55
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=6)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=6, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 50
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=6, chars[],
charIndex=6)
DBCV DBG2 DBAccess byte: 50
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=7)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=7, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 44
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=7, chars[],
charIndex=7)
DBCV DBG2 DBAccess byte: 44
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=8)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=8, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 41
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=8, chars[],
charIndex=8)
DBCV DBG2 DBAccess byte: 41
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=9)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=9, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 54
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=9, chars[],
charIndex=9)
DBCV DBG2 DBAccess byte: 54
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=10)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=10, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 45
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=10, chars[],
charIndex=10)
DBCV DBG2 DBAccess byte: 45
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=11)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=11, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 44
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=11, chars[],
charIndex=11)
DBCV DBG2 DBAccess byte: 44
DBCV DBG2 UCS-2 character byte: 00
PIKL DBG1 OracleTypeADT (., null)
PIKL DBG1 OracleTypeADT ([B@f96c, 0, 31, 1, .)
PIKL DBG1 OracleTypeADT (., null)
PIKL DBG1 OracleTypeADT ([B@7736bd, 0, 31, 1, .)
PIKL DBG1 OracleTypeADT (., null)
PIKL DBG1 OracleTypeADT ([B@2adc97, 0, 0, 0, .)
DBAC FUNC DBDataSetImpl.setNoOfDefineCol(noOfArgs= 3)
DBAC FUNC DBDataSetImpl.setTypes(index= 0 ,internalType= 1 , externalType= 0
,maxLength= 200)
m_dataSetType= 0
DBAC FUNC DBDataSetImpl.setTypes(index= 1 ,internalType= 1 , externalType= 0
,maxLength= 30)
m_dataSetType= 0
DBAC FUNC DBDataSetImpl.setTypes(index= 2 ,internalType= 12 , externalType=
0 ,maxLength= 0)
m_dataSetType= 0
DBAC FUNC DBDataSetImpl.hasStreamType()
DBAC FUNC DBDataSetImpl.setBatchSize(newBatchSize=10)
DBAC DBG1 DBDataSetImpl.setBatchSize: original batch size was 0, dataset
was=
oracle.jdbc.dbaccess.DBDataSetImpl@ebec
DBDataSetImpl.m_dynamic=false
DBDataSetImpl.m_arrayDepth=0 (valid only when m_dynamic=false)
DBDataSetImpl.m_dataSetType=0
DBDataSetImpl.m_noOfArgs=3
DBDataSetImpl.types.length=3
types[0].type= VARCHAR (max_length=200)
types[1].type= VARCHAR (max_length=30)
types[2].type= DATE (max_length=7)
DBDataSetImpl.data is null DBDataSetImpl.m_last_bind_values is null
DBDataSetImpl.m_tmp_first_row_items is null
DBDataSetImpl.m_tmp_first_row_types is null
DBAC FUNC DBDataSetImpl.hasStreamType()
DBAC FUNC DBDataSetImpl.setBatchSize(newBatchSize=10)
DBAC DBG1 DBDataSetImpl.setBatchSize: original batch size was 10, dataset
was=
oracle.jdbc.dbaccess.DBDataSetImpl@ebec
DBDataSetImpl.m_dynamic=false
DBDataSetImpl.m_arrayDepth=10 (valid only when m_dynamic=false)
DBDataSetImpl.m_dataSetType=0
DBDataSetImpl.m_noOfArgs=3
DBDataSetImpl.types.length=3
types[0].type= VARCHAR (max_length=200)
types[1].type= VARCHAR (max_length=30)
types[2].type= DATE (max_length=7)
DBDataSetImpl.data is null DBDataSetImpl.m_last_bind_values is null
DBDataSetImpl.m_tmp_first_row_items is null
DBDataSetImpl.m_tmp_first_row_types is null
DBAC FUNC DBDataSetImpl.rowCompleted()
DBAC FUNC DBDataSetImpl._definesRowCompleted()
DBAC DBG1 DBDataSetImpl._definesRowCompleted m_noOfArgs= 3
DBAC FUNC DBData.DBData(nItems=10)
DBAC FUNC DBData.DBData(nItems=10)
DBAC FUNC DBData.DBData(nItems=10)
DBAC FUNC DBDataSetImpl._setRowItems(colIndex= 0, item=
oracle.jdbc.ttc7.TTCItem@78460d)
DBAC FUNC DBDataSetImpl._setRowItems(colIndex= 1, item=
oracle.jdbc.ttc7.TTCItem@3f210f)
DBAC FUNC DBDataSetImpl._setRowItems(colIndex= 2, item=
oracle.jdbc.ttc7.TTCItem@138039)
DBAC FUNC DBDataSetImpl.isStreamType(index= 0)
DBAC FUNC DBDataSetImpl.isStreamType(index= 1)
DBAC FUNC DBDataSetImpl.isStreamType(index= 2)
DRVR DBG1 After execute: valid_rows=0
DRVR DBG2 defines: oracle.jdbc.dbaccess.DBDataSetImpl@ebec
DBDataSetImpl.m_dynamic=false
DBDataSetImpl.m_arrayDepth=10 (valid only when m_dynamic=false)
DBDataSetImpl.m_dataSetType=0
DBDataSetImpl.m_noOfArgs=3
DBDataSetImpl.types.length=3
types[0].type= VARCHAR (max_length=200)
types[1].type= VARCHAR (max_length=30)
types[2].type= DATE (max_length=7)
DBDataSetImpl.data.length=3
data[0].items[0] has 0 bytes:
data[0].items[0] has 200 bytes allocated
data[0].items[1] has 0 bytes:
data[0].items[1] has 200 bytes allocated
data[0].items[2] has 0 bytes:
data[0].items[2] has 200 bytes allocated
data[0].items[3] has 0 bytes:
data[0].items[3] has 200 bytes allocated
data[0].items[4] has 0 bytes:
data[0].items[4] has 200 bytes allocated
data[0].items[5] has 0 bytes:
data[0].items[5] has 200 bytes allocated
data[0].items[6] has 0 bytes:
data[0].items[6] has 200 bytes allocated
data[0].items[7] has 0 bytes:
data[0].items[7] has 200 bytes allocated
data[0].items[8] has 0 bytes:
data[0].items[8] has 200 bytes allocated
data[0].items[9] has 0 bytes:
data[0].items[9] has 200 bytes allocated
data[1].items[0] has 0 bytes:
data[1].items[0] has 30 bytes allocated
data[1].items[1] has 0 bytes:
data[1].items[1] has 30 bytes allocated
data[1].items[2] has 0 bytes:
data[1].items[2] has 30 bytes allocated
data[1].items[3] has 0 bytes:
data[1].items[3] has 30 bytes allocated
data[1].items[4] has 0 bytes:
data[1].items[4] has 30 bytes allocated
data[1].items[5] has 0 bytes:
data[1].items[5] has 30 bytes allocated
data[1].items[6] has 0 bytes:
data[1].items[6] has 30 bytes allocated
data[1].items[7] has 0 bytes:
data[1].items[7] has 30 bytes allocated
data[1].items[8] has 0 bytes:
data[1].items[8] has 30 bytes allocated
data[1].items[9] has 0 bytes:
data[1].items[9] has 30 bytes allocated
data[2].items[0] has 0 bytes:
data[2].items[0] has 7 bytes allocated
data[2].items[1] has 0 bytes:
data[2].items[1] has 7 bytes allocated
data[2].items[2] has 0 bytes:
data[2].items[2] has 7 bytes allocated
data[2].items[3] has 0 bytes:
data[2].items[3] has 7 bytes allocated
data[2].items[4] has 0 bytes:
data[2].items[4] has 7 bytes allocated
data[2].items[5] has 0 bytes:
data[2].items[5] has 7 bytes allocated
data[2].items[6] has 0 bytes:
data[2].items[6] has 7 bytes allocated
data[2].items[7] has 0 bytes:
data[2].items[7] has 7 bytes allocated
data[2].items[8] has 0 bytes:
data[2].items[8] has 7 bytes allocated
data[2].items[9] has 0 bytes:
data[2].items[9] has 7 bytes allocated
DBDataSetImpl.m_last_bind_values is null
DBDataSetImpl.m_tmp_first_row_items is null
DBDataSetImpl.m_tmp_first_row_types is null
DRVR FUNC OracleResultSetImpl.next(): closed=false
DRVR DBG1 closed=false, statement.current_row=-1,
statement.total_rows_visited=0, statement.max_rows=0,
statement.valid_rows=0, statement.got_last_batch=true
DRVR FUNC OracleResultSetImpl.internal_close()
DRVR FUNC OracleResultSetImpl.internal_close()
DRVR FUNC OracleResultSetImpl.internal_close()
DRVR OPER OraclePreparedStatement.close()
DRVR OPER OraclePreparedStatement.sendBatch()
DRVR DBG1 Send batch: batch=1, m_currentRank=0
DRVR OPER OracleStatement.close()
DBAC FUNC DBDataSetImpl.cleanup()
m_dataSetType= 0
DBAC FUNC DBDataSetImpl.cleanTypes()
m_dataSetType= 0
DBAC FUNC DBDataSetImpl.cleanData()
m_dataSetType= 0
DBAC FUNC DBData.cleanup()
DBAC FUNC DBData.cleanup()
DBAC FUNC DBData.cleanup()
DRVR OPER OracleConnection.getWarnings()
DRVR OPER OracleConnection.clearWarnings()
DRVR FUNC OracleConnection.isClosed() returned false
DRVR OPER OracleConnection.getWarnings()
DRVR OPER OracleConnection.clearWarnings()
DRVR OPER OracleConnection.setAutoCommit(autoCommit=false)
DRVR OPER OracleConnection.prepareStatement(sql)
DRVR DBG1 SQL: "SELECT count(*) FROM message WHERE message_name = ? AND
repository_name = ?"
DRVR FUNC OracleStatement.OracleStatement(conn, batchValue=1,
rowPrefetchValue=10)
DBAC FUNC DBDataSetImpl.DBDataSetImpl(conn, nrows=0 ,dataSetType= 0)
DRVR FUNC OraclePreparedStatement.OraclePreparedStatement(conn, sql,
batchValue, rowPrefetchValue)
DBAC FUNC DBDataSetImpl.DBDataSetImpl(conn, nrows=1 ,dataSetType= 1)
DRVR FUNC OracleConnection.nativeSQL(sql)
DRVR DBG1 Input SQL: "SELECT count(*) FROM message WHERE message_name = ?
AND repository_name = ?"
DRVR DBG1 Output SQL: "SELECT count(*) FROM message WHERE message_name = :1
AND repository_name = :2"
DBCV FUNC DBConversion.StringToCharBytes(str)
DBCV FUNC DBConversion.stringToAcessCharBytes(str, charset=31)
DBCV DBG2 UCS-2 bytes (154 bytes):
00 53 00 45 00 4c 00 45 00 43 00 54 00 20 00 63 00 6f 00 75
00 6e 00 74 00 28 00 2a 00 29 00 20 00 46 00 52 00 4f 00 4d
00 20 00 6d 00 65 00 73 00 73 00 61 00 67 00 65 00 20 00 57
00 48 00 45 00 52 00 45 00 20 00 6d 00 65 00 73 00 73 00 61
00 67 00 65 00 5f 00 6e 00 61 00 6d 00 65 00 20 00 3d 00 20
00 3a 00 31 00 20 00 41 00 4e 00 44 00 20 00 72 00 65 00 70
00 6f 00 73 00 69 00 74 00 6f 00 72 00 79 00 5f 00 6e 00 61
00 6d 00 65 00 20 00 3d 00 20 00 3a 00 32
DBCV FUNC DBConversion.stringToAsciiBytes(str)
DBCV DBG2 DBAccess bytes (77 bytes):
53 45 4c 45 43 54 20 63 6f 75 6e 74 28 2a 29 20 46 52 4f 4d
20 6d 65 73 73 61 67 65 20 57 48 45 52 45 20 6d 65 73 73 61
67 65 5f 6e 61 6d 65 20 3d 20 3a 31 20 41 4e 44 20 72 65 70
6f 73 69 74 6f 72 79 5f 6e 61 6d 65 20 3d 20 3a 32
DRVR OPER OraclePreparedStatement.setString(paramIndex=1,
x=Mail1014737867984-0)
DBCV FUNC DBConversion.StringToCharBytes(str)
DBCV FUNC DBConversion.stringToAcessCharBytes(str, charset=31)
DBCV DBG2 UCS-2 bytes (38 bytes):
00 4d 00 61 00 69 00 6c 00 31 00 30 00 31 00 34 00 37 00 33
00 37 00 38 00 36 00 37 00 39 00 38 00 34 00 2d 00 30
DBCV FUNC DBConversion.stringToAsciiBytes(str)
DBCV DBG2 DBAccess bytes (19 bytes):
4d 61 69 6c 31 30 31 34 37 33 37 38 36 37 39 38 34 2d 30
DRVR FUNC OraclePreparedStatement.setItem(index=0, type=1, array)
DBAC FUNC DBDataSetImpl._createOrGetBindDBType(index= 0, type= 1)
DBAC FUNC DBDataSetImpl._alloc_tmp_binds(index=0 isInBind=true)
DRVR OPER OraclePreparedStatement.setString(paramIndex=2, x=spool)
DBCV FUNC DBConversion.StringToCharBytes(str)
DBCV FUNC DBConversion.stringToAcessCharBytes(str, charset=31)
DBCV DBG2 UCS-2 bytes (10 bytes):
00 73 00 70 00 6f 00 6f 00 6c
DBCV FUNC DBConversion.stringToAsciiBytes(str)
DBCV DBG2 DBAccess bytes (5 bytes):
73 70 6f 6f 6c
DRVR FUNC OraclePreparedStatement.setItem(index=1, type=1, array)
DBAC FUNC DBDataSetImpl._createOrGetBindDBType(index= 1, type= 1)
DBAC FUNC DBDataSetImpl._alloc_tmp_binds(index=1 isInBind=true)
DRVR OPER OraclePreparedStatement.executeQuery()
DRVR OPER OraclePreparedStatement.executeUpdate()
DRVR FUNC OraclePreparedStatement.get_data_for_columns()
DBAC FUNC DBDataSetImpl.rowCompleted()
DBAC FUNC DBDataSetImpl._bindRowCompleted(rank= 0)
DBAC FUNC DBDataSetImpl._bindRowCompleted m_dataSetType is 1 ,m_noOfArgs is
2 m_first_row is true m_cleanedData is false
DBAC FUNC DBData.DBData(nItems=1)
DBAC FUNC DBData.DBData(nItems=1)
DRVR FUNC OracleStatement.doExecuteWithTimeout()
DRVR FUNC OracleStatement.doExecuteQuery()
DRVR DBG1 Before query: sql_kind=0, row_prefetch=10, need_to_parse=true,
need_to_prepare_define_buffer=true, columns_defined_by_user=false
DRVR DBG2 array_sql:
53 45 4c 45 43 54 20 63 6f 75 6e 74 28 2a 29 20 46 52 4f 4d
20 6d 65 73 73 61 67 65 20 57 48 45 52 45 20 6d 65 73 73 61
67 65 5f 6e 61 6d 65 20 3d 20 3a 31 20 41 4e 44 20 72 65 70
6f 73 69 74 6f 72 79 5f 6e 61 6d 65 20 3d 20 3a 32
DRVR DBG2 binds_in: oracle.jdbc.dbaccess.DBDataSetImpl@3c342b
DBDataSetImpl.m_dynamic=false
DBDataSetImpl.m_arrayDepth=1 (valid only when m_dynamic=false)
DBDataSetImpl.m_dataSetType=1
DBDataSetImpl.m_noOfArgs=2
DBDataSetImpl.types.length=2
types[0].type= VARCHAR (max_length=4000)
types[1].type= VARCHAR (max_length=4000)
DBDataSetImpl.data.length=2
data[0].items[0] has 19 bytes:
data[0].items[0] has 19 bytes allocated
4d 61 69 6c 31 30 31 34 37 33 37 38 36 37 39 38 34 2d 30
data[1].items[0] has 5 bytes:
data[1].items[0] has 5 bytes allocated
73 70 6f 6f 6c DBDataSetImpl.m_last_bind_values has size of 2
DBDataSetImpl.m_tmp_first_row_items is null
DBDataSetImpl.m_tmp_first_row_types is null
DRVR DBG2 defines: oracle.jdbc.dbaccess.DBDataSetImpl@530b8
DBDataSetImpl.m_dynamic=false
DBDataSetImpl.m_arrayDepth=0 (valid only when m_dynamic=false)
DBDataSetImpl.m_dataSetType=0
DBDataSetImpl.m_noOfArgs=0
DBDataSetImpl.types is null
DBDataSetImpl.data is null DBDataSetImpl.m_last_bind_values is null
DBDataSetImpl.m_tmp_first_row_items is null
DBDataSetImpl.m_tmp_first_row_types is null
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=0)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=0, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 43
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=0, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 43
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=1)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=1, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 4f
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=1, chars[],
charIndex=1)
DBCV DBG2 DBAccess byte: 4f
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=2)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=2, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 55
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=2, chars[],
charIndex=2)
DBCV DBG2 DBAccess byte: 55
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=3)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=3, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 4e
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=3, chars[],
charIndex=3)
DBCV DBG2 DBAccess byte: 4e
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=4)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=4, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 54
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=4, chars[],
charIndex=4)
DBCV DBG2 DBAccess byte: 54
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=5)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=5, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 28
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=5, chars[],
charIndex=5)
DBCV DBG2 DBAccess byte: 28
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=6)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=6, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 2a
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=6, chars[],
charIndex=6)
DBCV DBG2 DBAccess byte: 2a
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=7)
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=7, chars[],
charIndex=0)
DBCV DBG2 DBAccess byte: 29
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=7, chars[],
charIndex=7)
DBCV DBG2 DBAccess byte: 29
DBCV DBG2 UCS-2 character byte: 00
PIKL DBG1 OracleTypeADT (., null)
PIKL DBG1 OracleTypeADT ([B@419d05, 0, 0, 0, .)
DBAC FUNC DBDataSetImpl.setNoOfDefineCol(noOfArgs= 1)
DBAC FUNC DBDataSetImpl.setTypes(index= 0 ,internalType= 6 , externalType= 0
,maxLength= 0)
m_dataSetType= 0
DBAC FUNC DBDataSetImpl.hasStreamType()
DBAC FUNC DBDataSetImpl.setBatchSize(newBatchSize=10)
DBAC DBG1 DBDataSetImpl.setBatchSize: original batch size was 0, dataset
was=
oracle.jdbc.dbaccess.DBDataSetImpl@530b8
DBDataSetImpl.m_dynamic=false
DBDataSetImpl.m_arrayDepth=0 (valid only when m_dynamic=false)
DBDataSetImpl.m_dataSetType=0
DBDataSetImpl.m_noOfArgs=1
DBDataSetImpl.types.length=1
types[0].type= VARNUM (max_length=22)
DBDataSetImpl.data is null DBDataSetImpl.m_last_bind_values is null
DBDataSetImpl.m_tmp_first_row_items is null
DBDataSetImpl.m_tmp_first_row_types is null
DBAC FUNC DBDataSetImpl.hasStreamType()
DBAC FUNC DBDataSetImpl.setBatchSize(newBatchSize=10)
DBAC DBG1 DBDataSetImpl.setBatchSize: original batch size was 10, dataset
was=
oracle.jdbc.dbaccess.DBDataSetImpl@530b8
DBDataSetImpl.m_dynamic=false
DBDataSetImpl.m_arrayDepth=10 (valid only when m_dynamic=false)
DBDataSetImpl.m_dataSetType=0
DBDataSetImpl.m_noOfArgs=1
DBDataSetImpl.types.length=1
types[0].type= VARNUM (max_length=22)
DBDataSetImpl.data is null DBDataSetImpl.m_last_bind_values is null
DBDataSetImpl.m_tmp_first_row_items is null
DBDataSetImpl.m_tmp_first_row_types is null
DBAC FUNC DBDataSetImpl.rowCompleted()
DBAC FUNC DBDataSetImpl._definesRowCompleted()
DBAC DBG1 DBDataSetImpl._definesRowCompleted m_noOfArgs= 1
DBAC FUNC DBData.DBData(nItems=10)
DBAC FUNC DBDataSetImpl._setRowItems(colIndex= 0, item=
oracle.jdbc.ttc7.TTCItem@2bcc03)
DBAC FUNC DBDataSetImpl.isStreamType(index= 0)
DRVR DBG1 After execute: valid_rows=1
DRVR DBG2 defines: oracle.jdbc.dbaccess.DBDataSetImpl@530b8
DBDataSetImpl.m_dynamic=false
DBDataSetImpl.m_arrayDepth=10 (valid only when m_dynamic=false)
DBDataSetImpl.m_dataSetType=0
DBDataSetImpl.m_noOfArgs=1
DBDataSetImpl.types.length=1
types[0].type= VARNUM (max_length=22)
DBDataSetImpl.data.length=1
data[0].items[0] has 1 bytes:
data[0].items[0] has 22 bytes allocated
80
data[0].items[1] has 0 bytes:
data[0].items[1] has 22 bytes allocated
data[0].items[2] has 0 bytes:
data[0].items[2] has 22 bytes allocated
data[0].items[3] has 0 bytes:
data[0].items[3] has 22 bytes allocated
data[0].items[4] has 0 bytes:
data[0].items[4] has 22 bytes allocated
data[0].items[5] has 0 bytes:
data[0].items[5] has 22 bytes allocated
data[0].items[6] has 0 bytes:
data[0].items[6] has 22 bytes allocated
data[0].items[7] has 0 bytes:
data[0].items[7] has 22 bytes allocated
data[0].items[8] has 0 bytes:
data[0].items[8] has 22 bytes allocated
data[0].items[9] has 0 bytes:
data[0].items[9] has 22 bytes allocated
DBDataSetImpl.m_last_bind_values is null
DBDataSetImpl.m_tmp_first_row_items is null
DBDataSetImpl.m_tmp_first_row_types is null
DRVR FUNC OracleResultSetImpl.next(): closed=false
DRVR DBG1 closed=false, statement.current_row=-1,
statement.total_rows_visited=0, statement.max_rows=0,
statement.valid_rows=1, statement.got_last_batch=true
DRVR FUNC OracleStatement.getLongValue(getColumn=true, index=1)
DRVR FUNC OracleStatement.getBytesInternal(getColumn=true, index=1)
DBAC FUNC DBDataSetImpl.isStreamType(index= 0)
DRVR FUNC OracleResultSetImpl.internal_close()
DRVR FUNC OracleResultSetImpl.internal_close()
DRVR OPER OraclePreparedStatement.close()
DRVR OPER OraclePreparedStatement.sendBatch()
DRVR DBG1 Send batch: batch=1, m_currentRank=0
DRVR OPER OracleStatement.close()
DBAC FUNC DBDataSetImpl.cleanup()
m_dataSetType= 0
DBAC FUNC DBDataSetImpl.cleanTypes()
m_dataSetType= 0
DBAC FUNC DBDataSetImpl.cleanData()
m_dataSetType= 0
DBAC FUNC DBData.cleanup()
DRVR OPER OracleConnection.prepareStatement(sql)
DRVR DBG1 SQL: "INSERT INTO message (message_name, repository_name,
message_state, error_message, sender, recipients, remote_host, remote_addr,
last_updated, message_body) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
DRVR FUNC OracleStatement.OracleStatement(conn, batchValue=1,
rowPrefetchValue=10)
DBAC FUNC DBDataSetImpl.DBDataSetImpl(conn, nrows=0 ,dataSetType= 0)
DRVR FUNC OraclePreparedStatement.OraclePreparedStatement(conn, sql,
batchValue, rowPrefetchValue)
DBAC FUNC DBDataSetImpl.DBDataSetImpl(conn, nrows=1 ,dataSetType= 1)
DRVR FUNC OracleConnection.nativeSQL(sql)
DRVR DBG1 Input SQL: "INSERT INTO message (message_name, repository_name,
message_state, error_message, sender, recipients, remote_host, remote_addr,
last_updated, message_body) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
DRVR DBG1 Output SQL: "INSERT INTO message (message_name, repository_name,
message_state, error_message, sender, recipients, remote_host, remote_addr,
last_updated, message_body) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9,
:10)"
DBCV FUNC DBConversion.StringToCharBytes(str)
DBCV FUNC DBConversion.stringToAcessCharBytes(str, charset=31)
DBCV DBG2 UCS-2 bytes (408 bytes):
00 49 00 4e 00 53 00 45 00 52 00 54 00 20 00 49 00 4e 00 54
00 4f 00 20 00 6d 00 65 00 73 00 73 00 61 00 67 00 65 00 20
00 28 00 6d 00 65 00 73 00 73 00 61 00 67 00 65 00 5f 00 6e
00 61 00 6d 00 65 00 2c 00 20 00 72 00 65 00 70 00 6f 00 73
00 69 00 74 00 6f 00 72 00 79 00 5f 00 6e 00 61 00 6d 00 65
00 2c 00 20 00 6d 00 65 00 73 00 73 00 61 00 67 00 65 00 5f
00 73 00 74 00 61 00 74 00 65 00 2c 00 20 00 65 00 72 00 72
00 6f 00 72 00 5f 00 6d 00 65 00 73 00 73 00 61 00 67 00 65
00 2c 00 20 00 73 00 65 00 6e 00 64 00 65 00 72 00 2c 00 20
00 72 00 65 00 63 00 69 00 70 00 69 00 65 00 6e 00 74 00 73
... last 208 bytes were not printed to limit the output size
DBCV FUNC DBConversion.stringToAsciiBytes(str)
DBCV DBG2 DBAccess bytes (204 bytes):
49 4e 53 45 52 54 20 49 4e 54 4f 20 6d 65 73 73 61 67 65 20
28 6d 65 73 73 61 67 65 5f 6e 61 6d 65 2c 20 72 65 70 6f 73
69 74 6f 72 79 5f 6e 61 6d 65 2c 20 6d 65 73 73 61 67 65 5f
73 74 61 74 65 2c 20 65 72 72 6f 72 5f 6d 65 73 73 61 67 65
2c 20 73 65 6e 64 65 72 2c 20 72 65 63 69 70 69 65 6e 74 73
2c 20 72 65 6d 6f 74 65 5f 68 6f 73 74 2c 20 72 65 6d 6f 74
65 5f 61 64 64 72 2c 20 6c 61 73 74 5f 75 70 64 61 74 65 64
2c 20 6d 65 73 73 61 67 65 5f 62 6f 64 79 29 20 56 41 4c 55
45 53 20 28 3a 31 2c 20 3a 32 2c 20 3a 33 2c 20 3a 34 2c 20
3a 35 2c 20 3a 36 2c 20 3a 37 2c 20 3a 38 2c 20 3a 39 2c 20
... last 4 bytes were not printed to limit the output size
DRVR OPER OraclePreparedStatement.setString(paramIndex=1,
x=Mail1014737867984-0)
DBCV FUNC DBConversion.StringToCharBytes(str)
DBCV FUNC DBConversion.stringToAcessCharBytes(str, charset=31)
DBCV DBG2 UCS-2 bytes (38 bytes):
00 4d 00 61 00 69 00 6c 00 31 00 30 00 31 00 34 00 37 00 33
00 37 00 38 00 36 00 37 00 39 00 38 00 34 00 2d 00 30
DBCV FUNC DBConversion.stringToAsciiBytes(str)
DBCV DBG2 DBAccess bytes (19 bytes):
4d 61 69 6c 31 30 31 34 37 33 37 38 36 37 39 38 34 2d 30
DRVR FUNC OraclePreparedStatement.setItem(index=0, type=1, array)
DBAC FUNC DBDataSetImpl._createOrGetBindDBType(index= 0, type= 1)
DBAC FUNC DBDataSetImpl._alloc_tmp_binds(index=0 isInBind=true)
DRVR OPER OraclePreparedStatement.setString(paramIndex=2, x=spool)
DBCV FUNC DBConversion.StringToCharBytes(str)
DBCV FUNC DBConversion.stringToAcessCharBytes(str, charset=31)
DBCV DBG2 UCS-2 bytes (10 bytes):
00 73 00 70 00 6f 00 6f 00 6c
DBCV FUNC DBConversion.stringToAsciiBytes(str)
DBCV DBG2 DBAccess bytes (5 bytes):
73 70 6f 6f 6c
DRVR FUNC OraclePreparedStatement.setItem(index=1, type=1, array)
DBAC FUNC DBDataSetImpl._createOrGetBindDBType(index= 1, type= 1)
DBAC FUNC DBDataSetImpl._alloc_tmp_binds(index=1 isInBind=true)
DRVR OPER OraclePreparedStatement.setString(paramIndex=3, x=root)
DBCV FUNC DBConversion.StringToCharBytes(str)
DBCV FUNC DBConversion.stringToAcessCharBytes(str, charset=31)
DBCV DBG2 UCS-2 bytes (8 bytes):
00 72 00 6f 00 6f 00 74
DBCV FUNC DBConversion.stringToAsciiBytes(str)
DBCV DBG2 DBAccess bytes (4 bytes):
72 6f 6f 74
DRVR FUNC OraclePreparedStatement.setItem(index=2, type=1, array)
DBAC FUNC DBDataSetImpl._createOrGetBindDBType(index= 2, type= 1)
DBAC FUNC DBDataSetImpl._alloc_tmp_binds(index=2 isInBind=true)
DRVR OPER OraclePreparedStatement.setString(paramIndex=4, x=null)
DBCV FUNC DBConversion.StringToCharBytes(str)
DBCV FUNC DBConversion.stringToAcessCharBytes(str, charset=31)
DBCV DBG2 UCS-2 bytes: null
DRVR FUNC OraclePreparedStatement.setItem(index=3, type=1, array)
DBAC FUNC DBDataSetImpl._createOrGetBindDBType(index= 3, type= 1)
DBAC FUNC DBDataSetImpl._alloc_tmp_binds(index=3 isInBind=true)
DRVR OPER OraclePreparedStatement.setString(paramIndex=5,
[EMAIL PROTECTED])
DBCV FUNC DBConversion.StringToCharBytes(str)
DBCV FUNC DBConversion.stringToAcessCharBytes(str, charset=31)
DBCV DBG2 UCS-2 bytes (56 bytes):
00 73 00 61 00 6d 00 75 00 65 00 6c 00 40 00 73 00 65 00 63
00 65 00 6d 00 61 00 69 00 6c 00 2e 00 64 00 6e 00 73 00 61
00 6c 00 69 00 61 00 73 00 2e 00 63 00 6f 00 6d
DBCV FUNC DBConversion.stringToAsciiBytes(str)
DBCV DBG2 DBAccess bytes (28 bytes):
73 61 6d 75 65 6c 40 73 65 63 65 6d 61 69 6c 2e 64 6e 73 61
6c 69 61 73 2e 63 6f 6d
DRVR FUNC OraclePreparedStatement.setItem(index=4, type=1, array)
DBAC FUNC DBDataSetImpl._createOrGetBindDBType(index= 4, type= 1)
DBAC FUNC DBDataSetImpl._alloc_tmp_binds(index=4 isInBind=true)
DRVR OPER OraclePreparedStatement.setString(paramIndex=6,
[EMAIL PROTECTED])
DBCV FUNC DBConversion.StringToCharBytes(str)
DBCV FUNC DBConversion.stringToAcessCharBytes(str, charset=31)
DBCV DBG2 UCS-2 bytes (56 bytes):
00 6d 00 6f 00 6e 00 69 00 63 00 61 00 40 00 73 00 65 00 63
00 65 00 6d 00 61 00 69 00 6c 00 2e 00 64 00 6e 00 73 00 61
00 6c 00 69 00 61 00 73 00 2e 00 63 00 6f 00 6d
DBCV FUNC DBConversion.stringToAsciiBytes(str)
DBCV DBG2 DBAccess bytes (28 bytes):
6d 6f 6e 69 63 61 40 73 65 63 65 6d 61 69 6c 2e 64 6e 73 61
6c 69 61 73 2e 63 6f 6d
DRVR FUNC OraclePreparedStatement.setItem(index=5, type=1, array)
DBAC FUNC DBDataSetImpl._createOrGetBindDBType(index= 5, type= 1)
DBAC FUNC DBDataSetImpl._alloc_tmp_binds(index=5 isInBind=true)
DRVR OPER OraclePreparedStatement.setString(paramIndex=7,
x=rhenium.btinternet.com)
DBCV FUNC DBConversion.StringToCharBytes(str)
DBCV FUNC DBConversion.stringToAcessCharBytes(str, charset=31)
DBCV DBG2 UCS-2 bytes (44 bytes):
00 72 00 68 00 65 00 6e 00 69 00 75 00 6d 00 2e 00 62 00 74
00 69 00 6e 00 74 00 65 00 72 00 6e 00 65 00 74 00 2e 00 63
00 6f 00 6d
DBCV FUNC DBConversion.stringToAsciiBytes(str)
DBCV DBG2 DBAccess bytes (22 bytes):
72 68 65 6e 69 75 6d 2e 62 74 69 6e 74 65 72 6e 65 74 2e 63
6f 6d
DRVR FUNC OraclePreparedStatement.setItem(index=6, type=1, array)
DBAC FUNC DBDataSetImpl._createOrGetBindDBType(index= 6, type= 1)
DBAC FUNC DBDataSetImpl._alloc_tmp_binds(index=6 isInBind=true)
DRVR OPER OraclePreparedStatement.setString(paramIndex=8, x=194.73.73.93)
DBCV FUNC DBConversion.StringToCharBytes(str)
DBCV FUNC DBConversion.stringToAcessCharBytes(str, charset=31)
DBCV DBG2 UCS-2 bytes (24 bytes):
00 31 00 39 00 34 00 2e 00 37 00 33 00 2e 00 37 00 33 00 2e
00 39 00 33
DBCV FUNC DBConversion.stringToAsciiBytes(str)
DBCV DBG2 DBAccess bytes (12 bytes):
31 39 34 2e 37 33 2e 37 33 2e 39 33
DRVR FUNC OraclePreparedStatement.setItem(index=7, type=1, array)
DBAC FUNC DBDataSetImpl._createOrGetBindDBType(index= 7, type= 1)
DBAC FUNC DBDataSetImpl._alloc_tmp_binds(index=7 isInBind=true)
DRVR OPER OraclePreparedStatement.setTimestamp(paramIndex=9, timestamp)
DRVR FUNC OraclePreparedStatement.setItem(index=8, type=12, array)
DBAC FUNC DBDataSetImpl._createOrGetBindDBType(index= 8, type= 12)
DBAC FUNC DBDataSetImpl._alloc_tmp_binds(index=8 isInBind=true)
DRVR OPER OraclePreparedStatement.setObject(paramIndex=10, object)
DRVR OPER OraclePreparedStatement.setObject(paramIndex=10, object,
targetSqlType=-3, scale=0)
DRVR OPER OraclePreparedStatement.setBytes(paramIndex=10, bytes)
DRVR FUNC OraclePreparedStatement.setItem(index=9, type=23, array)
DBAC FUNC DBDataSetImpl._createOrGetBindDBType(index= 9, type= 23)
DBAC FUNC DBDataSetImpl._alloc_tmp_binds(index=9 isInBind=true)
DRVR OPER OraclePreparedStatement.execute()
DRVR OPER OraclePreparedStatement.executeUpdate()
DRVR FUNC OraclePreparedStatement.get_data_for_columns()
DBAC FUNC DBDataSetImpl.rowCompleted()
DBAC FUNC DBDataSetImpl._bindRowCompleted(rank= 0)
DBAC FUNC DBDataSetImpl._bindRowCompleted m_dataSetType is 1 ,m_noOfArgs is
10 m_first_row is true m_cleanedData is false
DBAC FUNC DBData.DBData(nItems=1)
DBAC FUNC DBData.DBData(nItems=1)
DBAC FUNC DBData.DBData(nItems=1)
DBAC FUNC DBData.DBData(nItems=1)
DBAC FUNC DBData.DBData(nItems=1)
DBAC FUNC DBData.DBData(nItems=1)
DBAC FUNC DBData.DBData(nItems=1)
DBAC FUNC DBData.DBData(nItems=1)
DBAC FUNC DBData.DBData(nItems=1)
DBAC FUNC DBData.DBData(nItems=1)
DRVR FUNC OracleStatement.doExecuteWithTimeout()
DRVR FUNC OracleStatement.doExecuteOther(batchForPlsql=false)
DRVR DBG1 Before execute: m_currentRank=1, sql_kind=2, need_to_parse=true
DRVR DBG2 binds_in: oracle.jdbc.dbaccess.DBDataSetImpl@4afb56
DBDataSetImpl.m_dynamic=false
DBDataSetImpl.m_arrayDepth=1 (valid only when m_dynamic=false)
DBDataSetImpl.m_dataSetType=1
DBDataSetImpl.m_noOfArgs=10
DBDataSetImpl.types.length=10
types[0].type= VARCHAR (max_length=4000)
types[1].type= VARCHAR (max_length=4000)
types[2].type= VARCHAR (max_length=4000)
types[3].type= VARCHAR (max_length=4000)
types[4].type= VARCHAR (max_length=4000)
types[5].type= VARCHAR (max_length=4000)
types[6].type= VARCHAR (max_length=4000)
types[7].type= VARCHAR (max_length=4000)
types[8].type= DATE (max_length=7)
types[9].type= RAW (max_length=320428)
DBDataSetImpl.data.length=10
data[0].items[0] has 19 bytes:
data[0].items[0] has 19 bytes allocated
4d 61 69 6c 31 30 31 34 37 33 37 38 36 37 39 38 34 2d 30
data[1].items[0] has 5 bytes:
data[1].items[0] has 5 bytes allocated
73 70 6f 6f 6c
data[2].items[0] has 4 bytes:
data[2].items[0] has 4 bytes allocated
72 6f 6f 74
data[3].items[0] has 0 bytes:
data[3].items[0] has 0 bytes allocated
data[4].items[0] has 28 bytes:
data[4].items[0] has 28 bytes allocated
73 61 6d 75 65 6c 40 73 65 63 65 6d 61 69 6c 2e 64 6e 73 61
6c 69 61 73 2e 63 6f 6d
data[5].items[0] has 28 bytes:
data[5].items[0] has 28 bytes allocated
6d 6f 6e 69 63 61 40 73 65 63 65 6d 61 69 6c 2e 64 6e 73 61
6c 69 61 73 2e 63 6f 6d
data[6].items[0] has 22 bytes:
data[6].items[0] has 22 bytes allocated
72 68 65 6e 69 75 6d 2e 62 74 69 6e 74 65 72 6e 65 74 2e 63
6f 6d
data[7].items[0] has 12 bytes:
data[7].items[0] has 12 bytes allocated
31 39 34 2e 37 33 2e 37 33 2e 39 33
data[8].items[0] has 7 bytes:
data[8].items[0] has 7 bytes allocated
78 66 02 1a 10 26 30
data[9].items[0] has 320428 bytes:
data[9].items[0] has 320428 bytes allocated
52 65 74 75 72 6e 2d 50 61 74 68 3a 20 3c 73 61 6d 75 65 6c
40 73 65 63 65 6d 61 69 6c 2e 64 6e 73 61 6c 69 61 73 2e 63
6f 6d 3e 0d 0a 52 65 63 65 69 76 65 64 3a 20 66 72 6f 6d 20
72 68 65 6e 69 75 6d 2e 62 74 69 6e 74 65 72 6e 65 74 2e 63
6f 6d 20 28 5b 31 39 34 2e 37 33 2e 37 33 2e 39 33 5d 29 0d
0a 20 20 20 20 20 20 20 20 20 20 62 79 20 73 65 63 65 6d 61
69 6c 2e 64 6e 73 61 6c 69 61 73 2e 63 6f 6d 20 28 4a 41 4d
45 53 20 53 4d 54 50 20 53 65 72 76 65 72 20 32 2e 30 61 32
29 20 77 69 74 68 20 53 4d 54 50 20 49 44 20 35 33 37 0d 0a
20 20 20 20 20 20 20 20 20 20 66 6f 72 20 3c 6d 6f 6e 69 63
... last 320228 bytes were not printed to limit the output size
DBDataSetImpl.m_last_bind_values has size of 10
DBDataSetImpl.m_tmp_first_row_items is null
DBDataSetImpl.m_tmp_first_row_types is null
DRVR FUNC OracleStatement.executeNonQuery(batchForPlsql=false)
DRVR FUNC DBError.throwSqlException(e="Connection reset by peer: socket
write error")
DRVR WARN Unable to find ORA number from exception
DRVR FUNC DBError.throwSqlException(errNum=2, obj=Connection reset by peer:
socket write error)
DRVR FUNC DBError.findMessage(errNum=2, obj=Connection reset by peer: socket
write error)
DRVR FUNC DBError.throwSqlException(reason="Io exception: Connection reset
by peer: socket write error", SQLState=null, vendorCode=17002)
DRVR FUNC OracleStatement.cleanupForBatching()
DRVR OPER OracleConnection.getWarnings()
DRVR OPER OracleConnection.clearWarnings()
DRVR OPER OracleConnection.getWarnings()
DRVR OPER OracleConnection.clearWarnings()
DRVR FUNC OracleConnection.isClosed() returned false
DRVR OPER OracleConnection.getWarnings()
DRVR OPER OracleConnection.clearWarnings()
DRVR OPER OracleConnection.prepareStatement(sql)
DRVR DBG1 SQL: "DELETE FROM message WHERE message_name = ? AND
repository_name = ?"
DRVR FUNC OracleStatement.OracleStatement(conn, batchValue=1,
rowPrefetchValue=10)
DRVR FUNC DBError.throwSqlException(e="Connection reset by peer: socket
write error")
DRVR WARN Unable to find ORA number from exception
DRVR FUNC DBError.throwSqlException(errNum=2, obj=Connection reset by peer:
socket write error)
DRVR FUNC DBError.findMessage(errNum=2, obj=Connection reset by peer: socket
write error)
DRVR FUNC DBError.throwSqlException(reason="Io exception: Connection reset
by peer: socket write error", SQLState=null, vendorCode=17002)
DRVR OPER OracleConnection.getWarnings()
DRVR OPER OracleConnection.clearWarnings()
DRVR OPER OracleConnection.getWarnings()
DRVR OPER OracleConnection.clearWarnings()
DRVR FUNC OracleConnection.isClosed() returned false
DRVR OPER OracleConnection.getWarnings()
DRVR OPER OracleConnection.clearWarnings()
DRVR OPER OracleConnection.prepareStatement(sql)
DRVR DBG1 SQL: "SELECT message_name, message_state, last_updated FROM
message WHERE repository_name = ? ORDER BY last_updated ASC"
DRVR FUNC OracleStatement.OracleStatement(conn, batchValue=1,
rowPrefetchValue=10)
DRVR FUNC DBError.throwSqlException(e="Connection reset by peer: socket
write error")
DRVR WARN Unable to find ORA number from exception
DRVR FUNC DBError.throwSqlException(errNum=2, obj=Connection reset by peer:
socket write error)
DRVR FUNC DBError.findMessage(errNum=2, obj=Connection reset by peer: socket
write error)
DRVR FUNC DBError.throwSqlException(reason="Io exception: Connection reset
by peer: socket write error", SQLState=null, vendorCode=17002)
DRVR OPER OracleConnection.getWarnings()
DRVR OPER OracleConnection.clearWarnings()
DRVR OPER OracleConnection.getWarnings()
DRVR OPER OracleConnection.clearWarnings()
DRVR FUNC OracleConnection.isClosed() returned false
DRVR OPER OracleConnection.getWarnings()
DRVR OPER OracleConnection.clearWarnings()
DRVR OPER OracleConnection.prepareStatement(sql)
DRVR DBG1 SQL: "SELECT message_name, message_state, last_updated FROM
message WHERE repository_name = ? ORDER BY last_updated ASC"
DRVR FUNC OracleStatement.OracleStatement(conn, batchValue=1,
rowPrefetchValue=10)
DRVR FUNC DBError.throwSqlException(e="Connection reset by peer: socket
write error")
DRVR WARN Unable to find ORA number from exception
DRVR FUNC DBError.throwSqlException(errNum=2, obj=Connection reset by peer:
socket write error)
DRVR FUNC DBError.findMessage(errNum=2, obj=Connection reset by peer: socket
write error)
DRVR FUNC DBError.throwSqlException(reason="Io exception: Connection reset
by peer: socket write error", SQLState=null, vendorCode=17002)
DRVR OPER OracleConnection.getWarnings()
DRVR OPER OracleConnection.clearWarnings()
DRVR OPER OracleConnection.getWarnings()
DRVR OPER OracleConnection.clearWarnings()
DRVR FUNC OracleConnection.isClosed() returned false
DRVR OPER OracleConnection.getWarnings()
DRVR OPER OracleConnection.clearWarnings()
DRVR OPER OracleConnection.prepareStatement(sql)
DRVR DBG1 SQL: "SELECT message_name, message_state, last_updated FROM
message WHERE repository_name = ? ORDER BY last_updated ASC"
DRVR FUNC OracleStatement.OracleStatement(conn, batchValue=1,
rowPrefetchValue=10)
DRVR FUNC DBError.throwSqlException(e="Connection reset by peer: socket
write error")
DRVR WARN Unable to find ORA number from exception
DRVR FUNC DBError.throwSqlException(errNum=2, obj=Connection reset by peer:
socket write error)
DRVR FUNC DBError.findMessage(errNum=2, obj=Connection reset by peer: socket
write error)
DRVR FUNC DBError.throwSqlException(reason="Io exception: Connection reset
by peer: socket write error", SQLState=null, vendorCode=17002)
DRVR OPER OracleConnection.getWarnings()
DRVR OPER OracleConnection.clearWarnings()
DRVR OPER OracleConnection.getWarnings()
DRVR OPER OracleConnection.clearWarnings()
DRVR FUNC OracleConnection.isClosed() returned false
DRVR OPER OracleConnection.getWarnings()
DRVR OPER OracleConnection.clearWarnings()
DRVR OPER OracleConnection.setAutoCommit(autoCommit=false)
DRVR FUNC DBError.throwSqlException(e="Connection reset by peer: socket
write error")
DRVR WARN Unable to find ORA number from exception
DRVR FUNC DBError.throwSqlException(errNum=2, obj=Connection reset by peer:
socket write error)
DRVR FUNC DBError.findMessage(errNum=2, obj=Connection reset by peer: socket
write error)
DRVR FUNC DBError.throwSqlException(reason="Io exception: Connection reset
by peer: socket write error", SQLState=null, vendorCode=17002)
DRVR OPER OracleConnection.getWarnings()
DRVR OPER OracleConnection.clearWarnings()
DRVR OPER OracleConnection.getWarnings()
DRVR OPER OracleConnection.clearWarnings()
DRVR FUNC OracleConnection.isClosed() returned false
DRVR OPER OracleConnection.getWarnings()
DRVR OPER OracleConnection.clearWarnings()
DRVR OPER OracleConnection.prepareStatement(sql)
DRVR DBG1 SQL: "DELETE FROM message WHERE message_name = ? AND
repository_name = ?"
DRVR FUNC OracleStatement.OracleStatement(conn, batchValue=1,
rowPrefetchValue=10)
DRVR FUNC DBError.throwSqlException(e="Connection reset by peer: socket
write error")
DRVR WARN Unable to find ORA number from exception
DRVR FUNC DBError.throwSqlException(errNum=2, obj=Connection reset by peer:
socket write error)
DRVR FUNC DBError.findMessage(errNum=2, obj=Connection reset by peer: socket
write error)
DRVR FUNC DBError.throwSqlException(reason="Io exception: Connection reset
by peer: socket write error", SQLState=null, vendorCode=17002)
DRVR OPER OracleConnection.getWarnings()
DRVR OPER OracleConnection.clearWarnings()
DRVR OPER OracleConnection.getWarnings()
DRVR OPER OracleConnection.clearWarnings()
DRVR FUNC OracleConnection.isClosed() returned false
DRVR OPER OracleConnection.getWarnings()
DRVR OPER OracleConnection.clearWarnings()
DRVR OPER OracleConnection.prepareStatement(sql)
DRVR DBG1 SQL: "SELECT message_name, message_state, last_updated FROM
message WHERE repository_name = ? ORDER BY last_updated ASC"
DRVR FUNC OracleStatement.OracleStatement(conn, batchValue=1,
rowPrefetchValue=10)
DRVR FUNC DBError.throwSqlException(e="Connection reset by peer: socket
write error")
DRVR WARN Unable to find ORA number from exception
DRVR FUNC DBError.throwSqlException(errNum=2, obj=Connection reset by peer:
socket write error)
DRVR FUNC DBError.findMessage(errNum=2, obj=Connection reset by peer: socket
write error)
DRVR FUNC DBError.throwSqlException(reason="Io exception: Connection reset
by peer: socket write error", SQLState=null, vendorCode=17002)
DRVR OPER OracleConnection.getWarnings()
DRVR OPER OracleConnection.clearWarnings()
DRVR OPER OracleConnection.getWarnings()
DRVR OPER OracleConnection.clearWarnings()
DRVR FUNC OracleConnection.isClosed() returned false
DRVR OPER OracleConnection.getWarnings()
DRVR OPER OracleConnection.clearWarnings()
DRVR OPER OracleConnection.prepareStatement(sql)
DRVR DBG1 SQL: "SELECT message_name, message_state, last_updated FROM
message WHERE repository_name = ? ORDER BY last_updated ASC"
DRVR FUNC OracleStatement.OracleStatement(conn, batchValue=1,
rowPrefetchValue=10)
DRVR FUNC DBError.throwSqlException(e="Connection reset by peer: socket
write error")
DRVR WARN Unable to find ORA number from exception
DRVR FUNC DBError.throwSqlException(errNum=2, obj=Connection reset by peer:
socket write error)
DRVR FUNC DBError.findMessage(errNum=2, obj=Connection reset by peer: socket
write error)
DRVR FUNC DBError.throwSqlException(reason="Io exception: Connection reset
by peer: socket write error", SQLState=null, vendorCode=17002)
DRVR OPER OracleConnection.getWarnings()
DRVR OPER OracleConnection.clearWarnings()
DRVR OPER OracleConnection.getWarnings()
DRVR OPER OracleConnection.clearWarnings()
Can anyone be so kind as to help me explain why Oracle throws the exception
at the point of executing the OraclePreparedStatement.execute() method call?
Thanks in advance.
Rgds,
Sam.
>Hi Samuel,
>From the stack-trace provided, it's pretty clear that the Oracle >driver is
>spitting in the OraclePreparedStatement.execute() call. Maybe the >Oracle
>logs can provide you with more information about what's going wrong.
>Something that can be immensely useful is to enable logging inside the
> >JDBC driver itself. This let's the JDBC driver tell you what's going on.
> >It's something like:
>DriverManager.setLogStream( System.out );
>(have a look at the API docs for java.sql.DriverManager)
>Hope this helps
>ciao
>Daz
>On Tue, 26 Feb 2002 22:00, you wrote:
>Hi all,
>
>I have problems sending and thus receiving mail attachment messages within
>James. I have placed some rigorous debug messages throughout the whole of
>James project and got the following results:
>
>
>Whenever I attempt to send a multipart mail message with some binary
>attachment files and send it to a local recipient (or non-local), it throws
>some strange exception:
>
>java.sql.SQLException: Io exception: Connection reset by peer: socket write
>erro
>r
> at
>oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
> at
>oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
> at
>oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:323)
> at
>oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.ja
>va:1460)
> at
>oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.jav
>a:1371)
> at
>oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
>nt.java:1900)
> at
>oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar
>edStatement.java:363)
> at
>oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStat
>ement.java:407)
> at
>org.apache.james.mailrepository.JDBCMailRepository.store(JDBCMailRepo
>sitory.java:479)
> at org.apache.james.James.sendMail(James.java:265)
> at java.lang.reflect.Method.invoke(Native Method)
> at
>org.apache.avalon.phoenix.components.application.BlockInvocationHandl
>er.invoke(BlockInvocationHandler.java:88)
> at $Proxy9.sendMail(Unknown Source)
> at
>org.apache.james.smtpserver.SMTPHandler.doDATA(SMTPHandler.java:609)
> at
>org.apache.james.smtpserver.SMTPHandler.parseCommand(SMTPHandler.java
>
>:255)
>
> at
>org.apache.james.smtpserver.SMTPHandler.handleConnection(SMTPHandler.
>java:164)
> at
>org.apache.avalon.cornerstone.blocks.connection.ConnectionRunner.run(
>Connection.java:163)
> at
>org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Ex
>ecutableRunnable.java:47)
> at
>org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread
>.java:80)
>
>
>When I then attemp to login into James POP server as the recipient
>expecting to read the attachment mail message, I'm unable to login at all,
>which is very odd, it also threw some spurious exceptions:
>
>
>(SQLException) AbstractJdbcUsersRepository.getUserByName): Io exception:
>Connect
>ion reset by peer: socket write error
>java.sql.SQLException: Io exception: Connection reset by peer: socket write
>erro
>r
> at
>oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
> at
>oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:210)
> at
>oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:323)
> at
>oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:417)
> at
>oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:432)
> at
>oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedState
>ment.java:182)
> at
>oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedState
>ment.java:165)
> at
>oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleCon
>nection.java:608)
> at
>oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection
>.java:489)
> at
>org.apache.james.util.mordred.PoolConnEntry.prepareStatement(PoolConn
>Entry.java:199)
> at
>org.apache.james.userrepository.AbstractJdbcUsersRepository.getUserBy
>Name(AbstractJdbcUsersRepository.java:407)
> at
>org.apache.james.userrepository.AbstractUsersRepository.test(Abstract
>UsersRepository.java:252)
> at
>org.apache.james.pop3server.POP3Handler.doPASS(POP3Handler.java:336)
> at
>org.apache.james.pop3server.POP3Handler.parseCommand(POP3Handler.java
>
>:290)
>
> at
>org.apache.james.pop3server.POP3Handler.handleConnection(POP3Handler.
>java:225)
> at
>org.apache.avalon.cornerstone.blocks.connection.ConnectionRunner.run(
>Connection.java:163)
> at
>org.apache.avalon.excalibur.thread.impl.ExecutableRunnable.execute(Ex
>ecutableRunnable.java:47)
> at
>org.apache.avalon.excalibur.thread.impl.WorkerThread.run(WorkerThread
>.java:80)
>(2nd Exception) POP3Handler.handleConnection(): Error accessing database
>
>Then after every 10 seconds the JamesSpoolManager reattempts to send the
>mail message, and I got the following exceptions:
>
>(SQLException) JDBCSpoolRepository.loadPendingMessages(): Io exception:
>Connecti
>on reset by peer: socket write error
>(1st Exception) JDBCSpoolRepository.loadPendingMessages(): null
>(2nd Exception) JDBCSpoolRepository.loadPendingMessages(): null
>
>
>I would be most grateful if you could shed a light into this peculiar
>James's behaviour.
>
>Thanks in advance.
>
>Sam.
>
>
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
