APAR status
Closed as program error.
Error description
The AdminConfig object in wsadmin.[sh][bat] fails to list all
DataSource template. Due to this inability we are unable to
create a DataSource using the correct template through wsadmin
or a wsadmin script.The jdbc-resource-provider-templates.xml
shows a template for the datasources but there are a couple
that don't show up in the running of $AdminConfig listTemplates
DataSource. The admin console reports all of them but wsadmin
does not.The cust did not modify the jdbc-resource-provider-tem
plate.xml file on the install of PTF 1 for WAS 5.0 on Windows.
Workaround :
1. Open the file.
2. Find the comment line that starts with "<!-- Start: Comment
Block
ToolboxV5R1" everything that's listed between this start line
and the
the end line which is "End: Comment Block ToolboxV5R1 -->" is
commented
out and thus not loaded.
. <resources.jdbc:JDBCProvider xmi:id="JDBCProvider_db2400_7"
name="DB2
UDB for iSeries (Toolbox - V5R1 and earlier)" .....truncated as
it's a very long line leading into this resources' section.
.The <resources.jdbc:JDBCProvider xmi:id=..... line section
needs to be pulled out from the comment section that's listed
above. It needs to be equal on the left alignment to the other
<resource.... sections.
The same update needs to be made to the
xmi:id="JDBCProvider_db2400_8
section as well.
3. Cleanup the multiple entries, find the following 4 entries
and ensure that they only exist once instead of being defined
multiple times.
.xmi:id="DataSource_3"
xmi:id="DataSource_4"
xmi:id="DataSource_ora_3"
xmi:id="DataSource_DD_2"
The customer fixed the duplicates in their
jdbc-resource-provider-templates.xml and now the can select
their desired DataSource template.
This also occurs when installing PTF 2 as well.
The quirk is in that wsadmin validaes the templates whereas the
GUI doesn't seem to do so.
Local fix
Sorry I put the local fix on the screen above. Basically just
delete the duplicates in the jdbc-resource-provider-templates.xm
l and this appears to resolve the problem.
Problem summary
****************************************************************
* USERS AFFECTED: WebSphere Application Server users of JDBC *
* resource provider templates. *
****************************************************************
* PROBLEM DESCRIPTION: Some JDBC Resource Provider Templates *
* are not usable in wsadmin. *
****************************************************************
* RECOMMENDATION: *
****************************************************************
The DataSource templates for :
Cloudscape JDBC Provider (XA)
Cloudscape JDBC Provider 5.0 (XA)
Oracle JDBC oci8 Driver, and
WebSphere embedded ConnectJDBC driver for MS SQL Server (XA)
will not be displayed through wsadmin.
They do show up through the admin GUI though. This apar fixes
the problem so that those templates are accessable through
wsadmin.
Problem conclusion
The templates were not displayed due to duplicate xmi:ids in
jdbc-resource-provider-templates.xml. Renaming the xmi:ids to
unique values solved the problem.
Temporary fix Comments
APAR information |
APAR number |
PQ77891 |
Reported component name |
WAS BASE 5.0 |
Reported component ID |
5630A3600 |
Reported release |
00W |
Status |
CLOSED PER |
PE |
NoPE |
HIPER |
NoHIPER |
Special Attention |
NoSpecatt |
Submitted date |
2003-08-28 |
Closed date |
2003-10-09 |
Last modified date |
2003-10-09 |
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
Publications Referenced
Applicable component levels |
R003 PSY |
UP |
R00A PSY |
UP |
R00H PSY |
UP |
R00I PSY |
UP |
R00P PSY |
UP |
R00S PSY |
UP |
R00W PSY |
UP |
|