Bug 900675 (JBPAPP6-1441) - Console just shows jdbc drivers from running servers in domain mode
Summary: Console just shows jdbc drivers from running servers in domain mode
Keywords:
Status: CLOSED EOL
Alias: JBPAPP6-1441
Product: JBoss Enterprise Application Platform 6
Classification: JBoss
Component: Web Console
Version: 6.0.0
Hardware: Unspecified
OS: Unspecified
urgent
high
Target Milestone: ---
: EAP 6.4.0
Assignee: Stefano Maestri
QA Contact: Pavel Jelinek
URL: http://jira.jboss.org/jira/browse/JBP...
Whiteboard:
Depends On:
Blocks: 1117785 1118239
TreeView+ depends on / blocked
 
Reported: 2012-06-28 21:31 UTC by Bruno Machado
Modified: 2019-08-19 12:48 UTC (History)
12 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2019-08-19 12:48:40 UTC
Type: Enhancement
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker JBPAPP6-1441 0 Major Closed Console just shows jdbc drivers from running servers in domain mode 2017-03-06 13:15:06 UTC
Red Hat Issue Tracker WFLY-3634 0 Major Resolved installed-drivers should show only drivers installed on current profile 2017-03-06 13:15:06 UTC

Description Bruno Machado 2012-06-28 21:31:06 UTC
Help Desk Ticket Reference: https://c.na7.visual.force.com/apex/Case_View?id=500A000000A635p&sfdc.override=1
project_key: JBPAPP6

We are using domain mode and when we try to create a new datasource to a specific profile selected in the combo placed in the left corner, it only shows jdbc drivers deployed in running server, including servers from different profiles from the selected one.

Also, it is possible to create the datasource in a profile without the reference to the driver on it, see code snipped domain.xml.

        <profile name="full-ha">
             .
             .
             .
            <subsystem xmlns="urn:jboss:domain:datasources:1.1">
                <datasources>
                    <datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS" enabled="true" use-java-context="true">
                        <connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1</connection-url>
                        <driver>h2</driver>
                        <security>
                            <user-name>sa</user-name>
                            <password>sa</password>
                        </security>
                    </datasource>
                    <datasource jta="false" jndi-name="java:/bla" pool-name="bla" enabled="true" use-ccm="false">
                        <connection-url>haosdjoksada</connection-url>
                        <driver-class>oracle.jdbc.OracleDriver</driver-class>
                        <driver>oracle</driver>
                        <validation>
                            <validate-on-match>false</validate-on-match>
                            <background-validation>false</background-validation>
                        </validation>
                        <statement>
                            <share-prepared-statements>false</share-prepared-statements>
                        </statement>
                    </datasource>
                    <drivers>
                        <driver name="h2" module="com.h2database.h2">
                            <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
                        </driver>
                    </drivers>
                </datasources>
            </subsystem>

In this example, I had the oracle jdbc driver defined in the default profile, and I had a running server based in the default profile. I chose full-ha in the combo when creating a new datasource, oracle jdbc driver was showed as an option to be selected and I was able to select it to create a new datasource.

*Probably it happens because the Console shows drivers defined in running servers. IMHO it should maybe just shows drivers associated to the current profile selected on the combo in the left corner not in running servers.*

Comment 1 Jimmy Wilson 2012-07-31 19:22:08 UTC
Moving to TBD EAP 6 as this is an RFE.

Comment 2 Anne-Louise Tangring 2012-11-13 20:58:00 UTC
Docs QE Status: Removed: NEW 


Comment 3 Heiko Braun 2013-02-27 17:32:12 UTC
It can only show drives of running servers, because w/o a server instance it's mereley a blob to the content repository. The DC itself cannot disinguish the binaries it maintains as "deployments".

Comment 4 Heiko Braun 2013-02-27 17:32:53 UTC
From my point of view this issue can be closed (as rejected)

Comment 5 Heiko Braun 2013-02-27 17:35:25 UTC
Maybe some further clarification: try to answer this question yourself:

What's are the drivers associated with selected profile?

Comment 7 Bruno Machado 2013-04-29 13:28:34 UTC
JDBC Driver is a module, thus it's available to every profile. Sometimes the user doesn't want to start the server to configure a datasource. For instance, during a management schedule. User usually stop the server, change what he needs and start it again. With the current implementation, the JDBC driver will not be available if the server with the associated profile with the driver metadata is not up.

Maybe it's not a UI issue, maybe it's the way AS7/EAP6 deals with datasources and drivers since its configurations are associated to a subsystem in a profile. It could be associated to a server settings in host.xml or to a server-group, not to a specific profile. Does it make more sense?

Comment 11 Jakub Cechacek 2014-07-16 10:51:49 UTC
Moving to 6.4 as the issue is still valid for 6.3

Comment 13 tom.jenkinson 2014-11-04 14:07:33 UTC
if we agree this is an improvement and not a bug we should close the bug and raise an EAP7 Jira to get this new feature into an EAP version.

Comment 15 tom.jenkinson 2014-11-05 14:09:16 UTC
Once we get agreement its an RFE I think we should close this and raise an EAP7 Jira.


Note You need to log in before you can comment on or make changes to this bug.