Re: java.sql.SQLException: Bigger type length than Maximum

Ravi,

I made a slight error in my previous email. The problem occurs when one of the rows returned in the query had a field that had exactly 254 chars. It also occured with 509 chars.

You say that your fields are only varchar2(100). It could be that there is some length below 100 which also causes the problem.

Hope this helps
Mick

Ravi Iyer wrote:

> We are having a serious problem with the Oracle thin driver
> or JDBC, where it raises an exception while iterating in the
> resultset when retrieving a large no. of records.
>
> The actual exception is below:
> java.sql.SQLException: Bigger type length than Maximum
>
> This happens after say about 15000 rows or so.
> Is this a size issue or something else.
> Doesn't seem to be a datatype issue, as we are
> only retrieving numbers/varchar(100) and the
> query retrieves all records if split into multiple
> smaller queries.
> Is there some setting in the driver ?
> I recall reading a troubleshooting section in the
> Oracle JDBC documentation. Now that link
> is dead.
> What is the solution/workaround ?
>
> Thx,
> Ravi.
> PS> Please include response to riyer_at_cisco.com
Received on Thu Apr 30 1998 - 00:00:00 CDT