Uploaded image for project: 'Magnolia UI'
  1. Magnolia UI
  2. MGNLUI-3525

Magnolia About App does not display database information for DataSource-based DB connections

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Fixed
    • Neutral
    • 5.3.12, 5.4.3
    • 5.3.10
    • about app
    • Kromeriz 17
    • 5

    Description

      We noticed that in our Magnolia implementations the Magnolia About App does not display any database-related information. I reported this in SUPPORT-4976 and this is due to the fact that we use DataSource-based database configurations (using JNDI) in our Magnolia Jackrabbit configuration files.

      Zdenek in SUPPORT-4976 says:

      as you most likely have noticed the presenter uses a java.sql.DriverManager for the job, a service for managing JDBC drivers. The issue basically is that a driver that is accessed via a DataSource object does not register itself with that DriverManager. As far as I can see we could utilize javax.sql.DataSource in such cases to get a connection information.

      Excerpt of our jackrabbit-bundle-mysql-search.xml file:

      <?xml version="1.0" encoding="UTF-8"?>
      <!DOCTYPE Repository PUBLIC "-//The Apache Software Foundation//DTD Jackrabbit 2.0//EN"
              "http://jackrabbit.apache.org/dtd/repository-2.0.dtd">
      <Repository>
          <FileSystem class="org.apache.jackrabbit.core.fs.db.DbFileSystem">
              <param name="driver" value="javax.naming.InitialContext"/>
              <param name="url" value="java:comp/env/jdbc/magnolia"/>
              <param name="schema" value="mysql"/>
              <param name="schemaObjectPrefix" value="fs_repo_"/>
          </FileSystem>
      [..]
      

      Checklists

        Acceptance criteria

        Attachments

          Issue Links

            Activity

              People

                rsiska Robert Šiška
                edgar Edgar Vonk
                Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  Checklists

                    Task DoD

                    Time Tracking

                      Estimated:
                      Original Estimate - 2d Original Estimate - 2d
                      2d
                      Remaining:
                      Remaining Estimate - 0d
                      0d
                      Logged:
                      Time Spent - 2d 0.25h
                      2d 0.25h