The manual warns that the blob implementions in some JDBC drivers do not work properly. Are blobs supposed to work with Postgres?

I am using Postgres 8 and Hibernate 2.1.7c.

When I try to fetch an object that has a blob field (contains XML) from the database, the Postgres JDBC driver apparently tries to coerce the blob value into an int!

Caused by: org.postgresql.util.PSQLException: Bad value for type int : <?xml version="1.0" encoding="UTF-8"?>...
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.toInt(AbstractJdbc2ResultSet.java:2508)
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getInt(AbstractJdbc2ResultSet.java:1984)
at org.postgresql.jdbc3.Jdbc3ResultSet.getBlob(Jdbc3ResultSet.java:54)
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getBlob(AbstractJdbc2ResultSet.java:312)
at net.sf.hibernate.type.BlobType.get(BlobType.java:32)
...

Blobs will work on Postgres in 3.0 final.

If you really need it, I can backport this to 2.1.x (you could easily backport it yourself.)

Thank you for the reply.

The reason why I am using 2.x and not 3.0 is that a month ago I could not find a 3.0-compatible replacement for hibernate-tools.jar. I need hbm2java.CodeGenerator (with finder generation) and hbm2ddl.SchemaExport.