Error when selecting SQL statement with semicolon in Execute Command window release701
authorSubhashini Sooriarachchi <subslk@netbeans.org>
Tue, 17 Jul 2012 09:14:49 +0530
branchrelease701
changeset 2566a4e706933eb
parent 255 ab42a180b26b
child 257 b16664261b68
Error when selecting SQL statement with semicolon in Execute Command window
PLSQL/Execution/src/org/netbeans/modules/plsql/execution/PlsqlFileExecutor.java
     1.1 --- a/PLSQL/Execution/src/org/netbeans/modules/plsql/execution/PlsqlFileExecutor.java	Fri Jul 13 11:11:53 2012 +0530
     1.2 +++ b/PLSQL/Execution/src/org/netbeans/modules/plsql/execution/PlsqlFileExecutor.java	Tue Jul 17 09:14:49 2012 +0530
     1.3 @@ -210,15 +210,19 @@
     1.4              }
     1.5              if (state == NORMAL) {
     1.6                  nonCommentQuery.append(line).append("\n");
     1.7 -            }
     1.8 +             }
     1.9          }
    1.10 -            nonCommentQuery.deleteCharAt(nonCommentQuery.length() - 1);
    1.11 -        
    1.12 +         
    1.13 +        String querryString = nonCommentQuery.toString().trim();
    1.14 +        if(querryString.endsWith(";")){
    1.15 +           querryString = querryString.substring(0, querryString.lastIndexOf(";"));
    1.16 +        }
    1.17 +                  
    1.18          String newQuery = "";
    1.19          String token;
    1.20          boolean format = false;
    1.21          
    1.22 -        StringTokenizer tokenizer = new StringTokenizer(nonCommentQuery.toString(), " \t\n");
    1.23 +        StringTokenizer tokenizer = new StringTokenizer(querryString, " \t\n");
    1.24          while (tokenizer.hasMoreTokens()) {
    1.25              token = tokenizer.nextToken();
    1.26