Bug 900675 (JBPAPP6-1441)

Summary: Console just shows jdbc drivers from running servers in domain mode
Product: [JBoss] JBoss Enterprise Application Platform 6 Reporter: Bruno Machado <bmachado>
Component: Web ConsoleAssignee: Stefano Maestri <smaestri>
Status: CLOSED EOL QA Contact: Pavel Jelinek <pjelinek>
Severity: high Docs Contact:
Priority: urgent    
Version: 6.0.0CC: asaji, atangrin, bmachado, brian.stansberry, hbraun, jawilson, jkudrnac, jmartisk, kkhan, pslavice, smaestri, tom.jenkinson
Target Milestone: ---   
Target Release: EAP 6.4.0   
Hardware: Unspecified   
OS: Unspecified   
URL: http://jira.jboss.org/jira/browse/JBPAPP6-1441
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2019-08-19 12:48:40 UTC Type: Enhancement
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 1117785, 1118239    

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.