Thursday, 6 February 2014

Adding Comments in WCM

WCM ADD Comments
----------------
MENU_Comments structure
-----------------------
// Header
<table><tbody><tr>
<td>___________________________________________________</td>

</td></tr>


// Design
<tr><td><br><br>
<b>Comments:<b><br>
<br>[Element context="autofill" type="content" key="Comment"]
<br>Commented By:[Property context="autofill" type="content" field="creator"]
<br>------------------------------------<br>
</td><td>
</td></tr>


// Footer
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.2.6/jquery.js" type="text/javascript"></script>
<script type="text/javascript">
            function checkdata() {


var sapath =$("input#paths").val();
var ctitle="&ctitle=" +'[Property context="current" type="content" field="title"]';
var remove = "/wps/wcm/myconnect/Dark+Theme+Library";
sapath=sapath.replace(remove,"");

var sa='[Property context="current" type="content" field="title"]';
var sec_remove=sa;
sapath=sapath.replace(sec_remove,"");


var link="/wps/wcm/jsp/html/ndtvcomment.jsp?contenttitle="+sapath+ctitle;

var frm = document.getElementById("frm_comment");
                frm.action=link;

            }
        </script><tr><td>
<br>ADD YOUR COMMENT<br>
<form name="contact" action="" method="post" id="frm_comment" onsubmit="checkdata()">  
<textarea rows="2" cols="20" name="Comment" id="comment_field"></textarea>
<input type="submit" name="AddComment" id="commentbtn" value="Add Comment">
</form></td></tr>
</tbody></table>
<input type="text" id="paths" value='[URLCmpnt context="current" type="content" mode="standalone"]' style="display:none;"></input>


// No Result Design
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.2.6/jquery.js" type="text/javascript"></script>
<script type="text/javascript">
            function checkdata() {


var sapath =$("input#paths").val();
var ctitle="&ctitle=" +'[Property context="current" type="content" field="title"]';
var remove = "/wps/wcm/myconnect/Dark+Theme+Library";
sapath=sapath.replace(remove,"");

var sa='[Property context="current" type="content" field="title"]';
var sec_remove=sa;
sapath=sapath.replace(sec_remove,"");


var link="/wps/wcm/jsp/html/ndtvcomment.jsp?contenttitle="+sapath+ctitle;

var frm = document.getElementById("frm_comment");
                frm.action=link;

            }
        </script>

<table><tbody><tr>
<td>___________________________________________________
<br>ADD YOUR COMMENT<br>

<form name="contact" action="" method="post" id="frm_comment" onsubmit="checkdata()">  
<textarea rows="2" cols="20" name="Comment" id="comment_field"></textarea>
<input type="submit" name="AddComment" id="commentbtn" value="Add Comment">
</form></td></tr>
</tbody></table>
<input type="text" id="paths" value='[URLCmpnt context="current" type="content" mode="standalone"]' style="display:none;"></input>

WCM Active Site Analytics - 2

Portal Analytics is the process of Collecting, Processing, and Reporting portal usage data.

Analytics Data Collection Approaches ::
 There are two main approaches for collecting analytics data:

Server side site analytics
Active Site Analytics

Analyzing portal usage data
----------------------------
You can collect data about the usage of your portal and analyze them.

You can collect these types of data:
1. Server side data of your portal site. This consists mainly of technical data internal to the portal.
2. Data about the behavior of your client users. You analyze this data by using Active Site Analytics (ASA).


Analyzing user behavior by Active Site Analytics ::
---------------------------------------------------
You can collect data about user behavior in your portal and send that data to a service for analysis. For this purpose the portal provides Active Site Analytics (ASA).

To configure active site analytics for a page. In page properties-->advanced options-->set parameter value
parameter value
--------- -----
asa_aggregator asa.jsp

If asa is configured for parent page, it is inhereted to child pages also.

=========================================================WCM 8==================================================================================================

We can collect data about user behavior in our portal and send that data to a service for analysis. For this purpose the portal provides Active Site Analytics (ASA).

The portal provides a rich set of page metadata as part of its themes and skins. Examples are:
Page title
Page identifier
Portlet title
Portlet identifier.

