Path: csiph.com!x330-a1.tempe.blueboxinc.net!feeder1.hal-mli.net!nx02.iad01.newshosting.com!newshosting.com!novia!news-out.readnews.com!transit3.readnews.com!news-out.news.tds.net!newsreading01.news.tds.net!86597e80!not-for-mail From: "Lew" Subject: Re: colon questions Message-ID: X-Comment-To: comp.lang.java.databases Newsgroups: comp.lang.java.databases In-Reply-To: References: Content-Type: text/plain; charset=IBM437 Content-Transfer-Encoding: 8bit X-Gateway: time.synchro.net [Synchronet 3.15a-Win32 NewsLink 1.92] Lines: 18 Date: Wed, 27 Apr 2011 15:22:20 GMT NNTP-Posting-Host: 96.60.20.240 X-Complaints-To: news@tds.net X-Trace: newsreading01.news.tds.net 1303917740 96.60.20.240 (Wed, 27 Apr 2011 10:22:20 CDT) NNTP-Posting-Date: Wed, 27 Apr 2011 10:22:20 CDT Organization: TDS.net Xref: x330-a1.tempe.blueboxinc.net comp.lang.java.databases:201 To: comp.lang.java.databases David Harper wrote: > ... and your code is portable -- it will work with > PostgreSQL as well as with MySQL or Oracle or any other database system. That last part is only true to the extent one uses portable SQL, which one cannot always do much in real life. For example, datetime types are radically different with radically different semantics between the RDBMSes you mentioned. You will not get the same behavior with, say, ResultSet#getTimestamp() across all three. -- Lew --- * Synchronet * The Whitehouse BBS --- whitehouse.hulds.com --- check it out free usenet! --- Synchronet 3.15a-Win32 NewsLink 1.92 Time Warp of the Future BBS - telnet://time.synchro.net:24