What DB are you using?

On Jan 26, 2006, at 10:22 AM, Bond= re, Prathit wrote:

Hi Nathan,

Thanks for your response.=

However the #name# a= nd #effDate# do not work in the select statement and my guess is beca= use in a prepared statement you cannot specify a ? in the select.

I have tried this= already.

That= =92s why I had to use the $effDate$ instead and use the statement and= remapResults. It worked for the name but not for the date.

=A0

<= O:P style=3D"color: rgb(0, 0, 128); font-family: Arial; font-size: 13= .3333px; ">=A0

=A0

<= SPAN class=3D"Apple-style-span" style=3D"font-family: Times New Roman= ; font-size: 16px; text-align: center; ">

From: Nathan.Maves@Sun.COM [mailto:Nathan.Maves@Sun.COM]
Sent: Thursday, Jan= uary 26, 2006 11:17 AM
user-java@ibatis.apache.org
Subject: Re: iBatis Subquery and Date error

=A0

Here are a few things to do that will n= ot solve your problem but will help clean it up.
=A0=
1. Use the <insert&= gt; instead of <statement>
<= P class=3D"MsoNormal">2. Don't specify "remapResults" becaus= e you dont have any :)=A0 This option is not available in an <inse= rt> see item #1
=A0
To fix your problem....
=A0
=
use #name# and #effDate#<= /O:P>
=A0
you are also missing the id parameter in the HashMap
=A0=
=A0=
Stick wi= th java.sql.Date.=A0 Try never to use java.util.Date.
=A0=
Nathan
=A0
=A0
=A0
= =A0
<= FONT size=3D"3" face=3D"Times New Roman">On Jan 26, 2006, at 9:41 AM, Bondre, Prathit wrote:= =

I currently have a query defined in my= XML as follows=
=A0<= /P>
<statement id=3D= =94insertQuery=94 parameterClass=3D=94java.util.Map=94 remapResults= =3D=94true=94>
=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0 Insert into table<= FONT color=3D"black">
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 Select
=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 Address,<= /SPAN>
=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 City,
= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0 Zip,<= SPAN style=3D"color:black; font-family: Times New Roman; font-size: 1= 6px; ">
= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0 $name$ as name,
=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 $e= ffDate$ as date<= O:P style=3D"font-family: Times New Roman; font-size: 16px; "><= /SPAN>
=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0 From
= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0 Table= = =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 Where
= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0 Id =3D #id#
</statement>= =A0
When I call it usi= ng the HashMap and set the effDate with java.sql.Date object it throw= s an exception
That the= =A0 value is not compatible with the datatype of the target which is = defined in the database as a Date field.
Also based on the documentation I also tried to pass i= n a java.util.Date instead of the java.sql.Date and it got an error=
=
=93An unexpected toke= n was found=94 and it seemed like it was passing in the String versio= n of the Date field which included the timestamp in the data and it w= as choking on the : in the timestamp.
= =A0
How s= hould I be passing the effDate to this query?<= FONT color=3D"black">
=A0= S= o far I had
HashMap = params =3D new HashMap();Params.put(=93name=94,=94Value=94)
Params.put (=93effDate=94,effDate) // effDate is an in= stance of java.sql.Date . Also tried with java.util.Date.
=A0
What am I doing wrong?
= =A0
Any h= elp will be appreciated.= =A0
Thanks,
Prathit Bondre<= /SPAN>
= =A0

<= O:P style=3D"font-family: Times New Roman; font-size: 16px; "><= /P>
=A0
=

--Boundary_(ID_I97294hl73t2Yr23XZKWJQ)--