Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-1838

Change to source model connection through AdminApi using assignToModel() does not reflect in jdbc queries to that source model

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 8.0
    • 7.5
    • AdminApi
    • None

      When source model's connection is changed using following adminapi code;

      AdminFactory adminFactory = AdminFactory.getInstance();
      Admin admin = adminFactory.createAdmin("admin", "admin".toCharArray(), "mms://localhost:31443");
      admin.assignToModel("Sample", 1, "SQLSourceA", "SQLSourceA", "sqlserver", "SQLSourceA_2");

      Any jdbc query result would still be from the old data source. However when verified using following adminapi code;

      VDB vdb = admin.getVDB("sample", 1);
      Model m = vdb.getModel("SQLSourceA");
      String jndiName = m.getSourceConnectionJndiName("SQLSourceA");

      The jndiName shows that the connection is successfully updated.

            rhn-engineering-rareddy Ramesh Reddy
            farrukh.ihtisham Farrukh Ihtisham (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: