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 81016 - Need ability to choose multiple schema in ConnectUsing option
Summary: Need ability to choose multiple schema in ConnectUsing option
Status: RESOLVED WORKSFORME
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 5.x
Hardware: Sun All
: P3 blocker (vote)
Assignee: Libor Fischmeistr
URL:
Keywords:
Depends on:
Blocks: 152818
  Show dependency tree
 
Reported: 2006-07-24 19:46 UTC by Sakthivel Gopal
Modified: 2014-01-05 21:28 UTC (History)
0 users

See Also:
Issue Type: ENHANCEMENT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Sakthivel Gopal 2006-07-24 19:46:35 UTC 
IDE 5.5 Dev build 20060720
with Creator Pack

I have added a database connection in Runtime window.
With my userid, i need to access tables from different schema, say, TRAVEL and
VIR schema (using userid dbadmin with derby)

The Current Connectusing dialog allows me to choose only one schema. So I have
to add two connections to be able to use tables from two different schemas. This
creates/configures two JDBC datasources with the AppServer, on deploymenyt.

I want to be able to choose multiple schema and use tables from those from One
connection, So that CreatorPack deployment configures only one datasource for
the connection i am using.

Creator releases (Thresher, leopard) had this feature.

-Sakthi
Comment 1 Jiri Rechtacek 2009-10-16 14:03:35 UTC 
Reassigned to new owner.
Comment 2 matthias42 2014-01-05 21:28:46 UTC 
Checked in 7.4 - all schemas are listed under a derby database node (that is under "Other schemas". The SQL needs to specify the schema, if it is not the default, but it is accessible.