Hi,
I'm working with Eclipse pluggin 3.5.0 beta and I'm able to connect to my Postgres 8.2 DB.
But the Database structure doesn't show me the Functions, Triggers or Procedures.
Any idea.
Thank you in advance and congratulations.
Carlos
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I've had a quick look and can't see anything wrong - at least from the client POV, it's executing the query and getting nothing back. I have absolutely zero experience with Postgres so I'm a bit stuck here. If you (or anyone else) was interested in taking a look, the classes to check out are:
If you want to submit changes, you can either do it directly or email them to me as patches and I'll add them in. It should just be as simple as tweaking the SQL to be 8.x compatible (eg making an inner join an outer), but unfortunately I simply haven't the time to learn Postgres :(
Cheers,
John
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Just a thought - I don't think that the Postgres plugin wasn't distributed with the 3.5.0beta1 so it may be simply that you have an out of date copy of the plugin. 3.5.0beta2 will be out soon (hopefully this week but that's what I said last week) and will include a fresh Postgres plugin - give it another go then and let me know what happens.
John
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi, I found SQL Explorer today and it seems like very nice tool! But I have the same problem with the PostgreSQL. The Functions, Procedures, etc view is broken probably because of org.postgresql.jdbc4.Jdbc4PreparedStatement.setQueryTimeout(int).
Error says: Error loading children: Method org.postgresql.jdbc4.Jdbc4PreparedStatement.setQueryTimeout(int) not implemented.
The same error is with the jdbc3 postgresql driver.
In driver version 8.3+ the driver throws exception for setQueryTimeout(int), for older versions driver simply do nothing...
Is there any chance to repair this from SQL Explorer side? Please! I'm tired from PgAdmin! :-)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Thank you very much, that was fast. Now the function tree works fine.
Unfortunately now it seems that I cannot view the bodies (definitions) of the functions (something like Create Table Script for tables -> Create Function Script).
Btw, on the website http://www.sqlexplorer.org/help.php - the donation link don't work (Eclipse SQL Explorer [RCP/Plugin] (eclipsesql) has not opted in to receive donations).
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I've added a SourceTab to the DatabaseDetails View for Postgres and MySQL.
If you click on a procedure in the db structure tree you will find a tab labeled 'Source' in the 'Database Details' view.
A new patch (3.5.0.RC6_P5) is posted.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
I'm working with Eclipse pluggin 3.5.0 beta and I'm able to connect to my Postgres 8.2 DB.
But the Database structure doesn't show me the Functions, Triggers or Procedures.
Any idea.
Thank you in advance and congratulations.
Carlos
I've had a quick look and can't see anything wrong - at least from the client POV, it's executing the query and getting nothing back. I have absolutely zero experience with Postgres so I'm a bit stuck here. If you (or anyone else) was interested in taking a look, the classes to check out are:
net.sourceforge.sqlexplorer.postgresql.nodes.AbstractFunctionFolder
net.sourceforge.sqlexplorer.postgresql.nodes.ProcedureFolder
net.sourceforge.sqlexplorer.postgresql.nodes.FunctionFolder
If you want to submit changes, you can either do it directly or email them to me as patches and I'll add them in. It should just be as simple as tweaking the SQL to be 8.x compatible (eg making an inner join an outer), but unfortunately I simply haven't the time to learn Postgres :(
Cheers,
John
Just a thought - I don't think that the Postgres plugin wasn't distributed with the 3.5.0beta1 so it may be simply that you have an out of date copy of the plugin. 3.5.0beta2 will be out soon (hopefully this week but that's what I said last week) and will include a fresh Postgres plugin - give it another go then and let me know what happens.
John
Hi, I found SQL Explorer today and it seems like very nice tool! But I have the same problem with the PostgreSQL. The Functions, Procedures, etc view is broken probably because of org.postgresql.jdbc4.Jdbc4PreparedStatement.setQueryTimeout(int).
Error says: Error loading children: Method org.postgresql.jdbc4.Jdbc4PreparedStatement.setQueryTimeout(int) not implemented.
The same error is with the jdbc3 postgresql driver.
In driver version 8.3+ the driver throws exception for setQueryTimeout(int), for older versions driver simply do nothing...
Is there any chance to repair this from SQL Explorer side? Please! I'm tired from PgAdmin! :-)
I've fixed the problem with setQueryTimeout and posted a new patch (3.5.0.RC6_P4).
Update your installation using the update site http://eclipsesql.sourceforge.net.
If there are any problems you can download the patch from the download page http://sourceforge.net/project/showfiles.php?group_id=132863&package_id=148199.
Thank you very much, that was fast. Now the function tree works fine.
Unfortunately now it seems that I cannot view the bodies (definitions) of the functions (something like Create Table Script for tables -> Create Function Script).
Btw, on the website http://www.sqlexplorer.org/help.php - the donation link don't work (Eclipse SQL Explorer [RCP/Plugin] (eclipsesql) has not opted in to receive donations).
I've added a SourceTab to the DatabaseDetails View for Postgres and MySQL.
If you click on a procedure in the db structure tree you will find a tab labeled 'Source' in the 'Database Details' view.
A new patch (3.5.0.RC6_P5) is posted.