File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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
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.
I agree. Here's the link:
subject: Column Mapping Resultset DATE TIME
It's not a secret anymore!