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

confused about storing image data in my database

2005-11-07 Thread Alan Chandler
Having made the first release of my family tree application its time to look to the future. Once of the things that has been suggested to me is to store pictures of the people and their marriages in the database. I am using Postgres which seems to have more than one method of binary storage.