It's not a secret anymore!*
The moose likes JDBC and the fly likes java.sql.SQLException: Bigger type length than Maximum Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "java.sql.SQLException: Bigger type length than Maximum" Watch "java.sql.SQLException: Bigger type length than Maximum" New topic
Author

java.sql.SQLException: Bigger type length than Maximum

vavilala akumar
Greenhorn

Joined: Jul 21, 2008
Posts: 7
Hi,

I am getting the exception : java.sql.SQLException: Bigger type length than Maximum while i am executing the callable statement. we are using oracle 10g version 10.2.0.3.0 .I have google it and found some answers about upgrading the latest Jdbc drivers. I have downloaded jdbc driver 10.2.0.3.0 and placed. But still getting the same error.

This callable statement is taking 3 input paramters and 3 output parameters.

See the below code

String strsql="call Mm_Sp_Abscollrpt_Main_Summary(?,?,?,2,?,?,?)"
csPopulateData = getCallableStatement(strSql);
csPopulateData.setString(1, strLocCode); // value : AHYD2
csPopulateData.setTimestamp(2, DateUtil.retTimestamp(strDtTo)); // value: 2009-04-06 00:00:00.0
csPopulateData.setString(3, strUserId); // Value is : SANT1D
csPopulateData.registerOutParameter(4, Types.BIGINT);
csPopulateData.registerOutParameter(5, Types.BIGINT);
csPopulateData.registerOutParameter(6, Types.LONGVARCHAR);
csPopulateData.execute(); //getting exception Here


We are facing this issue in Production . Your quick response is highly appreciated.
jay vas
Ranch Hand

Joined: Aug 30, 2005
Posts: 407
is the column that corresponds to the longvarchar modelled correctly ?
vavilala akumar
Greenhorn

Joined: Jul 21, 2008
Posts: 7
Yes the VARCHAR corresponding type in database is also VARCHAR only.It is working fine in production till 10 days back , i got the doubt on the types and changed 2 days back, still it is not working.

before my code was.

csPopulateData.registerOutParameter(4, Types.INTEGER);
csPopulateData.registerOutParameter(5, Types.INTEGER);
csPopulateData.registerOutParameter(6, Types.VARCHAR);

i have changed to

csPopulateData.registerOutParameter(4, Types.BIGINT);
csPopulateData.registerOutParameter(5, Types.BIGINT);
csPopulateData.registerOutParameter(6, Types.LONGVARCHAR);

still i am getting same error. please suggest.






 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: java.sql.SQLException: Bigger type length than Maximum
 
Similar Threads
java.sql.SQLException: Data size bigger than max size for this type : 34500
sql exception
SQL Exception
Bigger type length than Maximum
java.sql.SQLException: Bigger type length than Maximum