That looks ok. Timestamp is the correct thing to use.
You have two systems: one that works, one that doesn't. So, check for
differences in the SQL sub-systems between the two:
Are the drivers of the same (uptodate) version?
Are the database schemas using the same column type? (ie the one that
fails is silently truncating the data)
In your original post you mentioned Oracle9i and Postgres. If one works
and the other doesn't, again, check the column type is correct.
Jose Gargallo wrote:
This is the code:
java.sql.Timestamp time = new Timestamp(System.currentTimeMillis());
...
pstmt = this.conexion.prepareStatement(INSERT);
...
pstmt.setTimestamp(1, time);
should I use java.sql.Date instead of java.util.Data?
thanks
Christopher Schultz escribió:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Barry,
Propes, Barry L wrote:
and what date type are you using? sql.date or util.date?
I'm pretty sure that's going to be the problem.
- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFGuIVQ9CaO5/Lv0PARArnpAJ93DhQqc6o9l7P49h3AVJkK20mxYQCdFvSO
oPt8Wv6Y4Al0jqJBets5UuY=
=Mn29
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
