On 5/18/05, Jacques Desmazieres <[EMAIL PROTECTED]> wrote: > We have an application running OJB on Oracle 8i / 9i, HsqlDB and MSDE. As we > add functionalities we now have to include large binary object (actually to > store pdf content). > > My problem, is that I do not want to have mapping files depending on the > database. > > The application is working for Oracle, using a Blob column, mapped on Blob > Jdbc-type. But it seems it cannot work with HsqlDB, but I can deal with that > if not possible (HsqlDB is actually our dev database). But I definitly need > to have this feature available with MSDE. > > So what MSDE column data type should I use, mapped on which jdbc-type. Of > course the mapping file should be the same for MSDE and Oracle.
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). 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. Tom --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
