Return-Path: 
 <user-java-return-9341-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 84016 invoked from network); 10 Oct 2006 07:10:12 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 10 Oct 2006 07:10:12 -0000
Received: (qmail 49413 invoked by uid 500); 10 Oct 2006 07:10:09 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 49308 invoked by uid 500); 10 Oct 2006 07:10:07 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 49297 invoked by uid 99); 10 Oct 2006 07:10:06 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 10 Oct 2006 00:10:06 -0700
X-ASF-Spam-Status: No, hits=2.0 required=10.0
	tests=HTML_MESSAGE
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.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; Tue, 10 Oct 2006 00:10:03 -0700
Received: (qmail 10809 invoked from network); 10 Oct 2006 09:09:39 +0200
Received: from p54a0e8ad.dip.t-dialin.net (HELO lat) (84.160.232.173)
  by p15187949.pureserver.info with (RC4-MD5 encrypted) SMTP;
 10 Oct 2006 09:09:39 +0200
From: "Zsolt" <zkoppanylist@intland.com>
To: <user-java@ibatis.apache.org>
Subject: RE: iBATIS with the embedded Derby JDBC driver
Date: Tue, 10 Oct 2006 09:09:36 +0200
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_01C0_01C6EC4B.CF53B630"
X-Mailer: Microsoft Office Outlook, Build 11.0.6353
Thread-Index: Acbrr/Wp/Qj4AqWgQUyLMpv54brD4wAirc+w
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
In-Reply-To: <c593b8750610090733g4ad68f09ma82b952759924f8d@mail.gmail.com>
X-Virus-Checked: Checked by ClamAV on apache.org
Message-Id: <20061010071004.9372510FB012@asf.osuosl.org>
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

This is a multi-part message in MIME format.

------=_NextPart_000_01C0_01C6EC4B.CF53B630
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

Thank you Jeff,

 

Why is that necessary if I pass (java.lang.Integer)null?

 

Zsolt

 

  _____  

From: Jeff Butler [mailto:jeffgbutler@gmail.com] 
Sent: Monday, October 09, 2006 4:34 PM
To: user-java@ibatis.apache.org
Subject: Re: iBATIS with the embedded Derby JDBC driver

 

If a column can be null, then you need to specify the JDBC type in the
mapping.  For example:

 

<insert ...>

  insert into sometable (id, desc)

  values(#id:INTEGER#, #desc:VARCHAR#)

</insert>
 

This is true for all the DB2-like databases.

 

Jeff Butler

 


 

On 10/9/06, Zsolt <zkoppanylist@intland.com> wrote: 

Hi,

Our product uses the services of iBATIS and we are using MySQL for the
database layer. We recently tried out the Derby database engine and we 
were mainly successful.

We have an issue though, which seems to be related to iBATIS. While
things are under control with the networked Derby JDBC driver, the
embedded Derby JDBC driver does not work and we systematically receive 
the following stack trace pattern:

java.sql.SQLException: An attempt was made to get a data value of type
'VARCHAR' from a data value of type '0'.
   at
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate
(Ge
neralStatement.java:91)

Based on discussions with the Derby team, the problem seems to appear
due to a misbehaving iBATIS call. More specifically, the
java.sql.PreparedStatement.setNull(int parameterIndex, int sqlType) 
call seems to be always made with the sqlType argument being 0 instead
of the type of the parameter.

We are using iBATIS 2.1.7.597. We did not dive into the iBATIS source
code but instead thought to ask here. Is this a known issue? 

Zsolt

 


------=_NextPart_000_01C0_01C6EC4B.CF53B630
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
 namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags" =
name=3D"PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:blue;
	text-decoration:underline;}
span.E-MailFormatvorlage18
	{mso-style-type:personal-reply;
	font-family:Arial;
	color:blue;
	font-weight:normal;
	font-style:normal;
	text-decoration:none none;}
