Problem with JDBC Driver for MS SQL Server

[Benny]

Dear All,

I developed an web application which use MS SQL Server 2000. I
encounter the following SQLException "[Microsoft][SQLServer 2000
Driver for JDBC]Error setting up static cursor cache". Did anyone
encounter this problem before? What does this exception mean and how
to solve this problem?

[Remarks: The web application work properly on development machine and
this machine but encounter this exception when move to another
machine, so is this exception related to the machine?]

Thank you for your attention.

Yours faithfully,
Benny

[Joseph Weinstein]

Re: Problem with JDBC Driver for MS SQL Server



Benny wrote:
[color=blue]
> Dear All,
>
> I developed an web application which use MS SQL Server 2000. I
> encounter the following SQLException "[Microsoft][SQLServer 2000
> Driver for JDBC]Error setting up static cursor cache". Did anyone
> encounter this problem before? What does this exception mean and how
> to solve this problem?
>[/color]

I think it has to do with OS user file permissions in temp directories.
Joe Weinstein at BEA
[color=blue]
>
> [Remarks: The web application work properly on development machine and
> this machine but encounter this exception when move to another
> machine, so is this exception related to the machine?]
>
> Thank you for your attention.
>
> Yours faithfully,
> Benny[/color]

[SQRGUY]

Microsoft][SQLServer 2000 Driver for JDBC]Error setting up static cursor cache

I have been investigating the same thing. I have added the C:\Documents and Settings\Admini strator\Local Settings\Temp to every policy file that I could find (both the java.policy and catalina.policy files). This does not seem to help. Hmmmmm..... I will keep working on it, but if you have figured it out, I would really appreciate you letting me know how to resolve this.

This is a win2k environ w sqlserver 2000.