JDBC
Links
jTDS is an open source 100% pure Java JDBC 3.0 driver for Microsoft SQL Server.
http://log4jdbc.sourceforge.net/ log4jdbc is a Java JDBC driver that can log SQL and/or JDBC calls (and optionally SQL timing information).
Sample
jython - Database, Database.
See the JDBC/ODBC sample application in: https://weezy/svn/learn/java/jdbc-odbc/
Access
DSN’less JDBC connection to MSAccess.
We can setup a System/User DSN and connect to the Access database using a JDBC
URL like jdbc:odbc:DSN_NAME as documented here
but creating a DSN is an extra setup that I wanted to avoid (especially since my
app required the user to be able to switch to different MS Access databases). In
order to create a DSN’less connection to MS Access, you can use the following
JDBC connection URL:
jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=file path
SQL Server
SQL Server, ../microsoft/sql-server/sql-server.
SQL Server Express, Connection refused, ../microsoft/sql-server/express.
Tools
http://www.thinkui.com/sqlclient/ (includes code generation).
Diagnostics
http://www.p6spy.com/ P6Spy is an open source framework for applications that intercept and optionally modify database statements: