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]
