Added Derby dialect. Finished HSQL dialect. Documentation.

* Improved DEFAULT value specifications.
* Fixed bug in buildObjects where the ResultSet could be closed by the
automatic create table attempt.
* DbInspector now uses the dialect's reported DATETIME class preference.
* Improved IciqlException SQLState code checks.
* Integrated LIMIT and OFFSET expression appending in dialects.
* Updated to H2 1.3.159
* Allow reopening of a memory database in the test suite.

1 files changed, 2 insertions, 2 deletions

diff --git a/tests/com/iciql/test/SamplesTest.java b/tests/com/iciql/test/SamplesTest.java
index 30723bb..f16672a 100644
--- a/tests/com/iciql/test/SamplesTest.java
+++ b/tests/com/iciql/test/SamplesTest.java
@@ -60,7 +60,7 @@ public class SamplesTest {
 

 	@Before

 	public void setUp() {

-		db = IciqlSuite.openDb();

+		db = IciqlSuite.openNewDb();

 		db.insertAll(Product.getList());

 		db.insertAll(Customer.getList());

 		db.insertAll(Order.getList());

@@ -278,7 +278,7 @@ public class SamplesTest {
 	@Test

 	public void testSum() {

 		Product p = new Product();

-		Long sum = db.from(p).selectFirst(sum(p.unitsInStock));

+		Number sum = db.from(p).selectFirst(sum(p.unitsInStock));

 		assertEquals(323, sum.intValue());

 		Double sumPrice = db.from(p).selectFirst(sum(p.unitPrice));

 		assertEquals(313.35, sumPrice.doubleValue(), 0.001);