We can write scripts to retrieve the data. Such scripts are called aggregators.

Aggregators are located in the PortalServer_root/doc/js-samples directory of your portal installation.

Process for Active Site Analytics ::
1. Collecting analytics data
Before we can send data about user behavior in our portal to a service for analysis, we need to collect that data.
2. Displaying overlay analytic reports
Active Site Analytics show graphical statistics reports about individual portal resources, such as pages or portlets.
These reports are called Active Site Analytics overlay reports.
3. Analytics tags and site promotion

1. Collecting analytics data
----------------------------
The data for the analysis of user behavior is retrieved from markup embedded in the portal pages.
The data is represented as a 'microformat' in portal page. An example of such microformat is:
<span class="asa.portlet.title">My Portlet</span>
Portal supports several aggregator tags, like; asa.portlet.title etc...
The aggregator typically submits the collected data to an external analytics service where the data is then recorded, processed, and formatted in the form of reports.
Portal administrators can manage the aggregators. They can assign an aggregator to one or more portal labels or pages.
Adding an ASA aggregator to a portal page
-----------------------------------------
Goto webDAV-->js folder-->take the name of the aggregator file. ex:- asa_sample.js
Goto Portal administration-->Manage pages-->Page(to set aggreator)-->Page properties-->Advanced options-->I want to set parameters
-->Add Parameter and Value(aggregator file name)-->ok-->ok
*In the field New parameter, type a string that starts with 'asa_aggregator' or 'asa_dependency' . asa_aggregator are added to the page body, asa_dependency are added to the head.

2. Displaying overlay analytic reports
--------------------------------------
The statistics graph is shown on a portal page in the format of a overlay.
The statistics are generated as follows:
-> The data collected by the portal site analytics are collected and forwarded to your business partners for portal analytics.
-> Your business partner analyses and evaluates the portal data and sends back a report to your portal.
-> The portal then displays the report as the overlay graph.
To setup active site analytics overlay report on portal, we have to follow these steps:
1. Enable data collection. For example, you can do this by adding an Active Site Analytics aggregator to a portal page:
-> Access the IBM® Coremetrics® Web Analytics web site or contact your Coremetrics representative.
-> Retrieve the appropriate aggregator file from Coremetrics.
-> Upload the aggregator file to your portal theme folder, for example, by using WebDAV.
-> Add Active Site Analytics aggregator to a portal page.
-> As a result of these steps, analytics data is sent from browsers of your portal users to the Coremetrics data collection servers.
-> You can log on to Coremetrics and analyze the portal usage.
2. Enable inline display of Coremetrics reports by enabling overlay reports:
-> Establish trust with Coremetrics servers.
To display overlay analytic report we have to configure/activate overlay reports for our site :
- Goto Admin console-->Resources-->Resources Environment-->Resource Environment Provider-->WP Config Services-->Custom Properties-->New
- Use the property name 'wp.proxy.config.urlreplacement.default_policy.1' and the value https://welcome.coremetrics.com/*
- If this name is already in use increment the counter of key.
- Apply and Save.
- Next, Import the Coremetrics certificate into your server truststore.
- Goto Admin console-->Security-->SSL certificate and key management-->SSL configurations-->NodeDefaultSSLSettings-->Key stores and
 certificates-->NodeDefaultTrustStore-->Signer certificates-->Retrive form Port, and fill the form with details
If 'NodeDefaultSSLSettings' then it is Stand-alone environment
If 'CellDefaultSSLSettings' then it is Portal Clustur environment
- For the host: welcome.coremetrics.com
 For the port: 443
 For the alias: coremetrics or another identifying string of your choice.
- Retrive Signer Information and Apply & Save.

-> Optional: Set up security for overlay reports.
- You can administer which users can view overlay reports.
- To do this, you use the virtual resource OVERLAY_REPORTS having USER role assigned.

-> Configure your Coremetrics user ID.
- To access the IBM® Coremetrics® Web Analytics system, you have to store user information in a Credential Vault slot.
- If you do not do this, the portal overlay reports cannot show data from the Coremetrics system.
- To configure this we require,
Coremetrics client ID
Coremetrics user name
Coremetrics authentication key.
- Goto admin-->access-->credential vault-->add vault slot, and fill the portlet with details
- name : com.ibm.portal.asa.coremetrics.slot
 shared user ID : coremetrics_user_name#coremetrics_client_id

