Thursday, 7 July 2011

Tomcat 6, Connection Pooling

From context.xml
Code:

resource name="jdbc/MoleComp" auth="Container"
    type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="-1"
    username="domain\user" password="xxxx" 
    driverClassName="sun.jdbc.odbc.JdbcOdbcDriver" 
    url="jdbc:odbc:MolecularComplaint"

From web.xml
Code:
resource-ref
description DB connection description
res-ref-name jdbc/MoleComp res-ref-name
res-type javax.sql.DataSource res-type
res-auth Container res-auth
resource-ref
From one of the servlets
Code:
Context initContext = new InitialContext();
Context env = (Context) initContext.lookup("java:comp/env");
DataSource ds =(DataSource) env.lookup("jdbc/MoleComp");
System.out.println("got ds");System.out.flush();
Connection conn = ds.getConnection();  
System.out.println("got conn");System.out.flush();   
sql = "SELECT TOP 1 PullDate,convert(varchar,PullDate,101) as lastDate,Status FROM IsisPull ORDER BY PullDate DESC";
PreparedStatement stmt = conn.prepareStatement(sql);
etc...
conn.close()

No comments:

Post a Comment