The IJC-Spotfire connection times out when I try to load 60.000 datasets from IJC (shared project, Oracle DB) into Spotfire. The same happens with a result set of 2.300 from the 60.000. (Please see attachments for error messages.)
Where may I set the timeout limit?
I'm not sure this is configurable. We are investigating this and will get back to you.
I've updated Spotfire with the latest version of the Connector (March 30), but I still get a timeout. However, there now is an additional Web exception window(see attachment). Unfortunately you can't set the timeout there and you also can't close the window. (You need to exit Spotfire).
Please check if there are any errors in IJC. Particularly "java.lang.OutOfMemoryError: Java heap space" can couse the error you described. If so you might want to increase the java heap memory. It can be done in "instantjchem.conf" file by editing "-J-Xmx512m" parameter in "default_options" to "-J-Xmx1200m". The file is located in "IJCfolder/etc/" directory.
Please let us know if this helps and whether you experiencing any errors on IJC side when comunicating with Spotfire.
Thanks for reporting this, we are looking at the issue you have described.
Increasing Xmx to 1024m solves the problem on a local machine (Windows XP SR3) but not on a terminalserver (W2K8 R2, Citrix XenApp 6.0). I tried to further increase Xmx but 1024m seems to be the upper limit. With higher values of Xmx there is an error Unable to create JVM.
I tried it on my machine and the limit is somewhere above 1200m with 32bit JVM. Using 64bit JVM probably allows more memory to be allocated. Please try it if you can use 64bit JDK (JRE) on the terminal server.
It can be done by uncommenting/editing #jdkhome="/path/to/java6jre" property in instanjchem.conf file.