Prev: any good site for java
Next: ?k???O?T?h???C
From: Martin Gregorie on 23 Jan 2010 17:00 On Sat, 23 Jan 2010 13:26:01 -0800, Steve Sobol wrote: > (actually, when I go to Vista's "Programs and Features", there's the JDK > listed in one place, and JavaDB is listed as a separate application, > which is interesting...) > That's to be expected: the actions of starting, stopping, configuring and backing up a database server or using the database maintenance utilities are not in any way connected to the actions involved in using the Java compiler or developer tools. In addition, they are generally separated from running Java programs that access the database apart from the necessity for the database server to running. -- martin@ | Martin Gregorie gregorie. | Essex, UK org |
From: Lew on 23 Jan 2010 18:10 Steve Sobol wrote: > Aside from being part of the JDK, what's the benefit to using JavaDB > instead of sqlite? For that you'd have to go to their respective sites (use the Apache Derby site for more details on Java DB). Java DB/Derby is an excellent product, very SQL-standard compliant and usable either as a server or embedded. I don't know anything about SQLite. -- Lew
From: Arne Vajhøj on 23 Jan 2010 18:28 On 23-01-2010 18:10, Lew wrote: > Steve Sobol wrote: >> Aside from being part of the JDK, what's the benefit to using JavaDB >> instead of sqlite? > > For that you'd have to go to their respective sites (use the Apache > Derby site for more details on Java DB). > > Java DB/Derby is an excellent product, very SQL-standard compliant and > usable either as a server or embedded. I don't know anything about SQLite. It is a nice little embedded database that works fine in many languages. Most likely you are using it - FireFox, ThunderBird and Skype all use it internally. Arne
From: Steve Sobol on 23 Jan 2010 19:23 In article <4b5b6bb1$0$283$14726298(a)news.sunsite.dk>, arne(a)vajhoej.dk says... > But JavaDB=Derby is also a database server. right-o.... didn't realize it was Derby. :) sqlite is designed for use in "serverless" environments. -- Steve Sobol, Victorville, California, USA sjsobol(a)JustThe.net
From: Arne Vajhøj on 23 Jan 2010 22:09
On 23-01-2010 19:23, Steve Sobol wrote: > In article<4b5b6bb1$0$283$14726298(a)news.sunsite.dk>, arne(a)vajhoej.dk > says... >> But JavaDB=Derby is also a database server. > > right-o.... didn't realize it was Derby. :) > > sqlite is designed for use in "serverless" environments. JavaDB/Derby can be used in serverless environments as well, but only from Java (in server mode it should be usable from non-Java via ODBC and DB2 client, but even there it is mostly Java only). Arne |