db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-3973) Create function wrappers for DatabaseMetaData so that you can join metadata results in queries.
Date Thu, 04 Dec 2008 20:38:44 GMT

     [ https://issues.apache.org/jira/browse/DERBY-3973?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Rick Hillegas updated DERBY-3973:
---------------------------------

    Attachment: DBMDWrapper.java

Attaching a second rev of the DBMDWrapper program. This version lets you change the connection
used to get the DatabaseMetaData. Here is how you could use ij and the registered functions
to explore metadata in Derby and in a MySQL database:

-- list all of the columns in the connected Derby database
select t.table_schem, t.table_name, c.column_name, c.type_name
from table( getTables( null, null, null ) ) t,
        table( getColumns( null, null, null, null ) ) c
where c.table_schem = t.table_schem
and c.table_name = t.table_name
and t.table_type = 'TABLE'
;


-- now list metadata in a foreign database
call setDatabaseURL( 'com.mysql.jdbc.Driver', 'jdbc:mysql://localhost/world?user=root&password='
);

select t.table_schem, t.table_name, c.column_name, c.type_name
from table( getTables( 'WORLD', null, null ) ) t,
        table( getColumns( 'WORLD', null, null, null) ) c
where c.table_name = t.table_name
and t.table_type = 'TABLE'
;

-- release the foreign connection
call setDatabaseURL( '', '' );



> Create function wrappers for DatabaseMetaData so that you can join metadata results in
queries.
> -----------------------------------------------------------------------------------------------
>
>                 Key: DERBY-3973
>                 URL: https://issues.apache.org/jira/browse/DERBY-3973
>             Project: Derby
>          Issue Type: Improvement
>          Components: Demos/Scripts
>    Affects Versions: 10.5.0.0
>            Reporter: Rick Hillegas
>            Assignee: Rick Hillegas
>         Attachments: DBMDWrapper.java, DBMDWrapper.java
>
>
> Create a program to wrap the DatabaseMetaData methods in Derby functions.

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