JBoss를 이용하여 웹 어플리케이션 프로젝트를 만들어 보자. JBoss에는 jboss-web.xml 이란게 존재한다.
<?xml version="1.0" encoding="UTF-8"?> <datasources> <local-tx-datasource> <jndi-name>OracleDS</jndi-name> <connectionurl> jdbc:oracle:thin:@mkk.iptime.org:1521:orcl </connection-url> <driver-class> oracle.jdbc.driver.OracleDriver </driver-class> <user-name>scott</user-name> <password>tiger</password>
<min-pool-size>2</min-pool-size> <max-pool-size>10</max-pool-size>
<exception-sorter-class-name> org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter </exception-sorter-class-name> <metadata> <type-mapping>Oracle10g</type-mapping> </metadata> </local-tx-datasource> </datasources> |
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE jboss-web PUBLIC "-//JBoss//DTD Web Application 2.3V2//EN" "http://www.jboss.org/j2ee/dtd/jboss-web_4_0.dtd">
<jboss-web> <context-root>/default</context-root> <resource-ref> <res-ref-name>jdbc/OracleDS</res-ref-name> <jndi-name>java:/OracleDS</jndi-name> </resource-ref> </jboss-web> |
<?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>JbossTest</display-name> <resource-ref> <res-ref-name>jdbc/OracleDS</res-ref-name> <res-type>javax.sql.DataSource</res-type> <res-auth>Container</res-auth> </resource-ref> </web-app> |
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL Config Map 2.0//EN""http://ibatis.apache.org/dtd/sql-map-config-2.dtd"> <sqlMapConfig> <settings cacheModelsEnabled="true" enhancementEnabled="true" lazyLoadingEnabled="true" maxRequests="40" maxSessions="20" maxTransactions="6" useStatementNamespaces="true" />
<transactionManager type="JDBC"> <dataSource type="JNDI"> <property name="DBJndiContext"value="java:comp/env/jdbc/OracleDS"/> </dataSource> </transactionManager>
<sqlMap resource="org/thinker/database/test.xml" /> </sqlMapConfig> |
public class IBatis { private static SqlMapClient sqlMap; static{ try{ Reader reader = Resources.getResourceAsReader("org/thinker/database/sqlMapConfig.xml"); sqlMap = SqlMapClientBuilder.buildSqlMapClient(reader); }catch (Exception e){ System.out.println(e); } } public void getTest() throws SQLException{ HashMap map = (HashMap) sqlMap.queryForObject("test.sysdate"); System.out.println( "SELECT SYSDATE FROM DUAL : " + map.get("SYSDATE") ); } } |
'web application server > JBoss AS 6' 카테고리의 다른 글
JBoss6 배포(deploy)하기 (0) | 2013.01.08 |
---|---|
JBoss 시스템 변수 (0) | 2013.01.08 |
JBoss 6 시작 및 종료 (0) | 2013.01.08 |
JBOSS 6 소개 (0) | 2013.01.08 |