From 66e810aaf212c5e37b0a1702b6c33480595408ce Mon Sep 17 00:00:00 2001 From: James Moger Date: Mon, 15 Aug 2011 16:44:14 -0400 Subject: 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. --- src/com/iciql/SQLDialectMySQL.java | 11 ++++++----- 1 file changed, 6 insertions(+), 5 deletions(-) (limited to 'src/com/iciql/SQLDialectMySQL.java') diff --git a/src/com/iciql/SQLDialectMySQL.java b/src/com/iciql/SQLDialectMySQL.java index 2593e0a..a6c1218 100644 --- a/src/com/iciql/SQLDialectMySQL.java +++ b/src/com/iciql/SQLDialectMySQL.java @@ -31,7 +31,7 @@ public class SQLDialectMySQL extends SQLDialectDefault { } return sqlType; } - + @Override public boolean supportsMemoryTables() { return false; @@ -41,15 +41,16 @@ public class SQLDialectMySQL extends SQLDialectDefault { public String prepareColumnName(String name) { return "`" + name + "`"; } - + @Override - protected boolean prepareColumnDefinition(StatementBuilder buff, boolean isAutoIncrement, boolean isPrimaryKey) { + protected boolean prepareColumnDefinition(StatementBuilder buff, boolean isAutoIncrement, + boolean isPrimaryKey) { if (isAutoIncrement) { buff.append(" AUTO_INCREMENT"); } return false; } - + @Override public void prepareCreateIndex(SQLStatement stat, String schema, String table, IndexDefinition index) { StatementBuilder buff = new StatementBuilder(); @@ -74,7 +75,7 @@ public class SQLDialectMySQL extends SQLDialectDefault { buff.append(prepareColumnName(col)); } buff.append(") "); - + // USING switch (index.type) { case HASH: -- cgit v1.2.3