Re: Strange problems and wrong data on Linux (redhat) not on Windows

2008-11-25 Thread Corné A
Thanks Jeff , I noticed earlier that the BigDecimals I already had kept working. I swapped al other Numerics to BigDecimals with the javaTypeResolver and hurray al worked again. Still it's strange that non BigDecimals work as Keys but not as values, A fact is that it is a very odd database and t

Re: Strange problems and wrong data on Linux (redhat) not on Windows

2008-11-25 Thread Jeff Butler
You can force Abator to generate BigDecimals for these fields with this configuration setting: This might be better in your case as it seems that the UNIX driver has some difficulty converting BigDecimals to Short or Integer. Jeff Butler On Tue, Nov 25, 2008 at 5:27 AM, Corné A <[EMAIL PRO

Re: Strange problems and wrong data on Linux (redhat) not on Windows

2008-11-25 Thread Corné A
BTW: this behaviour only occurs on UPDATE setted values NOT on the where keys

Re: Strange problems and wrong data on Linux (redhat) not on Windows

2008-11-25 Thread Corné A
Ok I tested my but off and here is what I found: All fields from this database are or CHAR or NUMERIC (see bottom voor META info) the problematic columns both are NUMERIC without scale vdperc DATA_TYPE:2 TYPE_NAME:numeric PRECISION:3 LENGTH:3 SCALE:0 RADIX:0 NULLABLE:1 vdmuwe DATA_TYPE:2 TYPE_NAME

Re: Strange problems and wrong data on Linux (redhat) not on Windows

2008-11-25 Thread Corné A
Thanks for your interst but no. this is a very odd Database UNIMS and were stuck to it. We have a windows Driver and a Unix driver. I tested some type 3 Drivers but they are intended for network connections and not local and are 200% slower than the 'not recommended' ODBC-JDBC bridge' But I'm pret

Re: Strange problems and wrong data on Linux (redhat) not on Windows

2008-11-25 Thread Nicholoz Koka Kiknadze
> > > >> When I deploy everthing to a Linux box I get the weirdest errors from the >> Driver. >> --- Cause: java.sql.SQLException: [unixODBC][INTERCHAIN][UNIMS-ODBC] >> [UNIMS] >> > Well, maybe we can blame differences in ODBC layer? I've have never used ODBC (or ODBC-JDBC bridge) on linux, any cha

Re: Strange problems and wrong data on Linux (redhat) not on Windows

2008-11-25 Thread Corné A
For what its worth; I also tested it against the ibatis-2.3.4.726.jar build and all problems occur the same. 2008/11/24 Corné A <[EMAIL PROTECTED]> > Hi all, > I am a happy ibatis user for years and now I have encountered a strange > thing. > > I have Ibatis build with jdk 1.5.0_16 on my Windows

Strange problems and wrong data on Linux (redhat) not on Windows

2008-11-24 Thread Corné A
Hi all, I am a happy ibatis user for years and now I have encountered a strange thing. I have Ibatis build with jdk 1.5.0_16 on my Windows XP. When updating with any of the 4 abator generated stubs on either jdk 1.5 or 1.6 I encounter *no* problems on a windows XP box. When I deploy everthing to a