Given that it 2 versions of oracle, 2 versions of mysql, and a different version of derby, I'd say it's most likely a bug in either the jdbc driver or the database server.
Your best bet is to reproduce the bug with straight JDBC, and post it to the derby-dev@ list. Larry On 9/11/07, Zsolt Koppany <[EMAIL PROTECTED]> wrote: > Larry, > > as I described it in a previous email our application does work with > oracle-10, oracle-9, mysql-4, mysql-5 and derby 10.2.2.0 and we have this > problem only with derby 10.3.1.4. > > I understand that we could get it running (with huge efforts) also under > 10.3.1.4 but we should modify approx. 400 statements and it would be hard to > test the modifications (this is the biggest problem). > > I just don't understand why derby 10.3.1.4 behaves differently like other > databases including derby 10.2.2.0 and I'm sure that most ibatis > applications won't work with 10.3.1.4. > > Derby 10.3.1.4 is currently no-go for us. > > Zsolt > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf > > Of Larry Meadors > > Sent: Saturday, September 08, 2007 4:43 PM > > To: [EMAIL PROTECTED] > > Cc: Derby Discussion > > Subject: Re: Derby 10.3.1.4 not working with ibatis-2.3.0.677 > > > > Actually, you can tell iBATIS the type (see page 29 in the user guide) > > - in an insert or update, user the following notation: > > > > #property:JDBCTYPE# > > > > You can get a list of the valid JDBC types here: > > > > http://java.sun.com/j2se/1.5.0/docs/api/java/sql/Types.html > > > > So if your property is named address, and the type is VARCHAR it would > > be #address:VARCHAR#. > > > > Larry > > > > > > On 9/8/07, Zsolt Koppany <[EMAIL PROTECTED]> wrote: > > > Knut, > > > > > > thank you fort he info, but not my application but ibatis uses jdbc code > > and > > > I cannot do anything about. > > > > > > Our application does work with oracle-10, oracle-9, mysql-4, mysql-5 and > > > derby 10.2.2.0 and we have this problem only with derby 10.3.1.4. > > > > > > We cannot modify ibatis. Is that possible to get a derby-client that > > works > > > as before or we cannot use derby in the future? > > > > > > Zsolt > > > > -----Original Message----- > > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > > > Sent: Friday, September 07, 2007 9:16 AM > > > > To: Derby Discussion > > > > Subject: Re: Derby 10.3.1.4 not working with ibatis-2.3.0.677 > > > > > > > > Zsolt Koppany <[EMAIL PROTECTED]> writes: > > > > > > > > > Hi, > > > > > > > > > > I tried to upgrade to derby 10.3.1.4 but I get strange error > > messages > > > > that I > > > > > didn't get with derby 10.2.2.0. > > > > > > > > > > I use 10.3.1.4 with ibatis-2.3.0.677. > > > > > > > > > > Any ideas? > > > > [...] > > > > > --- Cause: java.sql.SQLException: An attempt was made to get a data > > > > value of > > > > > type '<UNKNOWN>' from a data value of type 'VARCHAR'. > > > > [...] > > > > > at org.apache.derby.client.am.PreparedStatement.setNull(Unknown > > > > Source) > > > > > > > > Hi, > > > > > > > > It seems like your application calls PreparedStatement.setNull() with > > an > > > > invalid type specification. If you change the type to > > > > java.sql.Types.VARCHAR, it will probably work. This was changed in > > > > 10.3.1.4 to make the network client driver and the embedded driver > > > > behave the same way. Please see this section in the release notes for > > > > details: > > > > > > > > http://db.apache.org/derby/releases/release-10.3.1.4.cgi#N10C87 > > > > > > > > -- > > > > Knut Anders > > > > > > > >