Hi, what kind of problems you are getting on Ubuntu? I have also tested on CentOS with NB 6.1+JDK5 with no problem. You can write me directly on my e-mail. Regards, Alexandre.
Very nice work. I'm on the dream team, and I've been evaluating this project for the grant program. Overall, I'm very impressed. Just thought you'd want to be aware of a few (pretty minor) snags I hit:
"Add New Oracle Connection" dialog has layout problem - I cannot see the Connect As dialog box very well (the bottom half is cut off). Easy fix with Matisse :)
Double-clicking on a Package Spec or Body downloads the file, prompting me for a save location. I'd expect it to open in the editor pane. layer/mime typing issue?
clicking around in the DBA/All/User buttons froze the IDE - if you total up the metadata from all users on this DB, it's very, very large. I'd be careful putting such a button right on the toolbar, or figure out a way to bail out if it takes too long.
Hi, why does it ask me to save to a file when I want to edit a procedure, why not open the editor with a default name (procedure name for example). Otherwise great plug-in, thank you!
Hey alexandre, I installed this plugin in NetBeans? 6.5 but it won't show code colors and formatting isn't possible. Is that a bug in version 6.5? Besides - thanks for the plugin! I think so far it is not much more than you can do f.ex. within SQLDeveloper. But it's very convenient to be able to open stuff and compile/get errors within NetBeans?. It would be just marvellous if one could go to definitions of variables, f.ex. - or even navigate through package files like through Java code....
I'd like to see this plugin turned into a generic editor that supports syntax for multiple databases: Oracle, PostgreSQL, MySQL, MSSQL, etc. Is it designed in a modular way to be able to support multiple database vendors, and do you have plans to do this?
Currently I'm much more interesting in porting existing project into GSF (Generic Scripting Framework). But GSF still does not have a public API… So expanding DB support is not planned yet.
What is the meaning of "code navigation" in this editor? I was assuming it as Ctrl+Click on a procedure name navigates me to the procedure definition; and Ctrl+Click on variable navigates to its declaration. I do not see that as the case here. Any idea if it is part of enhancements to this editor the same way Java code navigation works? Also, does any other third part tool allow it in the PLSQL context.
Currently the "code navigation" working only via NetBeans? navigator but not directly in PL/SQL code. This is the limitation of Generic Languages Framework (Project Schliemann).
from Valentin Jacquemin: "It would be great to define the default local directory when editing for example packages. Another usefull feature would be to have the possibility to launch the current file as a script on the database..."
Hi, is it possible to save the setup, here I mean the connection between the packages and the files? What should one do if many people are working on the same project, does everybody have to setup all the connection, or can it be saved in some sort of project?
hello, great plugin, but I can not use, because that tells me is needed memory in the heat more memory, it asks me 500mb. please help, or how I can change that to use it. Please, if anyone can help, write me at den.bosh.300@gmail.com, thanks.
You could edit .spc .bdy .prc .fnc .pks .pkb .trg .tps .tpb files without connecting to a DB server. Extension .sql is already registered by other Netbeans module.
could you also edit a sqlplus type file with spec and body in same file? and with / show errors prompt after spec and after body create I want to edit files that will later be used from sqlplus to add to a server.
I just downloaded your plugin this AM. I've been using it in NetBeans? 7.0M2. Setup was easy (after rebuilding from source after changing a module specification version due to the NetBeans? version).
Here's a patch for a missing feature. To get the toggle-comment functionality working, add the following to org.netbeans.modules.languages.pl_sql.PLSQLLanguage:
@Override
public String getLineCommentPrefix()
{
return "--";
}
There is a more correct way to do this (with a CommentHandler?) but this approach works fine.
Also, I wonder why all the actions are defined as non-asynchronous. I'll probably get tired of all the blocking going on (the database I work on is anywhere from 200ms to 800ms away in latency) and recompile at some future point. If I get to that point, I'll put in progress handles too.
Some plugins require plugin Editor Library to be installed. The plugin Editor Library is requested in version >= 2.10.1.10.2 (release version 2) but only 3.8.1.13.8 (of release version different from 2) was found. The following plugin is affected: (nb 7)
Hi! I installed this on Netbeans 7.0 and now I can't connect to Oracle either through the new "Oracle" panel or through the "classic" "Services" panel. When I try to connect it just timeouts after a long time trying. This same connection target works properly on SQLDevelopter, TOAD and it worked fine on netbeans 6.9. I don't think I tried to connect from NB 7.0 before installing your plugin so I don't really know who's at fault. Could it be related to the oracle-jdbc_thin_11.1.0.7.0_1.2.nbm in the bundle? Is there any way to unistall this? (It's not listed on "plugins" on NB). Have you ever seen something like this? Thanks a lot!!
I would also like to edit a SQL*Plus type file with both the spec and body in it. What is the limitation? Is it something that could be hacked into a slightly different version?
I would also like to edit a SQL*Plus type file with both the spec and body in it. What is the limitation? Is it something that could be hacked into a slightly different version?
If you know a good SQL*Plus grammar for ANTLR it’s not a big problem to create corresponding editor for Netbeans.
I try this modules in netbeans 7.0.1, It seems interesting, I use sqldeveloper3 too. It is very good idea, but we can't run a PL/SQL proc or function with parameters. the connection is easy, i must download the zip version, the module into the plugin manager doesn't work, it depends on something but what ???? plugin manager -> error depend on {O} or {1} ???
It seems to be missing the autocomplete option, future ... EXTRACT(DAY FROM SYSDATE) AND EXTRACT(DAY FROM SYSDATE) the world DAY, MONTH AND YEAR seem to be errors, but in sqldevelopper not trouble.
Great extension to netbeans! I've noticed that you already fixed the issue I found. I checked out the trunk to compile myself so I could have the fix, but keep getting the error nbplatform.default.harness.dir is undefined. I've researched on google links to try and fix it and nothing seems to work. Is it possible that you could just create another release on this page with the fix?
This is one of the best netbeans modules ever.
Hello, i get you module and try teste on Ubuntu Linux, 50 min after i stop, an try in Windows and it run very good. But in Linux how i can run???
Hi, what kind of problems you are getting on Ubuntu? I have also tested on CentOS with NB 6.1+JDK5 with no problem. You can write me directly on my e-mail. Regards, Alexandre.
Please validate this module and get it on the netbeans downloads from inside of netbeans so more people can use this.
Very nice work. I'm on the dream team, and I've been evaluating this project for the grant program. Overall, I'm very impressed. Just thought you'd want to be aware of a few (pretty minor) snags I hit:
"Add New Oracle Connection" dialog has layout problem - I cannot see the Connect As dialog box very well (the bottom half is cut off). Easy fix with Matisse :)
Double-clicking on a Package Spec or Body downloads the file, prompting me for a save location. I'd expect it to open in the editor pane. layer/mime typing issue?
clicking around in the DBA/All/User buttons froze the IDE - if you total up the metadata from all users on this DB, it's very, very large. I'd be careful putting such a button right on the toolbar, or figure out a way to bail out if it takes too long.
I can't install the plug in..the error says that there is not enough heap free space..how can I get around with it?
ok I'm just a noob..to solve the problem i've just extended the heap sizo from 404 to 512 MB ...tnx anyway guys
Thanks a lot guy, now I'm working fine with PL/SQL on Netbeans. I've just extended the heap size doing what the error msg says
hi Alex, Do you use Antlr in this project?
No, the PL/SQL language implementation is done based on Generic Languages Framework (Project Schliemann)
Does this plugin allow me to run procedures or do I still need to fire up SQL*Plus? If so, great. If not, I think that'd be a good addition.
Hi, why does it ask me to save to a file when I want to edit a procedure, why not open the editor with a default name (procedure name for example). Otherwise great plug-in, thank you!
This will be fixed in the next version.
Hey alexandre, I installed this plugin in NetBeans? 6.5 but it won't show code colors and formatting isn't possible. Is that a bug in version 6.5? Besides - thanks for the plugin! I think so far it is not much more than you can do f.ex. within SQLDeveloper. But it's very convenient to be able to open stuff and compile/get errors within NetBeans?. It would be just marvellous if one could go to definitions of variables, f.ex. - or even navigate through package files like through Java code....
Thank you!
Ah, I must correct myself: It took a while, but now code colours are there, and code formatting is possible by keyboard-shortcut.
I want to use an SID to connect but could not figure out how to do that. Like: myserver:1521:ORCL
Any ideas?
Just put ORCL as Database Name in connection dialog.
I'd like to see this plugin turned into a generic editor that supports syntax for multiple databases: Oracle, PostgreSQL, MySQL, MSSQL, etc. Is it designed in a modular way to be able to support multiple database vendors, and do you have plans to do this?
Currently I'm much more interesting in porting existing project into GSF (Generic Scripting Framework). But GSF still does not have a public API… So expanding DB support is not planned yet.
What is the meaning of "code navigation" in this editor? I was assuming it as Ctrl+Click on a procedure name navigates me to the procedure definition; and Ctrl+Click on variable navigates to its declaration. I do not see that as the case here. Any idea if it is part of enhancements to this editor the same way Java code navigation works? Also, does any other third part tool allow it in the PLSQL context.
Currently the "code navigation" working only via NetBeans? navigator but not directly in PL/SQL code. This is the limitation of Generic Languages Framework (Project Schliemann).
from Valentin Jacquemin: "It would be great to define the default local directory when editing for example packages. Another usefull feature would be to have the possibility to launch the current file as a script on the database..."
Hi, is it possible to save the setup, here I mean the connection between the packages and the files? What should one do if many people are working on the same project, does everybody have to setup all the connection, or can it be saved in some sort of project?
Has anyone been able to connect to an 8i database using this tool?
Would there be any way to modify the oracle-jdbc module, or replace it with an "8i" version?
Thanks, Mitch
Would be great if any one could introduce the Annotations to the editor (Errors, Warning etc.)
The Oracle database I use is accessed via the oracle.lite.poljdbc.POLJDBCDriver which needs its own library jar and custom jdbc connection string
Can't you re-use the standard Services --> Databases tab and connection logic? This would make it more standard.
oops, ignore that, it seems oracle lite doesn't support pl/sql!
hello, great plugin, but I can not use, because that tells me is needed memory in the heat more memory, it asks me 500mb. please help, or how I can change that to use it. Please, if anyone can help, write me at den.bosh.300@gmail.com, thanks.
Is there a way to edit without having a connection to a server? how about just editing files .sql instead of live connection
You could edit .spc .bdy .prc .fnc .pks .pkb .trg .tps .tpb files without connecting to a DB server. Extension .sql is already registered by other Netbeans module.
could you also edit a sqlplus type file with spec and body in same file? and with / show errors prompt after spec and after body create I want to edit files that will later be used from sqlplus to add to a server.
No, the SQL+ syntax is not supported.
auhhhhh , thats too bad :) now i just edit en dan use diff to create my .sql sqlplus files! works finee
This is ONE great plugin that I use most. Do you have any plan to include PL/SQL beautifier? Thanks!
I will put the "nice" formatting feature for PL/SQL code in my to-do list.
круто, молодец!
I just downloaded your plugin this AM. I've been using it in NetBeans? 7.0M2. Setup was easy (after rebuilding from source after changing a module specification version due to the NetBeans? version).
Here's a patch for a missing feature. To get the toggle-comment functionality working, add the following to org.netbeans.modules.languages.pl_sql.PLSQLLanguage:
@Override public String getLineCommentPrefix() { return "--"; }There is a more correct way to do this (with a CommentHandler?) but this approach works fine.
Also, I wonder why all the actions are defined as non-asynchronous. I'll probably get tired of all the blocking going on (the database I work on is anywhere from 200ms to 800ms away in latency) and recompile at some future point. If I get to that point, I'll put in progress handles too.
Thanks for the great plugin, it has made my day.
-Kris
Hi, nice plugin but im getting Syntax Erros when using named notation:
procedure_name
);At least PL/SQL Editor Version 2 supports such syntax and shows no error…
Some plugins require plugin Editor Library to be installed. The plugin Editor Library is requested in version >= 2.10.1.10.2 (release version 2) but only 3.8.1.13.8 (of release version different from 2) was found. The following plugin is affected: (nb 7)
Hi! I installed this on Netbeans 7.0 and now I can't connect to Oracle either through the new "Oracle" panel or through the "classic" "Services" panel. When I try to connect it just timeouts after a long time trying. This same connection target works properly on SQLDevelopter, TOAD and it worked fine on netbeans 6.9. I don't think I tried to connect from NB 7.0 before installing your plugin so I don't really know who's at fault. Could it be related to the oracle-jdbc_thin_11.1.0.7.0_1.2.nbm in the bundle? Is there any way to unistall this? (It's not listed on "plugins" on NB). Have you ever seen something like this? Thanks a lot!!
I would also like to edit a SQL*Plus type file with both the spec and body in it. What is the limitation? Is it something that could be hacked into a slightly different version?
If you know a good SQL*Plus grammar for ANTLR it’s not a big problem to create corresponding editor for Netbeans.
Please send me (in e-mail) your connection properties from SQL Developer. What Oracle DB version do you have?
Hi,
I try this modules in netbeans 7.0.1, It seems interesting, I use sqldeveloper3 too. It is very good idea, but we can't run a PL/SQL proc or function with parameters. the connection is easy, i must download the zip version, the module into the plugin manager doesn't work, it depends on something but what ???? plugin manager -> error depend on {O} or {1} ???
It seems to be missing the autocomplete option, future ... EXTRACT(DAY FROM SYSDATE) AND EXTRACT(DAY FROM SYSDATE) the world DAY, MONTH AND YEAR seem to be errors, but in sqldevelopper not trouble.
It's GREAT !
Olivier
Hi Olivier,
Are you following the installation instruction from http://code.google.com/p/pl-sql-editor/ ?
Alexandre.
that's what I did
thanks
good job keep the good work up :) http://www.pomnazanie-pieniedzy.pl/inwestycyjny-kredyt.html
is there a way to browse the database tables in this plugin?
No, unfortunately not.
Great extension to netbeans! I've noticed that you already fixed the issue I found. I checked out the trunk to compile myself so I could have the fix, but keep getting the error nbplatform.default.harness.dir is undefined. I've researched on google links to try and fix it and nothing seems to work. Is it possible that you could just create another release on this page with the fix?
Please, check your e-mail.