ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jeff Butler <jeffgbut...@gmail.com>
Subject Re: error fetching BLOB and CLOB data
Date Tue, 14 Jul 2009 14:10:34 GMT
Where in the iBATIS code is this happening?  You haven't given us much to go
on - perhaps an abbreviated stack trace would be in order?
Jeff Butler

On Tue, Jul 14, 2009 at 8:58 AM, Pat Thatte <pat4520@hotmail.com> wrote:

>  Thanks Mario. We are using a "CLI-based Type 2 JDBC Driver" which uses
> jdbc 2.0.
>
> We eliminated the driver as an issue, as I mentioned in my question, by
> using the same datasource with straight SQL. We were able to successfully
> fetch BLOB and CLOB with straight SQL instead of iBATIS.
>
> Any other suggestions would be appreciated.
>
>
> > Subject: Re: error fetching BLOB and CLOB data
> >
> > Pat,
> >
> > looks like you are using a very old version of the DB2 JDBC driver
> (atleast
> > in the iBatis use-case u have detailed below)
> > a - which is not a type 4 JDBC driver
> > b - is a JDBC v1 driver.
> >
> > The versions of DB2 i have seen, dont even ship with that JDBC driver
> > anymore. However here is a link that should be describing your env and
> what
> > u need to do - http://www-01.ibm.com/support/docview.wss?uid=swg21081165
> >
> >
> > Mario
> >
> >
> ---------------------------------------------------------------------------
> >
> > Pat Thatte
> >
> > Subject : error fetching BLOB and CLOB data
> >
> >
> > We have BLOBs and CLOBs in a DB2 v8 database. We use a jdbcType of 'BLOB'
> > or 'CLOB' respectively in our SQL Map file and are getting an error
> > 'CLI0123E SQL data type out of range. SQLSTATE=HY004'.
> >
> > There was an older post about checking the driver type, but we are able
> to
> > fetch the data with the same DataSource using straight SQL.
> >
> > What else could we look at?
> >
> > Thanks,
> > Pat.
>

Mime
View raw message