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

Summary:	Need ability to choose multiple schema in ConnectUsing option
Product:	db	Reporter:	Sakthivel Gopal <sakthivelg>
Component:	Code	Assignee:	Libor Fischmeistr <lfischmeistr>
Status:	RESOLVED WORKSFORME
Severity:	blocker
Priority:	P3
Version:	5.x
Hardware:	Sun
OS:	All
Issue Type:	ENHANCEMENT	Exception Reporter:
Bug Depends on:
Bug Blocks:	152818

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.