opensubscriber
   Find in this group all groups
 
Unknown more information…

o : ojb-user@db.apache.org 1 December 2008 • 12:39AM -0500

AS400 Column Mapping Resultset DATE TIME
by Tokajac

REPLY TO AUTHOR
 
REPLY TO GROUP




Hello,


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

<parameter property="ORGDEPDT" jdbcType="DATE" javaType="java.lang.String"
mode="OUT"/>
<parameter property="ORGDEPTM" jdbcType="TIME" javaType="java.lang.String"
mode="OUT"/>
<parameter property="DSTDEPDT" jdbcType="DATE" javaType="java.lang.String"
mode="OUT"/>
<parameter property="DSTDEPTM" jdbcType="TIME" javaType="java.lang.String"
mode="OUT"/>


and i get Exception:

javax.servlet.ServletException:
--- 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.
org.apache.struts.action.RequestProcessor.processE
xception(RequestProcessor.java:535)


Any useful hint for solving this?


Regards
--
View this message in context: http://www.nabble.com/AS400-Column-Mapping-Resultset-DATE-TIME-tp20758759p20758759.html
Sent from the Apache DB - ObjectRelationalBridge Users mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.a...
For additional commands, e-mail: ojb-user-help@db.a...

Bookmark with:

Delicious   Digg   reddit   Facebook   StumbleUpon

opensubscriber is not affiliated with the authors of this message nor responsible for its content.