You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Tokajac <im...@hotmail.com> on 2008/12/02 19:36:54 UTC
Re: Problem with date format.
Hello!
I'm mapping columns of types DATE(10), TIME(8):
<parameterMap>
<parameter property="ORGDEPDT" jdbcType="DATE" javaType="java.sql.Date"
mode="OUT"/>
<parameter property="ORGDEPTM" jdbcType="TIME" javaType="java.sql.Time"
mode="OUT"/>
</parameterMap>
and i get Exception:
javax.servlet.ServletException:
*
o
+ The error occurred in
com/linehaul/persistence/sql/LineHaulManifests.xml.
+ The error occurred while applying a parameter map.
+ Check the ApplicationSP.Params.
+ Check the statement (update procedure failed).
+ Cause: java.sql.SQLException: SQL0180 Syntax of date,
time, or timestamp value not valid. Cause . . . . . : The string
representation of a date, time, or timestamp value does not conform to the
syntax for the specified or implied data type and format. *N is either the
character string constant that is not valid or the column or host variable
that contained the string. If the name is *N, then the value is an
expression specified in the statement. If the string was found in a host
variable, the host variable number is 9. Recovery . . . : Ensure that the
date, time, or timestamp value conforms to the syntax for the data type it
represents. Try the request again.
I tried to combine java.util.Date; java.lang.String; java.sql.Date; but no
success so far.
I was changing the URL connection string also (date separator, date format,
time separator, time format properties).
SELECT query called via query browser returns correct resultset, example:
Date: 2008-10-10
Time: 16.48.30
Any useful hint for solving this mapping problem?
Regards
P.S.
I can get data via SQL SELECT query, so I believe that it can be reached
simply from Java/iBatis
--
View this message in context: http://www.nabble.com/Problem-with-date-format.-tp14042017p20798255.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.