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

    • Type: Bug Bug
    • Status: Closed Closed (View Workflow)
    • Priority: Major Major
    • Resolution: Done
    • Affects Version/s: EAP_EWP 5.1.0
    • Fix Version/s: EAP_EWP 5.1.2 ER1
    • Component/s: Consoles
    • Security Level: Public (Everyone can see)
    • Labels:
      None
    • 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
    • Similar Issues:
      Show 8 results 

      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.

        Issue Links

          Activity

          Hide
          Jan Martiska
          added a comment -

          Are the release notes related things resolved? Can we close this one?

          Show
          Jan Martiska
          added a comment - Are the release notes related things resolved? Can we close this one?
          Hide
          Russell Dickenson
          added a comment -

          Attention : Jan Martiska

          I haven't had any further feedback on this issue so am proceeding with the Release Notes text I drafted some time ago. For Release Notes I have marked this issue "Documented as Known Issue".

          Show
          Russell Dickenson
          added a comment - Attention : Jan Martiska I haven't had any further feedback on this issue so am proceeding with the Release Notes text I drafted some time ago. For Release Notes I have marked this issue "Documented as Known Issue".
          Hide
          Jan Martiska
          added a comment -

          Release notes presence verified. Patch presence in 5.1.2 ER1 verified. Ok, closing.

          Show
          Jan Martiska
          added a comment - Release notes presence verified. Patch presence in 5.1.2 ER1 verified. Ok, closing.
          Hide
          RH Bugzilla Integration
          added a comment -

          Heiko W. Rupp <hrupp@redhat.com> changed the Status of bug 694660 from VERIFIED to CLOSED

          Show
          RH Bugzilla Integration
          added a comment - Heiko W. Rupp <hrupp@redhat.com> changed the Status of bug 694660 from VERIFIED to CLOSED
          Hide
          RH Bugzilla Integration
          added a comment -

          Heiko W. Rupp <hrupp@redhat.com> made a comment on bug 694660

          Bulk closing of old issues that are in VERIFIED state.

          Show
          RH Bugzilla Integration
          added a comment - Heiko W. Rupp <hrupp@redhat.com> made a comment on bug 694660 Bulk closing of old issues that are in VERIFIED state.

            People

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

              Dates

              • Created:
                Updated:
                Resolved: