Created attachment 66339 [details]
stacktrace

Build: NetBeans IDE Dev (Build 080804)
VM: Java HotSpot(TM) Client VM, 1.5.0_13-121, Java(TM) 2 Runtime Environment, Standard Edition, 1.5.0_13-b05-241
OS: Mac OS X, 10.4.11, i386

User Comments: 
1. Connect to DB.
2. Rightclick some table ad choose "View Data...".
3. Disconnect during retrieve data.

Result: NullPointerException arises.

Stacktrace: 
java.lang.NullPointerException
        at org.netbeans.modules.db.dataview.output.DataViewTablePanel.<init>(DataViewTablePanel.java:89)
        at org.netbeans.modules.db.dataview.output.DataViewUI.<init>(DataViewUI.java:146)
        at org.netbeans.modules.db.dataview.output.DataView.createComponents(DataView.java:130)
        at org.netbeans.modules.db.dataview.api.DataView.createComponents(DataView.java:88)
        at org.netbeans.modules.db.sql.loader.SQLEditorSupport$2.run(SQLEditorSupport.java:328)
        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)

Created attachment 66459 [details]
stacktrace

jawed, can you please evaluate this issue (that means assigning a Target Milestone).  Thanks.

Build: NetBeans IDE Dev (Build 200808061401)
VM: Java HotSpot(TM) Client VM, 10.0-b22, Java(TM) SE Runtime Environment, 1.6.0_06-b02
OS: Windows XP, 5.1, x86

User Comments: 
tried to execute sp_helptext

Stacktrace: 
java.lang.NullPointerException
        at org.netbeans.modules.db.dataview.output.DataViewTablePanel.<init>(DataViewTablePanel.java:89)
        at org.netbeans.modules.db.dataview.output.DataViewUI.<init>(DataViewUI.java:146)
        at org.netbeans.modules.db.dataview.output.DataView.createComponents(DataView.java:128)
        at org.netbeans.modules.db.dataview.api.DataView.createComponents(DataView.java:88)
        at org.netbeans.modules.db.sql.loader.SQLEditorSupport$2.run(SQLEditorSupport.java:332)
        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)

Created attachment 66906 [details]
stacktrace

Build: NetBeans IDE 6.5 Beta (Build 200808111757)
VM: Java HotSpot(TM) Client VM, 11.0-b12, Java(TM) SE Runtime Environment, 1.6.0_10-beta-b25
OS: Windows XP, 5.1, x86

User Comments: 
Running a SQL query (select * from table) on an Oracle database.

Stacktrace: 
java.lang.NullPointerException
        at org.netbeans.modules.db.dataview.output.DataViewTablePanel.<init>(DataViewTablePanel.java:89)
        at org.netbeans.modules.db.dataview.output.DataViewUI.<init>(DataViewUI.java:146)
        at org.netbeans.modules.db.dataview.output.DataView.createComponents(DataView.java:130)
        at org.netbeans.modules.db.dataview.api.DataView.createComponents(DataView.java:88)
        at org.netbeans.modules.db.sql.loader.SQLEditorSupport$2.run(SQLEditorSupport.java:328)
        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)

Created attachment 67772 [details]
stacktrace

Build: NetBeans IDE Dev (Build 080819)
VM: Java HotSpot(TM) Client VM, 11.0-b13, Java(TM) SE Runtime Environment, 1.6.0_10-rc-b26
OS: Windows XP, 5.1, x86

User Comments: 
1. Added MS SQL Server driver.
2. Added MS SQL Server to the IDE.
3. Rightclick some table and choose "View Data...".
4. Rightclick another table quickly and choose "View Data...".

Result: NullPointerException arises.

Stacktrace: 
java.lang.NullPointerException
        at org.netbeans.modules.db.dataview.output.DataViewTablePanel.<init>(DataViewTablePanel.java:89)
        at org.netbeans.modules.db.dataview.output.DataViewUI.<init>(DataViewUI.java:146)
        at org.netbeans.modules.db.dataview.output.DataView.createComponents(DataView.java:128)
        at org.netbeans.modules.db.dataview.api.DataView.createComponents(DataView.java:88)
        at org.netbeans.modules.db.sql.loader.SQLEditorSupport$2.run(SQLEditorSupport.java:332)
        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)

Created attachment 67808 [details]
stacktrace

