db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stanley Bradbury <Stan.Bradb...@gmail.com>
Subject Re: Question about Working With Derby Manual, v10.2
Date Thu, 08 Mar 2007 03:53:45 GMT
John (john@foobox.com) wrote:
> I'm working on Activity 3 of the Working With Derby manual (v10.2 - 
> doc build March 6, 2007, 8:31:05 PM PST).
>
> I'm playing around with the WwwEmbedded.java class and am running into 
> some problems. I can get the program running per the instructions on 
> pages 17 and 18 of the manual. If I enter a "wished item" greater than 
> 32 characters, an exception is thrown (per the note on page 21). My 
> assumption is that this maximum length constraint is due to line 50 of 
> WwwEmbedded.java in which the length of the WISH_ITEM varchar is 
> defined to have a maximum length of 32. I changed this length to a 
> much higher value (e.g., 256) but after recompiling and rerunning, I 
> still have the maximum constraint of 32 characters. Is this correct? 
> Is this due to an inherent constraint on java.sql.PreparedStatement? 
> Your help is appreciated.
>
> Thanks,
> John
>
> -- 
> --------------------------------------
> Be conscious of life
> john@foobox.com <mailto:john@foobox.com> 
Hi John -
The exception is an SqlException which comes from Derby.  The problem is 
that the column of the table is varchar(32).  In addition the the change 
you made you will need to recreate the underlying table with a larger 
column size to allow for larger values.






Mime
View raw message