Uploaded image for project: 'JBoss Enterprise Application Platform 4 and 5'
  1. JBoss Enterprise Application Platform 4 and 5
  2. JBPAPP-5285

Admin console does not persist a 'Check Valid Connection SQL' database change

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • EAP_EWP 5.1.2 ER1
    • EAP_EWP 5.1.0
    • Consoles
    • None
    • Workaround Exists
    • Hide

      edit the associated attachments file in .../server/<conf-name>/data/attachments/.. will force the datasource config to use the new settings

      Show
      edit the associated attachments file in .../server/<conf-name>/data/attachments/.. will force the datasource config to use the new settings
    • Hide
      If you change the database properties via the Admin Console, the changes are persistent. However, if you undo the changes, the old values still persist when you restart the Application Server. This problem is not yet resolved, but you can work around it by editing the associated attachments file in <filename>server/<replaceable>PROFILE</replaceable>/data/attachments</filename>, to force the datasource configuration to use the new settings.
      Show
      If you change the database properties via the Admin Console, the changes are persistent. However, if you undo the changes, the old values still persist when you restart the Application Server. This problem is not yet resolved, but you can work around it by editing the associated attachments file in <filename>server/<replaceable>PROFILE</replaceable>/data/attachments</filename>, to force the datasource configuration to use the new settings.
    • Documented as Known Issue

      If you change the database properties via the admin console they persist.
      If you undo the changes the old ones are still there.

      For example

      In the admin console

      1) Select Datasource -> Local TX Datasources
      2) Select DefaultDS
      3) Select the Configuration Tab
      4) Un check the Check Valid Connection SQL check box and enter any sql statement - like 'select * from dual'
      5) Select Save - all saves fine

      6) Select the Configuration Tab again
      7) Un check the Check Valid Connection SQL check box - the box clears
      8) Select Save - all appears to saves fine

      9) Select the Configuration Tab again
      10) Observe that the SQL statement is stiil there even though it was cleared in step 7.

              rhn-support-jawilson Jimmy Wilson
              rhn-support-sappleton Shaun Appleton
              Russell Dickenson Russell Dickenson (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Created:
                Updated:
                Resolved: