questo va nel server.xml
codice:
<Context debug="0" docBase="percorso" path="/contesto" reloadable="true" workDir="directory work">
<Resource name="jdbc/nomeDataSource" auth="Container" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/nomeDataSource">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter>
<name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value>
</parameter>
<parameter>
<name>url</name>
<value>jdbc:oracle:thin:@server:1521:database</value>
</parameter>
<parameter>
<name>username</name>
<value>nome utente</value>
</parameter>
<parameter>
<name>password</name>
<value>passw database</value>
</parameter>
<parameter>
<name>maxActive</name>
<value>20</value>
</parameter>
<parameter>
<name>maxIdle</name>
<value>10</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>-1</value>
</parameter>
</ResourceParams>
questo va nel web.xml della webapp
codice:
<resource-ref>
<description>descrizione</description>
<res-ref-name>jdbc/nomeDataSource</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
<res-sharing-scope>Unshareable</res-sharing-scope>
</resource-ref>
e si usa cosė
codice:
Context envCtx = new InitialContext();
DataSource ds = (DataSource)envCtx.lookup("jdbc/nomeDataSource");
Connection conn = ds.getConnection();