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.
These are the paths to get to each CCX logs through CLI. They may be helpful if you are having issues accessing RTMT or downloading logs through it.
If you want to download them you have to prefix "file get " and you can add one of the options (re...