Created by: Cisco Developer on 17-08-2009 07:44:28 PM Hi, I'm working on a project for a client that will run on both windows and linux, to use Java to run JDBC/SQL queries for Unity Connection 7. Has anyone achieved this? I've looked at Ciscounitytools.com and configured the database proxy service (which connects via TCP 20532) with Unity Connection and tried different Informix JDBC drivers. Any help/guidance would be greatly appreciated!!! When attempting to establish a connection via JDBC, I keep getting SQL error code -908 com.informix.asf.IfxASFException: Attempt to connect to database server (myunityserver) failed thanks!!!
Subject: RE: Unity Connection JDBC? Replied by: Paul Wilkinson on 21-08-2009 06:35:04 AM Hi, -908 indicates that the server couldn't be contacted. Double check the following: 1. Make sure that the DBProxy shutdown shutdown timer is non-zero. 2. Make sure that you have started the DBProxy service from the serviceabilty web page 3. Verify that the proxy is running using telnet: "telnet mycucaddress 20532" on Windows or "telnet mycucaddress:20532" on UNIX 4. Download cudli from CiscoUnityTools.com and verify connectivity that way 5. Note that the default administrator user doesn't have permissions to access the database. You need to create a user for that purpose. Refer to the help file in Cudli for more information. Regards, Paul
Subject: RE: Unity Connection JDBC? Replied by: Petter Sjolin on 24-09-2009 03:19:07 PM Hi, I have the same problem as described above. Did the problem ever get solved? I have double checked the list and all checks. I can connect from CUDI without a problem. I use the following code to try to connect (and have added ifxjdbc.jar to the classpath): Class.forName("com.informix.jdbc.IfxDriver"); DriverManager.getConnection("jdbc:informix-sqli://cuxn71:20532/UnityDirDb:INFORMIXSERVER=ciscounity", "admin", "password"); The second line throws the same exception a the first post (¿java.sql.SQLException: com.informix.asf.IfxASFException: Attempt to connect to database server (ciscounity) failed.¿, -908) I have tested with both versions 3.00 JC3 and 3.50 JC4DE of the IBM Informix JDBC driver. But with the same result. Any help is appreciated, I am out of ideas. thanks, Petter
Subject: RE: Unity Connection JDBC? Replied by: Vinay S on 18-05-2010 10:09:49 AM Hi Paul/Petter, Did any of you get this working? I am facing the same issues. Pleae help. -Vinay
Subject: RE: Unity Connection JDBC? Replied by: Steven Lass on 28-06-2011 10:59:22 AM Has anyone gotten JDBC to Unity Connection working? The IBM/Informix forums mention needing the DBPATH specified as a file.
Subject: RE: Unity Connection JDBC? Replied by: Ravi Narasimhan on 06-07-2011 04:56:11 PM after failing to get this stuff working using pure jdbc, was able to get it to work using jdbc-odbc bridge. may not work for every one. hope this helps some who can afford to run on windows.
We have custom integration jars deployed in CVP that previously leveraged log4j1.x FileAppenders and such to allow for creation of individual LOG files for each integration. For example, integration A resulted in a dedicated integrationA.log file in addit...
Hello, we're using UCCX 12.5. We faced issue, where we cannot change agent's status to Ready after login in to Finesse app and external app controlling our devices. Everything is fine when we are using only Finesse app. Problem is present only in sit...
My request works fine in 188.8.131.5200-20 but gives back 599 unsupported header in 184.108.40.20600-132. DId something change in SU1 ? I have tried with both v12 and v14 database and fails with SU1. Works fine in older verson of CallManager 14, jus...
Hello,1-what is the difference between gadget and non gadget samples. I can see that both can be html files and calling JS at the back end. finessenongadget.js and finesse.js2- Regarding gadgets , if we need to call an API (for example answer ca...