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 <[email protected]> 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. >
