Hi,
I'm writing a store based on OJB for the Jakarta Slide WebDAV server and one of the main reasons for using OJB is to get database independence. So far it's been ok but now I'm at the point where I need to store the file contents into the database. Naturally I want to use the BLOB data type and I want to make sure that the BLOB is not brought into memory but accessed via io streams. However, it seems that not all databases have a true BLOB type or good JDBC support for it but they all seem to have some support for large objects.
So, what would be the best way to do this?
I haven't actually tested anything but just looking at PostgreSQL, for instance, it doesn't seem that JDBC type BLOB mapped to native bytea type would work, or BLOB to oid (pg large object interface). Note that I want to have a fixed java data type across all databases.
Any suggestions?
Carlos
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
