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 219815 - Database explorer tool, can not view data as "long varchar" with Sybase ASA v10 and v12 drivers.
Summary: Database explorer tool, can not view data as "long varchar" with Sybase ASA v...
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 7.2
Hardware: PC Windows 7 x64
: P2 normal (vote)
Assignee: Jaroslav Havlin
URL:
Keywords: NETFIX
Depends on:
Blocks:
 
Reported: 2012-10-10 12:18 UTC by rickqin
Modified: 2012-10-25 10:52 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
IDE log (66.25 KB, text/plain)
2012-10-10 12:18 UTC, rickqin 		Details
proposed patch v1 (2.47 KB, patch)
2012-10-11 17:52 UTC, matthias42 		Details | Diff
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 rickqin 2012-10-10 12:18:41 UTC 
Product Version = NetBeans IDE 7.2 (Build 201207171143)
Operating System = Windows 7 version 6.1 running on x86
Java; VM; Vendor = 1.6.0_33
Runtime = Java HotSpot(TM) Client VM 20.8-b03

Database explorer tool
Sybase ASA, jconn3.jar, com.sybase.jdbc3.jdbc.SybDataSource & com.sybase.jdbc3.jdbc.SybDrive.
Can not view data in the table which contains column of long varchar type.

java.lang.UnsupportedOperationException: The method com.sybase.jdbc3.jdbc.SybResultSet.getClob(int) is not supported and should not be called.
	at com.sybase.jdbc3.jdbc.ErrorMessage.raiseRuntimeException(Unknown Source)
	at com.sybase.jdbc3.utils.Debug.notSupported(Unknown Source)
	at com.sybase.jdbc3.jdbc.SybResultSet.getClob(Unknown Source)
	at org.netbeans.modules.db.dataview.util.DBReadWriteHelper.readResultSet(DBReadWriteHelper.java:267)
	at org.netbeans.modules.db.dataview.output.SQLExecutionHelper.loadDataFrom(SQLExecutionHelper.java:518)
	at org.netbeans.modules.db.dataview.output.SQLExecutionHelper.initialDataLoad(SQLExecutionHelper.java:141)
	at org.netbeans.modules.db.dataview.output.DataView.create(DataView.java:105)
	at org.netbeans.modules.db.dataview.api.DataView.create(DataView.java:74)
[catch] at org.netbeans.modules.db.sql.execute.SQLExecuteHelper.execute(SQLExecuteHelper.java:116)
	at org.netbeans.modules.db.sql.loader.SQLEditorSupport$SQLExecutor.run(SQLEditorSupport.java:564)
	at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:1452)
	at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:2032)
Comment 1 rickqin 2012-10-10 12:18:52 UTC 
Created attachment 125683 [details]
IDE log
Comment 2 rickqin 2012-10-10 12:21:44 UTC 
nb7.0.2 is ok.
Comment 3 matthias42 2012-10-11 17:52:00 UTC 
Created attachment 125797 [details]
proposed patch v1

(In reply to comment #0)
> Database explorer tool
> Sybase ASA, jconn3.jar, com.sybase.jdbc3.jdbc.SybDataSource &
> com.sybase.jdbc3.jdbc.SybDrive.
> Can not view data in the table which contains column of long varchar type.
> 
> java.lang.UnsupportedOperationException: The method
> com.sybase.jdbc3.jdbc.SybResultSet.getClob(int) is not supported and should not
> be called.
>     at com.sybase.jdbc3.jdbc.ErrorMessage.raiseRuntimeException(Unknown Source)
>     at com.sybase.jdbc3.utils.Debug.notSupported(Unknown Source)
>     at com.sybase.jdbc3.jdbc.SybResultSet.getClob(Unknown Source)
>     at
> org.netbeans.modules.db.dataview.util.DBReadWriteHelper.readResultSet(DBReadWriteHelper.java:267)

Jay! It would have be too easy to wrap the Error into an SQLException, which is already caught (and documented to be thrown by getClob...). Someday I will meet a jdbc driver developer ... :-)

Can you try the attached patch? It was created against netbeans core-main and catches the exception - whether this fixes all issues remains to be seen.
Comment 4 Jaroslav Havlin 2012-10-22 15:58:29 UTC 
The patch seems OK.
Integrated as http://hg.netbeans.org/core-main/rev/209beea7c2e9
Thank you very much, Matthias.

Rickqin, please verify.
Comment 5 Quality Engineering 2012-10-25 10:52:36 UTC 
Integrated into 'main-golden', will be available in build *201210250921* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress)
Changeset: http://hg.netbeans.org/main-golden/rev/209beea7c2e9
User: Jaroslav Havlin <jhavlin@netbeans.org>
Log: #219815: Database explorer tool, can not view data as "long varchar" with Sybase ASA v10 and v12 drivers