-> Display overlay reports by choosing Show Portlet Reports or Show Page Reports.
- To enable overlay statistics, the user opens the page actions menu and selects either Show Portlet Reports or Show Page Reports.
- When the user clicks a report type in the actions menu, the display reports setting is persisted in the navigational state.
- This means that the user can now navigate through the portal and view statistics on every page that the user visits.
- To disable overlay statistics, the user opens the page actions menu again and clicks the menu item Close Analytics Reports.

-> Optional: Customize the overlay report by providing additional configuration parameters.

3. Optional: To further customize the tagging of your site, assign site promotions to pages and portlets as required.




Ref : http://publib.boulder.ibm.com/infocenter/wcmdoc/v6r1/index.jsp?topic=%2Fcom.ibm.lotus.wcm.doc_v615%2Fadmin%2Fsa_asa_use_theme.html
: http://wpcertification.blogspot.in/search/label/asa
: http://www-10.lotus.com/ldd/portalwiki.nsf/dx/Enabling_Active_Site_Analytics_in_WebSphere_Portal_7.0
: http://www-10.lotus.com/ldd/portalwiki.nsf/xpDocViewer.xsp?lookupName=IBM+WebSphere+Portal+8+Product+Documentation#action=openDocument&res_title=Displaying_overlay_analytics_reports_wp8&content=pdcontent
http://www-10.lotus.com/ldd/portalwiki.nsf/xpDocViewer.xsp?lookupName=IBM+WebSphere+Portal+8+Product+Documentation#action=openDocument&res_title=Analyzing_user_behavior_by_Active_Site_Analytics_wp8&content=pdcontent
http://www-10.lotus.com/ldd/portalwiki.nsf/xpDocViewer.xsp?lookupName=IBM+WebSphere+Portal+8+Product+Documentation#action=openDocument&res_title=Web_analytics_wp8&content=pdcontent

http://www-10.lotus.com/ldd/portalwiki.nsf/xpSearch.xsp?searchValue=active%20site%20analytics







Portal Scripting jython(.py) files samples that implemented

 customJDBCProvider.py

#
# My Custom Jython Script file for creating JDBC Provider --- customJDBCProvider.py
# To Run script in wsadmin follow below command
# wsadmin.bat -lang jython -javaoption "-Djython.package.path=D:\IBM\WebSphere\AppServer\plugins\com.ibm.ws.wlm.jar" -username admin -password admin -f  customJDBCProvider.py
#
sc =  AdminConfig.getid('/Cell:TIT-JAVA-010Cell/Node:TIT-JAVA-010Node/Server:WebSphere_Portal/')
t = AdminConfig.listTemplates('JDBCProvider', 'User-defined JDBC Provider Only(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_0)')
AdminConfig.createUsingTemplate('JDBCProvider', sc, [['name', 'customUserDefined']], t)
AdminConfig.save()


customDataSourceTotal.py

newjdbc = AdminConfig.getid('/Cell:TIT-JAVA-010Cell/Node:TIT-JAVA-010Node/Server:WebSphere_Portal/JDBCProvider:customUserDefined/')
print newjdbc
print AdminConfig.required('DataSource')
name = ['name', 'customUserDefinedDataSource']
dsAttrs = [name]
newds = AdminConfig.create('DataSource', newjdbc, dsAttrs)
print newds
AdminConfig.save()

newds = AdminConfig.getid('/Cell:TIT-JAVA-010Cell/Node:TIT-JAVA-010Node/Server:WebSphere_Portal/JDBCProvider:customUserDefined/DataSource:customUserDefinedDataSource/')
print AdminConfig.create('ConnectionPool', newds, [])
AdminConfig.save()

newds = AdminConfig.getid('/Cell:TIT-JAVA-010Cell/Node:TIT-JAVA-010Node/JDBCProvider:customUserDefined/DataSource:customUserDefinedDataSource/')
print newds
propSet = AdminConfig.showAttribute(newds, 'propertySet')
print propSet
print AdminConfig.required('J2EEResourceProperty')
name = ['name', 'RP4']
rpAttrs = [name]
print AdminConfig.create('J2EEResourceProperty', propSet, rpAttrs)
AdminConfig.save()


