Hi

Since weeks I try to overcome the exception below ("unable to
allocate memory from operating system") without success. I tried
various different settings (also the default one) in firebird.conf
without much success. The core settings used are:

DefaultDbCachePages = 2048
MaxFileSystemCache = 524288
RemoteAuxPort = 8992
RemoteServicePort = 9002
LockMemSize = 524288
SortMemUpperLimit = 134217728
ConnectionTimeout = 720
Authentication = Native
TempDirectories = temp;temp\email;c:\WINDOWS\Temp;c:\WINNT\Temp;

I am using Firebird superserver 2.1.1.17910. All operations are done
on one single machine P4 2.8 GHz with 1.5 GB RAM

The exception occures during a commission calculation routine where
10 000+ queries are executed (mostly select (65%) but also insert
(15%) and update (10%)). The exception occures always between 30 to
60 minutes after start of the routine. We are using beteen 7 and 13
connections.

Although I am using Jaybird to connect I do not belive this is a
Java related issue.

Any help is greatly appreciated.
Thanks
Daniel Putra
-------------------------------------------------------------------
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544430.
unable to allocate memory from operating system
at org.firebirdsql.jdbc.FBCachedFetcher.<init>
(FBCachedFetcher.java:125)
at org.firebirdsql.jdbc.AbstractResultSet.<init>
(AbstractResultSet.java:137)
at org.firebirdsql.jdbc.FBResultSet.<init>
(FBResultSet.java:19)
at org.firebirdsql.jdbc.AbstractStatement.getResultSet
(AbstractStatement.java:622)
at org.firebirdsql.jdbc.AbstractStatement.getResultSet
(AbstractStatement.java:603)
at org.firebirdsql.jdbc.AbstractStatement.executeQuery
(AbstractStatement.java:217)
at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown
Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.firebirdsql.pool.StatementHandler.invoke
(StatementHandler.java:105)
at $Proxy1.executeQuery(Unknown Source)