Mixed connections and sql
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
I used Squirrel 2.6.1 and java 1.6.
I was using 4 sessions on 4 differents DBMS (Oracle,Postgresql,MySQL and Postgresql), issuing sql commands and looking at table columns metadata.
I encountered strange problems :
- sql commands were issued on the wrong connection (noticed because of the error messages) : I could resolve it by switching to objects tabs, switching into differents sessions and coming back
- the wrong sql command was issued (a previous one) even with an empty sql area : same resolution as before.
I am not sure wether it comes from java 1.6 or Squirrel but these problems are very annoying.
I will switch back to java 1.5 and see if problems still present tomorrow.
Logged In: YES
user_id=172727
Originator: YES
One missing details : I had closed two sessions so my 4 remaining sessions were numerated up to 6.