Re: to work with database...

Bumsys@xxxxxxxxx wrote:
I want to write file to database sybase. I run the following code:

If I write a small file to database sybase all is ok. But if a big
file I have error:
com.sybase.jdbc3.jdbc.SybSQLException: There is not enough procedure
cache to run this procedure, trigger, or SQL batch. Retry later, or
ask your SA to reconfigure ASE with more procedure cache.

There is not enough procedure cache to run this procedure, trigger, or
SQL batch. Retry later, or ask your SA to reconfigure ASE with more
procedure cache.

at com.sybase.jdbc3.tds.Tds.a(Unknown Source)

I change procedure cache but I have this error again. What can do that
write a big file to sybase?

It seems as if you have not increased procedure cache enough.

This is a pure Sybase configuration problem not a Java or JDBC problem.

Arne
.

Relevant Pages

  • Re: Accessing ASP.NET Cache
    ... > user makes a change to a particular table in a SQL Server database (so ... > the changes appear immediately in the browser). ... particular table then create the cache with filedependency on ... Write a trigger that always overwrites this blankfile ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: System Cache and expiration
    ... In .NET 2.0 you can use SqlDependency to trigger the clean out of expired ... > One of the solutions was to read the whole thing into a class and cache ... >> If there are concurrency issues, then don't use Session: ... With the system cache, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: insert trigger problem
    ... Yes I think I got it - It's a good trick to keep the right value in ... > thing your trigger do be: ... this is what is cuasing the problem. ... you MUST contrive to cache @@IDENTITY coming into your trigger ...
    (microsoft.public.access.adp.sqlserver)
  • Re: SCO: ISPs are blocking our site Blake Stowell
    ... On Mon, 2 Feb 2004, Bill Vermillion wrote: ... > minute retry, and if the name server is unreachable the cache is ...
    (comp.unix.sco.misc)
  • Re: Secure file storage in web application
    ... I created a DownloadBridge.aspx and I cache the product it in the session and then I do: ... while (retry < 10) ...
    (microsoft.public.dotnet.framework.aspnet)