RE: [Squirrel-sql-users] Maximum Cursors

[Colin B. <col...@bi...>]

Hi Robert,

I constantly use Squirrel at work with an Oracle server running on Solaris
and haven't had this problem. I use Oracle 8.1.6 and the 8.1.6 thin drivers.

Which version of Squirrel are you using? If you're using 1.0final try the
latest beta of 1.1 and see if you have the same problem (just make sure you
backup your driver and alias definition file first. They're in your
<home>/.squirrel-sql directory). There has been a lot of code cleanup done
and it may make a difference.

In the schema that you click on how many tables are there?

Col

-----Original Message-----
From: squ...@li...
[mailto:squ...@li...]On Behalf Of Robert
Davis
Sent: Thursday, 25 April 2002 9:19 AM
To: squ...@li...
Subject: [Squirrel-sql-users] Maximum Cursors


java.sql.SQLException: ORA-01000: maximum open cursors exceeded

I am an Oracle DBA, so I know what the error means --> I am wondering why am
I getting this error when I only ;
1. connected to an Oracle instance
2. clicked on a schema owner
3. clicked on the table item

I am running Win98 on a 1G Duron w/256 megs of ram and I have jsdk1.4.0
installed. I am using oracle thin driver classes12.zip . My connection is to
an Oracle Database on a Unix server that I am accessing through a VPN.

Appreciate any help

Robert Davis


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.350 / Virus Database: 196 - Release Date: 4/17/02