Uploaded image for project: 'Admin Tools Application'
  1. Admin Tools Application
  2. ADMINTOOL-50

Allow queries also for HSQLDB databases

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Fixed
    • Major
    • 4.4
    • 4.1.8
    • None
    • None

    Description

      If you install Admin Tools, on the homepage, the database tools are not displayed, mentioning that they are intended only for MySQL database, see message.png

      The Admin.Query page is working for HSQLDB with the appropriate parameter values. We should:

      • provide a select in the Admin.Query page for HSQLDB and MySQL, prefilling the parameters values;
      • remove the info message restricting the page only for MySQL.

      Parameters for:

      • HSQLDB
        user: sa
        password:
        URL: jdbc:hsqldb:file:data/database/xwiki_db;shutdown=true
        driver: org.hsqldb.jdbcDriver
        
      • MySQL
        user: xwiki
        password: xwiki 
        URL: jdbc:mysql://localhost/xwiki?useServerPrepStmts=false&useUnicode=true&characterEncoding=UTF-8
        driver: com.mysql.jdbc.Driver
        

      Attachments

        1. HSQLDB_params.png
          98 kB
          Ecaterina Moraru (Valica)
        2. message.png
          23 kB
          Ecaterina Moraru (Valica)

        Issue Links

          Activity

            People

              mouhb Mohamed Boussaa
              evalica Ecaterina Moraru (Valica)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: