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?
Sign in to add a comment
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!