This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 151248 - getSchema
Summary: getSchema
Status: VERIFIED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: DB schema (show other bugs)
Version: 6.x
Hardware: All All
: P3 blocker (vote)
Assignee: David Vancouvering
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-10-24 10:30 UTC by fpujol
Modified: 2008-11-24 17:09 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description fpujol 2008-10-24 10:30:25 UTC
Hello,

  I'm using a Jdbc of transtools, is a propietary db. When I try to execute an Sql query netbeans 6.5rc try to get
Schema and it can't do it. In the 6.1 version I can execute the sql with the same jdbc because don't try to get the
Schema. Anyway the 6.5rc and 6.1 can't get the schema
Comment 1 David Vancouvering 2008-10-27 18:07:58 UTC
Hi.  It's more than likely that the JDBC driver doesn't support the JDBC metadata command to get the list of schemas. 
Can you see if you can run a JDBC program that does the following:

Connection conn = getConnection() // However you get a connection for this driver
DatabaseMetadata dbmd = conn.getMetaData();

ResultSet rs = dbmd.getSchemas()

and then iterate through the list of schemas.

If this fails, then it is a limitation of the driver and there's not much we can do about it...

If it succeeds, then please remove the INCOMPLETE field.  Also, we need a pointer to the driver and the associated
database so we can test this.

If it fails, please provide information saying it doesn't fail, and we'll close this issue.  You can then raise the
request to add support for getSchemas() to the transtools JDBC driver folks.
Comment 2 fpujol 2008-11-24 10:59:56 UTC
I've speaken with transtools people and they have implemented the funcition getSchema but it returns anything because
multibase don't use schema inside the database. Now I can execute sql commands.
       
                         Thank you!
Comment 3 Roman Mostyka 2008-11-24 15:23:50 UTC
Verified by reporter.
Comment 4 David Vancouvering 2008-11-24 17:09:13 UTC
Great!  Glad you could get this to work.