[MGNLUI-3525] Magnolia About App does not display database information for DataSource-based DB connections Created: 14/Aug/15  Updated: 17/Oct/16  Resolved: 30/Oct/15

Status: Closed
Project: Magnolia UI
Component/s: about app
Affects Version/s: 5.3.10
Fix Version/s: 5.3.12, 5.4.3

Type: Improvement Priority: Neutral
Reporter: Edgar Vonk Assignee: Robert Šiška
Resolution: Fixed Votes: 0
Labels: support
Remaining Estimate: 0d
Time Spent: 2d 0.25h
Original Estimate: 2d

Issue Links:
causality
relation
is related to MGNLUI-3768 NPE in About Magnolia app after parsi... Closed
Template:
Acceptance criteria:
Empty
Task DoD:
[ ]* Doc/release notes changes? Comment present?
[ ]* Downstream builds green?
[ ]* Solution information and context easily available?
[ ]* Tests
[ ]* FixVersion filled and not yet released
[ ]  Architecture Decision Record (ADR)
Date of First Response:
Sprint: Kromeriz 17
Story Points: 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>
[..]


 Comments   
Comment by Sang Ngo Huu [ 11/Oct/15 ]

After investigated, customer want to support connect to JNDI without depend on Driver class of database connector.
This feature should come from core, and in about app can use DI for getting infomation.

Put ticket onhold, need to discuss more.

Comment by Robert Šiška [ 30/Oct/15 ]

Prevented NPEs on unknown urls, looking up JNDI DataSources.

Generated at Mon Feb 12 09:07:28 CET 2024 using Jira 9.4.2#940002-sha1:46d1a51de284217efdcb32434eab47a99af2938b.