Jack Eidsness wrote:
> Hello
>
> I'm using squirrel sql 2.0 RC 1 with Java 1.5 and an Oracle thin
> driver for oracle 9i;
>
> I have found that when I do a simple select query in the SQL window
> (e.g. "select sysdate from dual"), it will work and show me a result
> set, but my send query will always hang indefinitely. I haven't seen
> one finish yet. I know I'm not giving a lot to go on, but I'm not
> sure what other information needs to be collected.
>
> If I close that window & connection, and reconnect, I can do another
> query.
>
> Does anyone have any advice for troubleshooting this problem?
Jack,
I don't have jdk 1.5 installed (I have 1.4.2_08-b03/WinXP). However, I
do have Oracle 9i installed and I am
using the type 4 driver (<ORACLE_HOME>/jdbc/lib/classes12.zip) I am able
to issue the query
"select sysdate from dual" and it successfully completes giving me a
single column in the results tab with the
current date (according to Oracle). Are you using the same driver? Do
you have access to a 1.4 JVM that you
could try running SQuirreL with? Are you seeing any exceptions at the
very end of your
<user.home>/.squirrel-sql/logs/squirrel-sql.log file ?
Rob
CollabraSpace - Revolutionary Collaboration
Visit us at http://www.collabraspace.com
This message has been scanned for viruses by
ClamAV v0.83
|
