Return-Path: 
 <derby-user-return-7574-apmail-db-derby-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-derby-user-archive@www.apache.org
Received: (qmail 85769 invoked from network); 8 Sep 2007 11:36:37 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 8 Sep 2007 11:36:37 -0000
Received: (qmail 92411 invoked by uid 500); 8 Sep 2007 11:36:30 -0000
Delivered-To: apmail-db-derby-user-archive@db.apache.org
Received: (qmail 92385 invoked by uid 500); 8 Sep 2007 11:36:29 -0000
Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:derby-user-help@db.apache.org>
list-unsubscribe: <mailto:derby-user-unsubscribe@db.apache.org>
List-Post: <mailto:derby-user@db.apache.org>
List-Id: <derby-user.db.apache.org>
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Delivered-To: mailing list derby-user@db.apache.org
Received: (qmail 92374 invoked by uid 99); 8 Sep 2007 11:36:29 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 08 Sep 2007 04:36:29 -0700
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=MISSING_MID,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: local policy)
Received: from [212.227.76.129] (HELO www.intland.com) (212.227.76.129)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 08 Sep 2007 11:37:51 +0000
Received: (qmail 32307 invoked from network); 8 Sep 2007 13:36:05 +0200
Received: from 85-127-233-197.dynamic.xdsl-line.inode.at (HELO d820)
 (85.127.233.197)
  by p15187949.pureserver.info with SMTP; 8 Sep 2007 13:36:05 +0200
From: "Zsolt Koppany" <zkoppanylist@intland.com>
To: "'Derby Discussion'" <derby-user@db.apache.org>
Cc: <user-java@ibatis.apache.org>
Subject: RE: Derby 10.3.1.4 not working with ibatis-2.3.0.677
Date: Sat, 8 Sep 2007 13:36:03 +0200
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Office Outlook, Build 11.0.5510
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
In-Reply-To: <wjo8odgfq730.fsf@sun.com>
Thread-Index: AcfxHwE2v+rAVEwASF6wsXhyoUBDgQA7PSRQ
X-Virus-Checked: Checked by ClamAV on apache.org
Message-Id: <20070908113759.D9BEA4DA0A5@nike.apache.org>

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: Knut.Hatlen@Sun.COM [mailto:Knut.Hatlen@Sun.COM]
> 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 <zkoppanylist@intland.com> 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