This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes Struts and the fly likes Column Mapping Resultset DATE TIME Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "Column Mapping Resultset DATE TIME" Watch "Column Mapping Resultset DATE TIME" New topic

Column Mapping Resultset DATE TIME

Imre Tokai
Ranch Hand

Joined: Jun 04, 2008
Posts: 130

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:

--- 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.

Any useful hint for solving this?

David Newton

Joined: Sep 29, 2008
Posts: 12617

This is a database or ORM question, not Struts.
Don't get me started about those stupid light bulbs.
subject: Column Mapping Resultset DATE TIME
Similar Threads
iBatis Stored Procedure call
IBATIS - multiple parameter
Error in updating a table in mysql using IBATIS
jdbctype for enum in parameterMap's parameter in IBATIS
AS400 Column Mapping Resultset DATE TIME