//CONFIGURING DATASOURCE IN TOMCAT 6
STEP
1: Include the following Resource element inside GlobalNamingResources
element in server.xml located in apache_tomcat_root/conf
|
<GlobalNamingResources>
……………………….
<Resource auth="Container" type="javax.sql.DataSource"
driverClassName="com.ibm.db2.jcc.DB2Driver" url="jdbc:db2://localhost/ACETEST"
name="jdbc/SAMPLETEST"
username="db2admin"
password="db2admin" />
…………………………….
</GlobalNamingResources>
//url={your database server url}
// name={your datasource name}
// username/password={your database username/password}
|
STEP
2: Include the following ResourceLink element inside Context
element in context.xml located in apache_tomcat_root/conf
|
<Context>
………………….
<ResourceLink name="jdbc/SAMPLETEST"
global="jdbc/SAMPLETEST" type="javax.sql.DataSource"/>
……………………
</Context>
|
STEP
3: Use the datasource to get the connection
|
//code to access the datasource
Context initCtx = new InitialContext();
Context envCtx = (Context)
initCtx.lookup("java:comp/env");
DataSource ds = (DataSource)
envCtx.lookup("jdbc/SAMPLETEST");
Connection c = ds.getConnection();
|
