BLOB is a JDBC datatype that is mapped by the concrete JDBC driver (which is database specific) to the real database SQL type. In the case of PostgreSQL, the jdbc driver maps it to bytea. You can see the difference in the related OJB files: in repository.xml you use BLOB as the datatype, and in the database schema (Torque files or SQL calls), you use the corresponding database type, e.g. bytea for PostgreSQL.
So, IMO your best bet is using BLOB, e.g. via java.sql.Blob objects. I'm not sure whether BLOB support is required for some JDBC level (perhaps 2.0 ?), but every JDBC-supported database that has a large binary datatype should have a BLOB-supporting JDBC driver. Tom --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
