[ https://issues.apache.org/jira/browse/DERBY-2258?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Saurabh Vyas updated DERBY-2258: -------------------------------- Attachment: Derby-2258.stat Derby-2258.diff After some investigations I found out following : - - For Metadata values, derby uses procedures from 'metadata.properties' and getTypeInfo() is one such method. - getTypeInfo() is use to for retrieving the description for all the data types supported by this database and in derby there are descriptions of some data types which are not supported by derby & data type like XML not present at all ( as addressed in this issue ) - some data types have incorrect description (as addressed by Derby 2259 & 2260). I had modified the procedure to remove the data type not supported by derby & added XML data type, but I am not sure for the remaining values in the description so I used values similar to that of CLOB. Can some one please correct me for XML data type on following descriptions : 1. TYPE_NAME String => XML 2. DATA_TYPE int => 2007 3. PRECISION int => 2147483647 4. LITERAL_PREFIX String => '''' 5. LITERAL_SUFFIX String => '''' 6. CREATE_PARAMS String => length 7. NULLABLE short => 1 (i.e. typeNullable) 8. CASE_SENSITIVE boolean=> TRUE 9. SEARCHABLE short => 0 (i.e. typePredNone) 10. UNSIGNED_ATTRIBUTE boolean => CAST (NULL AS BOOLEAN) 11. FIXED_PREC_SCALE boolean => FALSE 12. AUTO_INCREMENT boolean => CAST (NULL AS BOOLEAN) 13. LOCAL_TYPE_NAME String => CAST (NULL AS INTEGER) 14. MINIMUM_SCALE short => CAST (NULL AS INTEGER) 15. MAXIMUM_SCALE short => CAST (NULL AS INTEGER) Apart this issue also address Derby-2259 (https://issues.apache.org/jira/browse/DERBY-2259) & Derby-2260 (https://issues.apache.org/jira/browse/DERBY-2260) > 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 > > > 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.