Added support for HSQL database. Revised dialects some more.

Moved CREATE TABLE and CREATE INDEX statement generation to the dialect.
Added DECIMAL(length, scale) support.
Improved automatic dialect detection.
Unspecified length string is now CLOB instead of TEXT.
Boolean now maps to BOOLEAN instead of BIT.
Expressions on unmapped fields will throw an IciqlException.
Improved exception reporting.

1 files changed, 2 insertions, 7 deletions

diff --git a/src/com/iciql/SQLDialectH2.java b/src/com/iciql/SQLDialectH2.java
index c65c277..80786f9 100644
--- a/src/com/iciql/SQLDialectH2.java
+++ b/src/com/iciql/SQLDialectH2.java
@@ -31,12 +31,7 @@ public class SQLDialectH2 extends SQLDialectDefault {
 	}

 

 	@Override

-	public boolean supportsMerge() {

-		return true;

-	}

-

-	@Override

-	public String prepareCreateIndex(String schema, String table, IndexDefinition index) {

+	public void prepareCreateIndex(SQLStatement stat, String schema, String table, IndexDefinition index) {

 		StatementBuilder buff = new StatementBuilder();

 		buff.append("CREATE ");

 		switch (index.type) {

@@ -62,7 +57,7 @@ public class SQLDialectH2 extends SQLDialectDefault {
 			buff.append(col);

 		}

 		buff.append(")");

-		return buff.toString();

+		stat.setSQL(buff.toString());		

 	}

 	

 	@Override