This issue has already 5 duplicates 
see http://statistics.netbeans.org/exceptions/detail.do?id=85362

Build: NetBeans IDE Dev (Build 200808221401)
VM: Java HotSpot(TM) Client VM, 1.6.0_02-b06, Java(TM) SE Runtime Environment, 1.6.0_02-b06
OS: Windows XP, 5.1, x86

User Comments: 
hi!

Good day!

Got this exception when I run my SQL select statement
Thanks and more power,
Allen Montejo

Stacktrace: 
java.lang.NullPointerException
        at org.netbeans.modules.db.dataview.output.DataViewTablePanel.<init>(DataViewTablePanel.java:89)
        at org.netbeans.modules.db.dataview.output.DataViewUI.<init>(DataViewUI.java:146)
        at org.netbeans.modules.db.dataview.output.DataView.createComponents(DataView.java:128)
        at org.netbeans.modules.db.dataview.api.DataView.createComponents(DataView.java:88)
        at org.netbeans.modules.db.sql.loader.SQLEditorSupport$2.run(SQLEditorSupport.java:332)
        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)

Created attachment 68156 [details]
stacktrace

I did try with MS SQL Server to re create this problem but i don't see any exception being thrown out. It works fine for
me. can you please test with latest installer. Let me know the steps you are following in case you still get NPE.

I followed steps in desc10 and still able to reproduce this issue with latest build.
Probably it depends on connection speed, since my connection to MS SQL Server is pretty slow.

I changed my MS SQL Server driver from 1.1.1501.101 to 1.2.2828.100 and everything is fine now, so probably changing
driver to latest should help.

Verified.

I am getting this in build 200809220201 with the Merlia 7.03 driver.

Not sure about Merlia 7.03 driver, I don't think that in our supported driver list.

Actually my issue were fixed.

Fixed.

Verified.

I just got it in 200810080201 running a sp_helptext on a stored procedure with Merlia 7.03 driver

This issue for supported DBs was fixed. At least I don't see it.
ranbato, can You file new issue for particular driver with steps to reproduce and attached message.log.
Since Merlia isn't supported driver, we should track this issue in separate thread.
Sorry for inconvenience.

Verified.

I have added 150950

Thanks ranbato.

Reopening - reproduced in NetBeans IDE 6.5 RC2 (Build 200810270001)
http://statistics.netbeans.org/exceptions/detail.do?id=137488

guys, this makes the SQL editor useless in 6.5 

This worked in 6.1 and previous builds of 6.5

MS SQL Server driver is not fully JDBC compliant, maybe that's the cause ?

How about trying the jTDS driver

We're using Sybase. 

This was working in the daily builds of 6.5 so it's a very recent change that has broken it. 

Which other databases aren't working now ? 

We really need to get this fixed ASAP and get it into the patch release.  I am not sure what changed but we need to
track this down.  jawed, please confirm that you're working on this; if I don't hear from you in 24 hours I'll reassign.

There was a change on Oct 17 that looks suspicious.
http://hg.netbeans.org/main?cmd=changeset;node=70ca140cad82

DBMetaDataFactory.getForeignKeys(...)  was changed to return null if an exception occurred.

I see David caught this change (sent feedback) but this hasn't been fixed.

however, reverting the change mentioned in my last comment may not fix the bug - I would expect a different exception to
occur.  So, maybe that isn't the cause of this exception, just a guess.

do you want me to test a patch ? 

We use a combination of Postgres, Sybase and Oracle.

I am not able to re produce this with Oracle, MySQL, MS SQL Server databases, though with Merlia driver i can see the
same NPE exception but Merlia is not supported driver. Can you please help me to re-create this problem.

John, This problem is not because of the fix : http://hg.netbeans.org/main?cmd=changeset;node=70ca140cad82.

We use jConnect from Sybase running on Solaris. 

It has been broken very recently. It was working in previous builds of 6.5 and of course in 6.1 so we are taking a
backward step. 

For Sybase databases it doesn't work at all ( previously did) 

Works fine for Postgres thou. 

Is there more logging or some more details I can give you so that you can fix ? 

If the stack trace differs from any of the stacktraces, then yes, please attach the sybase stack trace

jawed: Please try with Sybase.  

