First, thanks a lot for all the work on SQL Explorer.
My configuration :
Eclipse 3.5.1
SQL Explorer 3.5.1
PostgreSQL 8.4.2
Driver : postgresql Driver (8.4-701, jdbc 4)
The problem I face is that when I execute UPDATE, DELETE or INSERT statements, I don't get the number of affected rows in the "Message tab", which is annoying.
"Log success messages" in preferences is ON.
Any idea ?
Thanks in advance,
Cedric
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I can't configure a JDBC 4 Driver in SQL-Explorer.
If I use the 8.4-701, jdbc 3 driver against my PostgreSQL 8.3 Server the affected rows are correctly displayed in the messages tab.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Using Java 6 I could configure the JDBC 4 driver and it works for too.
What is displayed in the messages tab when you execute an INSERT?
Which connection URL you are using?
Do you have any Exceptions in the error log?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Thank you for your help.
I'm using Java 1.6.0_13.
The displayed message in message tab when I execute an INSERT (insert into mytable(test) values ('1'), ('2');) is : "overall execution time 16 ms".
I have no exception in the error log.
My connection URL : "jdbc:postgresql://192.9.200.35:5432/mydatabase"
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I have also tested with a JDBC 3 driver on PostgreSQL 8.4.
But as with a JDBC 4 driver, I only get the overall execution time, without the number of affected rows when performing INSERT, UPDATE or DELETE.
I don't understand what I am doing wrong…
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Please recheck set 'Log Success Messages' in the SQLExplorer preferences is checked. If this is switched off only overall execution time is displayed.
Switching this preferences works for me imediatly for the current open editor. Try to change the setting on and off and execute your statement again.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi all,
First, thanks a lot for all the work on SQL Explorer.
My configuration :
Eclipse 3.5.1
SQL Explorer 3.5.1
PostgreSQL 8.4.2
Driver : postgresql Driver (8.4-701, jdbc 4)
The problem I face is that when I execute UPDATE, DELETE or INSERT statements, I don't get the number of affected rows in the "Message tab", which is annoying.
"Log success messages" in preferences is ON.
Any idea ?
Thanks in advance,
Cedric
I can't configure a JDBC 4 Driver in SQL-Explorer.
If I use the 8.4-701, jdbc 3 driver against my PostgreSQL 8.3 Server the affected rows are correctly displayed in the messages tab.
Using Java 6 I could configure the JDBC 4 driver and it works for too.
What is displayed in the messages tab when you execute an INSERT?
Which connection URL you are using?
Do you have any Exceptions in the error log?
Thank you for your help.
I'm using Java 1.6.0_13.
The displayed message in message tab when I execute an INSERT (insert into mytable(test) values ('1'), ('2');) is : "overall execution time 16 ms".
I have no exception in the error log.
My connection URL : "jdbc:postgresql://192.9.200.35:5432/mydatabase"
I get the same problem with SQL Server 2000, using Microsoft JDBC 4 driver (version 2.0).
I have also tested with a JDBC 3 driver on PostgreSQL 8.4.
But as with a JDBC 4 driver, I only get the overall execution time, without the number of affected rows when performing INSERT, UPDATE or DELETE.
I don't understand what I am doing wrong…
Please recheck set 'Log Success Messages' in the SQLExplorer preferences is checked. If this is switched off only overall execution time is displayed.
Switching this preferences works for me imediatly for the current open editor. Try to change the setting on and off and execute your statement again.
That was it ! It works perfectly.
Thanks a lot for your help.