Include JDBC database info in automatic support request email

XMLWordPrintable

      Confluence now has a "submit support request" feature, whereby it submits an email with the user's question, and all the system info to help diagnosis. This system info include the following about the database:

              Database Dialect: net.sf.hibernate.dialect.HSQLDialect
        Database Connection URL: jdbc:hsqldb:/Users/pcurren/Atlassian/data/confluence/trunk/database/confluencedb
        Database Driver Name: org.hsqldb.jdbcDriver
        Database Driver Version: 1.8
        Database connection transaction isolation: None

      It would be nice if this also included the actual database version. Sometimes we really need to know if they're using Oracle 9 or 10, and it's generally useful to know when, eg. customers stop using old versions of databases (eg. MySQL 4.0).

      From JDBC one can obtain both the database version and JDBC driver version. Eg (from a JIRA auto-support-request):

          Database version: 5.0.32-Debian_7etch1-log
    Database JNDI address: java:comp/env/jdbc/JiraDS
    Database driver: MySQL-AB JDBC Driver mysql-connector-java-5.0.5 ( $Date: 2007-03-01 00:01:06 +0100 (Thu, 01 Mar 2007) $, $Revision: 6329 $ )

              Assignee:
              Anatoli
              Reporter:
              Jeff Turner
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: