db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Saurabh Vyas (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-2258) DatabaseMetaData.getTypeInfo() does not list supported Derby SQL types correctly.
Date Mon, 05 Feb 2007 12:21:05 GMT

    [ 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.


Mime
View raw message