File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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 OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "Column Mapping Resultset DATE TIME" Watch "Column Mapping Resultset DATE TIME" New topic
Author

Column Mapping Resultset DATE TIME

Imre Tokai
Ranch Hand

Joined: Jun 04, 2008
Posts: 130
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.processException(RequestProcessor.java:535)


Any useful hint for solving this?


Regards
David Newton
Author
Rancher

Joined: Sep 29, 2008
Posts: 12617

This is a database or ORM question, not Struts.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Column Mapping Resultset DATE TIME