1 Reply Latest reply on Nov 26, 2015 10:29 AM by Ricardo Veloso

    Wildfly DB2/400 connection ignores schema

    Ricardo Veloso Newbie

      Scenario:

      * AS400 with two databases, one for production and other one for staging

      * One machine running Wildfly for production and one running for staging, each one connected with respective database

       

      The staging Wildfly is managing data from production database, even with the corrected schema specified in connection-url.

       

      Does Wildfly, somehow, change datasource connection-url?

       

      Accordingly with AS400 documentation, when a connection does not define schema then it picks up tables and views from the first schema found.

      This is not happening when connected with SQL clients.