[Jython-checkins] SF.net SVN: jython:[6667] trunk/jython/src/com/ziclix/python/sql/handler/ OracleDataHandler.java

[<pj...@us...>]

Revision: 6667
          http://jython.svn.sourceforge.net/jython/?rev=6667&view=rev
Author:   pjenvey
Date:     2009-08-16 01:11:01 +0000 (Sun, 16 Aug 2009)

Log Message:
-----------
allow Oracle's touchy DML returning ResultSet to be used here

Modified Paths:
--------------
    trunk/jython/src/com/ziclix/python/sql/handler/OracleDataHandler.java

Modified: trunk/jython/src/com/ziclix/python/sql/handler/OracleDataHandler.java
===================================================================
--- trunk/jython/src/com/ziclix/python/sql/handler/OracleDataHandler.java	2009-08-14 00:55:05 UTC (rev 6666)
+++ trunk/jython/src/com/ziclix/python/sql/handler/OracleDataHandler.java	2009-08-16 01:11:01 UTC (rev 6667)
@@ -141,9 +141,17 @@
                     break;
                 }
 
-                ResultSetMetaData metaData = set.getMetaData();
-                int scale = metaData.getScale(col);
-                int precision = metaData.getPrecision(col);
+                int scale;
+                int precision;
+                // Oracle's DML returning ResultSet doesn't support getMetaData
+                try {
+                    ResultSetMetaData metaData = set.getMetaData();
+                    scale = metaData.getScale(col);
+                    precision = metaData.getPrecision(col);
+                } catch (SQLException sqle) {
+                    scale = precision = 0;
+                }
+
                 if (scale == -127) {
                     if (precision == 0) {
                         // Unspecified precision. Normally an integer from a sequence but


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