Help coderanch get a
new server
by contributing to the fundraiser
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Column Mapping Resultset DATE TIME

 
Ranch Hand
Posts: 130
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
 
Author
Posts: 12617
IntelliJ IDE Ruby
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
This is a database or ORM question, not Struts.
 
All of the world's problems can be solved in a garden - Geoff Lawton. Tiny ad:
We need your help - Coderanch server fundraiser
https://coderanch.com/t/782867/Coderanch-server-fundraiser
reply
    Bookmark Topic Watch Topic
  • New Topic