差分

[[Tomcat]]

<&lt;Context path="/myoracle" docBase="DBTest" debug="5" reloadable="true" crossContext="true">&gt;

<&lt;!-- maxActive: Maximum number of dB connections in pool. Make sure you

-->&gt;

<&lt;!-- maxIdle: Maximum number of idle dB connections to retain in pool.

-->&gt;

<&lt;!-- maxWait: Maximum time to wait for a dB connection to become available

-->&gt;

<&lt;!-- username and password: MySQL dB username and password for dB connections -->&gt;

<&lt;!-- driverClassName: Class name for the old mm.mysql JDBC driver is

-->&gt;

<&lt;!-- url: The JDBC connection url for connecting to your MySQL dB.

-->&gt;

<&lt;Resource name="jdbc/myoracle" auth="Container"

maxWait="-1"/> &gt;

<&lt;/Context>&gt;

<&lt;resource-ref>&gt; <&lt;description>&gt;Oracle Datasource example<&lt;/description>&gt; <&lt;res-ref-name>&gt;jdbc/myoracle<&lt;/res-ref-name>&gt; <&lt;res-type>&gt;javax.sql.DataSource<&lt;/res-type>&gt; <&lt;res-auth>&gt;Container<&lt;/res-auth>&gt; <&lt;/resource-ref>&gt;

<&lt;%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql" %>&gt; <&lt;%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>&gt;

<&lt;sql:query var="rs" dataSource="jdbc/myoracle">&gt;

<&lt;/sql:query>&gt;

<&lt;html>&gt; <&lt;head>&gt; <&lt;title>&gt;DB Test<&lt;/title>&gt; <&lt;/head>&gt; <&lt;body>&gt;

<&lt;h2>&gt;Results<&lt;/h2>&gt;

<&lt;c:forEach var="row" items="${rs.rows}">&gt; Foo ${row.foo}<&lt;br/>&gt; Bar ${row.bar}<&lt;br/>&gt; <&lt;/c:forEach>&gt;

<&lt;/body>&gt; <&lt;/html>&gt;