RE: scb_*.tmp Files

Hello Hong,

These files will be created in some scenarios as described in the
documentation:

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.

However, they should be getting closed when the resultsets are closed. Are
these files not getting closed? Do you have some code to demonstrate when
these files are staying around?

Thanks,
Kamil


Kamil Sykora
Microsoft Developer Support - Web Data

Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.


Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/secur­ity.



--------------------
| From: babyjiang_us2@xxxxxxxxx
| Newsgroups: microsoft.public.sqlserver.jdbcdriver
| Subject: scb_*.tmp Files
| Date: 5 May 2005 09:37:09 -0700
|
| I am facing a problem similar to the problem here.
| http://www.linuxquestions.org/questions/showthread.php?threadid=74955
|
| Basically, I am using MS Sql Server JDBC driver. After running my
| servlet for a while, I got a "Too many open files" error. Then I
| discovered JDBC driver had created more than 20000 files named
| "scb_*.tmp", "scb_*.tmp" and "scp_*.tmp" in /var/tomcat/temp/. "*"
| is a number here.
|
| the scd_ file appears to contain the results of my query, whilst one,
| the scb file, is always empty.
|
| I have no idea where these files come from.
|
| Need help.
|
| Thanks very much.
|
| Hong
|
| :)
|
|

.

Loading