[
https://issues.apache.org/jira/browse/DERBY-2258?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12470195
]
Saurabh Vyas commented on DERBY-2258:
-------------------------------------
Thanks Dan for drawing attention towards DatabaseMetaDataTest.
Well I modified the test method testGetTypeInfo() accordingly and done the
following changes :
- removed the LONG NVARCHAR, NATIONAL CHAR, NATIONAL CHAR VARYING data (which
are not supported by derby)
- corrected the precision value for VARCHAR FOR BIT DATA
- then I tried adding the XML data type checks also as
<----------- code snippet--------------------->
case Types.SQLXML:
createParams = null;
break;
---------------
case Types.SQLXML:
searchable = DatabaseMetaData.typePredNone;
break;
<------------------------------------------------------>
But after doing the last change (i.e. adding XML data type in test) I got
following build error :
compilet2:
[javac] Compiling 11 source files to
/export/home/vyas/NewDerby/trunk/classes
[javac]
/export/home/vyas/NewDerby/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/DatabaseMetaDataTest.java:1506:
cannot find symbol
[javac] symbol : variable SQLXML
[javac] location: class java.sql.Types
[javac] case Types.SQLXML:
[javac] ^
[javac]
/export/home/vyas/NewDerby/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/DatabaseMetaDataTest.java:1554:
cannot find symbol
[javac] symbol : variable SQLXML
[javac] location: class java.sql.Types
[javac] case Types.SQLXML:
[javac] ^
[javac] 2 errors
--------------------------
After some investigation on this, I got to know that build.xml in jdbcapi still
uses jdk 1.3 & jdk 1.4 only and SQLXML data type is added in java.sql.Types
only in jdk 1.6.
Thus this modification in test will require the dependency on jdk1.6 to be
added in the build.xml in jdbcapi. I tried some modification bu was not
successful in getting it compiled correctly.
Now not to make things complex I 'll raise another JIRA for this.
Also that issue will be a blocker for this issue.
Comments / Suggestions ?
> DatabaseMetaData.getTypeInfo() does not list supported Derby SQL types
> correctly.
> ---------------------------------------------------------------------------------
>
> Key: DERBY-2258
> URL: https://issues.apache.org/jira/browse/DERBY-2258
> Project: Derby
> Issue Type: Bug
> Components: JDBC, Network Client
> Affects Versions: 10.1.1.0, 10.1.2.1, 10.1.3.1, 10.2.1.6, 10.2.2.0,
> 10.3.0.0
> Reporter: Daniel John Debrunner
> Assigned To: Saurabh Vyas
> Priority: Minor
> Attachments: Derby-2258.diff, Derby-2258.stat, Derby-2258_v2.diff
>
>
> These types are returned but not supported by Derby.
> LONG NVARCHAR
> NATIONAL CHAR
> NATIONAL CHAR VARYING
> The XML type is supported by Derby but not returned.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