I just checked with QE, and Sybase is not on our list of supported databases.  That doesn't mean I'll close the bug, but
it does mean I'm going to downgrade this to a P2.

 nleck, instead of using the jConnect driver, could you please try the jTDS driver ?

Driver Location 	 http://sourceforge.net/project/showfiles.php?group_id=33291
Driver Version 	jTDS 1.2.1 jtds-1.2.1-dist.zip
Driver JAR File	jtds-1.2.1.jar
Driver Classname 	net.sourceforge.jtds.jdbc.Driver
URL Format 	jdbc:jtds:sqlserver://<host>[:<port>][/<database>][;<property>=<value>[;...]]

wow Sybase is has a huge install base on Solaris in the banking instustry... it really should be one of your supported
databaases. 

Again this was working as of a few releases ago and it's a NPE which is normally the easiest of all bugs to fix, ie give
it a default value at the line number that it fails on. 

I know, I know, but we are only a small team and can only cover so much.  Each database requires setting up an
environment and keeping it up and running.  Hey, I *worked* at Sybase for 10 years, so I know what a great database it is.

But take a look at this

http://davidvancouvering.blogspot.com/2008/11/httpstatisticsnetbeansorganalyticsgraph.html

Sybase falls within "other".  This is consistent with surveys and activity on the nbusers list.

So, we have to prioritize...

I'm not saying we won't fix this - we should and I would really like to, and let's work on getting it fixed.  I'd really
like to get it in the patch release.  It just can't be a P1 blocker if it's not a supported database vendor.

Can you please send us your *specific* stack trace that you get? That would really help.

Meanwhile, Roman, do you think you can set up a Sybase environment?

By the way, we should get this to work with jConnect, it's the official TDS driver for Sybase.  But it would be
interesting to see if you can work around this by using jTDS.

It works with the jTDS driver, thanks.

OK, this seems like a reasonable workaround.  But I'd still like to see if we can get this fixed.  Can you please attach
the stack trace you get with jConnect?

Created attachment 73888 [details]
Stack Traces

Looks very similar to 153219 - I think the fix proposed by sansan might fix this

jConnect doesn't support getTableName

yes, this looks like the same issue. Should we mark this bug as a dependant of #153219 ?

Since we don't know for sure, we can just leave the issues as is 

153219 was fixed so waiting for nleck to confirm that this fixed also (possibly duplicates)

Created attachment 73895 [details]
Errro after appying patch

No metadata can be retrieved using jConnect

Looks like the only way to execute Sybase queries is to use the jTDS driver.

Reducing the priority, changing TM to next

restoring the priority to 2.

I think there should be another way to execute queries for Sybase even if no metadata is available.

another user says "
"The same problem was with Merlia driver for MS SQL Server. Metadata could not be retrieved using this driver. "

Update.  The fix for 153219 fixes the problem with using the Merlia driver with MS SQLServer

At this point, the only driver that we know fails is the jConnect driver with Sybase

I'm going to try to install Sybase to try this out.

Just to be sure thought, when using jConnect you should use version 6.0.5 or later
and the driver class is com.sybase.jdbc3.jdbc.SybDriver

nleck are these the version and class you are using ?

Hi shikua , did you intend to change the component of this issue to schema2beans ?

Do you have any more comments to add, here?

This bug (in db.dataview) has mostly been fixed - fix is in the trunk builds and might be available in the 6.5 patch

The remaining bug occurs when using the jConnect driver.  A workaround is to use the jTDS driver.

*** Issue 150950 has been marked as a duplicate of this issue. ***

Created attachment 74103 [details]
sybase jconnect view data result

The fix for 153219  also fixes this issue.

To connect to Sybase, use jConnect6.0.5

Driver jar:  jconn3.jar
Driver class: com.sybase.jdbc3.jdbc.SybDataSource

See attached screenshot sybase_jconnect6_result.PNG showing successful view data result

Verified using this build:   Product Version: NetBeans IDE Dev (Build 200811240201)

*** This issue has been marked as a duplicate of 153219 ***

Fixed.

Fixed with issue #153219.

Verified.

this is *NOT* fixed as of 6.5....

Unless your talking about a daily build this issue should be re-opened.

6.5 was already released, so can only be included in patch releases of 6.5

The fix has been verified using the trunk builds.  I mentioned this in a previous comment des60

Fix is going to be included in 6.5 Patch 1