Re: confused about storing image data in my database

2005-11-07 Thread Alan Chandler
On Monday 07 Nov 2005 23:10, Jeff Butler wrote: > Ah...sorry. > This is sometimes hard to work through. The problem is that bytea doesn't > map easily to a JDBC type - hence the posgresql documentation telling you > exactly what JDBC method to call. If bytea means that you should call > getBytes()

Re: confused about storing image data in my database

2005-11-07 Thread Jeff Butler
Ah...sorry.   This is sometimes hard to work through.  The problem is that bytea doesn't map easily to a JDBC type - hence the posgresql documentation telling you exactly what JDBC method to call.  If bytea means that you should call getBytes(), then I think you should use a byte[] in your bean, bu

RE: confused about storing image data in my database

2005-11-07 Thread Niels Beekman
november 2005 23:28 To: user-java@ibatis.apache.org Subject: Re: confused about storing image data in my database On Monday 07 Nov 2005 20:56, Jeff Butler wrote: > For BLOBs, the property in your bean should be of type byte[]. In the > result map you may, or may not, need to specify jdbcType

Re: confused about storing image data in my database

2005-11-07 Thread Alan Chandler
On Monday 07 Nov 2005 20:56, Jeff Butler wrote: > For BLOBs, the property in your bean should be of type byte[]. In the > result map you may, or may not, need to specify jdbcType="BLOB" - it's > dependant on the driver (e.g. with DB2 it does not matter). > I'm not familiar with OID - the byte[] an

Re: confused about storing image data in my database

2005-11-07 Thread Jeff Butler
For BLOBs, the property in your bean should be of type byte[].  In the result map you may, or may not, need to specify jdbcType="BLOB" - it's dependant on the driver (e.g. with DB2 it does not matter).   I'm not familiar with OID - the byte[] and BLOB might work.  If not, then try a property of ty