implicit.ly

Scala software, hot off the presses

« Back to blog

ScalaQuery 0.9.5

Hello,

I am pleased to announce release 0.9.5 of ScalaQuery, the type-safe database API for Scala.

ScalaQuery is an API / DSL (domain specific language) built on top of JDBC for accessing relational databases in Scala. It is being made available under a liberal BSD-style license and has no dependencies other then the Scala core library. The current release is ScalaQuery 0.9.4 for Scala 2.8.0, 2.8.1 and 2.9.0, with full support for the following database systems: PostgreSQL, MySQL, H2, HSQLDB/HyperSQL, Derby/JavaDB, MS SQL Server, MS Access, SQLite. Accessing other database systems is possible, with a reduced feature set.

For more information, see the ScalaQuery web site: http://scalaquery.org
Source code: http://github.com/szeiger/scala-query
Mailing list: http://groups.google.com/group/scalaquery

The following changes have been made since release 0.9.4:

- Built for Scala 2.9.0-1 and 2.8.1

- Added Invoker.to and Invoker.toMap to build Maps and arbitrary collections from database results

- Added some helper methods to CloseableIterator which make it easier to keep a Closeable resource alive until a CloseableIterator is closed

- Implemented foreign key query combining

- Added Database.forName to look up a database through JNDI

- Widened signature of inSet and inSetBind to accept Traversable instead of Seq

- Bug fix: PositionedResult.hasMoreColumns returned false before last column (https://github.com/szeiger/scala-query/issues/14)

- Bug fix: Don't reset column pos if rs.next throws an exception

- Bug fix: Date, time and timestamp SQL literal values for SQLite and SQL Server were broken

- Bug fix: PositionedResultIterator did not close() automatically at the end

- Plenty of refactoring and cleanup work

Best regards,
Stefan

Posted August 19, 2011 by email