http://forums.visual-paradigm.com/posts/14.html JForum - http://www.jforum.net
This is a mysql-jdbc question. I am trying to issues a jdbc statement to add a row into the mysql table named ‘registration’. There are three columns in the table. The last one is a timestamp.

The following is the jdbc statement in my java code:

PreparedStatement pstmt = con.prepareStatement(
"insert into registration(username, password, timestamp) values (?, ?, ?)");

pstmt.setString(1, username);
pstmt.setString(2, password);
pstmt.setString(3, “now()”);
pstmt.executeUpdate();


With this statement, the timestamp in the table is always set to ‘0000000000’. I know the problem is related to how to format now() in a right way, I have tried “now()”, ‘now()’, and now(), and none of them work.

Could any one advice how to make this right?

Thanks in advance,

James]]> http://forums.visual-paradigm.com/posts/746#2240.html http://forums.visual-paradigm.com/posts/746#2240.html
I presume you are using the "mysql-connector-java-3.0.14-production-bin.jar" of some sort.

Now, I do not understand where you got the method "now()". Which class does it come from?

More information is required.
Thanks.

Martyn]]> http://forums.visual-paradigm.com/posts/746#2241.html http://forums.visual-paradigm.com/posts/746#2241.html
PreparedStatement pstmt = con.prepareStatement(
"insert into registration(username, password, timestamp) values (?, ?, now())");

pstmt.setString(1, username);
pstmt.setString(2, password);
pstmt.executeUpdate();]]> http://forums.visual-paradigm.com/posts/746#2242.html http://forums.visual-paradigm.com/posts/746#2242.html
PreparedStatement pstmt = con.prepareStatement(
"insert into registration(username, password, timestamp) values (?, ?, now())");

pstmt.setString(1, username);
pstmt.setString(2, password);
pstmt.executeUpdate();]]> http://forums.visual-paradigm.com/posts/746#2243.html http://forums.visual-paradigm.com/posts/746#2243.html
PreparedStatement pstmt = con.prepareStatement(
"insert into registration(username, password, timestamp) values (?, ?, now())");

pstmt.setString(1, username);
pstmt.setString(2, password);
pstmt.executeUpdate();]]> http://forums.visual-paradigm.com/posts/746#2244.html http://forums.visual-paradigm.com/posts/746#2244.html The solution you have given will probably work but it goes against the MDA concept and isn't round trip reversible.
How do I add a generated timestamp value for this field that is fully reversible and specify it from the model rather than the code?]]> http://forums.visual-paradigm.com/posts/746#20388.html http://forums.visual-paradigm.com/posts/746#20388.html