Automic Workload Automation

 View Only

Configure DB-Configuration for Java based worker processes

  • 1.  Configure DB-Configuration for Java based worker processes

    Posted Jul 09, 2020 10:11 AM

    Hello community,

    according to the Documentation Installing the JWP  it is recommended to use a separately Connection for connecting Java based worker processes to the Database.

    Referncing the notes on top of the documentation: "As of version 12.1, it is mandatory to use and enable the JDBC section in the UCSRV.INI file."

    I have tested to comment the sqlDriverConnect configuration in section 
    [JDBC] in configruation file ucsrv.ini. 
    It figured out that the connection from JWP to database works fine without these configuration.

    The JWP now use the sqlDriverConnect configuration from section [ODBC]

    In the documentation (linked above) there is explicitly described how a DNS-less ODBC Connection should be configured.

    Now i am wondering about the note:

    "As of version 12.1, it is mandatory to use and enable the JDBC section in the UCSRV.INI file."

    and

    The steps, descibed in section "DSN-less ODBC Connection"

    Do you know if there is a need for configuring explicitly the sqlDriverConnect in section [JDBC] or can i (re)use the sqlDriverConnect from section [ODBC] for DB-Connection of Java based worker processes as well?

    Thanks for your efforts!