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

    Details

    • Workaround:
      Workaround Exists
    • Workaround Description:
      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
    • Release Notes Text:
      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.
    • Release Notes Docs Status:
      Documented as Known Issue

      Description

      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.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  jiwils Jimmy Wilson
                  Reporter:
                  ShaunA Shaun Appleton
                  Writer:
                  Russell Dickenson
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  6 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: