Pre-requisite. Download Oracle JDBC Driver from: Oracle JDBC Drivers are available at Oracle Site: http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html
In order to configure a Datasource on Tomcat for Oracle Database you need to follow these three simple steps:
1) Define the Datasource in server.xml
Include a Datasource configuration in your Tomcat's server.xml file within the Context section, containing information about the JDBC URL, username and password and the maximum number of active connections allowed in the pool:
Next, before starting up Tomcat place Oracle JDBC driver into CATALINA_HOME/lib/ . For Oracle, either class 12.jar or ojdbc5.jar
3) Finally, in your web.xml reference your datasource by including the JNDI name assigned in your server.xml:
In order to configure a Datasource on Tomcat for Oracle Database you need to follow these three simple steps:
1) Define the Datasource in server.xml
Include a Datasource configuration in your Tomcat's server.xml file within the Context section, containing information about the JDBC URL, username and password and the maximum number of active connections allowed in the pool:
2) Install the JDBC Driver<Resource name="jdbc/OracleDS" auth="Container" type="javax.sql.DataSource" username="scott" password="tiger" driverClassName="com.mysql.jdbc.Driver" url="jdbc:oracle:thin:@localhost:1521:test" maxActive="15" maxIdle="7" defaultTransactionIsolation="READ_COMMITTED" validationQuery="Select 1" />
Next, before starting up Tomcat place Oracle JDBC driver into CATALINA_HOME/lib/ . For Oracle, either class 12.jar or ojdbc5.jar
3) Finally, in your web.xml reference your datasource by including the JNDI name assigned in your server.xml:
Now you can look up your Datasource in your application as follows:<resource-ref> <description>Oracle Datasource for tomcat </description> <res-ref-name>jdbc/OracleDS</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref>
InitialContext cxt = new InitialContext(); DataSource ds = (DataSource) cxt.lookup( "java:/comp/env/jdbc/OracleDS" ); if ( ds == null ) { throw new Exception("Data source not found!"); }
Commenti
Posta un commento