SQL Server JDBC - Error setting up static cursor cache.

Author

Error setting up static cursor cache.

Jahz

2006-01-24, 9:23 am

Hi all,

I get sometimes the following error when my weblogic webapp try to upload a
file :

"java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error
setting up static cursor cache."

I can't understand the origin of the error because it appears like 1% of time.
But after getting this error one time, it desappears and then i get 100% of
time the following :

"org.apache.commons.fileupload. FileUploadException:
Processing of
multipart/form-data request failed.
G:\...\upload_00000223.tmp (Too many open files)"

which is only resolved by restarting weblogic server (700 SP2).

All sort of help (link to documentation...) would be very appreciated (i've
already googled a LOT).

Thanks in advance.

Christophe

Sue Purkis

2006-01-24, 8:23 pm

Christophe,
The following is from the JDBC 2000 SQL Server 2000 Driver for JDB C User's Guide and Reference:

To use insensitive scrollable cursors, and perform client-side sorting of some DatabaseMetaData ResultSets, all code bases
must have access to temporary files. If access to temporary files is not available, the driver may throw an exception indicating that
it is unable to set up a static cursor cache.

For JDK 1.1 environments, access to "current working directory"
must be granted.
For Java 2 environments, access to the temporary directory
specified by the VM configuration must be granted.

The following is an example of permissions being granted for the
C:\TEMP directory:
// permissions granted to all domains
grant {
// Permission to create and delete temporary files.
// Adjust the temporary directory for your environment.
permission java.io.FilePermission "C:\\TEMP\\-", "read,write,delete";};

I cannot say for sure why this happens only 1% of the time, but my guess is that it is due to not enough space (or something like that). As for the second error message, I really cannot give any insight.

I hope that this helps!!

Sue Purkis
DataDirect Technologies

"Jahz" <Jahz@discussions.microsoft.com> wrote in message news:C8E43AC5-3099-4D87-A7A0- F23D7E672475@microso
ft.com...

> Hi all,
>
> I get sometimes the following error when my weblogic webapp try to upload a
> file :
>
> "java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error
> setting up static cursor cache."
>
> I can't understand the origin of the error because it appears like 1% of time.
> But after getting this error one time, it desappears and then i get 100% of
> time the following :
>
> "org.apache.commons.fileupload. FileUploadException:
Processing of
> multipart/form-data request failed.
> G:\...\upload_00000223.tmp (Too many open files)"
>
> which is only resolved by restarting weblogic server (700 SP2).
>
> All sort of help (link to documentation...) would be very appreciated (i've
> already googled a LOT).
>
> Thanks in advance.
>
> Christophe

Jahz

2006-01-26, 4:53 pm

Hi,

Thanks for your reply, even if i had already seen this before. I didn't
tried this before as my error appears 1% of the time.
I'll try this and keep you informed !

Christophe

"Sue Purkis" wrote:

> Christophe,
> The following is from the JDBC 2000 SQL Server 2000 Driver for JDB C User's Guide and Reference:
>
>
> To use insensitive scrollable cursors, and perform client-side sorting of some DatabaseMetaData ResultSets, all code bases
> must have access to temporary files. If access to temporary files is not available, the driver may throw an exception indicating that
> it is unable to set up a static cursor cache.
>
> For JDK 1.1 environments, access to "current working directory"
> must be granted.
> For Java 2 environments, access to the temporary directory
> specified by the VM configuration must be granted.
>
> The following is an example of permissions being granted for the
> C:\TEMP directory:
> // permissions granted to all domains
> grant {
> // Permission to create and delete temporary files.
> // Adjust the temporary directory for your environment.
> permission java.io.FilePermission "C:\\TEMP\\-", "read,write,delete";};
>
> I cannot say for sure why this happens only 1% of the time, but my guess is that it is due to not enough space (or something like that). As for the second error message, I really cannot give any insight.
>
> I hope that this helps!!
>
> Sue Purkis
> DataDirect Technologies

Jahz

2006-02-15, 7:23 am

Hi again,

Just in case it could help someone :
my problem came from unclosed resultsets, after some iteration the error
setting up static cursor cache appeared...

Now i closed this resulsets and evrything seems to work fine.

Regards,

Christophe

Sponsored Links