- 论坛徽章:
- 0
|
jsp中下载程序问题
谢谢。。
错误信息:
javazoom.upload.UploadException: Database store error:There is not enough procedure cache to run this procedure, trigger, or SQL batch. Retry later, or ask your SA to reconfigure SQL Server with more procedure cache.
.5 Configuring JDBC connection caches
For JDBC connection caches using jConnect(TM) for JDBC(TM), the
property is enabled by default, so that prepared statements are translated to temporary stored
procedures. This can increase performance when prepared statements are executed more than once.
However, this setting also increases use of the Adaptive Server Enterprise procedure cache space.
If the procedure cache is too small, you may see this exception in the server log file:
javax.ejb.EJBException: nested exception is:com.sybase.jdbc2.jdbc.SybSQLException: There is not
enough procedure cache to run this procedure, trigger, or SQL batch. Retry later, or ask your SA
to reconfigure SQL Server with more procedure cache
To solve this problem, you can do one of the following:
Edit the connection cache properties. On the All Properties tab, set the value of the
DYNAMIC_PREPARE property to
false
, or add the property if it does not already exist:
DYNAMIC_PREPARE=false
sybase中我怎样改写啊。。。。??
Increase the size of the procedure cache. The size required depends on the number of database
connections and the number of prepared statements used. See the Adaptive Server Enterprise
documentation for more information
|
|