java - Date insert to sqlite db using hibernate -


for learning purpose have created simple application using sqlite db along hibernate , struts 2. in trying insert row table - user(id,mydate). insertion happening without error, when retrieve data db , try display on screen, displays incorrect data. don't know wrong doing. value of date column retrieved 1/1/70 5:30:02 am.007. below code might related this.

user.java

public class user implements serializable {      private integer id;      private date mydate;      //getters , setters } 

user.hbm.xml

<hibernate-mapping> <class name="com.user" table="user">     <id name="id" type="java.lang.integer">         <column name="id" />         <generator class="native" />     </id>     <property name="mydate" type="java.util.date">         <column name="mydate" />     </property> </class> </hibernate-mapping> 

insert statement

insert user(id,mydate) values (2,date('2013-04-03')); 

query method

@override public user querybyuserid(integer id) {    return gethibernatetemplate().get(user.class, id); } 

i think i'm late answer question:

the date must have format:

'2000-01-01 00:00:00' 

yyyy-mm-dd hh:mm:ss

and type of 'mydate' must "java.sql.date" instead of "java.util.date"


Comments

Popular posts from this blog

.htaccess - First slash is removed after domain when entering a webpage in the browser -

Automatically create pages in phpfox -

c# - Farseer ContactListener is not working -