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.
| Summary: | SQL Log window has unwanted blank lines and does not have click-links for successful statements | ||
|---|---|---|---|
| Product: | db | Reporter: | NukemBy |
| Component: | Show Data | Assignee: | matthias42 |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | ||
| Priority: | P3 | ||
| Version: | 8.2 | ||
| Hardware: | All | ||
| OS: | All | ||
| Issue Type: | ENHANCEMENT | Exception Reporter: | |
| Attachments: |
sample SQL output
SQLExecutionLoggerImpl.java |
||
Created attachment 161609 [details]
SQLExecutionLoggerImpl.java
Thank you - I integrated your patch but modified it slightly. So there is still one blank line between statements. The changeset is pushed as: http://hg.netbeans.org/core-main/rev/0a396c2f9d6f Integrated into 'main-silver', will be available in build *201703230002* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress) Changeset: http://hg.netbeans.org/main-silver/rev/0a396c2f9d6f User: Matthias Blaesing <matthias42@netbeans.org> Log: #267511: Print location of executed statement as hyperlink and reduce printed lines Based on patch from NukemBy@netbeans.org |
Created attachment 161608 [details] sample SQL output There are 2 problems in current implementation of output of SQL execution logs which get especially annoying for SQL scripts having large number of statements 1. Each successful statement is logged, but it is not possible to click-navigate to a particular one - for example in the case when I have 100 consecutive statements and some of them in-between runs significantly longer then others, it is not possible to quickly locate it in source code. 2. Current output format is too long - takes at least 5 lines per statement (one of them is just excessive blank line). It will rather readable without blank lines - each statement can be visually separated by the 'link' to source code at the beginning of corresponding log message. Please take a look onto attached image of how it may look like. I also attach vesion of "db.core\src\org\netbeans\modules\db\sql\loader\SQLExecutionLoggerImpl.java" as my attempt to make output look better. Feel free to 'compare' and copy/paste code as needed.