Forums Register Login

java.sql.SQLException: Bigger type length than Maximum

+Pie Number of slices to send: Send
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.
+Pie Number of slices to send: Send
is the column that corresponds to the longvarchar modelled correctly ?
+Pie Number of slices to send: Send
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.






What? What, what, what? What what tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 3567 times.
Similar Threads
java.sql.SQLException: Bigger type length than Maximum
java.sql.SQLException: Data size bigger than max size for this type : 34500
sql exception
SQL Exception
Bigger type length than Maximum
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 18, 2024 22:32:06.