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:[EMAIL PROTECTED]> >For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>