Thread: Re: RES: Problems retrieving data from bytea field

----- Original Message -----

From: Sherman Wood

To: pgsql-jdbc@postgresql.org

Sent: Tuesday, May 20, 2003 5:13 AM

Subject: Re: [JDBC] RES: Problems retrieving data from bytea field

Original post: http://archives.postgresql.org/pgsql-jdbc/2003-04/msg00105.php

 

I am still having problems with this. My environment is JDK 1.4.1_02, Win2K, Eclipse 2.1, Postgres 7.3.2.

 

When I select a row with a bytea in it and try to get the blob, I am getting the following behavior:

 

Under pg72jdbc2.jar:

 

Bad Integer <?xml version="1.0"?>\012<!DOCTYPE hibernate-mapping PUBLIC ....
 at org.postgresql.jdbc2.ResultSet.toInt(ResultSet.java:1481)
 at org.postgresql.jdbc2.ResultSet.getInt(ResultSet.java:247)
 at org.postgresql.jdbc2.ResultSet.getBlob(ResultSet.java:934)
 at org.postgresql.jdbc2.ResultSet.getBlob(ResultSet.java:929)
 at net.sf.hibernate.type.BlobType.get(BlobType.java:26)
 at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:59)
 at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:51)
 at net.sf.hibernate.type.AbstractType.hydrate(AbstractType.java:65)
 at net.sf.hibernate.loader.Loader.hydrate(Loader.java:408)
 at net.sf.hibernate.loader.Loader.loadFromResultSet(Loader.java:358)
 at net.sf.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:332)
 at net.sf.hibernate.loader.Loader.getRow(Loader.java:273)
 at net.sf.hibernate.loader.Loader.doFind(Loader.java:150)
 at net.sf.hibernate.loader.Loader.find(Loader.java:602)
 at net.sf.hibernate.hql.QueryTranslator.find(QueryTranslator.java:860)
 at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1338)
 at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1317)
 at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1309)
 at com.galenworks.procedurelink.hibernate.test.Populate.test6(Populate.java:374)
 at com.galenworks.procedurelink.hibernate.test.Populate.main(Populate.java:411)

Under pg73jdbc2.jar:

 

Bad Integer <?xml version="1.0"?>\012<!DOCTYPE hibernate-mapping PUBLIC \012...
 at org.postgresql.jdbc1.AbstractJdbc1ResultSet.toInt(AbstractJdbc1ResultSet.java:700)
 at org.postgresql.jdbc1.AbstractJdbc1ResultSet.getInt(AbstractJdbc1ResultSet.java:144)
 at org.postgresql.jdbc3.Jdbc3ResultSet.getBlob(Jdbc3ResultSet.java:41)
 at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getBlob(AbstractJdbc2ResultSet.java:262)
 at net.sf.hibernate.type.BlobType.get(BlobType.java:26)
 at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:59)
 at net.sf.hibernate.type.NullableType.nullSafeGet(NullableType.java:51)
 at net.sf.hibernate.type.AbstractType.hydrate(AbstractType.java:65)
 at net.sf.hibernate.loader.Loader.hydrate(Loader.java:408)
 at net.sf.hibernate.loader.Loader.loadFromResultSet(Loader.java:358)
 at net.sf.hibernate.loader.Loader.instanceNotYetLoaded(Loader.java:332)
 at net.sf.hibernate.loader.Loader.getRow(Loader.java:273)
 at net.sf.hibernate.loader.Loader.doFind(Loader.java:150)
 at net.sf.hibernate.loader.Loader.find(Loader.java:602)
 at net.sf.hibernate.hql.QueryTranslator.find(QueryTranslator.java:860)
 at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1338)
 at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1317)
 at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1309)
 at com.galenworks.procedurelink.hibernate.test.Populate.test6(Populate.java:367)
 at com.galenworks.procedurelink.hibernate.test.Populate.main(Populate.java:404)

 

Any help would be appreciated.

 

Thanks,

 

 

Sherman