Error Messages (J)

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #

java.lang.outOfMemory

If you experience java.lang.outOfMemory errors, adjust the JDBC URL to include the following --FBS=1This will set the size of row prefetch buffer to 1 row. Default is 99 rows. Experimentation will find the optimal setting for each environment and application.DLF=YThe OpenLink JDBC driver will now fetch long data types (TEXT, NTEXT, IMAGE, etc.) in 32 KB chunks. Default is N.

Each of these will decrease the memory use of the JDBC Application.

Example:

Original URL
jdbc:openlink://localhost/SVT=SQLServer/Database=pubs/UID=sa/PWD=/

Revised URL
jdbc:openlink://localhost/SVT=SQLServer/Database=pubs/UID=sa/PWD=/DLF=Y/FBS=1/