--- David Crawshaw <[EMAIL PROTECTED]> wrote:
Joe wrote:
> public synchronized ResultSet getTables(String c, String s,
> public ResultSet getColumns(String c, String s, String tbl, String
Hi Joe, these functions look good, but what I need more than the
function is the test case for what they're fixing. I can guess from
reading the code, but that can be a dangerous thing to do. I would be
more interested if you could give me an example of what DbVisualizer
expects so I can write a test case.
Enough test cases is the only way I'm ever going to stabilise the meta
data interface.
Without these meta method improvements you cannot introspect database
columns, or distinguish views from tables from indexes.
I have no affiliation with DbVisualizer, nor do I have access to its
source code. It's just one JDBC browser among many. Other such JDBC
browsers would have similar issues. I'm just implementing a healthy
sub-set of the JDBC spec just to get it to work with my programs.
getColumns() improvements:
- make colPat argument work correctly (this is mandatory)
- populate ordinal number attribute (mandatory)
- fix nullable and is_nullable attributes (very useful to have)
- use better defaults for other attributes - largely cosmetic.
getTables() improvements:
- "String[] types" argument is now used to determine what table
types to query. (mandatory)
DbVisualizer needs this info to correctly populate its
tree-view of tables and views.
- names and types promoted to upper case just in case.
getIndexInfo() (and to a lesser extent getImportedKeys()),
still must be implemented to implement a good sub-set of the JDBC
meta data API. Automatic INSERT, UPDATE, DELETE and SELECT statement
generation for "on-the-fly" data editting need this information to function.
I will likely implement getIndexInfo() as I need it for another
program to function correctly. I'll send you a patch assuming you do
not get to it before I do.
thanks.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"SQLiteJDBC" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups-beta.google.com/group/sqlitejdbc?hl=en
-~----------~----~----~----~------~----~------~--~---
