Re: Blob

2005-05-22 Thread Brandon Goodin
umm... how dumb do you have to be to do something like that? uurmm... oh yeah... i did that too! Brandon On 5/22/05, Larry Meadors <[EMAIL PROTECTED]> wrote: > One almost unrelated thing on this (that I have screwed up before) is > that you may want to leave out the blob unless you really, really

Re: Blob

2005-05-22 Thread Larry Meadors
One almost unrelated thing on this (that I have screwed up before) is that you may want to leave out the blob unless you really, really need it. :-) Imagine 10-20 users in a web app loading up these lists...and all of those blobs getting suffed into memory. ;-) Larry On 5/22/05, Lieven De Keyze

Re: Blob

2005-05-22 Thread Brandon Goodin
This should help: http://opensource.atlassian.com/confluence/oss/display/IBATIS/How+do+I+use+a+Custom+Type+Handler+with+a+BLOB+or+CLOB%3F Brandon On 5/22/05, Lieven De Keyzer <[EMAIL PROTECTED]> wrote: > I want to retrieve the values from a table where 1 column is of type Blob. > My Bean to stor

Re: BLOB and CLOB FAQ page now restored.

2005-05-07 Thread Clinton Begin
Awesome Nathan.  Thanks so much for fixing that. Clinton On 5/4/05, Nathan Maves <[EMAIL PROTECTED]> wrote: Team,I have restored the FAQ on one way to use the built in BLOB and CLOBCustom Type Handlers (CTH).  I have also added a section near thebottom on the to common problems.- 86 length on the

RE: BLOB type handler

2005-05-04 Thread Yee, Richard K, CTR,, DMDCWEST
Ming, Since BLOBs can contain binary data, some values cannot be represented in a Java String variable (ie. 0). -Richard -Original Message- From: Ming Xue [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 04, 2005 11:07 AM To: 'ibatis-user-java@incubator.apache.org' Subject: RE:

Re: BLOB type handler

2005-05-04 Thread Brandon Goodin
inal Message- > From: Brandon Goodin [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 04, 2005 1:58 PM > To: ibatis-user-java@incubator.apache.org > Subject: Re: BLOB type handler > > This link may help you. We used to have a FAQ on our wiki that dealt > with it. But, recent tran

RE: BLOB type handler

2005-05-04 Thread Ming Xue
I try to map BLOB to byte[] and it works, BUT the question is : How to map BLOB to String? and other possible java types? -Original Message- From: Brandon Goodin [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 04, 2005 1:58 PM To: ibatis-user-java@incubator.apache.org Subject: Re: BLOB

Re: BLOB type handler

2005-05-04 Thread Brandon Goodin
> How should I use the Custom Type handler to handle these cases ? or there > are other ways? > > thanks > > > -Original Message- > From: Brandon Goodin [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 04, 2005 12:48 PM > To: ibatis-user-java@incubato

RE: BLOB type handler

2005-05-04 Thread Ming Xue
should I use the Custom Type handler to handle these cases ? or there are other ways? thanks -Original Message- From: Brandon Goodin [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 04, 2005 12:48 PM To: ibatis-user-java@incubator.apache.org Subject: Re: BLOB type handler Depends on

Re: BLOB type handler

2005-05-04 Thread Brandon Goodin
Depends on what database you are using and how their driver supports it. Please provide more information. Brandon On 5/4/05, Ming Xue <[EMAIL PROTECTED]> wrote: > I am doing some testing on Custom Type Handler, in my project, BLOB is > mapped to a "String" type java bean property, it seems the

Re: BLOB Field

2005-02-17 Thread äåå
Use ibatis's typeHandler. On Wed, 16 Feb 2005 16:56:59 +0100, BOUSSEBHA Djamel <[EMAIL PROTECTED]> wrote: > Hi; > > I use into my j2ee application, the Ibatis tool for database access. Another > external application stores into this database of the documents (pdf) in > using of the fields BLOB

Re: BLOB Field

2005-02-17 Thread Brice Ruth
Version 2.0.9 of iBATIS supports BLOB field to byte[], as long as the JDBC driver you're using "does the right thing". So, just define a byte[] field in your javabean and have a go, post back if it doesn't work! On Wed, 16 Feb 2005 16:56:59 +0100, BOUSSEBHA Djamel <[EMAIL PROTECTED]> wrote: >

Re: BLOB/LONGBLOB w/ MySQL & Connector/J

2005-01-10 Thread Brice Ruth
I got it all working. Ya know, the crazy thing is - I ended up googling and writing a TypeHandlerCallback and kept getting frustrated that wasNull kept returning false and getBlob() kept returning null. Until I started checking my SQL statement against the database ... and found that the record it

Re: BLOB/LONGBLOB w/ MySQL & Connector/J

2005-01-09 Thread Clinton Begin
Yes, definitely specify the types as javaType="byte" and jdbcType="BLOB". Also be sure to use iBATIS 2.0.9, as it is the first to have included BLOB/CLOB type handlers. If that doesn't work (i.e. if MySQL doesn't support standard JDBC BLOB API), then you may have to write a custom type handler.

Re: BLOB/LONGBLOB w/ MySQL & Connector/J

2005-01-09 Thread Nathan Maves
Are you using a result map? If so send it out. If you are not then you need to specify the type inline. Nathan On Jan 9, 2005, at 12:27 PM, Brice Ruth wrote: I'm using the latest Connector/J driver (3.1.6) for MySQL 3.23.58 (don't ask - inherited database). Anyway, I've never much used BLOB fie