
こんな感じ













JDBC Driver Class: | |
|---|---|
| See the documentation for your JDBC driver. | |
Driver JAR: | |
| The JAR(s) required to make a connection to the database. Use CTRL-click or SHIFT-click to select multiple jars. The JAR(s) should already be installed under GERONIMO/repository/ (or ) | |
DB User Name: | |
| The username used to connect to the database | |
DB Password: | |
Confirm Password: | |
| The password used to connect to the database | |
| Driver Connection Properties | |
Typical JDBC URL: | jdbc:db2://{Host}:{Port}/{Database} |
Port: | |
| A property used to connect to DB2. May be optional (see JDBC driver documentation). | |
Host: | |
| A property used to connect to DB2. May be optional (see JDBC driver documentation). | |
Database: | |
| A property used to connect to DB2. May be optional (see JDBC driver documentation). | |
|
| Create Database Pool -- Step 3: Final Pool Configuration |
|
| Create Database Pool -- Step 4: Test Connection |
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" id="WebApp_ID" version="2.5">
<display-name>wasce_jndi_sample</display-name>
<welcome-file-list>
<welcome-file>index.html</welcome-file>
<welcome-file>index.htm</welcome-file>
<welcome-file>index.jsp</welcome-file>
<welcome-file>default.html</welcome-file>
<welcome-file>default.htm</welcome-file>
<welcome-file>default.jsp</welcome-file>
</welcome-file-list>
<servlet>
<servlet-name>lookup</servlet-name>
<servlet-class>DSLookup</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>lookup</servlet-name>
<url-pattern>/lookup</url-pattern>
</servlet-mapping>
<resource-ref>
<res-ref-name>jdbc/DB2DataSource</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
<res-sharing-scope>Shareable</res-sharing-scope>
</resource-ref>
</web-app>
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.SQLException;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;
public class DSLookup extends HttpServlet {
DataSource ds = null;
public void doGet(HttpServletRequest req, HttpServletResponse res) throws IOException {
Context context = null;
PrintWriter pw = res.getWriter();
try {
context = new InitialContext();
pw.println("get InitialContext: ok
");
}
catch(NamingException ne) {
pw.println("get InitialContext: ng
");
ne.printStackTrace(pw);
}
try {
ds = (DataSource)context.lookup("java:comp/env/jdbc/DB2DataSource");
pw.println("get DataSource: ok
");
Connection conn = ds.getConnection();
pw.println("get Connection: ok
");
} catch(NamingException ne) {
pw.println("get DataSource: ng
");
ne.printStackTrace(pw);
} catch (SQLException se) {
pw.println("get Connection: ng
");
se.printStackTrace(pw);
}
}
}
get InitialContext: ok
get DataSource: ok
get Connection: ok