Build: NetBeans IDE 6.5 (Build 200811100001)
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
aldobrucale: click in a link in an sql output tab
aldobrucale: following a link in db output
java.lang.IndexOutOfBoundsException: Invalid line index=57 >= lineCount=55
Created attachment 73584 [details]
I think what's happening here is you are executing SQL with an error in it that refers to a line number, but the line
number is wrong, so the hyperlink fails.
The line number comes from the database server, so if the server is sending us the wrong line number, there's not much
we can do here.
It would be great if you could tell us what database vendor you are using, and what version of their driver you are using.
If you can provide an example of a SQL statement that doesn't work, that would be awesome.
Anyway, even though we can't prevent the exception, what we can do is see if there is a way to report the error that
isn't just an exception report.
Hm, I think I need to retract what I said before. For example, if I execute this:
from actor a
I get this:
Error code 1064, SQL state 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near 'from actor a LIMIT 20 OFFSET 0' at line 5
Line 1, column 1
Execution finished after 0 s, 1 error(s) occurred.
Notice that the server says "line 5" but the hyperlink says "Line 1, column 1". So it does sound like *we're* the ones
generating the line number, and we're doing it wrong for some reason.
victoriaz: can you please provide the SQL that caused the error? That would be really helpful.
I have tried various ways to get a bad line number but don't seem to have the right magic key to make it happen...
Reassigned to new owner.
I just received this error, so here is some more info:
Product Version: NetBeans IDE 6.5 (Build 200811100001)
Java: 1.5.0_16; Java HotSpot(TM) Client VM 1.5.0_16-133
System: Mac OS X version 10.5.6 running on i386; MacRoman; en_US (nb)
I was using a MySQL database:
Server version: 6.0.9-alpha MySQL Community Server (GPL)
Created attachment 78164 [details]
SQL file that produces issue
Sorry, one more thing I forgot,
Database Connection Driver:
NB6.7 was released already - http://www.netbeans.org/community/releases/67/
Postpone fixing this issue on the next release.
Caused by improper handling of line comments.
*** This issue has been marked as a duplicate of 171865 ***