Prepared statements. Time Stamps.

2003-03-14 Thread Gustavo Cebrian 

We are trying to set a TimeStamp in mysql from Java.
We use the set TimeStamp funcion in PreparedStatement, but the date is not logged 
properly in the database. ( We are using a DateTime in the database ).
In other words, does JDBC cope with TimeStamps?
It was working fine when we had a TimeStamp in the database.
I would appreciate a lot your answer.
Thanks in advance.
Gustavo.



***
Gustavo Cebrian
Analyst/Programmer

Want to improve the ROI on your EAI project?
Download RV Tester and reduce your development 
and testing timescales by as much as 50%. 
http://www.greenhatconsulting.com/rvtester 

Green Hat Consulting Ltd.
107 Fleet Street, London EC4A 2AB
DDI +44 (0)20 7936 9495
Mobile +44 (0)7788 922291
http://www.greenhatconsulting.com
[EMAIL PROTECTED]
***




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Prepared statements. Time Stamps.

2003-03-14 Thread Mark Matthews 
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Gustavo Cebrian wrote:
We are trying to set a TimeStamp in mysql from Java.
We use the set TimeStamp funcion in PreparedStatement, but the date is not logged 
properly in the database. ( We are using a DateTime in the database ).
In other words, does JDBC cope with TimeStamps?
It was working fine when we had a TimeStamp in the database.
I would appreciate a lot your answer.
Thanks in advance.
Gustavo.
I've never seen a timestamp _not_ work with PreparedStatements...Can you 
give a more detailed example demonstrating exactly what your particular 
problem is?

	-Mark

- -- 
MySQL 2003 Users Conference - http://www.mysql.com/events/uc2003/

For technical support contracts, visit https://order.mysql.com/?ref=mmma

__  ___ ___   __
   /  |/  /_ __/ __/ __ \/ /  Mark Matthews [EMAIL PROTECTED]
  / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
 /_/  /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
___/ www.mysql.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.1.90 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQE+cdX+tvXNTca6JD8RAiaLAKC+B4w7OEo6ENUDwHiiA2Rx+WECQQCfelgn
Uz6o5I2TJa2W3nwSqLGNPNI=
=tUnr
-END PGP SIGNATURE-
-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php