Unity Connection JDBC?

Version 1
    This document was generated from CDN thread

    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.

    -steve

    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.

    jdbc configuration:
    ================
    driver: sun.jdbc.odbc.JdbcOdbcDriver
    url: jdbc:odbc:unity-ibm-informix;Database=UnityDirDB

    odbc configuration
    ================
    servername:ciscounity
    hostname:<hostname>
    port:20532
    protocol:onsoctcp
    DatabaseName:UnityDirDB

    Isolation level(advanced tab): read committed



    -Ravi