SideStep 5: Start Your SQL Engines


click to expand

I included HSQLDB as the database for this book because it is Open Source and 100% Pure Java. Open Source makes it possible for programmers to learn new technologies on their own. 100% Pure Java means that this database will run anywhere a JVM runs, so certainly it will run wherever Eclipse runs. But that doesn't mean it's the only valid database. You should research various databases and find out which suits your needs. Use this SideStep as a starting point.

This is a very short SideStep. I don't plan to provide much more information than links to the website for the various SQL engines I've found. However, I would like to point out something. Of all the databases I found, only IBM's JTOpen (which connects to an iSeries database) and SAP's SAP DB database provide comprehensive support for the new JDBC 2.0 specification. The others support only the minimum JDBC 2.0 requirements, and provide no implementation of what I consider to be the most important addition to the standard: scrollable, updatable cursors .

Without going into a long diatribe, scrollable, updatable cursors allow applications to position themselves within and through a view a record at a time and perform updates on records only if the application decides such an update is necessary. The business logic used to determine what updates need to be performed does not have to adhere to SQL syntax and can instead be of any arbitrary complexity. This sort of flexibility is crucial to business applications and makes SQL far more useful for implementing complex business rules.

Anyway, I've provided the basic HelloHSQL program in each of three additional dialects, all located in the folder /Source/Step 10 (Other DB). It's pretty easy to switch form one database to another programmatically; the setup is a little more difficult. More information on all four of the databases can be found at the following URLs:

  • HSQLDB ”a 100% Pure Java SQL database: hsqldb. sourceforge .net/

  • JTOpen (JT/400) ”IBM's Open Source Java Toolbox for the iSeries (AS/400): www-124.ibm.com/developerworks/oss/jt400/index.html

  • PostgreSQL ”one of the most popular Open Source SQL packages: www.postgresql.org/

  • SAP DB ”the free version of SAP's very robust database: www.sapdb.org/




Eclipse
Eclipse: Step by Step (Step-by-Step series)
ISBN: 1583470441
EAN: 2147483647
Year: 2003
Pages: 90
Authors: Joe Pluta

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net