Re: Help with JDBC trace.

From: Fred Tilly <ftilly_at_btinternet.com>
Date: Wed, 9 Sep 2009 06:35:05 +0000 (GMT)
Message-ID: <434158.61523.qm_at_web87116.mail.ird.yahoo.com>

Hi,

The varchar2 parameters as defined in JAVA using:

st.registerOutParameter(2, Types.
 

And the maximum size of the data column in the table being called is varchar2(500)
 

We are using the thin JDBC driver for 10g.
 

Thanks
 

FredVARCHAR);

It looks to me like you are trying to shove 10lbs of data into a 9.99 lb box. Look at the datatype of the column and make sure that you are registering the correct type. Also, any more data that you can share would be great.

WGB -----Original Message-----
From: oracle-l-bounce_at_freelists.org
[oracle-l-bounce_at_freelists.org] On Behalf Of Fred Tilly Sent: Tuesday, September 08, 2009 9:47 AM To: oracle-l_at_freelists.org
Subject: Help with JDBC trace.

All,

Looking through a JDBC trace file I see the following SEVERE message, does anyone know what it means.

08-Sep-2009 14:47:38 oracle.jdbc.driver.OracleCallableStatement registerOutParameter
INFO: OracleCallableStatement.registerOutParameter(paramIndex=2, sqlType=12, scale=0, maxLength=-1)
08-Sep-2009 14:47:38 oracle.jdbc.driver..T4CCallableStatement allocateAccessor
SEVERE:
oracle.jdbc.driver.T4CCallableStatement.allocateAccessors:return: oracle.jdbc.driver.T4CVarcharAccessor_at_19616c7, statement=oracle.jdbc.driver.T4CCallableStatement_at_b166b5, outBind=true, internalType=1, internalTypeMaxLength=32512, isStream=false, formOfUse=1, internalOtype=null, externalType=12, internalTypeName=null, columnName=null, describeType=0, describeMaxLength=0, nullable=false,

precision=0, scale=0, flags=0, contflag=0, total_elems=0,
describeOtype=null, describeTypeName=null, rowSpaceByte=null,
rowSpaceChar=null, rowSpaceIndicator=null, columnIndex=0, lengthIndex=0,

indicatorIndex=0, byteLength=0, charLength=32513

Thanks

Fred

--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Sep 09 2009 - 01:35:05 CDT