Some were ponderings rather than questions directly! :-)
- Thanks for all the answers.
- It's great to get immediate feedback on this as it is really
hindering our progress.
We have now solved the problem (to a point).
The issue seems to be that SQLJ.INSTALL_JAR does not work
when we use JDK 1.4.1 (which we need to use for JAVA Regular
Expression support)
So having reset JDK_PATH=/opt/IBMJava2-131, we are able to run
it succesfully!
However, having run successfully, we we now change back to
JDK_PATH=/opt/IBMJava2-141, to be able to run our UDFs, and we get
two dbfmp processes which spin-off running @ 100% CPU and never
come back (query never ends) ???
We know the UDFs work under 1.4.1, as they are runnning fine on
another machine (with JDK_PATH=/opt/IBMJava2-141, which was created
from a backup/restore of the database which is now not working).
So, may be running of INSTALL_JAR with 1.3.1 is not compatible with
actually
running the UDFs with 1.4.1 ??
This is really hurting my head, I thought Java was meant to get away
from all these inter-dependencies, it just seems to be worse! :-(
Thanks again.
Paul.
Sean McKeough <mc******@nospam.ca.ibm.com> wrote in message news:<bo**********@hanover.torolab.ibm.com>...
Ah Paul, so many questions. :-)