Thanks for your help, > Hsqldb can deal with binary data, though from what I gather from the > doc, it does not understand the BLOB/CLOB datatypes but rather uses > LONGVARBINARY and LONGVARCHAR. However the hsqldb jdbc driver seems to > implement the Blob-handling API so you should be safe using BLOB on > the JDBC side (mapping it to LONGVARBINARY in the database). I saw that also but on version 1.7.3 and of course I use the 1.7.1 version, but anyway
> The type in SQL Server should be IMAGE, but this depends on the JDBC > driver that you use. For jTDS this will work because it maps BLOB to > IMAGE. I also have an "external" constraint to use the Sun's JDBC-ODBC bridge and I cannot find how to map the SQL Image data type to my Java Blob data type. During execution the driver raises a "[ODBC SQL Server Driver]Invalid SQL data type], SQL code [S1004]" while try to map IMAGE to Blob, either IMAGE to LONGVARBINARY ! Jacques --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
