[GLASSFISH-12568] JDBC resource need to allow system property for pool name Created: 07/Jul/10  Updated: 13/Dec/10

Status: Open
Project: glassfish
Component/s: jdbc
Affects Version/s: 3.1
Fix Version/s: None

Type: Improvement Priority: Critical
Reporter: Anissa Lam Assignee: Shalini
Resolution: Unresolved Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Operating System: All
Platform: All


Issuezilla Id: 12,568

 Description   

In the JDBC resource screen, the connection pool is a drop down list.
This means user cannot use system properties ie, token to specify a pool name. eg $

{PoolName}

To support such use case, the dropdown needs to be a 'combo box', allowing user to select from
dropdown or enter the pool name. Client side validation should ensure that it starts with "${"

Currently, CLI allows that.
This will be JDBC enhancement.



 Comments   
Comment by Shalini [ 08/Jul/10 ]

This needs to be done for Connector Connection pools also.

Comment by sumasri [ 06/Oct/10 ]

Added the target milestone.

Comment by sumasri [ 22/Oct/10 ]

-> MS7

Comment by sumasri [ 29/Nov/10 ]

In V2.1 also, There is no way to add a system property as pool name through GUI.
Steps to do it in CLI is,
1)Create a node agent na.
2)Create a cluster(c1).
3)Create an instance(i1) under cluster c1 with the node agent na.
4)start the node agent(na).
5)Create a system property(Ex: poolname=DerbyPool) with the target as c1.
6)Create a jdbc resource using the target c1 and pool name as "$

{poolname}".
command : asadmin create-jdbc-resource --connectionpoolid "\${poolname}

" --target c1 jdbc1.

But, In v3.1, there is no support for start-node-agent. Through CLI, it is not supporting system property for jdbc resource creation.
Steps to reproduce the issue.
1)Create a cluster
2)Create an instance(i1) under cluster c1 with the node agent localhost.
3)Start the cluster
4)Create a system property(Ex: poolname=DerbyPool) with the target as c1.
5)./bin/asadmin create-jdbc-resource --connectionpoolid "\$

{poolname}" --target c1 j1
org.glassfish.api.admin.CommandException: remote failure: Attribute value (pool-name = ${poolname}

) is not found in list of jdbc connection pools.
Command create-jdbc-resource failed.

Transferring it to the backend team to look into the issue. Please transfer it to me for GUI support once you are done with the backend changes.

Generated at Wed Jul 01 19:53:04 UTC 2015 using JIRA 6.2.3#6260-sha1:63ef1d6dac3f4f4d7db4c1effd405ba38ccdc558.