http://homepage2.nifty.com/yoks/TechNote/tomcat/TCAT41_DB.htm

http://d.hatena.ne.jp/spider-man/20080307/p1

http://d.hatena.ne.jp/spider-man/20080307/p1

JDBC-ODBC ドライバは標準のJDKにはいっている。

ソースに直接

  <!-- JDBCに関するパラメータ設定 -->
   <context-param>
       <param-name>jdbcDriver</param-name>
       <param-value>sun.jdbc.odbc.JdbcOdbcDriver</param-value>
       <description>JDBC Driver</description>
   </context-param>
   <context-param>
       <param-name>jdbcUri</param-name>
       <param-value>jdbc:odbc:TEST_DB</param-value>
       <description>ODBC URI</description>
   </context-param>
   <context-param>
       <param-name>dbUser</param-name>
       <param-value>Java_TEST</param-value>
       <description>Access DB USER</description>
   </context-param>
   <context-param>
       <param-name>dbPassword</param-name>
       <param-value></param-value>
       <description>Access DB PASSWORD</description>
   </context-param>
  <!-- ここまで -->

       ServletContext w_SrvCont = getServletContext();
       String jdbcdriver = w_SrvCont.getInitParameter("jdbcDriver");
  
           Class.forName(jdbcdriver);
           String dbURI      = w_SrvCont.getInitParameter("jdbcUri");
           String dbUserID   = w_SrvCont.getInitParameter("dbUser");
           String dbPassword = w_SrvCont.getInitParameter("dbPassword");
           Connection db = DriverManager.getConnection(dbURI, dbUserID, dbPassword);
           Statement stmt = db.createStatement();