[dna-issues] [JBoss JIRA] Updated: (DNA-37) Federate schema information from relational sources

[Brian Carothers (JIRA)]

     [ https://jira.jboss.org/jira/browse/DNA-37?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Brian Carothers updated DNA-37:
-------------------------------

    Attachment: DNA-37_mysql_postgresql.patch


Thanks!  

However, as soon as I started testing against other drivers, I found a few one-off issues.  The attached patch gets the connector to a state where it will work with HSQLDB, MySql5, or PostgreSQL8.  The Oracle, MS, Sybase, and DB2 JDBC drivers don't seem to be in the JBoss maven repository anymore, so I haven't tested against those yet.

The patch adds the support for MySQL and PostgreSQL and fixes two minor problems with the previous patches that Randall had caught, switching JdbcMetadataException to be an unchecked exception and using the more efficient Path.getSegmentsList() instead of Path.getSegmentsAsArray() in JdbcMetadataRepository.getNode(Path).

> Federate schema information from relational sources
> ---------------------------------------------------
>
>                 Key: DNA-37
>                 URL: https://jira.jboss.org/jira/browse/DNA-37
>             Project: DNA
>          Issue Type: Feature Request
>          Components: Connectors
>            Reporter: Randall Hauch
>            Assignee: Brian Carothers
>            Priority: Minor
>             Fix For: 1.1
>
>         Attachments: DNA-37_deletes_and_project_pom.patch, DNA-37_graph_changes.patch, DNA-37_jdbc_meta_connector.patch, DNA-37_mysql_postgresql.patch
>
>
> Create a connector for the federation engine that contributes and exposes the database schema information for a relational database (via JDBC) into the federated repository.  This would make it possible to have a repository provide information about the databases in an organization.  One choice would be whether to import (and copy) the schema structure, or to provide access to it in real time.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira