[teiid-commits] teiid SVN: r674 - trunk/server/src/main/java/com/metamatrix/common/jdbc/db.
Author: vhalbert(a)redhat.com
Date: 2009-03-31 17:10:32 -0400 (Tue, 31 Mar 2009)
New Revision: 674
Modified:
trunk/server/src/main/java/com/metamatrix/common/jdbc/db/PostgresPlatform.java
Log:
TEIID-448 - Error Finding Latest active VDB suing Postgres as a Repository - The
PostgresPlatform needed to override the default to add its specific UPPER operator to its
platform.
Modified: trunk/server/src/main/java/com/metamatrix/common/jdbc/db/PostgresPlatform.java
===================================================================
---
trunk/server/src/main/java/com/metamatrix/common/jdbc/db/PostgresPlatform.java 2009-03-31
21:08:57 UTC (rev 673)
+++
trunk/server/src/main/java/com/metamatrix/common/jdbc/db/PostgresPlatform.java 2009-03-31
21:10:32 UTC (rev 674)
@@ -25,8 +25,10 @@
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
+import java.util.Map;
import com.metamatrix.common.jdbc.JDBCPlatform;
+import com.metamatrix.common.jdbc.syntax.ExpressionOperator;
public class PostgresPlatform extends JDBCPlatform {
@@ -42,8 +44,18 @@
public boolean isDefault() {
return false;
- }
+ }
+
+ protected Map buildPlatformOperators() {
+ Map operators = super.buildPlatformOperators();
+ // override for Oracle specfic
+
addOperator(ExpressionOperator.simpleFunction("toUpperCase","UPPER"));
//$NON-NLS-1$ //$NON-NLS-2$
+
+ return operators;
+
+ }
+
public boolean isClosed(Connection connection) {
if(!super.isClosed(connection)) {