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