nabezo wiki

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();