Return-Path: 
 <derby-user-return-9872-apmail-db-derby-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-derby-user-archive@www.apache.org
Received: (qmail 65225 invoked from network); 7 Oct 2008 02:16:37 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 7 Oct 2008 02:16:36 -0000
Received: (qmail 85454 invoked by uid 500); 7 Oct 2008 02:16:34 -0000
Delivered-To: apmail-db-derby-user-archive@db.apache.org
Received: (qmail 85429 invoked by uid 500); 7 Oct 2008 02:16:34 -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 85418 invoked by uid 99); 7 Oct 2008 02:16:34 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 06 Oct 2008 19:16:34 -0700
X-ASF-Spam-Status: No, hits=-3.9 required=10.0
	tests=DNS_FROM_SECURITYSAGE,RCVD_IN_DNSWL_MED,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: local policy)
Received: from [192.18.6.21] (HELO gmp-eb-inf-1.sun.com) (192.18.6.21)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 07 Oct 2008 02:15:30 +0000
Received: from fe-emea-09.sun.com (gmp-eb-lb-2-fe3.eu.sun.com [192.18.6.12])
	by gmp-eb-inf-1.sun.com (8.13.7+Sun/8.12.9) with ESMTP id m972G0dI001476
	for <derby-user@db.apache.org>; Tue, 7 Oct 2008 02:16:04 GMT
Received: from conversion-daemon.fe-emea-09.sun.com by fe-emea-09.sun.com
 (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007))
 id <0K8C00I01JGNHD00@fe-emea-09.sun.com>
 (original mail from Dag.Wanvik@Sun.COM) for derby-user@db.apache.org; Tue,
 07 Oct 2008 03:16:00 +0100 (BST)
Received: from khepri23.norway.sun.com ([129.159.112.235])
 by fe-emea-09.sun.com
 (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007))
 with ESMTPSA id <0K8C00BGEJMNN1C0@fe-emea-09.sun.com> for
 derby-user@db.apache.org; Tue, 07 Oct 2008 03:15:59 +0100 (BST)
Date: Tue, 07 Oct 2008 04:15:58 +0200
From: Dag.Wanvik@Sun.COM (Dag H. Wanvik)
Subject: Re: help me
In-reply-to: <48E91139.1000200@elfyard.com>
Sender: Dag.Wanvik@Sun.COM
To: Derby Discussion <derby-user@db.apache.org>
Message-id: <x1oxiqs5w3oh.fsf@sun.com>
MIME-version: 1.0
Content-type: text/plain; charset=utf-8
Content-transfer-encoding: QUOTED-PRINTABLE
References: <BLU122-DS68EB6BAFC112D087D63238C3C0@phx.gbl>
 <48E91139.1000200@elfyard.com>
User-Agent: Gnus/5.1008 (Gnus v5.10.8) Emacs/22.1 (usg-unix-v)
X-Virus-Checked: Checked by ClamAV on apache.org

Valentin Cozma <vcozma@elfyard.com> writes:

> =E8=B5=B5=E5=B3=B0 wrote:
>> Apache Derby Network Server =EF=BC=8D 10.4.2.0
>> String sql=3D"insert into test (id,name) value(1,?)";
>> PreparedStatement ps=3Dcon.prepareStatement(sql);
>> ps.setObject(1,null);
>> ps.executeUpdate()
>
>
> try something like this :
>
> ps.setNull(1, Types.Integer);

Yes, the error message says something like "type not supported" as fa=
r
as I can understand, so try to use the set<type> method of the <type>
for the column "name" - setString ?

Supporting this, in English locale, using ps.setObject(1,null) instea=
d
of ps.setNull(1, Types.String) gave me this error message:

java.sql.SQLException: Type is not supported