ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tokajac <imre_to...@hotmail.com>
Subject AS400 Column Mapping Resultset DATE TIME
Date Tue, 02 Dec 2008 15:55:34 GMT


I'm mapping columns of types DATE(10), TIME(8):

<parameter property="ORGDEPDT" jdbcType="DATE" javaType="java.sql.Date"
<parameter property="ORGDEPTM" jdbcType="TIME" javaType="java.sql.Time"

and i get Exception:

--- The error occurred in
--- 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

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?


  If I can get data via SQL SELECT query, I believe that it can be reached
simply from Java/iBatis
View this message in context: http://www.nabble.com/AS400-Column-Mapping-Resultset-DATE-TIME-tp20794393p20794393.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.

View raw message