squirrel-sql-commits

[Squirrel-sql-commits] SF.net SVN: squirrel-sql:[6252] trunk/sql12/fw/src/main/java/net/ sourceforge/squirrel_sql/fw/dialects/ProgressDialectExt.java

[<man...@us...>]

Revision: 6252
          http://squirrel-sql.svn.sourceforge.net/squirrel-sql/?rev=6252&view=rev
Author:   manningr
Date:     2011-05-10 12:52:27 +0000 (Tue, 10 May 2011)

Log Message:
-----------
removed qualifier from indexName as progress calls this a syntax error.

Modified Paths:
--------------
    trunk/sql12/fw/src/main/java/net/sourceforge/squirrel_sql/fw/dialects/ProgressDialectExt.java

Modified: trunk/sql12/fw/src/main/java/net/sourceforge/squirrel_sql/fw/dialects/ProgressDialectExt.java
===================================================================
--- trunk/sql12/fw/src/main/java/net/sourceforge/squirrel_sql/fw/dialects/ProgressDialectExt.java	2011-05-09 21:34:32 UTC (rev 6251)
+++ trunk/sql12/fw/src/main/java/net/sourceforge/squirrel_sql/fw/dialects/ProgressDialectExt.java	2011-05-10 12:52:27 UTC (rev 6252)
@@ -594,7 +594,11 @@
 			result.append("UNIQUE ");
 		}
 		result.append(" INDEX ");
-		result.append(DialectUtils.shapeQualifiableIdentifier(indexName, qualifier, prefs, this));
+		// Progress version 10.1C yields the following error for a qualified index name:
+		//   [DataDirect][OpenEdge JDBC Driver][OpenEdge] Syntax error in SQL statement at or 
+		//   about ".testIndex ON MANNINGR.CREATEINDEXTEST(IDXTESTCOLUMNNAME)
+		//result.append(DialectUtils.shapeQualifiableIdentifier(indexName, qualifier, prefs, this));
+		result.append(indexName);
 		result.append(" ON ");
 		result.append(DialectUtils.shapeQualifiableIdentifier(tableName, qualifier, prefs, this));
 		result.append("(");


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[Squirrel-sql-commits] SF.net SVN: squirrel-sql:[6258] trunk/sql12/fw/src/main/java/net/ sourceforge/squirrel_sql/fw/dialects/ProgressDialectExt.java

[<man...@us...>]

Revision: 6258
          http://squirrel-sql.svn.sourceforge.net/squirrel-sql/?rev=6258&view=rev
Author:   manningr
Date:     2011-05-14 23:07:35 +0000 (Sat, 14 May 2011)

Log Message:
-----------
Fixed inconsistent quoting of column constraint names.

Modified Paths:
--------------
    trunk/sql12/fw/src/main/java/net/sourceforge/squirrel_sql/fw/dialects/ProgressDialectExt.java

Modified: trunk/sql12/fw/src/main/java/net/sourceforge/squirrel_sql/fw/dialects/ProgressDialectExt.java
===================================================================
--- trunk/sql12/fw/src/main/java/net/sourceforge/squirrel_sql/fw/dialects/ProgressDialectExt.java	2011-05-14 21:23:27 UTC (rev 6257)
+++ trunk/sql12/fw/src/main/java/net/sourceforge/squirrel_sql/fw/dialects/ProgressDialectExt.java	2011-05-14 23:07:35 UTC (rev 6258)
@@ -553,8 +553,12 @@
 
 		final StringTemplate st = new StringTemplate(templateStr);
 
+		final String constraintNameValue = 
+			prefs.isQuoteConstraintNames() ? 
+				DialectUtils.shapeIdentifier(constraintName, prefs, this) : constraintName; 
+		
 		final HashMap<String, String> valuesMap =
-			DialectUtils.getValuesMap(ST_TABLE_NAME_KEY, tableName, ST_CONSTRAINT_NAME_KEY, constraintName);
+			DialectUtils.getValuesMap(ST_TABLE_NAME_KEY, tableName, ST_CONSTRAINT_NAME_KEY, constraintNameValue);
 
 		return new String[] { DialectUtils.getAddUniqueConstraintSQL(st, valuesMap, columns, qualifier, prefs,
 			this) };


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[Squirrel-sql-commits] SF.net SVN: squirrel-sql:[6261] trunk/sql12/fw/src/main/java/net/ sourceforge/squirrel_sql/fw/dialects/ProgressDialectExt.java

[<man...@us...>]

Revision: 6261
          http://squirrel-sql.svn.sourceforge.net/squirrel-sql/?rev=6261&view=rev
Author:   manningr
Date:     2011-05-15 21:00:28 +0000 (Sun, 15 May 2011)

Log Message:
-----------
Progress version 10.1C can handle up to 9 digits of sub-second fractional time in a timestamp.

Modified Paths:
--------------
    trunk/sql12/fw/src/main/java/net/sourceforge/squirrel_sql/fw/dialects/ProgressDialectExt.java

Modified: trunk/sql12/fw/src/main/java/net/sourceforge/squirrel_sql/fw/dialects/ProgressDialectExt.java
===================================================================
--- trunk/sql12/fw/src/main/java/net/sourceforge/squirrel_sql/fw/dialects/ProgressDialectExt.java	2011-05-15 20:43:29 UTC (rev 6260)
+++ trunk/sql12/fw/src/main/java/net/sourceforge/squirrel_sql/fw/dialects/ProgressDialectExt.java	2011-05-15 21:00:28 UTC (rev 6261)
@@ -1113,7 +1113,17 @@
 	@Override
 	public boolean supportsSubSecondTimestamps()
 	{
-		return false;
+		return true;
 	}
 
+	/**
+	 * @see net.sourceforge.squirrel_sql.fw.dialects.CommonHibernateDialect#getTimestampMaximumFractionalDigits()
+	 */
+	@Override
+	public int getTimestampMaximumFractionalDigits()
+	{
+		return 9;
+	}
+
+	
 }


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.