Highlighted

OutOfMemory Exception - JBoss/SQL Server

Avatar

Guest

20-11-2008

Adobe LiveCycle 8.2 Environment:

Windows 2003 (64 bit)Server

JBOSS

MS SQL Server



Received the following error:

2008-11-19 14:52:33,357 ERROR [org.jboss.ejb.plugins.LogInterceptor] TransactionRolledbackLocalException in method: public abstract com.adobe.pof.omapi.POFObjectSet com.adobe.pof.omapi.POFObjectManagerLocal.retrieveObjectSet(com.adobe.pof.omapi.POFQuery,int,int,com.adobe.idp.Context) throws com.adobe.pof.POFException, causedBy:

com.microsoft.sqlserver.jdbc.SQLServerException: The system is out of memory. Use server side cursors for large result sets:Java heap space. Result set size:13,100,660. JVM total memory size:1,017,315,328.

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)



Resolution: Installed a newer sql jar file (1.2) from Microsoft's web site.



Regards,

Keri