customDataSourceCustomProperties.py

newds=AdminConfig.getid('/Cell:TIT-JAVA-010Cell/Node:TIT-JAVA-010Node/Server:WebSphere_Portal/JDBCProvider:customDB2JDBCProviderfortesting/DataSource:customDB2JDBCProviderDataSource/')
print newds
propSet = AdminConfig.showAttribute(newds, 'propertySet')
print propSet
print AdminConfig.required('J2EEResourceProperty')
name = ['name', 'RP4']
rpAttrs = [name]
print AdminConfig.create('J2EEResourceProperty', propSet, rpAttrs)
AdminConfig.save()

customDataSource.py

newjdbc = AdminConfig.getid('/Cell:TIT-JAVA-010Cell/Node:TIT-JAVA-010Node/Server:WebSphere_Portal/JDBCProvider:customDB2JDBCProviderfortesting/')
print newjdbc
print AdminConfig.required('DataSource')
name = ['name', 'customDB2JDBCProviderDataSource']
dsAttrs = [name]
newds = AdminConfig.create('DataSource', newjdbc, dsAttrs)
print newds
AdminConfig.save()


customConnectionPool.py

newds = AdminConfig.getid('/Cell:TIT-JAVA-010Cell/Node:TIT-JAVA-010Node/Server:WebSphere_Portal/JDBCProvider:customDB2JDBCProviderfortesting/DataSource:customDB2JDBCProviderDataSource/')
print AdminConfig.create('ConnectionPool', newds, [])
AdminConfig.save()

Portal Scripting - Configuring new Java 2 Connector authentication data entries using scripting

Configuring new Java 2 Connector authentication data entries using scripting
----------------------------------------------------------------------------

1. Identify the parent ID:
security = AdminConfig.getid('/Cell:TIT-JAVA-010Cell/Security:/')
print security

2. Get required attributes:
print AdminConfig.required('JAASAuthData')

3. Set up required attributes:
alias = ['alias', 'myCustomAlias']
userid = ['userId', 'root']
password = ['password', 'admin']
jaasAttrs = [alias, userid, password]
print jaasAttrs

4. Create JAAS auth data:
print AdminConfig.create('JAASAuthData', security, jaasAttrs)

5. Save changes
AdminConfig.save()


When we try to establish connection below exception is showing up;

The test connection operation failed for data source Custom Datasource on server WebSphere_Portal at node TIT-JAVA-010Node with the following exception: java.sql.SQLException: Access denied for user ''@'tit-java-010.tecnicsdev.com' (using password: NO) DSRA0010E: SQL State = 28000, Error Code = 1,045. View JVM logs for further details.

But if we go to created alias and once again type the same userid and password then it is connecting.

Portal Scripting - Created JDBC Provider using AdminTask

Created JDBC Provider using Admin Task with interactive
-------------------------------------------------------

AdminTask.createJDBCProvider (['-interactive'])

Cell=TIT-JAVA-010Cell, Node=TIT-JAVA-010Node, Server=WebSphere_Portal

User-defined

User-defined JDBC Provider

Connection pool data source

com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource

D:\smn\Jars\mysql-connector-java-5.1.6.jar

Native, false
isolated, false

AdminConfig.save()

Portal Scripting - Creating new Datasource using wsadmin tool

***Creating new Datasource using wsadmin tool***
------------------------------------------------
There are two ways to configure datasource through wsadmin
1. AdminConfig object
2. AdminTask object

AdminConfig gives you more configuration control than the AdminTask object.

Using the AdminConfig object to configure a new data source:
------------------------------------------------------------
1. Identify the parent ID, which is the name and location of the JDBC provider that supports your data source
newjdbc = AdminConfig.getid('/Cell:TIT-JAVA-010Cell/Node:TIT-JAVA-010Node/Server:WebSphere_Portal/JDBCProvider:CustomJDBC2/')
print newjdbc

2. Obtain the required attributes
print AdminConfig.required('DataSource')

