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 115413 - MS SQLServer 2005 - Netbeans 5.5 Issue : Database tables not displayed under Tables for custom shemas after the connections is established
Summary: MS SQLServer 2005 - Netbeans 5.5 Issue : Database tables not displayed under ...
Status: CLOSED INVALID
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 5.x
Hardware: All Windows XP
: P4 blocker (vote)
Assignee: Andrei Badea
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-09-13 08:39 UTC by chenji
Modified: 2007-09-13 15:48 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments
SQL FILE (40.95 KB, application/octet-stream)
2007-09-13 08:40 UTC, chenji
Details
Error Images zip file (309.06 KB, application/octet-stream)
2007-09-13 08:42 UTC, chenji
Details

Note You need to log in before you can comment on or make changes to this bug.
Description chenji 2007-09-13 08:39:07 UTC
In NetBeans 5.5 or 5.5.1, after connecting to MICROSOFT SQL SERVER 2005 EVALUATION EDITION version using sqljdbc.jar
driver(Microsoft SQL Server 2005 JDBC Driver 1.2 or 1.1 versions) unable to see database tables for custom schemas
created under a database.

OS : Windows XP SP2
JDK : java version "1.6.0_02"
Java(TM) SE Runtime Environment (build 1.6.0_02-b06)
Java HotSpot(TM) Client VM (build 1.6.0_02-b06, mixed mode, sharing)

More details :

In SQL Server 2005 created a database with name "InventoryControl". The name of the database is "InventoryControl" this
database consists of about 30 tables.  By default these 30 tables are created using the dbo schema.  Example
dbo.TableName1, dbo.TableName2, etc.Have changed that.  In the InventoryControl database I've created 3 schemas under
Security->Schemas.  The schema names are bmd, agdia, and abook. I then changed the tables to be part of the new schemas.
 Example bmd.TableName1, bmd.TableName2, agdia.TableName1, agdia.TableName2, abook.TableName1, abook.TableName2 

Please run the attached SQL Script which does create the custom schemas & tables under database from the MS SQL Server
2005 Management Studio.

When I click the Runtime tab -> Databases -> Add  Driver -> Add MS SQL Server jdbc driver -> Connect using..-> 

Connection Details :
Driver : com.microsoft.sqlserver.jdbc.SQLServerDriver
Database URL : jdbc:sqlserver://localhost:1433;databaseName=InventoryControl;selectMethod=cursor
user : sa
passwd : XXXXXX

Click Ok & connection is established successfully. In the Advanced tab NEVER shows the 3 custom schemas that have been
created. I can see all the other default schemas including dbo but the custom schemas do not show up. The connection URL
is correct. 

If select the dbo as schema from the drop down also NO database tables are visible under the Tables under the new
connection.

But when you open SQL Editor for the connection & run a simple SQL statement to retrieve values from any tables existing
in the database it works fine.The results are displayed in the output.

It is reproducible on NetBeans 5.5 or 5.5.1 versions also. 

More details please refer to attached screen shots.

Microsoft SQL Server Management Studio (expires in 180 days)			9.00.1399.00
Microsoft Analysis Services Client Tools					2005.090.1399.00
Microsoft Data Access Components (MDAC)						2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML						                        2.6 3.0 4.0 5.0 6.0 
Microsoft Internet Explorer						        7.0.5730.11
Microsoft .NET Framework						        2.0.50727.832
Operating System						                5.1.2600
Comment 1 chenji 2007-09-13 08:40:15 UTC
Created attachment 48718 [details]
SQL FILE
Comment 2 chenji 2007-09-13 08:42:04 UTC
Created attachment 48719 [details]
Error Images zip file
Comment 3 chenji 2007-09-13 09:15:41 UTC
Please ignore this case. This issue has been resolved by myself. Consider as INVALID case.

Just changed the schema name property to required database custom schema "bmd" or "abook" in the database connection
properties resolved my problem.

Anyway thnx for the support