Realm および プログラムで共通の Datasourceを利用する場合の server.xml

サンプル

server.xml

<?xml version="1.0" encoding="UTF-8"?>
<Server
	port="8105"
	shutdown="SHUTDOWN">

	<Listener
		SSLEngine="on"
		className="org.apache.catalina.core.AprLifecycleListener" />

	<Listener className="org.apache.catalina.core.JasperListener" />
	<Listener className="org.apache.catalina.core.JreMemoryLeakPreventionListener" />
	<Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener" />
	<Listener className="org.apache.catalina.core.ThreadLocalLeakPreventionListener" />

	<GlobalNamingResources>
		<Resource
			auth="Container"
			name="jdbc/mysql-base2"
			type="javax.sql.DataSource"
			driverClassName="com.mysql.jdbc.Driver"
			username="base2"
			password="base2"
			url="jdbc:mysql://localhost/base2">
		</Resource>

	</GlobalNamingResources>
	.
	<Service name="Catalina">
		<Connector
			connectionTimeout="20000"
			port="8180"
			protocol="HTTP/1.1"
			redirectPort="8443" />
		<Engine
			defaultHost="localhost"
			name="Catalina">

			<!-- jdbc:mysql://localhost/base2 -->
			<Realm className="org.apache.catalina.realm.CombinedRealm">
				<Realm
					className="org.apache.catalina.realm.DataSourceRealm"
					dataSourceName="jdbc/mysql-base2"
					digest="MD5"
					userTable="tbuser"
					userNameCol="account"
					userCredCol="password"
					userRoleTable="tbuser"
					roleNameCol="role" />
				<Realm
					className="org.apache.catalina.realm.DataSourceRealm"
					dataSourceName="jdbc/mysql-base2"
					digest="MD5"
					userTable="tbuser"
					userNameCol="mailaddress"
					userCredCol="password"
					userRoleTable="tbuser"
					roleNameCol="role" />
			</Realm>

			<Host
				appBase="webapps"
				autoDeploy="true"
				name="localhost"
				unpackWARs="false">

				<Context
					docBase="struts2.app"
					path="/struts2.app"
					reloadable="true"
					source="org.eclipse.jst.j2ee.server:struts2.app">

					<ResourceLink
						name="jdbc/mysql-base2"
						global="jdbc/mysql-base2"
						type="javax.sql.DataSource" />
				</Context>
			</Host>
		</Engine>
	</Service>
</Server>