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
Post a Comment