Exactly!! I have removed the "Debug" option in the Console Logging section
of jboss.conf and still get zillions of scrolled crap on my console for
every DB hit. I even tried removing all the options like "Information",
"Warning" and "Error" and still get the same output! Here's a sample output
:
DRVR OPER OracleConnection.prepareStatement(sql)
DRVR DBG1 SQL: "SELECT MEMBER_ID FROM TBL_MEMBER WHERE MEMBER_ID = ? AND
MEMBER_PASSWORD = ?"
DRVR FUNC OracleStatement.OracleStatement(conn, batchValue=1,
rowPrefetchValue=10)
DBAC FUNC DBDataSet.DBDataSet(conn, nrows=0)
DRVR FUNC OraclePreparedStatement.OraclePreparedStatement(conn, sql,
batchValue, rowPrefetchValue)
DRVR OPER OraclePreparedStatement.setObject(paramIndex=1, object)
DRVR OPER OraclePreparedStatement.setObject(paramIndex=1, object,
targetSqlType=12, scale=0)
DRVR OPER OraclePreparedStatement.setString(paramIndex=1, x=M1)
DBCV FUNC DBConversion.StringToCharBytes(str)
DBCV FUNC DBConversion.stringToAcessCharBytes(str, charset=1)
DBCV DBG2 UCS-2 bytes (4 bytes):
00 4d 00 31
DBCV FUNC DBConversion.stringToAsciiBytes(str)
DBCV DBG2 DBAccess bytes (2 bytes):
4d 31
DRVR FUNC OraclePreparedStatement.setItem(index=0, type=1, array)
DRVR FUNC OraclePreparedStatement.alloc_tmp_binds(index=0)
DRVR FUNC OracleConnection.nativeSQL(sql)
DRVR DBG1 Input SQL: "SELECT MEMBER_ID FROM TBL_MEMBER WHERE MEMBER_ID = ?
AND MEMBER_PASSWORD = ?"
DRVR DBG1 Output SQL: "SELECT MEMBER_ID FROM TBL_MEMBER WHERE MEMBER_ID = :1
AND MEMBER_PASSWORD = :2"
DBCV FUNC DBConversion.StringToCharBytes(str)
DBCV FUNC DBConversion.stringToAcessCharBytes(str, charset=1)
DBCV DBG2 UCS-2 bytes (156 bytes):
00 53 00 45 00 4c 00 45 00 43 00 54 00 20 00 4d 00 45 00 4d
00 42 00 45 00 52 00 5f 00 49 00 44 00 20 00 46 00 52 00 4f
00 4d 00 20 00 54 00 42 00 4c 00 5f 00 4d 00 45 00 4d 00 42
00 45 00 52 00 20 00 57 00 48 00 45 00 52 00 45 00 20 00 4d
00 45 00 4d 00 42 00 45 00 52 00 5f 00 49 00 44 00 20 00 3d
00 20 00 3a 00 31 00 20 00 41 00 4e 00 44 00 20 00 4d 00 45
00 4d 00 42 00 45 00 52 00 5f 00 50 00 41 00 53 00 53 00 57
00 4f 00 52 00 44 00 20 00 3d 00 20 00 3a 00 32
DBCV FUNC DBConversion.stringToAsciiBytes(str)
DBCV DBG2 DBAccess bytes (78 bytes):
53 45 4c 45 43 54 20 4d 45 4d 42 45 52 5f 49 44 20 46 52 4f
4d 20 54 42 4c 5f 4d 45 4d 42 45 52 20 57 48 45 52 45 20 4d
45 4d 42 45 52 5f 49 44 20 3d 20 3a 31 20 41 4e 44 20 4d 45
4d 42 45 52 5f 50 41 53 53 57 4f 52 44 20 3d 20 3a 32
DRVR OPER OraclePreparedStatement.setObject(paramIndex=2, object)
DRVR OPER OraclePreparedStatement.setObject(paramIndex=2, object,
targetSqlType=12, scale=0)
DRVR OPER OraclePreparedStatement.setString(paramIndex=2, x=1)
DBCV FUNC DBConversion.StringToCharBytes(str)
DBCV FUNC DBConversion.stringToAcessCharBytes(str, charset=1)
DBCV DBG2 UCS-2 bytes (2 bytes):
00 31
DBCV FUNC DBConversion.stringToAsciiBytes(str)
DBCV DBG2 DBAccess bytes (1 bytes):
31
DRVR FUNC OraclePreparedStatement.setItem(index=1, type=1, array)
DRVR FUNC OraclePreparedStatement.alloc_tmp_binds(index=1)
DRVR OPER OraclePreparedStatement.executeQuery()
DRVR OPER OraclePreparedStatement.executeUpdate()
DRVR FUNC OraclePreparedStatement.get_data_for_columns()
DRVR DBG1 First row: noOfArgs=2, noOfOutParams=0, m_currentRank=0
DBAC FUNC DBDataSet.DBDataSet(conn, ncols=2, nrows=1)
DBAC FUNC DBData.DBData(nItems=1)
DBAC FUNC DBData.DBData(nItems=1)
DRVR FUNC OracleStatement.doExecuteWithTimeout()
DRVR FUNC OracleStatement.doExecute()
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 4d 45 4d 42 45 52 5f 49 44 20 46 52 4f
4d 20 54 42 4c 5f 4d 45 4d 42 45 52 20 57 48 45 52 45 20 4d
45 4d 42 45 52 5f 49 44 20 3d 20 3a 31 20 41 4e 44 20 4d 45
4d 42 45 52 5f 50 41 53 53 57 4f 52 44 20 3d 20 3a 32
DRVR DBG2 binds_in: oracle.jdbc.dbaccess.DBDataSet@588325
DBDataSet.m_dynamic=false
DBDataSet.m_arrayDepth=1 (valid only when m_dynamic=false)
DBDataSet.types.length=2
types[0].type= VARCHAR (max_length=4000)
types[1].type= VARCHAR (max_length=4000)
DBDataSet.data.length=2
data[0].items[0] has 2 bytes:
4d 31
data[1].items[0] has 1 bytes:
31
DRVR DBG2 defines: oracle.jdbc.dbaccess.DBDataSet@a2a38
DBDataSet.m_dynamic=false
DBDataSet.m_arrayDepth=0 (valid only when m_dynamic=false)
DBDataSet.types is null
DBDataSet.data 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: 4d
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=2, chars[],
charIndex=2)
DBCV DBG2 DBAccess byte: 4d
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: 42
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=3, chars[],
charIndex=3)
DBCV DBG2 DBAccess byte: 42
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: 45
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=4, chars[],
charIndex=4)
DBCV DBG2 DBAccess byte: 45
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: 52
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=5, chars[],
charIndex=5)
DBCV DBG2 DBAccess byte: 52
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: 5f
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=6, chars[],
charIndex=6)
DBCV DBG2 DBAccess byte: 5f
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: 49
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=7, chars[],
charIndex=7)
DBCV DBG2 DBAccess byte: 49
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: 44
DBCV DBG2 UCS-2 character byte: 00
DBCV DBG2 DBConversion.CHARBytesToJavaChar(bytes[], byteIndex=8, chars[],
charIndex=8)
DBCV DBG2 DBAccess byte: 44
DBCV DBG2 UCS-2 character byte: 00
DRVR DBG1 doDefaultTypes
DRVR DBG1 doDefinesFromTypes
DBAC FUNC DBData.DBData(nItems=10)
DRVR DBG1 After execute: valid_rows=1
DRVR DBG2 defines: oracle.jdbc.dbaccess.DBDataSet@a2a38
DBDataSet.m_dynamic=false
DBDataSet.m_arrayDepth=10 (valid only when m_dynamic=false)
DBDataSet.types.length=1
types[0].type= VARCHAR (max_length=10)
DBDataSet.data.length=1
data[0].items[0] has 2 bytes:
4d 31
data[0].items[1] has 0 bytes:
data[0].items[2] has 0 bytes:
data[0].items[3] has 0 bytes:
data[0].items[4] has 0 bytes:
data[0].items[5] has 0 bytes:
data[0].items[6] has 0 bytes:
data[0].items[7] has 0 bytes:
data[0].items[8] has 0 bytes:
data[0].items[9] has 0 bytes:
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.getStringValue(getColumn=true, index=1)
DRVR FUNC OracleStatement.getBytesInternal(getColumn=true, index=1)
DBCV FUNC DBConversion.CharBytesToString(bytes[], nbytes=2)
DBCV DBG2 DBAccess bytes: (2 bytes):
4d 31
DBCV DBG2 UCS-2 bytes (4 bytes):
00 4d 00 31
DRVR FUNC OracleResultSetImpl.next(): closed=false
DRVR DBG1 closed=false, statement.current_row=0,
statement.total_rows_visited=1, statement.max_rows=0,
statement.valid_rows=1, statement.got_last_batch=true
DRVR FUNC OracleResultSetImpl.internal_close()
DRVR FUNC OracleResultSetImpl.internal_close()
DRVR FUNC OracleResultSetImpl.internal_close()
DRVR OPER OracleConnection.getAutoCommit() returned false
DRVR OPER OracleConnection.commit()
DRVR OPER OraclePreparedStatement.sendBatch()
DRVR DBG1 Send batch: batch=1, m_currentRank=0
Why would anyone want to view all this crap?? The above shown output
is just a fraction of what I normally get for a DB hit!! Somebody please
help.
-Regards,
-Prince
> -----Original Message-----
> From: Tobias Frech [SMTP:[EMAIL PROTECTED]]
> Sent: Saturday, February 24, 2001 10:03 PM
> To: JBoss-User
> Subject: Re: [jBoss-User] How to prevent JBoss from giving all those
> detailsof every query fired to an Oracle DB??
>
> Hi!
> Probably these debug messages are not generated by JBoss. I remember
> someone asking this question some weeks ago. He/she also used Orcale. In
> the end we need to have an example to help you :-)
>
> Cheers,
> Tobias
>
> Prince Mathew Samuel schrieb:
> >
> > This can get very irriatating, especially if u know that your code is
> > working fine.
> > -Prince
> >
> > --
> > --------------------------------------------------------------
> > To subscribe: [EMAIL PROTECTED]
> > To unsubscribe: [EMAIL PROTECTED]
> > List Help?: [EMAIL PROTECTED]
>
>
>
> --
> --------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> List Help?: [EMAIL PROTECTED]
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
List Help?: [EMAIL PROTECTED]