3. Set up the required attributes
name = ['name', 'customDataSource']
dsAttrs = [name]

4. Create the data source
newds = AdminConfig.create('DataSource', newjdbc, dsAttrs)
print newds

5. Save changes
AdminConfig.save()

Using the AdminTask object to configure a new data source:
----------------------------------------------------------
1. AdminTask.createDatasource (['-interactive'])

2. provide requird fields and follow the procedure

3. save changes




***Configuring new data source custom properties using wsadmin***
-----------------------------------------------------------------
1. Identify the parent ID
newds = AdminConfig.getid('/Cell:TIT-JAVA-010Cell/Node:TIT-JAVA-010Node/Server:WebSphere_Portal/JDBCProvider:CustomJDBC2/DataSource:customDataSource/')
print newds

2. Get the J2EE resource property set
propSet = AdminConfig.showAttribute(newds, 'propertySet')
print propSet

3. Get required attribute
print AdminConfig.required('J2EEResourceProperty')

4. Set up attributes
name = ['name', 'RP4']
rpAttrs = [name]

5. Create a J2EE resource property
print AdminConfig.create('J2EEResourceProperty', propSet, rpAttrs)

6. Save changes
AdminConfig.save()

Portal Scripting - jdbc provider list of templates

'"Cloudscape JDBC Provider (XA)(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_db2j_4)"\r\n
 "Cloudscape JDBC Provider Only (XA)(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_db2j_4)"\r\n
 "Cloudscape JDBC Provider Only(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_db2j_3)"\r\n
 "Cloudscape JDBC Provider(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_db2j_3)"\r\n
 "Cloudscape Network Server Using Universal JDBC Driver Provider Only(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_db2jN_1)"\r\n
 "Cloudscape Network Server Using Universal JDBC Driver(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_db2jN_1)"\r\n

 "DB2 Legacy CLI-based Type 2 JDBC Driver (XA)(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_4)"\r\n
 "DB2 Legacy CLI-based Type 2 JDBC Driver Provider Only (XA)(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_4)"\r\n
 "DB2 Legacy CLI-based Type 2 JDBC Driver Provider Only(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_3)"\r\n
 "DB2 Legacy CLI-based Type 2 JDBC Driver(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_3)"\r\n
 "DB2 UDB for iSeries (Native - V5R1 and earlier)(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_db2400_5)"\r\n
 "DB2 UDB for iSeries (Native - V5R2 and later)(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_db2400_3)"\r\n
 "DB2 UDB for iSeries (Native XA - V5R1 and earlier)(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_db2400_6)"\r\n
 "DB2 UDB for iSeries (Native XA - V5R2 and later)(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_db2400_4)"\r\n
 "DB2 UDB for iSeries (Native XA)(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_db2400_2)"\r\n
 "DB2 UDB for iSeries (Native)(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_db2400_1)"\r\n
 "DB2 UDB for iSeries (Toolbox XA)(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_db2400_10)"\r\n
 "DB2 UDB for iSeries (Toolbox)(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_db2400_9)"\r\n
 "DB2 UDB for iSeries Provider Only (Native - V5R2 and later)(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_db2400_3)"\r\n
 "DB2 UDB for iSeries Provider Only (Native XA - V5R2 and later)(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_db2400_4)"\r\n
 "DB2 UDB for iSeries Provider Only (Native XA)(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_db2400_2)"\r\n
 "DB2 UDB for iSeries Provider Only (Native)(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_db2400_1)"\r\n
 "DB2 UDB for iSeries Provider Only (Toolbox XA)(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_db2400_10)"\r\n
 "DB2 UDB for iSeries Provider Only (Toolbox)(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_db2400_9)"\r\n
 "DB2 Universal JDBC Driver Provider (XA)(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_DB2_UNI_2)"\r\n
 "DB2 Universal JDBC Driver Provider Only (XA)(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_DB2_UNI_2)"\r\n
 "DB2 Universal JDBC Driver Provider Only(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_DB2_UNI_1)"\r\n
 "DB2 Universal JDBC Driver Provider(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_DB2_UNI_1)"\r\n
 "DB2 Using IBM JCC Driver (XA)(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_DB2IDS_XA)"\r\n
 "DB2 Using IBM JCC Driver Provider Only (XA)(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_DB2IDS_XA)"\r\n
 "DB2 Using IBM JCC Driver Provider Only(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_DB2IDS)"\r\n
 "DB2 Using IBM JCC Driver(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_DB2IDS)"\r\n
 "DB2 for zOS Local JDBC Provider (RRS)(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_DB2_RRS_zOS)"\r\n
 "DB2 for zOS Local JDBC Provider Only (RRS)(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_DB2_RRS_zOS)"\r\n

 "DataDirect ConnectJDBC type 4 driver for MS SQL Server (XA)(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_DataDirect_2)"\r\n
 "DataDirect ConnectJDBC type 4 driver for MS SQL Server Provider Only (XA)(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_DataDirect_2)"\r\n
 "DataDirect ConnectJDBC type 4 driver for MS SQL Server Provider Only(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_DataDirect_1)"\r\n
 "DataDirect ConnectJDBC type 4 driver for MS SQL Server(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_DataDirect_1)"\r\n
 "DataDirect SequeLink type 3 JDBC driver for MS SQL Server (XA)(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_DataDirect_4a)"\r\n
 "DataDirect SequeLink type 3 JDBC driver for MS SQL Server (templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_DataDirect_3a)"\r\n

 "Derby JDBC Provider (XA)(templates/servertypes/APPLICATION_SERVER/servers/DeveloperServer|resources.xml#builtin_jdbcprovider)"\r\n
 "Derby JDBC Provider (XA)(templates/servertypes/APPLICATION_SERVER/servers/PortalServerTemplate|resources.xml#builtin_jdbcprovider)"\r\n
 "Derby JDBC Provider (XA)(templates/servertypes/APPLICATION_SERVER/servers/defaultZOS|resources.xml#builtin_jdbcprovider)"\r\n
 "Derby JDBC Provider (XA)(templates/servertypes/APPLICATION_SERVER/servers/default|resources.xml#builtin_jdbcprovider)"\r\n
 "Derby JDBC Provider (XA)(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_Derby_4)"\r\n
 "Derby JDBC Provider 40 (XA)(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_Derby_2)"\r\n
 "Derby JDBC Provider 40 Only (XA)(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_derby_2)"\r\n
 "Derby JDBC Provider 40 Only(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_derby_1)"\r\n
 "Derby JDBC Provider 40(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_Derby_1)"\r\n
 "Derby JDBC Provider Only (XA)(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_derby_4)"\r\n
 "Derby JDBC Provider Only(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_derby_3)"\r\n
 "Derby JDBC Provider(templates/servertypes/APPLICATION_SERVER/servers/DeveloperServer|resources.xml#JDBCProvider_1124467079638)"\r\n
 "Derby JDBC Provider(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_derby_3)"\r\n

 "Derby Network Server Using Derby Client (XA)(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_derbyNS_3)"\r\n

 "Derby Network Server Using Derby Client 40 (XA)(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_derbyNS_8)"\r\n
 "Derby Network Server Using Derby Client 40 Only (XA)(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_derbyNS_8)"\r\n
 "Derby Network Server Using Derby Client 40 Only(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_derbyNS_7)"\r\n
 "Derby Network Server Using Derby Client 40(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_derbyNS_7)"\r\n

 "Derby Network Server Using Derby Client Only (XA)(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_derbyNS_3)"\r\n

 "Derby Network Server Using Derby Client Only(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_derbyNS_2)"\r\n
 "Derby Network Server Using Derby Client(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_derbyNS_2)"\r\n

 "Derby Network Server Using Universal JDBC Driver Provider Only(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_derbyNS_1)"\r\n
 "Derby Network Server Using Universal JDBC Driver(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_derbyNS_1)"\r\n

 "Informix JDBC Driver (XA)(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_Informix_2)"\r\n
 "Informix JDBC Driver Provider Only (XA)(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_Informix_2)"\r\n
 "Informix JDBC Driver Provider Only(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_Informix_1)"\r\n
 "Informix JDBC Driver(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_Informix_1)"\r\n
 "Informix Using IBM DB2 JDBC Universal Driver (XA)(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_Informix_JCC_2)"\r\n
 "Informix Using IBM DB2 JDBC Universal Driver Provider Only (XA)(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_Informix_JCC_2)"\r\n
 "Informix Using IBM DB2 JDBC Universal Driver Provider Only(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_Informix_JCC_1)"\r\n
 "Informix Using IBM DB2 JDBC Universal Driver(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_Informix_JCC_1)"\r\n
 "Informix Using IBM JCC Driver (XA)(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_Informix_JCC4_2)"\r\n
 "Informix Using IBM JCC Driver Provider Only (XA)(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_Informix_JCC4_2)"\r\n
 "Informix Using IBM JCC Driver Provider Only(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_Informix_JCC4_1)"\r\n
 "Informix Using IBM JCC Driver(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_Informix_JCC4_1)"\r\n

 "Microsoft JDBC driver for MSSQLServer 2000 (XA)(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_MS_2)"\r\n
 "Microsoft JDBC driver for MSSQLServer 2000(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_MS_1)"\r\n
 "Microsoft SQL Server JDBC Driver (XA)(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_Microsoft_XA)"\r\n
 "Microsoft SQL Server JDBC Driver Provider Only (XA)(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_Microsoft_XA)"\r\n
 "Microsoft SQL Server JDBC Driver Provider Only(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_Microsoft)"\r\n
 "Microsoft SQL Server JDBC Driver(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_Microsoft)"\r\n

 "Oracle JDBC Driver (XA)(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_Oracle_6)"\r\n
 "Oracle JDBC Driver Provider Only (XA)(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_Oracle_6)"\r\n
 "Oracle JDBC Driver Provider Only(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_Oracle_5)"\r\n
 "Oracle JDBC Driver UCP (XA)(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_Oracle_6_UCP)"\r\n
 "Oracle JDBC Driver UCP Provider Only (XA)(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_Oracle_6_UCP)"\r\n
 "Oracle JDBC Driver UCP Provider Only(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_Oracle_5_UCP)"\r\n
 "Oracle JDBC Driver UCP(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_Oracle_5_UCP)"\r\n
 "Oracle JDBC Driver(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_Oracle_5)"\r\n

 "Sybase JDBC 2 Driver (XA)(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_Sybase_4)"\r\n
 "Sybase JDBC 2 Driver Provider Only (XA)(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_Sybase_4)"\r\n
 "Sybase JDBC 2 Driver Provider Only(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_Sybase_3)"\r\n
 "Sybase JDBC 2 Driver(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_Sybase_3)"\r\n
 "Sybase JDBC 3 Driver (XA)(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_Sybase_6)"\r\n
 "Sybase JDBC 3 Driver Provider Only (XA)(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_Sybase_6)"\r\n
 "Sybase JDBC 3 Driver Provider Only(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_Sybase_5)"\r\n
 "Sybase JDBC 3 Driver(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_Sybase_5)"\r\n
 "Sybase JDBC 4 Driver (XA)(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_Sybase_8)"\r\n
 "Sybase JDBC 4 Driver Provider Only (XA)(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_Sybase_8)"\r\n
 "Sybase JDBC 4 Driver Provider Only(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_Sybase_7)"\r\n
 "Sybase JDBC 4 Driver(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_Sybase_7)"\r\n

 "User-defined JDBC Provider Only(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_0)"\r\n
 "User-defined JDBC Provider(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_0)"\r\n

 "WebSphere embedded ConnectJDBC driver for MS SQL Server (XA)(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_DataDirect_2a)"\r\n
 "WebSphere embedded ConnectJDBC driver for MS SQL Server Provider Only (XA)(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_DataDirect_2a)"\r\n
 "WebSphere embedded ConnectJDBC driver for MS SQL Server Provider Only(templates/system|jdbc-resource-provider-only-templates.xml#JDBCProvider_DataDirect_1a)"\r\n
 "WebSphere embedded ConnectJDBC driver for MS SQL Server(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_DataDirect_1a)"\r\n
 wpdbJDBC_derby(templates/servertypes/APPLICATION_SERVER/servers/PortalServerTemplate|resources.xml#JDBCProvider_1335003070131)'