@page Section1
	{size:595.3pt 841.9pt;
	margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.Section1
	{page:Section1;}
-->
</style>

</head>

<body lang=3DDE link=3Dblue vlink=3Dblue>

<div class=3DSection1>

<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:blue'>Thank you =
Jeff,<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:blue'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DArial><span =
lang=3DEN-GB
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>Why is that =
necessary if
I pass (java.lang.Integer)null?<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DArial><span =
lang=3DEN-GB
style=3D'font-size:10.0pt;font-family:Arial;color:blue'><o:p>&nbsp;</o:p>=
</span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DArial><span =
lang=3DEN-GB
style=3D'font-size:10.0pt;font-family:Arial;color:blue'>Zsolt</span></fon=
t><font
size=3D2 color=3Dblue face=3DArial><span lang=3DEN-GB =
style=3D'font-size:11.0pt;
font-family:Arial;color:blue'><o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DArial><span =
lang=3DEN-GB
style=3D'font-size:10.0pt;font-family:Arial;color:blue'><o:p>&nbsp;</o:p>=
</span></font></p>

<div style=3D'border:none;border-left:solid blue 1.5pt;padding:0cm 0cm =
0cm 4.0pt'>

<div>

<div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font =
size=3D3
face=3D"Times New Roman"><span style=3D'font-size:12.0pt'>

<hr size=3D3 width=3D"100%" align=3Dcenter tabindex=3D-1>

</span></font></div>

<p class=3DMsoNormal><b><font size=3D2 face=3DTahoma><span lang=3DEN-GB
style=3D'font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</spa=
n></font></b><font
size=3D2 face=3DTahoma><span lang=3DEN-GB =
style=3D'font-size:10.0pt;font-family:Tahoma'>
Jeff Butler [mailto:jeffgbutler@gmail.com] <br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> </span></font><font =
size=3D2
face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma'>Monday, October
09, 2006 4:34 PM<br>
<b><span style=3D'font-weight:bold'>To:</span></b> <st1:PersonName =
w:st=3D"on">user-java@ibatis.apache.org</st1:PersonName><br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> Re: iBATIS with =
the
embedded Derby JDBC driver</span></font><o:p></o:p></p>

</div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>If a column can be null, then you need to specify the JDBC type =
in the
mapping.&nbsp; For example:<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>&lt;insert ...&gt;<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>&nbsp; insert into sometable (id, =
desc)<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>&nbsp; values(#id:INTEGER#, =
#desc:VARCHAR#)<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>&lt;/insert&gt;<br>
&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>This is true for all the =
DB2-like&nbsp;databases.<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>Jeff Butler<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><br>
&nbsp;<o:p></o:p></span></font></p>

</div>

<div>

<p class=3DMsoNormal><span class=3Dgmailquote><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'>On 10/9/06, <b><span =
style=3D'font-weight:bold'>Zsolt</span></b>
&lt;<a =
href=3D"mailto:zkoppanylist@intland.com">zkoppanylist@intland.com</a>&gt;=

wrote:</span></font></span> <o:p></o:p></p>

<p class=3DMsoNormal style=3D'margin-bottom:12.0pt'><font size=3D3
face=3D"Times New Roman"><span style=3D'font-size:12.0pt'>Hi,<br>
<br>
Our product uses the services of iBATIS and we are using MySQL for =
the<br>
database layer. We recently tried out the Derby database engine and we =
<br>
were mainly successful.<br>
<br>
We have an issue though, which seems to be related to iBATIS. While<br>
things are under control with the networked Derby JDBC driver, the<br>
embedded Derby JDBC driver does not work and we systematically receive =
<br>
the following stack trace pattern:<br>
<br>
java.sql.SQLException: An attempt was made to get a data value of =
type<br>
'VARCHAR' from a data value of type '0'.<br>
&nbsp;&nbsp; at<br>
com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeUpdate=
 (Ge<br>
neralStatement.java:91)<br>
<br>
Based on discussions with the Derby team, the problem seems to =
appear<br>
due to a misbehaving iBATIS call. More specifically, the<br>
java.sql.PreparedStatement.setNull(int parameterIndex, int sqlType) <br>
call seems to be always made with the sqlType argument being 0 =
instead<br>
of the type of the parameter.<br>
<br>
We are using iBATIS 2.1.7.597. We did not dive into the iBATIS =
source<br>
code but instead thought to ask here. Is this a known issue? <br>
<br>
Zsolt<o:p></o:p></span></font></p>

</div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

</div>

</div>

</body>

</html>

------=_NextPart_000_01C0_01C6EC4B.CF53B630--