Re: error fetching BLOB and CLOB data

2009-07-13 Thread Mario Ds Briggs
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 t

error fetching BLOB and CLOB data

2009-07-13 Thread Pat Thatte
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

Re: any way to use wildcards in sqlMapConfig file?

2009-07-13 Thread Clinton Begin
I think the problem with this has always been that there's no way to do a "package" listing of all of the classes/files/resources in a package. So we'd have to convert the package to a file path via a URL (file://) and then do quite a messy hack that would only work *sometimes* (i.e. if your resou

Re: any way to use wildcards in sqlMapConfig file?

2009-07-13 Thread Nathan Maves
This sounds like a reasonable request. I love more convention over configuration, even if it is just less configuration. Wonder if we can get it into IB 3. Might want to submit a ticket so it does not get lost. Nathan On Sat, Jul 11, 2009 at 6:09 AM, Marco Musu wrote: > Hi everyone, > it is po