Sorry for the noise, but you might want to change 'dateOfBird' to 'dateOfBirth', I doubt that most users have two wings ;)
No offense, just a friendly pointer... Niels -----Original Message----- From: dimitriBarzagli [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2008 3:39 PM To: user-java@ibatis.apache.org Subject: Re: Problem Timestamp insert and retriev Hi Ryan, thank you for response. I modified the column definition in database and type definition in Objectbean. Actually I have another problem: I write this part of code to test the modifiy: ... SimpleDateFormat sf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); java.util.Date date = sf.parse("2008-01-01 00:00:00"); uBean.setDateOfBird(date); sqlMap.insert("insertUser", user); ... where uBean is the UserBean that mapping table user and dateOfBird property is java.util.Date. When I call insertMethod, I receive this message: com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in eu/csportaromana/xml/giornata.xml. --- The error occurred while applying a parameter map. --- Check the insertGiornata-InlineParameterMap. --- Check the statement (update failed). --- Cause: java.sql.SQLException: Incorrect datetime value: '01-an-Tue ' for column 'DATA_GIORNATA' at row 1 I think the problem is in format date, but I not understood why. By Eclipse I inspected value of " sf.parse("2008-01-01 00:00:00"); " and I obtained " Tue Jan 01 00:00:00 CET 2008 ". Can you help me? Thank you Dimitri Ryan Shelley-2 wrote: > > Should "dateOfBird" be a timestamp? Normally, timestamp is DB generated > with "CURRENT_TIMESTAMP" as the default value (and On Update > Current_Timestamp optionally enabled). You shouldn't need to SET this > value > if you're insistent on it being a timestamp. Otherwise, it should be a > Datetime datatype in the DB, "timestamp" in the jdbctype of the resultmap, > and your model would have a matching member variable of "java.util.Date" > datatype. If it has to be a timestamp, it'd essentially be the same > types. > > -Ryan > > On Mon, Mar 17, 2008 at 1:00 AM, dimitriBarzagli < > [EMAIL PROTECTED]> wrote: > >> >> Hi, >> >> I'm developing a web application by IBatis framework to manage database. >> I >> have a problem about insert and retrieve Timestamp value. >> I use Mysql 5.0 for database and I create a table USER with TIMESTAMP >> type >> for the DATE_OF_BIRD element. I create Java Bean User with dateOfBird >> member >> by java.sql.Timestamp. >> When I try to insert a new User by the IBatis insert() method the value >> in >> the database is always 0000-00-00 00:00, but I would it's different >> value. >> When I try a retrieve by queryForObject() method, the value for >> dateOfBird >> in UserBean is null. >> Below my user.xml: >> >> <?xml version="1.0" encoding="UTF-8" ?> >> >> <!DOCTYPE sqlMap >> PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" >> "http://ibatis.apache.org/dtd/sql-map-2.dtd";> >> >> <sqlMap namespace="User"> >> >> <!-- Select with no parameters using the result map for Account class. >> --> >> <select id="selectUser" resultClass="User"> >> SELECT U.ID_UTENTE as idUtente, >> U.USERID as userId, >> U.PASSWORD as password, >> U.COGNOME as cognome, >> U.NOME as nome, >> U.DATE_OF_BIRD as dateOfBird, >> U.PRIMA_PASSWORD as firstPassword, >> U.ID_PROFILO as idProfile, >> U.EMAIL as email, >> U.USER_ACTIVE as userActive >> FROM USER U >> WHERE ID_UTENTE = #value# >> </select> >> <update id="insertUser" parameterClass="User"> >> INSERT INTO USER (USERID, PASSWORD, COGNOME, NOME, DATE_OF_BIRD, >> PRIMA_PASSWORD, ID_PROFILO, EMAIL, USER_ACTIVE) >> VALUES (#userId#, #password#, #cognome#, #nome#, #dateOfBird#, >> #firstPassword#, #idProfile#, #email#, 'Y'); >> </update> >> </sqlMap> >> >> Someone can I help me? >> >> Thank you. >> >> -- >> View this message in context: >> http://www.nabble.com/Problem-Timestamp-insert-and-retriev-tp16089864p16 089864.html >> Sent from the iBATIS - User - Java mailing list archive at Nabble.com. >> >> > > -- View this message in context: http://www.nabble.com/Problem-Timestamp-insert-and-retriev-tp16089864p16 121979.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
