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: | Statement seperator needs to be configurable in sql editor | ||
---|---|---|---|
Product: | db | Reporter: | paolosca <paolosca> |
Component: | SQL Editor | Assignee: | Jiri Rechtacek <jrechtacek> |
Status: | RESOLVED WONTFIX | ||
Severity: | normal | CC: | akiliyevich |
Priority: | P3 | ||
Version: | 7.1 | ||
Hardware: | PC | ||
OS: | Linux | ||
Issue Type: | DEFECT | Exception Reporter: |
Description
paolosca
2011-12-14 16:04:12 UTC
> Could it be a compatibility issue with OpenJDK 1.7?
The problem is probably in splitting text into statements. Semicolon is used as a statement delimiter, which is incorrect if semicolon is used inside statement (e.g. procedures, triggers).
*** Bug 165125 has been marked as a duplicate of this bug. *** MySQL (and probably most DBMS) has the same problem - the command line client offers the "DELIMITER" command, which changes the statement terminator till the next "DELIMITER" command is reached. Either something similar is needed for netbeans editor or the ability to change the delimiter for the whole file, but the latter poses the problem that this needs to be persisted in some way. (In reply to comment #3) > Either something similar is needed for netbeans editor or the ability to change > the delimiter for the whole file, but the latter poses the problem that this > needs to be persisted in some way. I'm wrong this is already implemented in the db.core. Please try to run this sequence: ======SNIP====== DELIMITER / create or replace trigger wishers_insert before insert on wishers for each row begin select wishers_id_seq.nextval into :new.id from dual; end; / DELIMITER ; ======SNAP====== This should work. Please test - if this works the tutorial should be updated to include this. I checked the tutorial and tried my suggested fix. It works. I submitted that information via the feedback formular. I'll asume that fix will find it's way into the tutorial. |