CA IDMS

Expand all | Collapse all

IDMS and JAVA connection via JDBC

  • 1.  IDMS and JAVA connection via JDBC

    Posted 07-17-2017 04:41 AM

    Hi All,

     

    In my project we thought of using IDMS in JAVA.

    So we need to connect IDMS using JDBC, To connect via JDBC we need the idmsjdbc.Jar file, Server name, Port number and Dictionary name.

     

    Can any one tell me how to find the Server Name and Port Number of the machine where IDMS is installed?

     

    Is there any steps to Configure JDBC to connect with IDMS?

     

    Regards,
    Vaasudevan Balusamy (India- Chennai)



  • 2.  Re: IDMS and JAVA connection via JDBC

    Posted 07-17-2017 04:33 PM

    Prior technote might be of some help:

     

    Tech Tip: CA IDMS steps to establish a TCP/IP connection from a PC  

     

    Server name is in System statement in Sysgen.  Port is in PTE definition.



  • 3.  Re: IDMS and JAVA connection via JDBC

     
    Posted 07-17-2017 05:00 PM

    You can determine the IP address by issuing a DCMT D TCPIP ALL command from within your IDMS CV.  

     

    DCMT D TCPIP ALL:    

     

    Hostname IP address                  Job name           Active    IPv6
    ======== =============== =========== ====== ====
    USILCA31    ***.***.***.***      TCPIP31 (D)      Y             Y

     

    -------------------------------

     

    The port number can be determined by coding DCMT D LINE TCPIP (where TCPIP is the name of your TCP/IP line).   Look for a 'LIST' type PTE (typically named TCPJSRV) who's Task code invokes RHDCNP3J:

     

    DCMT D LINE TCPIP:

     

    LTerm-ID PTerm-ID Type/M Status Port Target-host
    TCPJSRV TCPJSRV     LIST InSrv 03760

     

    -----------------------------------

     

    DCMT D PTE TCPJSRV:

     

    D PTE TCPJSRV
    Logical Term ID TCPJSRV
    Physical Term ID TCPJSRV
    Physical Line ID TCPIP
    Physical Term Type TCP/IP List
    Physical Term Model
    Physical Term Status InSrv
    Logical Term Status InSrv
    Task code RHDCNP3J
    Task mode SYSTEM
    Port number 3760
    Backlog 100
    Maximum connections OFF
    Active connections 0
    Connections rejected 0
    IP specification *none (*DEFAULT)
    PARM string TASK=IDMSJSRV



  • 4.  Re: IDMS and JAVA connection via JDBC

    Posted 07-20-2017 02:08 AM

    Hi David,

     

    Thanks for the quick and useful reply.

    I have tried the commands which you mentioned But there are some error message. So we have send those details to our system DBA.
    Regards
    Vaasu



  • 5.  Re: IDMS and JAVA connection via JDBC

    Posted 07-18-2017 08:04 AM

    First you need to make sure the IDMS SQL Option is installed at your site, and the IDMS System Programmer should be able to answer that and should also be able to provide you with the necessary information, such as server name, port number, etc. as well as the JDBC related files.



  • 6.  Re: IDMS and JAVA connection via JDBC

    Posted 07-20-2017 02:10 AM

    Hi Tommy,

     

    Thanks for the Suggestion.

    How we can find whether IDMS SQL is installed or not?
    I am able to query the DB using SQL query from JCL - If this is possible then we can conclude that IDMS SQL is installed?
    Regards
    Vaasu



  • 7.  Re: IDMS and JAVA connection via JDBC

    Posted 07-20-2017 03:43 AM

    Hi, Vaasu,

    Depending on what release of IDMS you are running, your dynamic SQL statement from IDMSBCF might work even if the SQL Option is not intentionally installed, due to the Web-connect feature added at r18.5.
    (See https://docops.ca.com/ca-idms/19/en/administrating/administrating-ca-idms-system-operations/sql-web-connect-considerations )

    To check if the SQL option was installed:

    1. Look in your *.CAISAG.CONFIG(VARBLIST) installation member for this line:
    GTJ000OP = YES CA IDMS SQL
    (the "GTJ000OP" may be different for different releases).

    2. An RHDCPINT entry will have been generated in member *.CUSTOM.SRCLIB(RHDCPINT). Look for this line:
    #DEFPINT SQL CA IDMS SQL

    3. Within your IDMS system, from the ENTER NEXT TASK CODE: prompt, type the command DCPROFIL, then scroll through to the end where you will find a screen with the heading "* Product Intent Status *".
    Look for this line:
    CA IDMS SQL YES

    These things will tell you if the SQL Option was intentionally installed in this environment.

    Best regards,
    Ian Hill.



  • 8.  Re: IDMS and JAVA connection via JDBC

    Posted 07-20-2017 07:27 AM

    Hi Ian Hill,

     

    Your reply is more useful and we have IDMS Version 19 and after checking with your commands we got to know that we have "CA IDMS SQL YES"  .

    Thank you

     

    Regards,
    Vaasu