접기
dbs.properties
C:\jboss5\server\default\deploy\ROOT.war\WEB-INF\dbs.properties
driver=com.mysql.jdbc.Driver
url=jdbc:mysql://127.0.0.1:3306/pg
user=ID
pword=PASSWORD
---------------------------------
SqlMapConfigS.xml
C:\jboss5\server\default\deploy\ROOT.war\WEB-INF\SqlMapConfigS.xml
<properties resource="dbs.properties"/>
<transactionManager type="JDBC" commitRequired="false">
<dataSource type="SIMPLE">
<property name="JDBC.Driver" value="${driver}"/>
<property name="JDBC.ConnectionURL" value="${url}"/>
<property name="JDBC.Username" value="${user}"/>
<property name="JDBC.Password" value="${pword}"/>
<!-- optional properties below -->
<property name="Pool.MaximumActiveConnectinos" value="100"/>
<property name="Pool.MaximumIdleConnections" value="50"/>
<property name="Pool.MaximumCheckoutTime" value="120000"/>
<property name="Pool.TimeToWait" value="10000"/>
<property name="Pool.PingQuery" value="select * from ibatis_pool_ping_check"/>
<property name="Pool.PingConnectionsOlderThan" value="0"/>
<property name="Pool.PingConnectionsNotUsedFor" value="0"/>
</dataSource>
</transactionManager >
--------------------------------------
Test.xml( sqlmap) ,Test.java 그대로 사용.
접기
접기
<local-tx-datasource>
<jndi-name>JNDI명 </jndi-name>
<connection-url>jdbc:mysql://127.0.0.1:3306/pg?useUnicode=true&characterEncoding=EUC_KR </connection-url>
<driver-class>com.mysql.jdbc.Driver </driver-class>
<user-name>ID </user-name>
<password>PASS </password>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
<!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
<metadata>
<type-mapping>mySQL</type-mapping>
</metadata>
</local-tx-datasource>
접기
접기
<jboss-web>
<resource-ref>
<res-ref-name>jdbc/JNDI명 </res-ref-name>
<jndi-name>java:/JNDI명 </jndi-name>
</resource-ref>
</jboss-web>
접기
접기
<web-app>
<display-name>Welcome to JBoss</display-name>
<description>
Welcome to JBoss
</description>
<servlet>
<servlet-name>Status Servlet</servlet-name>
<servlet-class>org.jboss.web.tomcat.service.StatusServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>Status Servlet</servlet-name>
<url-pattern>/status</url-pattern>
</servlet-mapping>
<resource-ref>
<description>리소스설명</description>
<res-ref-name>jdbc/JNDI명 </res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>
</web-app>
접기