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().
jTDS is an open source 100% pure Java (type 4) JDBC 3.0 driver for Microsoft SQL Server (6.5, 7, 2000 and 2005) and Sybase (10, 11, 12, 15). jTDS is based on FreeTDS and is currently the fastest production-ready JDBC driver for SQL Server and Sybase. jTDS
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
different solutions for: Cannot create JDBC driver of class...
Update: Tomcat's standard data source resource factory is org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory