issue for increase procedure cache size

[caesarkim]

I am not sure if this is the right place where I can post my
issue. I am using Sybase JDBC driver for my database. The
problem is this.

"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."

I think that this error goes away when I increased cache
size on the DB. But what I am wondering about is if there is
a way to send this properties to the sybase database from
the JDBC client, when establishing connection. I know that
jdbc client can send some properties through connection.

It is kind of strict and hard to change the cache size on
the DB sise.

It would be great if someone has this problem and let me
know if there is any other option available.

Thanks.

[Jason L. Froebe [TeamSybase]]

Unfortunately, the procedure cache is not session specific but at a
system level.

jason