March 15, 2005 at 1:47 am
I am using Microsoft SQLServer 2000 Driver for JDBC, with JBOSS4
I get the error:
[Microsoft][SQLServer 2000 Driver for JDBC]Error setting up static cursor cache.
According to the SQLServer 2000 Driver for JDBC documentation this error is caused because the JVM do not have access/rights to the designated temp directory (Documents and Settings\User\Local Settings\Temp). Apparently to fix this I have to give the JVM access rights to this directory.
I added the following lines to the java.policy file to try and fix this:
permission java.util.PropertyPermission "java.naming.*", "read,write"; permission java.net.SocketPermission "*.microsoft.com:0-65535", "connect";
permission java.io.FilePermission "C:\\Documents and Settings\\Administrator.C21MAINSVR\\Local Settings\\Temp\\-","read,write,delete";
In this temp directory there are scb_?????.tmp files created milliseconds after each other, the number of files just keeps growing, in a few hours it gets to over 5000 files, then suddenly I get the error:
Error setting up static cursor cache.
If I restart JBOSS4 all is fine, up till a few hours then the error occurs again.
Please can anyone help, I have been struggling for over a week and can't find a solution.
March 18, 2005 at 8:00 am
This was removed by the editor as SPAM
September 29, 2005 at 2:29 pm
I have had the same problem. I have posted "C:\Documents and Settings\......\Temp" to almost every policy file I can find and I still get "Microsoft][SQLServer 2000 Driver for JDBC]Error setting up static cursor cache"
No Luck.. I will try it under All Users
September 29, 2005 at 2:31 pm
I have had the same problem. I have posted "C:\Documents and Settings\......\Temp" to almost every policy file I can find and I still get "Microsoft][SQLServer 2000 Driver for JDBC]Error setting up static cursor cache"
No Luck.. I will try it under All Users
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply