I posted this on the squirrel mailing list yesterday and since I have not received a response, I thought I would try here too.
I'm running squirrel 3.4.0 and oracle database 11g.
I can now connect to my oracle database in my linux guest and I see a nice display of tabs. Previously I had a bad syntax for my connection
string and was not connecting. Here is my connection string for squirrel:
jdbc:oracle:thin:@192.168.1.131:1521:orcl
(My connection string for
java is
and my program executes my query correctly.)
When I try to expand "TABLE" I'm expecting a list of tables and I see no tables. What is wrong?
When I click on the SQL tab I enter the following SQL:
I get
Error:Closed Connection
SQL State: 08003
ErrorCode: 17008
However, my java program executes this SQL query correctly with the connection string below.
What am I doing wrong?
Thanks
Siegfried
This fragment of java code successfully connects from my windows 7 host to my oracle linux guest running the oracle database: