Re: java.sql.SQLException: Data size bigger than max size for this type: 3991

From: Laurenz Albe <invite_at_spam.to.invalid>
Date: 25 Jul 2008 06:49:51 GMT
Message-ID: <1216968590.919310@proxy.dienste.wien.at>


uday <uday1067_at_gmail.com> wrote:
> i have been using setString() of prepared statement. but it is giving
> me
> java.sql.SQLException: Data size bigger than max size for this type:
> 3991 exception. where as as per my understanding, the size of varchar2
> is 4000.
>
> can someone suggest the solution

Well, how is the field defined? What is the value you want to store? What is the database character set?

Yours,
Laurenz Albe Received on Fri Jul 25 2008 - 01:49:51 CDT

Original text of this message