Topic
  • 9 replies
  • Latest Post - ‏2012-08-30T08:03:15Z by DaJoZi
DaJoZi
DaJoZi
7 Posts

Pinned topic JDBC connection to Informix Server using DRDA protocol - Which driver?

‏2012-08-27T10:03:37Z |
I can make a successful standard JDBC connection to my database server using connect string:-
jdbc:informix-sqli://myserver:9088:informixserver=ids115;DatabaseName=sysmaster

I now wish to be able to connect through DRDA protocol to the same server, and so did the same as above, but with port 9089.

This does not work, and receive the below dump. What am I doing wrong? Am I using the right jdbc data driver and if not, which driver supports DRDA?

Many thanks in advance,
David Ziants

========================================================================================================================================================================================

java.util.concurrent.ExecutionException: java.lang.RuntimeException: java.sql.SQLException: com.informix.asf.IfxASFException: Attempt to connect to database server (ids115) failed.
at java.util.concurrent.FutureTask$Sync.innerGet(Unknown Source)
at java.util.concurrent.FutureTask.get(Unknown Source)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.RuntimeException: java.sql.SQLException: com.informix.asf.IfxASFException: Attempt to connect to database server (ids115) failed.
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:171)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$000(OpenConnectionCommand.java:45)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$1.run(OpenConnectionCommand.java:104)
... 6 more
Caused by: java.sql.SQLException: com.informix.asf.IfxASFException: Attempt to connect to database server (ids115) failed.
at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:1467)
at sun.reflect.GeneratedConstructorAccessor19.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.informix.jdbc.IfxDriver.connect(IfxDriver.java:254)
at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:133)
at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.executeConnect(OpenConnectionCommand.java:167)
... 8 more
Caused by: com.informix.asf.IfxASFException: Attempt to connect to database server (ids115) failed.
at com.informix.util.IfxErrMsg.getLocIfxASFException(IfxErrMsg.java:815)
at com.informix.asf.Connection.establishConnection(Connection.java:1797)
at com.informix.asf.Connection.<init>(Connection.java:395)
at com.informix.jdbc.IfxSqliConnect.<init>(IfxSqliConnect.java:1104)
... 14 more
Updated on 2012-08-30T08:03:15Z at 2012-08-30T08:03:15Z by DaJoZi
  • SystemAdmin
    SystemAdmin
    1143 Posts

    Re: JDBC connection to Informix Server using DRDA protocol - Which driver?

    ‏2012-08-27T10:54:42Z  
    Hi,

    you can download the driver from here:

    http://www-01.ibm.com/support/docview.wss?uid=swg24032756

    Documentation:

    http://publib.boulder.ibm.com/infocenter/idshelp/v117/topic/com.ibm.jccids.doc/jcc.htm

    HTH,

    Marion
  • SystemAdmin
    SystemAdmin
    1143 Posts

    Re: JDBC connection to Informix Server using DRDA protocol - Which driver?

    ‏2012-08-27T10:54:45Z  
    Hi,

    you can download the driver from here:

    http://www-01.ibm.com/support/docview.wss?uid=swg24032756

    Documentation:

    http://publib.boulder.ibm.com/infocenter/idshelp/v117/topic/com.ibm.jccids.doc/jcc.htm

    HTH,

    Marion
  • DaJoZi
    DaJoZi
    7 Posts

    Re: JDBC connection to Informix Server using DRDA protocol - Which driver?

    ‏2012-08-27T10:58:04Z  
    Hi,

    you can download the driver from here:

    http://www-01.ibm.com/support/docview.wss?uid=swg24032756

    Documentation:

    http://publib.boulder.ibm.com/infocenter/idshelp/v117/topic/com.ibm.jccids.doc/jcc.htm

    HTH,

    Marion
    Thank you.
  • DaJoZi
    DaJoZi
    7 Posts

    Re: JDBC connection to Informix Server using DRDA protocol - Which driver?

    ‏2012-08-27T11:40:38Z  
    Hi,

    you can download the driver from here:

    http://www-01.ibm.com/support/docview.wss?uid=swg24032756

    Documentation:

    http://publib.boulder.ibm.com/infocenter/idshelp/v117/topic/com.ibm.jccids.doc/jcc.htm

    HTH,

    Marion
    Hi Marion,
    Thank you very much for your reply. I actually have this driver and have been using it for DRDA on DB2 .
    I did not know, though, that it was suitable for Informix. I can now see that I can connect the above using:
    jdbc:db2://myserver:9089/sysmaster

    Is using this driver for Informix, officially supported by IBM?
    Although not an Informix question, do you know whether it is also good for DB2 on mainframe?

    Many thansk and regards,
    David

    PS I could not reach the documentation link through my IE browser. Is there an alternative way to reach this?
  • DaJoZi
    DaJoZi
    7 Posts

    Re: JDBC connection to Informix Server using DRDA protocol - Which driver?

    ‏2012-08-27T11:44:27Z  
    Hi,

    you can download the driver from here:

    http://www-01.ibm.com/support/docview.wss?uid=swg24032756

    Documentation:

    http://publib.boulder.ibm.com/infocenter/idshelp/v117/topic/com.ibm.jccids.doc/jcc.htm

    HTH,

    Marion
    Hi Marion,
    Thank you very much for your reply. I actually have this driver and have been using it for DRDA on DB2 .
    I did not know, though, that it was suitable for Informix. I can now see that I can connect the above using:
    jdbc:db2://myserver:9089/sysmaster

    Is using this driver for Informix, officially supported by IBM?
    Although not an Informix question, do you know whether it is also good for DB2 on mainframe?

    Many thansk and regards,
    David

    PS I could not reach the documentation link through my IE browser. Is there an alternative way to reach this?
  • DaJoZi
    DaJoZi
    7 Posts

    Re: JDBC connection to Informix Server using DRDA protocol - Which driver?

    ‏2012-08-27T11:47:49Z  
    PS I am doing my best that my postings do not appear twice, but because of slow responses etc, this keeps happening.... Is there a moderator that can delete duplicate messages?
  • SystemAdmin
    SystemAdmin
    1143 Posts

    Re: JDBC connection to Informix Server using DRDA protocol - Which driver?

    ‏2012-08-27T12:19:16Z  
    Hi David,

    yes, the driver is officially supported for Informix.

    http://publib.boulder.ibm.com/infocenter/idshelp/v117/index.jsp
    Programming > Client APIs and tools
    IBM Data Server Driver for JDBC and SQLJ for Informix

    The driver can be used to connect to DB2 on Z/OS but there are some restrictions.
    see here
    http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp
    Database fundamentals > Installing
    IBM data server clients and drivers overview

    Regards,
    Marion
  • SystemAdmin
    SystemAdmin
    1143 Posts

    Re: JDBC connection to Informix Server using DRDA protocol - Which driver?

    ‏2012-08-27T12:25:37Z  
    Hi,
    if you are connection to Informix with DRDA protocol, URL should start with
    jdbc:ids:
    (not jdbc:db2)
    As far as I know, jcc driver is fully supported by IBM for connecting to Informix.
    Also, I believe (I'm expecting) that you can use it for connections to db2 on mainframe.
    You can download Informix documentation here:
    http://www-01.ibm.com/support/docview.wss?uid=swg27019520
    Look for "Data Server Driver for JDBC and SQLJ for Informix" document - English version is here:
    http://www.ibm.com/shop/publications/order?CTY=US&FNC=SRX&PBL=SC27-3850-00

    HTH
    Hrvoje
  • DaJoZi
    DaJoZi
    7 Posts

    Re: JDBC connection to Informix Server using DRDA protocol - Which driver?

    ‏2012-08-30T08:03:15Z  
    Hi,
    if you are connection to Informix with DRDA protocol, URL should start with
    jdbc:ids:
    (not jdbc:db2)
    As far as I know, jcc driver is fully supported by IBM for connecting to Informix.
    Also, I believe (I'm expecting) that you can use it for connections to db2 on mainframe.
    You can download Informix documentation here:
    http://www-01.ibm.com/support/docview.wss?uid=swg27019520
    Look for "Data Server Driver for JDBC and SQLJ for Informix" document - English version is here:
    http://www.ibm.com/shop/publications/order?CTY=US&FNC=SRX&PBL=SC27-3850-00

    HTH
    Hrvoje
    Thank you Hrvoje and Marion for your replies and the links to the documentation. Also, thank you for pointing out to use "ids" in the connection string.
    Actually, I had found the documentation links previously but was unable to access them. Having access might have saved me the need to post to this forum.
    The reason why I did not have access is that I was using MS Explorer, and although most of IBM's web pages seem to be loadable with this browser, this page was not.
    FireFox browser solved the problem. and can now browse the site.
    Am, of course, happy to know that for DRDA protocol connection, can use the DB2 driver also for Informix.
    David