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-refFrom 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