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 16840

Summary:	getTables() not returning all tables for MS SQL via Avenir
Product:	db	Reporter:	Larry D. Wilson <casadelnorte>
Component:	Code	Assignee:	issues@db <issues>
Status:	CLOSED INVALID
Severity:	blocker
Priority:	P2
Version:	-FFJ-
Hardware:	PC
OS:	Linux
Issue Type:	DEFECT	Exception Reporter:

Description Larry D. Wilson 2001-10-22 23:37:56 UTC

Using JDBC driver from www.atinav.com (CaveCEXAPI25C.jar) to connect to remote
MS SQL Server 2000 instance.

The "Tables" folder in the Explorer only displays 2 of the tables. Using
Explorer, Execute command, I can query successully any of the missing tables.

This behavior is also apparent on the Views and Procedures folders (only
displays a subset of the schema)
Using JDK 1.4 beta2, RedHat 7.1 Prof, Avenir 2.5, and Forte4J 3.0

Comment 1 Radko Najman 2001-10-24 13:09:32 UTC

The problem is caused by Avenir's DatabaseMetaData.getSchemas() method implementation. The method doesn't 
return all available schemas so you cannot choose the rigth schema and that's why you don't see your 
tables.

Comment 2 Martin Schovanek 2003-03-12 14:14:39 UTC

VERIFIED

Comment 3 Quality Engineering 2003-06-30 17:17:44 UTC

Resolved for 3.3.x or earlier, no new info since then -> closing.