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.
Hi, I am trying to subscribe to team events in Cisco Ajax Xmpp Library for the Supervisor, but am unable to do so. Is there any sample or documentation regarding CAXL for getting a subscription of the team via Xmpp connection? Thanks.
Hi Team ,I am building one web application from my side, where i need to get Realtime data and Historical data from this Cisco UCCE awdb/hds DB .Queries:a. Whether its possible to get realtime SQL data from UCCE AWDB to my third pa...
Hi, We are trying to pack a CTI Server OPEN_REQ message and send it over the socket to our sandbox environment. We have read the documentation, link below, but we are pretty sure that we have misunderstood something. Is there anyone that might have s...