FIRST ,WRITE IN THE SERVER.XML
<Context path="/hibernate" docBase="hibernate" debug="0" reloadable="true" crossContext="true">
<Resource name="jdbc/homeOracle" auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/homeOracle">
<parameter><name>username</name><value>scott</value></parameter>
<parameter><name>password</name><value>tiger</value></parameter>
<parameter><name>driverClassName</name>
<value>oracle.jdbc.driver.OracleDriver</value></parameter>
<parameter><name>url</name>
<value>jdbc:oracle:thin:@127.0.0.1:1521:book</value></parameter>
<parameter><name>maxIdle</name><value>20</value></parameter>
<parameter>
<name>maxActive</name>
<value>0</value>
</parameter>
<parameter>
<name>maxWait</name>
<value>5000</value>
</parameter>
</ResourceParams>
</Context>
SECOND ,SET THE hibernate.cfg.xml
<session-factory name="java:comp/env">
<property name="show_sql">true</property>
<property name="connection.datasource">jdbc/homeOracle</property>
<property name="hibernate.connection.url">jdbc:oracle:thin:@127.0.0.1:1521:book</property>
<property name="dialect">net.sf.hibernate.dialect.OracleDialect</property>
<property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="hibernate.connection.username">scott</property>
<property name="hibernate.connection.password">tiger</property>
<property name="hibernate.connection.pool_size">50</property>
</session-factory>
THIRD ,WRITE THE JSP
Context initCtx = new InitialContext();
Context envCtx = (Context) initCtx.lookup("java:comp/env");
DataSource ds = (DataSource)envCtx.lookup("jdbc/homeOracle");