JDBC

Java Database Connectivity

JDBC is the part of the Java library which allows interaction with relational databases using SQL. Developers can either code directly to the JDBC API or use SQLJ which allows SQL statements to be embedded directly into Java source.

Given the wide use of relational databases, JDBC is used in a large number of Java applications.

JDBC discussion forums

• http://forum.java.sun.com/forum.jsp?forum=48
• http://archives.java.sun.com/jdbc-interest.html

Articles

• JDBC tutorial
• DatabaseApps
• JDBCWithoutCodeRepetition
• Getting Started With JDBC
• Duke's Bakery - A JDBC Order Entry Prototype
• DBAccessor: A JDBC Wrapper Package
• SQLExecutor: A Simple Open Source JDBC Framework
• DontRepeatTryCatchBlocks
• Using CachedRowSet to Transfer JDBC Query Results Between Classes
• Top Ten Oracle JDBC Tips

Open source connection pools

• c3p0
• Apache Commons DBCP
• proxool
• xapool

Interesting open source projects

• Apache Commons DBUtils - Small, transparant DB helper library
• http://ldbc.sourceforge.net/
• http://www.crossdb.com/
• http://squirrel-sql.sourceforge.net/
• http://basicquery.sourceforge.net/
• https://sqlexplorer.dev.java.net/
• http://isql.sourceforge.net/
• http://jfacedbc.sourceforge.net/
• http://www.p6spy.com/
• Jahia SQL profiler
• Apache DB DDLUtils - Library for working with database definition files (DDL)
• http://jxdbcon.sourceforge.net/
• http://www.objectweb.org/rmijdbc/
• http://jdbc.postgresql.org/
• http://qform.sourceforge.net/
• http://ha-jdbc.sourceforge.net/
• https://jdbcpersistence.dev.java.net/
• Continuent.org Sequoia
• http://c-jdbc.objectweb.org/
• xlSQL Excel JavaDocument(B)Connectivity Driver
• http://sourceforge.net/projects/pfjdbc/
• http://sourceforge.net/projects/backpedal/
• http://jdbi.codehaus.org/
• http://www.theserverside.com/articles/article.tss?l=SQLExecutor
• Spring Framework: JdbcTemplate
• Spring Framework: JdbcDaoSupport
• http://butler.sourceforge.net/
• http://vjdbc.sourceforge.net/
• http://jtds.sourceforge.net/
• http://msjdbcproxy.sourceforge.net/
• http://jdbcimporter.sourceforge.net/
• http://diaz.sourceforge.net/
• https://sqlbinder.dev.java.net/
• http://jxdbc.jxta.org/
• https://jdbcwrapper.dev.java.net/
• http://executequery.org/
• http://schemacrawler.sourceforge.net/
• http://schemaspy.sourceforge.net/
• Scriptella ETL Tool : http://scriptella.javaforge.com/

Also see

• Wikipedia entry
• BLOB
• IronEye Cache - JDBC caching
• RAIDb
• DataAccessObject

Discussion about JDBC

"Note that JDBC is a trademarked name and not an acronym; nevertheless, it is often associated with Java Database Connectivity."

- Maydene Fisher, in The Java Tutorial