Re: work with sybase...
Bumsys@gmail.com wrote:
I run sql query:
if (isAUResChecksumColumnExist) {
query = "insert into "
+ getFullTableName(Tables.RESOURCE)
+ " (application_id, backupno, path, name,
contents, last_written, last_modified, packed, checksum, type,
deleted, client_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
} else {
query = "insert into "
+ getFullTableName(Tables.RESOURCE)
+ " (application_id, backupno, path, name,
contents, last_written, last_modified, packed, type, deleted,
client_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
}
int numberOfRows = ps.executeUpdate();
logNumberOfRows(numberOfRows);
ps.close();
}
and when run ps.executeUpdate(), i.e. run sql query and then I have
error: 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.
What can do that to solve this problem?
The errors text is rather clear.
Sybase need to be reconfigured with more procedure cache.
If you ask the DBA he/she should know what it is. And it
need the be fixed - the database is fubar as is.
I am a bit puzzled because you are using straight insert and
not a SP, but maybe there is an insert trigger on the table.
Arne