CentOS6.4に最低限のOpenJDK + HTTPD + Tocmat6 + MySQL5環境を構築する

環境 :

CentOS6.4 x86_64(minimal)

openjdk-1.7.0.19-2.3.9.1

httpd-2.2.15-26

tomcat6-6.0.24-52

mysql-server-5.1.67-1

タイトルの環境を構築した。全てyumでインストール。

最終的な動作確認で少し躓いたので、設定ファイルを残しておく。

・/etc/httpd/conf.d/proxy_ajp.conf

ProxyPass /tomcat/ ajp://localhost:8009/
ProxyPass /examples/ ajp://localhost:8009/examples/
ProxyPass /sample/ ajp://localhost:8009/sample/
ProxyPass /test/ ajp://localhost:8009/test/

・/etc/my.cnf

[mysqld]
↓このセクションに以下行を追加

character-set-server = utf8

・mysql-connector

cd /usr/share/java/tomcat6

ln -s /usr/share/java/mysql-connector-java.jar mysql-connector-java.jar

・/var/lib/tomcat6/webapps/test/META-INF/context.xml

<Context>
        <Resource
                name            = "jdbc/test"
                auth            = "Container"
                type            = "javax.sql.DataSource"
                maxActive       = "100"
                maxIdle         = "30"
                maxWait         = "10000"
                username        = "testuser"
                password        = "testpass"
                driverClassName = "com.mysql.jdbc.Driver"
                url             = "jdbc:mysql://localhost:3306/test"
        />
</Context>

・/var/lib/tomcat6/webapps/test/WEB-INF/web.xml

  <resource-ref>
    <description>DB Connection</description>
    <res-ref-name>jdbc/test</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>
  </resource-ref>

・サンプルのjsp

<%@ page contentType="text/plain"
import="javax.sql.*,javax.naming.*,java.sql.*" %>
<%
        Context context = new InitialContext();
        DataSource datasource = (DataSource)context.lookup("java:comp/env/jdbc/test");
        Connection connection= datasource.getConnection();
        DatabaseMetaData metadata= connection.getMetaData();
        out.println("DatabaseProductName: "+ metadata.getDatabaseProductName());
        out.println("DatabaseProductVersion: "+ metadata.getDatabaseProductVersion());
        out.println("DriverName: "+ metadata.getDriverName());
        out.println("DriverVersion: "+ metadata.getDriverVersion());
        out.println("URL: "+ metadata.getURL());
        out.println("UserName: "+ metadata.getUserName());
        connection.close();
%>

以上。