Hi All,
I started new on XSLT project and learning and
implementing in JAVA - XML- XSLT transformation
Converting the XML file data into insert statement
I have 2 Questions below .Appreciate any
suggestions/help :-
1)
These "value-of" tags in XSLT are not getting replaced
by values in XML file at the place in wanted in Output
<xsl:value-of select="/bea/weblogic-version"/>,
I checked many examples but unable to figureout :-(
How to achieve this Output from XML ,XSLT Transform by
having xml values in between commas "," ?
2)
How to get all 3 insert statements in the output(My
current output is stuck after first insert staement ..
not going back to XML file )?
DETAILS WITH EXAMPLES BELOW:-
Correct output should look like this -Aiming to get
this output below --
--------------------
insert into server (
'oracleAppVersion',java-version,java-vendor,java-vm-version,java-vm-vendor,java-vm-name,os-arch,os-name,os-version
) values ( 17T09:30:47.0Z,1.0 ,true ,1 ,2.01 ,wls ,bea
,bea-wls ,jdbc );
insert into jdbc-data ( datasource
,driver-name,database-product-version,database-product-name)
values ( jdbc,2.0,1.1.1,orcl1 );
insert into jdbc-data ( datasource
,driver-name,database-product-version,database-product-name)
values ( odbc,2.2.0,1.1.1,sybase);
------------
Wrong Ouput I am getting now
-----------
1)When I run XML file with XSLT , I am getting Output
as below .I wanted the values to be replaced in
between commas "," but they are pasted after the XSLT
template output text .
2)And also I am getting Only one insert statement and
doesnot go back to XML file for getting next 2 insert
statements
insert into server (
'oracleAppVersion',java-version,java-vendor,java-vm-version,java-vm-vendor,java-vm-name,os-arch,os-name,os-version
) values ( , , , , , , , , );
2001-12-17T09:30:47.0Z1.0true1.1.0bea5.0bea-wlswlswlsarchbeaos3.3jdbc2.01.1.1orcl
---------
XSLT File:-
-------
<?xml version="1.0" encoding="UTF-8"?>
<xsl:stylesheet version="2.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:fn="http://www.w3.org/2005/xpath-functions"
xmlns:xdt="http://www.w3.org/2005/xpath-datatypes"
<xsl:output method="text" indent="yes"/>
<xsl:template match="domain-name/server">
insert into server (
'oracleAppVersion',java-version,java-vendor,java-vm-version,java-vm-vendor,java-vm-name,os-arch,os-name,os-version
) values (
<xsl:value-of select="/comp/weblogic-version"/>,
<xsl:value-of select="/java/version"/>,
<xsl:value-of select="java/vendor"/>,
<xsl:value-of select="java/vm/version"/>,
<xsl:value-of select="java/vm/vendor"/>,
<xsl:value-of select="java/vm/name"/>,
<xsl:value-of select="os/arch"/>,
<xsl:value-of select="os/name"/>,
<xsl:value-of select="os/version"/>
);
</xsl:template>
<xsl:template match="domain-name/jdbc-data">
insert into jdbc-data (
'oracleAppVersion',java-version,java-vendor,java-vm-version,java-vm-vendor,java-vm-name,os-arch,os-name,os-version
) values (
<xsl:value-of select="/datasource/driver-name"/>,
<xsl:value-of
select="/datasource/database-product-version"/>,
<xsl:value-of
select="/datasource/database-product-name"/>,
);
</xsl:template>
</xsl:stylesheet>
-------------
XML file :
------------
<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet href="file.xslt" type="text/xslt"?>
<!--Sample XML file generated by XMLSpy v2006 sp1 U
(http://www.altova.com)-->
<inventory xmlns="http://xx"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
id="String">
<domain-name>WLS</domain-name>
<timestamp>2001-12-17T09:30:47.0Z</timestamp>
<server is-admin-server="false" name="String">
<comp>
<weblogic-version>1.0</weblogic-version>
<production-mode-enabled>true</production-mode-enabled>
<subsystem name="Text"/>
<subsystem name="Text"/>
</comp>
<java>
<version>1.1.0</version>
<vendor>bea</vendor>
<vm>
<version>5.0</version>
<vendor>bea-wls</vendor>
<name>wls</name>
</vm>
</java>
<os>
<arch>wlsarch</arch>
<name>beaos</name>
<version>3.3</version>
</os>
</server>
<jdbc-data>
<datasource name="String">
<driver-name>jdbc</driver-name>
<driver-version>2.0</driver-version>
<database-product-version>1.1.1</database-product-version>
<database-product-name>orcl</database-product-name>
</datasource>
</jdbc-data>
<jdbc-data>
<datasource name="String">
<driver-name>odbc</driver-name>
<driver-version>2.2.0</driver-version>
<database-product-version>1.1.1</database-product-version>
<database-product-name>sybase</database-product-name>
</datasource>
</jdbc-data>
</inventory>
Any help is greatly appreciated
Jyotsna
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--