Plex 2E

  • Private Community
 View Only
Back to discussions
Expand all | Collapse all

Java Application with IBM i as Database BUT use of JDBC instead of IBM i Dispatcher

  • 1.  Java Application with IBM i as Database BUT use of JDBC instead of IBM i Dispatcher

    Posted Feb 12, 2025 11:16 AM

    Hello everyone,

    does anyone uses the following configuration:

    Client = Java

    Server = Java

    Database = IBM i (AS400)

    Connection via JDBC Driver instead of IBM i Listener

    And is the performance of the application acceptable?

    Background:

    We roll-out two different software environments depending of our customers:

    SQL-Backend via SQL JDBC and IBM i Backend via IBM i Listener.

    Normally the IBM i Backend calls RPGIV Serverfunctions located on the IBM i.

    In a test environment i copied our sql environment to an ibm i customer and uses JDBC Driver to call java server functions (they are located at the windows server who runs the application; not on the ibm i).

    runs out of the box but the performance is horrible.

    does anyone has made experiences in this?

    thank you and best regards, Tobias