Wrox Home  
Search P2P Archive for: Go

  Return to Index  

pro_java_server thread: Re: 255 character limitation with preparedstatemt


Message #1 by niko77@r... on Thu, 1 Nov 2001 12:29:05
hi

this is a problem with the JDBC PreparedStatement.setString() method.
It does not allow you to set a string more than 255 chars.
Instead try PreparedStatement.setClob() method for character data more than
255 chars

cheers

niko
> I've created an insert statement that uses the preparedstatement.  I've
> noticed that my JSP is truncating anything over the 255th character.  The
> database is running in Access 2000 temporarily.  I'm wondering if the
> limitation is with the prepared statement?  The database field is a memo
> field which has > than 255 character limit.  Could it be an ODBC JDBC 
thing?
> 
> 
> ohh..and I am using the POST method on my HTML form.
> 
> appreciate any insight.
> 
> thanks in advance,
> 
> BK
> 
> 
> 
> -----Original Message-----
> From: Chanoch Wiggers [mailto:ChanochW@w...]
> Sent: Friday, October 12, 2001 7:14 AM
> To: Java Server
> Subject: [pro_java_server] RE: starting WSAdmin Server
> 
> 
> this is probably some kind of file related problem - windows cant find a
> required file or it cant open a file it needs or it is being handed an
> inknown or incompatible file format. Do you have any more info, what 
version
> of windows, what error detail do you get?
> 
> chanoch
> 
> -----Original Message-----
> From: henry bonghanoy [mailto:henzki@e...]
> Sent: 08 October 2001 06:03
> To: Java Server
> Subject: [pro_java_server] starting WSAdmin Server
> 
> 
> 
> 
> hi friends,
> 
>  Is anyone knows this problem message? "Windows could not start IBM 
> WSAdmin Server on local Computer.Service specific error code 10"
>  PLs help mee.....
> 
> Regards,
> henry
> 
> 

  Return to Index