tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Eric Everman <ever...@precedadesign.com>
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 www.sourceforge.org

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.
>
>Regards,
>
>Paul
>
>
>_________________________________________________________________
>Send and receive Hotmail on your mobile device: http://mobile.msn.com
>
>
>--
>To unsubscribe, e-mail:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
>For additional commands, e-mail: <mailto:tomcat-user-help@jakarta.apache.org>


--
To unsubscribe, e-mail:   <mailto:tomcat-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-user-help@jakarta.apache.org>


Mime
View raw message