I am having an interesting problem when connecting to Oracle 10 G from my UCCX 8.5 script. I am able to connect to Oracle and run the querries successfully when I load the JDBC driver from the database subsystem and use the DB-Read/DB-Get node in my script.
The problem is when I try to use my custom java class to achieve the same functionality. Infact, we have an extended piece of application that is written in java and does the similar functionality we need in the IVR script.
We simply loaded all the required jar files including the JDBC driver jar file from the document management area and then selected all of them from System > Custom File configuration.
Even a very simple java query fails and I get absolutely no response on my UCCX script.
Any other custom java files that don't interact with Oracle works fine, but the one connecting with oracle and running a simple SELECT query FAILS.
Thanks in advance,