Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLException : Bigger type length than Maximum

441615Sep 12 2006 — edited Sep 13 2006

Hi,

I am facing a curious error ( I have posted the Stack Trace below ). I keep getting this intermittently - if I change the JAR file, I don't get it in some classes, but it reappears when I try to run other classes.

I have read about this in a couple of Therads & I even switched the JAR files - I have tried this with both ojdbc14.jar and classes12.jar, but this error simply persists :-

MissedCallsEngineWrapper:
    [java] log4j:WARN No appenders could be found for logger (com.sandeep.test.ConnectionProxy).
    [java] log4j:WARN Please initialize the log4j system properly.
    [java] MTG-MissedCallsEngineWrapper.getSearch :: Before Executing the State
ment
    [java] com.sandeep.test.BacktrackableSQLException: Bigger type leng
th than Maximumcall getCallsByAcc (:1,:2)
    [java] ^

    [java]     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseEr
ror.java:125)
    [java]     at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseEr
ror.java:162)
    [java]     at oracle.jdbc.driver.DatabaseError.check_error(DatabaseError.ja
va:885)
    [java]     at oracle.jdbc.driver.T4CMAREngine.buffer2Value(T4CMAREngine.jav
a:2231)
    [java]     at oracle.jdbc.driver.T4CMAREngine.unmarshalUB2(T4CMAREngine.jav
a:1048)
    [java]     at oracle.jdbc.driver.T4CTTIdcb.receiveCommon(T4CTTIdcb.java:112
)
    [java]     at oracle.jdbc.driver.T4CTTIdcb.receiveFromRefCursor(T4CTTIdcb.j
ava:104)
    [java]     at oracle.jdbc.driver.T4CResultSetAccessor.unmarshalOneRow(T4CRe
sultSetAccessor.java:165)
    [java]     at oracle.jdbc.driver.T4CTTIrxd.unmarshal(T4CTTIrxd.java:788)
    [java]     at oracle.jdbc.driver.T4CTTIrxd.unmarshal(T4CTTIrxd.java:705)
    [java]     at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:527)
    [java]     at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableSt
atement.java:180)
    [java]     at oracle.jdbc.driver.T4CCallableStatement.execute_for_rows(T4CC
allableStatement.java:783)
    [java]     at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Oracl
eStatement.java:1028)
    [java]     at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(Or
aclePreparedStatement.java:2888)
    [java]     at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePrep
aredStatement.java:2979)
    [java]     at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCall
ableStatement.java:4103)
    [java]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    [java]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcces
sorImpl.java:39)
    [java]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMet
hodAccessorImpl.java:25)
    [java]     at java.lang.reflect.Method.invoke(Method.java:585)
    [java]     at com.sandeep.test.StatementProxy.invoke(StatementProxy
.java:89)
    [java]     at oracle.jdbc.driver.$Proxy1.execute(Unknown Source)
    [java]     at com.sandeep.test.MissedCallsEngineWrappe
r.getSearch(MissedCallsEngineWrapper.java:179)
    [java]     at com.sandeep.test.MissedCallsEngineWrappe
r.main(MissedCallsEngineWrapper.java:116) 

I am not sure if I need to include any other information - please do let me know if anything else is necessary to get an insight into this nagging error.

I am using ANT to build & compile my Java Classes.

Regards,

Sandeep

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 11 2006
Added on Sep 12 2006
5 comments
4,375 views