Prepared statements. Time Stamps.
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
sql
I am implementing a inheritence in sql database. I have got a table called Entity with attributes Name,Password and a = Advertiser table. Basically, in my java program the Entity is the base class of the = Advertiser class. ( I like using inheritence a lot ). Both tables have an autonumber as key. When inserting a new advetiser, I need to insert a row in the entity = table, when the index ( autonumber ) and insert the same key in the = advertiser table. Does anyone know how to get integer ( autonumber ) just inserted, so I = can have the same key in the advertiser table? What do you think about implementing inheritence this way in the = database? Thanks. Gustavo. - 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: Connector/J
What is Connector/J. Is it just the program which runs on the server? What GUI do you use for mysql? Gustavo. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 03 March 2003 13:10 To: Gustavo Cebrian Subject: Re: Connector/J Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query,queries,smallint If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: What is Connector/J. Is it just the program which runs on the server? What GUI do you use? Gustavo. - 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
