DbUtils

• Overview
• Download
• Examples
• Release Notes
• Dependencies
• License
• Wiki

Development

• Mailing Lists
• Issue Tracking
• Source Repository
• Building
• Javadoc (SVN latest)

Project Documentation

• Project Information
• Project Reports
  • Changes Report
  • Checkstyle
  • Cobertura Test Coverage
  • CPD Report
  • FindBugs Report
  • JavaDocs
  • JDepend
  • PMD Report
  • RAT Report
  • Source Xref
  • Surefire Report
  • Test JavaDocs
  • Test Source Xref

Commons

• Home
• Components
• Sandbox
• Dormant
• Volunteering
• Contributing Patches
• Building Components
• Releasing Components
• Wiki

ASF

• Sponsorship
• Thanks

Changes Report

Release History

Version	Date	Description
1.3	2009-11-04	Adds Java5 generics and varargs
1.2	2009-03-06	Another round of fixes; deprecates methods in preparation for varargs in java5
1.1	2006-12-01	Last couple of years of fixes
1.0	2003-11-10	First release of DbUtils

Release 1.3 - 2009-11-04

Type	Changes	By
	Java 1.5 generics and varargs Fixes DBUTILS-48.	dfabulich
	BeanProcessor#mapColumnsToProperties now prefers to use column labels over column names (where aliases are not set, these should be identical) Fixes DBUTILS-57.	dfabulich
	Setting pmdKnownBroken in QueryRunner constructor now completely ignores ParameterMetaData Fixes DBUTILS-58.	dfabulich
	Fixed error message in QueryRunner#rethrow Fixes DBUTILS-60.	dfabulich

Release 1.2 - 2009-03-06

Type	Changes	By
	Removed setDataSource method to guarantee thread safety Fixes DBUTILS-52.	dfabulich
	Made numerous private instance members final to guarantee thread safety; changed protected member of KeyedHandler to final Fixes DBUTILS-51.	sebb
	Remove old Maven1/Ant build scripts	bayard
	Support bean property to SQL IN parameter mapping Fixes DBUTILS-29.	dfabulich
	fillStatement setNull bug with the Postgres/Derby JDBC driver (and others) Fixes DBUTILS-31.	dfabulich
	Make GenericListHandler (now AbstractListHandler) public Fixes DBUTILS-33.	dfabulich
	BasicRowProcessor loses any information on database field case Fixes DBUTILS-34.	dfabulich
	BeanListHandler#handle(ResultSet) is not optimal Fixes DBUTILS-37.	dfabulich
	NullPointerException occured at rethrow method Fixes DBUTILS-40.	dfabulich
	Object with Long or Decimal got initial zero value while database field is null Fixes DBUTILS-42.	dfabulich
	example documentation page, update query Fixes DBUTILS-38.	dennisl
	Add serialVersionUID to BasicRowProcessor.CaseInsensitiveHashMap Fixes DBUTILS-36.	bayard

Release 1.1 - 2006-12-01

Type	Changes	By
	Tests fail to build under 1.6, and warning while compiling source Fixes DBUTILS-32.	bayard
	BeanListHandler and BeanHandler fail to support java.sql.Date() Fixes DBUTILS-1.	bayard
	ResultSetRowProcessor abstract handler and some classes rework Fixes DBUTILS-16.	bayard
	Setting bean properties fails silently Fixes DBUTILS-3.	bayard
	MockResultSet needs to handle equals and hashCode Fixes DBUTILS-9.	dgraham
	MockResultSet: Throw UnsupportedOperationException for not implemented methods Fixes DBUTILS-7.	bayard
	Implement Pluggable Adaptors to Make BeanHandler Smarter Fixes DBUTILS-20.	dgraham
	Patch for extending BasicRowProcessor Fixes DBUTILS-15.	dgraham
	Protected QueryRunner.close() methods Fixes DBUTILS-12.	dgraham
	Updated docs for example.html page (select AS) Fixes DBUTILS-23.	dgraham
	Added protected ResultSetIterator.rethrow() method to wrap SQLExceptions in RuntimeExceptions. Fixes DBUTILS-4.	dgraham
	Added SQLState and error code to rethrown SQLExceptions. Fixes DBUTILS-5.	dgraham
	Added KeyedHandler to create a Map of Maps from a ResultSet. Fixes DBUTILS-25.	dgraham
	Use current class' ClassLoader instead of QueryLoader's ClassLoader in loadQueries(). Fixes DBUTILS-2.	dgraham
	Made QueryLoader.loadQueries() protected so subclasses can use query repositories other than properties files. Fixes DBUTILS-22.	dgraham
	QueryRunner now calls getDataSource() internally any time it needs access to its DataSource object to allow subclasses to provide different behavior.	dgraham
	Added DbUtils.rollbackAndClose() and DbUtils.rollbackAndCloseQuietly().	dgraham
	Call ResultSet.getTimestamp() in BeanProcessor.processColumn() if the bean property is a java.sql.Timestamp. Oracle's getObject() implementation returns its own incompatible Timestamp class. Fixes DBUTILS-26.	dgraham
	Changed QueryRunner.fillStatement() null handling to use Types.VARCHAR instead of Types.OTHER. This works for the following tested drivers: Firebird 1.5/firebirdsql 1.5RC3, Oracle 9/ Thin driver, MySQL 4.0/Msql Connecttor 3.0 and mm.mysql 2.0.4 MaxDB 7.5, HSQLDB 1.7.1, and MS Access/ODBC Bridge. Fixes DBUTILS-18.	dgraham
	Added a protected QueryRunner.prepareConnection() method to allow subclasses to customize the Connections retrieved from the DataSource before they're used. Fixes DBUTILS-21.	dgraham
	Refactored bean handling from BasicRowProcessor into new BeanProcessor class. This also fixes the common problem with Oracle NUMERIC fields not being set into bean properties.	dgraham
	Added QueryRunner.batch() methods for batch updates. Fixes DBUTILS-13.	dgraham
	Added new ResultSetHandler implementation, ColumnListHandler, that converts one ResultSet column into a List of Objects. Fixes DBUTILS-11.	dgraham

Release 1.0 - 2003-11-10

Type	Changes	By
	This is the first release of the Commons DbUtils package. DbUtils is a small set of classes designed to make working with JDBC easier.
	QueryRunner class with ResultSetHandler interface allow you to easily query or update a database and handle the ResultSet. Several useful implementations of the ResultSetHandler interface are located in the org.apache.commons.dbutils.handlers.* package.
	ResultSet wrappers that decorate ResultSets with specialized behavior. See the classes in the org.apache.commons.dbutils.wrappers.* package for details.
	Dynamic JDBC API interface implementations via the standard java.lang.reflect.Proxy class. This allows you to implement JDBC interfaces such as ResultSet at runtime to avoid API version incompatibilities. See org.apache.commons.dbutils.ProxyFactory for details.