tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Eric Everman <>
Subject Re: Storing Java Objects in SQL
Date Wed, 12 Jun 2002 18:02:52 GMT
I'm not all that familiar with MS SQL, but is it possible that there is a 
size restriction on the binary field in the underlying db?  Also, if you 
would like to do this in a more structured way such as mapping property 
values to db fields, check out the Hibernate project at

Good luck,

Eric Everman

At 12:38 PM 6/12/2002, you wrote:
>Hi all,
>I'm trying to store objects (instances) of a class in Microsoft SQL Server 
>2K using the Microsoft-provided JDBC driver, but I've been without any 
>luck thus far.
>I've used the setObject() method in the PreparedStatement class and set my 
>target sql type to "BINARY", yet it doesn't work, I keep getting an 
>SQLException. A look at the driver documentation shows that this method is 
>supported while set/getBlob() aren't.
>Is what I'm trying to achieve impossible or am I doing something wrong?
>I could serialize the objects to disk but I'll have files lying all over 
>the place - storing them in the database per user would be much neater.
>I need help fast! I'm Thanks.
>Send and receive Hotmail on your mobile device:
>To unsubscribe, e-mail:   <>
>For additional commands, e-mail: <>

To unsubscribe, e-mail:   <>
For additional commands, e-mail: <>

View raw message