different solutions for: Cannot create JDBC driver of class...
Update: Tomcat's standard data source resource factory is org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory
rformance can be better if changes to the database are batched: turn off autocommit; add multiple SQL statements using the Statement.addBatch() method; execute Statement.executeBatch().
The JDBC Importer provides a consistent mechanism of importing data from files into a JDBC compliant database. Currently, each database vendor has their own utility or command that must be learned. Additionally, there are some limitations and caveats abou
jPersist is an extremely powerful, light-weight, object-relational database persistence API that manages to avoid the need for configuration and annotation; mapping is automatic. jPersist uses JDBC and can work with any relational database and any type of connection resource. jPersist uses information obtained from the database to handle mapping between the database and Java objects, so mapping configuration is not needed, and annotation is not needed, in fact there is no configuration needed at all.
Apache Derby, an Apache DB subproject, is an open source relational database implemented entirely in Java.
Formerly known as IBM Cloudscape it is now included in Java 6 as Java DB.
Eclipse SQL Explorer is a thin SQL client that allows you to query and browse any JDBC compliant database. It supports plugins with specialized functionality for individual databases (Oracle, DB2 and MySQL) and can be extended to include specialized support for other databases.
DB Schema Viewer is an Eclipse plugin that builds a graphical view of an existing database. Reverse Engineering is performed through JDBC. The most popular databases are currently supported:
* MySQL
* PostgreSQL
* Firebird