그간 framework에 모든 걸 맡겼더니...
기본을 까먹네.
Tomcat6와 5.x 설정이 약간 틀린 듯.
하지만 앞으로도 계속 6를 사용할 참이니...
5.x는 필요할 때 찾아보지 뭐.
필요 패키지.
common-dbcp.jar
common-pool.jar
{tomcat}/conf/server.xml
<GlobalNamingResources>
기본을 까먹네.
Tomcat6와 5.x 설정이 약간 틀린 듯.
하지만 앞으로도 계속 6를 사용할 참이니...
5.x는 필요할 때 찾아보지 뭐.
필요 패키지.
common-dbcp.jar
common-pool.jar
{tomcat}/conf/server.xml
<GlobalNamingResources>
<Resource name="jdbc/hsql" auth="Container" type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="10000" username="sa" password="" driverClassName="org.hsqldb.jdbcDriver" url="jdbc:hsqldb:hsql://localhost/tt"/>
</GlobalNamingResources>
{tomcat}/conf/context.xml
<ResourceLink global="jdbc/hsql" name="jdbc/hsql" type="javax.sql.DataSource"/>
web.xml
<resource-ref>
<description>HSQL DataSource</description>
<res-ref-name>jdbc/hsql</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
Source.java
public Connection getConnection() throws SQLException, Exception {
Context context = new InitialContext();
DataSource dataSource = (DataSource) context.lookup( "java:/comp/env/jdbc/hsql" );
return dataSource.getConnection();
}
{tomcat}/conf/context.xml
<ResourceLink global="jdbc/hsql" name="jdbc/hsql" type="javax.sql.DataSource"/>
web.xml
<resource-ref>
<description>HSQL DataSource</description>
<res-ref-name>jdbc/hsql</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
Source.java
public Connection getConnection() throws SQLException, Exception {
Context context = new InitialContext();
DataSource dataSource = (DataSource) context.lookup( "java:/comp/env/jdbc/hsql" );
return dataSource.getConnection();
}
