<%@ page import="oracle.sql.*, oracle.jdbc.driver.*, oracle.jdbc.*, java.sql.*" %>
<%@ taglib uri="http://xmlns.oracle.com/j2ee/jsp/tld/ojsp/sqltaglib.tld" prefix="sql" %>
<%@ taglib uri="http://xmlns.oracle.com/j2ee/jsp/tld/ojsp/xml.tld" prefix="xml" %>

<%! String dataSrcStr; %>
<%@ include file="checkDataSource.jsp" %>

<xml:transform href="style/rowset.xsl" >
   <sql:dbOpen connId="conn1" dataSource="<%= dataSrcStr %>" >
    </sql:dbOpen>
    <sql:dbQuery connId="conn1" output="xml" queryId="myquery">
       select ENAME, EMPNO from EMP order by ename
    </sql:dbQuery>
    <sql:dbCloseQuery queryId="myquery" />
    <sql:dbClose connId="conn1" />
</xml:transform>

