Groups > comp.lang.java.databases > #201

Re: colon questions

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" <lew@THRWHITE.remove-dii-this>
Subject	Re: colon questions
Message-ID	<oJudnf2bAtNBS_fVnZ2dnUVZ_jGdnZ2d@comcast.com> (permalink)
X-Comment-To	comp.lang.java.databases
Newsgroups	comp.lang.java.databases
In-Reply-To	<Tivak.19078$E41.1872@text.news.virginmedia.com>
References	<Tivak.19078$E41.1872@text.news.virginmedia.com>
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

Show key headers only | View raw

  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

Back to comp.lang.java.databases | Previous | Next | Find similar

Thread

Re: colon questions "Lew" <lew@THRWHITE.remove-dii-this> - 2011-04-27 15:22 +0000

csiph-web