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.
I'm using the SQL Profiler on a project that generates SQL statements of extreme length. These SQL statements show up in the profiler, but the end is missing. At first I tought this was only done to show in the table, but Right-click > View SQL Query doesn't show a longer version than the table does. I would expect upto 64K characters to be shown in the View SQL Query popup.
You are right, there is a limit for size of SQL statements. SQL profiler is not sql debugger - our main task is to track from which java code invokes SQL statements and how long it takes to execute it. We can increase current limit, but it can have performance impact on both profiled application and NetBeans itself. I wonder how you came to the conclusion that upto 64K characters should be shown in the View SQL Query popup. Why not 32K or 128K?
I read somewhere 64K was the maximum length of a sql statement in Oracle. I just thought the 1K limit felt quite short. (In reply to Tomas Hurka from comment #1) > You are right, there is a limit for size of SQL statements. SQL profiler is > not sql debugger - our main task is to track from which java code invokes > SQL statements and how long it takes to execute it. We can increase current > limit, but it can have performance impact on both profiled application and > NetBeans itself. I wonder how you came to the conclusion that upto 64K > characters should be shown in the View SQL Query popup. Why not 32K or 128K?