Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (asf.osuosl.org: domain of gcaddu-derby-user@m.gmane.org
 designates 80.91.229.2 as permitted sender)
To: derby-user@db.apache.org
From: Eike Stepper <stepper@sympedia.com>
Subject: Re: 'VARCHAR' from a data value of type '0'
Date: Tue, 11 Jul 2006 12:31:53 +0200
Lines: 35
Message-ID: <e8vumn$23r$1@sea.gmane.org>
References: <e8d7dh$5an$1@sea.gmane.org> <wjo864idlj60.fsf@sun.com>
 <e8dnnk$pje$1@sea.gmane.org> <wjo81wt0lbvs.fsf@sun.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
User-Agent: Thunderbird 1.5.0.4 (Windows/20060516)
In-Reply-To: <wjo81wt0lbvs.fsf@sun.com>
Sender: news <news@sea.gmane.org>


Knut Anders Hatlen schrieb:
> Eike Stepper <stepper@sympedia.com> writes:
> 
>> Knut Anders Hatlen schrieb:
>>> Eike Stepper <stepper@sympedia.com> writes:
>>>
>>> [...]
>>>
>>> It seems like setNull() is called with 0 as type id (second argument)
>>> at line 95 in StatementCreatorUtils.java. It should work if you change
>>> the type id to java.sql.Types.VARCHAR.
>> Hi Knut,
>>
>> Thx for your quick reply.
>> Unfortunately the call to setNull() is in the Spring Framework,
>> which I can't change ;-(
> 
> How do you supply the null to Spring? There should be a way to tell
> Spring to use the correct type id.
> 
> My guess after looking at your stack trace and the Spring code, is
> that org.eclipse.emf.cdo.server.impl.MapperImpl.sql() invokes the
> org.springframework.jdbc.core.JdbcTemplate.update() method with two
> parameters (String sql, Object[] args). There is also an update method
> with three parameters (String sql, Object args[], int[] argTypes). You
> could try to use that one instead.

Yeah, that works ;-)
Many Thanks!

Cheers
/Eike