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 141417 - No table view
Summary: No table view
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-07-23 21:05 UTC by zodiac1913
Modified: 2008-07-24 18:01 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
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 zodiac1913 2008-07-23 21:05:44 UTC 
I have the ms sql server jdbc drivers (tried both 1.2 and 2) for sqlsvr 2005.  I have connected to the sql server 
without any problems but when I try to open tables,views,or procedures I get nothing.  I did this on the mysql server 
with no trouble.  I really wouldnt mind that much to programmatically attach db tables to jsf tables but I cant find 
any good docs on that either.  Id rather not reinvent the wheel anyways, I just want to see my sql server tables.  
Again I did this on a SLES 10 server and a Windows XP machine and got the same results
Comment 1 John Baker 2008-07-23 21:41:20 UTC 
Please attach messages.log (View->IDE Log File)

For using MSSQL with Visual Web JSF you might want to try the jTDS driver
http://wiki.netbeans.org/DatabasesAndDrivers#section-DatabasesAndDrivers-JTDSDriverForTheSQLServerDatabase
Comment 2 Andrei Badea 2008-07-24 09:48:16 UTC 
Are you sure you are connecting to the right schema? In the Connect dialog, after entering your name and password,
select the Advanced tab and press Get Schemas. Check if selecting the "dbo" schema helps.
Comment 3 zodiac1913 2008-07-24 17:39:48 UTC 
jbaker thanks for the suggestion although abadea solved the issue I do love open source and TDS so I am glad to have
that alternative.  abadea many thanks that was my issue.
Comment 4 Roman Mostyka 2008-07-24 18:01:10 UTC 
Verified with build 080724.