my first JNDI

最新推荐文章于 2025-11-24 14:21:40 发布

原创最新推荐文章于 2025-11-24 14:21:40 发布 · 675 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#hibernate #oracle #java #jsp #path

本文介绍如何在Tomcat服务器中配置Hibernate框架连接Oracle数据库的方法，包括修改server.xml文件、设置hibernate.cfg.xml配置及编写JSP页面来获取数据源。

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");