Hypersonic does have a jdbc driver, it's a type 4. I think it's jdbc 2, but I'm not sure.
Oracle supports jdbc version 2 at least, 3 I think, not sure. They're kind of funny, they don't always support all parts of the version that they're nearest too. They have a type 4 as well as the type that uses native libraries. They additionally have different types of type 4's, which you use depends on the application. DB2 also has a JDBC driver, but other than that I don't know. Also, cloudscape used to be part of the j2ee development kit, that version was free as I recall. --mikej -=----- mike jackson [EMAIL PROTECTED] > -----Original Message----- > From: Jens Skripczynski [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 18, 2003 1:37 PM > To: Tomcat Users List > Subject: Re: [OT] free Database with Transaction (Sorry for the noise) > > > Hi, > > I would like to stop this thread, i started. > > I would like to thank everybody for contributions. > > Many things i forgot to write. > - I'm not the administrator of the final tomcat box, so needing any other > database than mysql, needs a lot of talk with the admin. > - yes, i did check the mysql website, but rely on (maybe > outdated) information > of computer magazines, that labeled the transaction support > very limited. > > > So for me Hypersonic is fine, since (i hope) i can copy the files in a war > to my isp and i do not have to keep two databases up2date. > > As a summary (for the archive) (and as a homework for me) > > databases with jdk / jdbc support (highest version listed) > --------------------------------- > > free: > - Hypersonic now hsqldb (http://hsqldb.sourceforge.net/index.html) > - pure java > - supports jdk 1.4 > - supports jdbc ?.? > - JDBC Type ? Driver (4 since it is pure java ?) > > - postgresql (http://www.postgresql.org/) > connectors: > - PostgreSQL JDBC Drivers (http://jdbc.postgresql.org/) > - supports jdk ?.? > - supports jdbc 2.2 > - JDBC Type ? Driver > > - sapdb (http://www.sapdb.org/) > connectors: > - SAP DB JDBC (http://www.sapdb.org/7.4/sap_db_jdbc.htm) > - supports jdk 1.4 > - supports jdbc 3.0 > - JDBC Type 4 Driver > > - firebird (http://firebird.sourceforge.net/) > connectors: > - jbird > (no homepage) > > (http://prdownloads.sourceforge.net/firebird/FirebirdSQL-1.0.0RC3. > zip?download) > - supports jdk 1.4 > - supports jdbc 3.0 > - JDBC Type 4 Driver > > almost free (for non-commercial use): > - Mysql (http://www.mysql.com/) > connectors: > - MySQL Connector/J (http://www.sapdb.org/7.4/sap_db_jdbc.htm) > - supports jdk 1.4 > - supports jdbc 3.0 > - JDBC Type 4 Driver > > $$$: > - cloudscape (http://www-3.ibm.com/software/data/cloudscape/) > - pure java > - supports jdk 1.4 > - supports jdbc 2.0 > - JDBC Type ? Driver (4 since it is pure java ?) > > high-end & $$$: > - db2 (http://www-3.ibm.com/software/data/db2/) > connectors: > - ? > > - Oracle (http://www.oracle.com/ip/deploy/database/oracle9i/index.html) > connectors: > - ? > > ------------------------------------------- > Hope the informations i found now are correct. > If some people that have proper information can fill the '??'. > > for the JDBC Type deffinition see: > http://java.sun.com/products/jdbc/driverdesc.html > > P.S.: I did not belief this thread to grow so much. > Again thx for the great help and for the others: > _sorry_ for the noise. > > Ciao > > Jens Skripczynski > -- > E-Mail: skripi(at)myrealbox(dot)com > > Tollef Fog Heen > Unix _IS_ user friendly... It's just selective about who its friends are. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
