ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mario Ds Briggs <mario.bri...@in.ibm.com>
Subject Re: error fetching BLOB and CLOB data
Date Tue, 14 Jul 2009 04:06:50 GMT
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                                                    
             <pat4520@hotmail.                                             
             com>                                                       To 
                                       <user-java@ibatis.apache.org>       
             14/07/2009 02:07                                           cc 
                                                                           
                                                                   Subject 
             Please respond to         error fetching BLOB and CLOB data   
             user-java@ibatis.                                             
                apache.org                                                 
                                                                           
                                                                           
                                                                           
                                                                           




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.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


Mime
View raw message