본문 바로가기
Developer/Server & JVM

[Server] 제우스 다중컨넥션

by 순수한소년 2017. 7. 5.
728x90
반응형
[JEUSMain.xml]
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
<resource>
    <data-source>
        <database>
            <vendor>oracle</vendor>
            <export-name>jdbc/name_test</export-name>
            <data-source-class-name>
               oracle.jdbc.pool.OracleConnectionPoolDataSource
            </data-source-class-name>
            <data-source-type>ConnectionPoolDataSource</data-source-type>
            <database-name>oracle sid</database-name>
            <description>
               This is a sample for database setting.
            </description>
            <user>아이디</user>
            <password>아이디</password>
            <port-number>1521</port-number>
            <server-name>아이피</server-name>
            <property>
                <name>driverType</name>
                <type>java.lang.String</type>
                <value>thin</value>
            </property>
            <auto-commit>true</auto-commit>
            <action-on-connection-leak>Warning</action-on-connection-leak>
            <connection-pool>
                <pooling>
                    <min>2</min>
                    <max>30</max>
                    <step>4</step>
                    <period>3600000</period>
                </pooling>
                <wait-free-connection>
                <enable-wait>true</enable-wait>
                <wait-time>10000</wait-time>
                </wait-free-connection>
            </connection-pool>
        </database>
 
        <!-- <database>..</database> 두개 이상일 경우 -->
    </data-source>
</resource>


[jeus-web-dd.xml]
1
2
3
4
5
6
7
<res-ref>
    <jndi-info>
        <ref-name>jdbc/name_test</ref-name><!-- JEUSMain.xml 설정 참고 -->
        <export-name>jdbc/name_test</export-name><!-- JEUSMain.xml 설정 참고 -->
    </jndi-info>
<!-- <jndi-info>..</jndi-info> 두개 이상일 경우 -->
 </res-ref>


JEUSMain.xml
1
2
3
4
5
<resource-ref>
    <res-ref-name>jdbc/name_test</res-ref-name
    <res-type>javax.sql.DataSource</res-type>
</resource-ref>
<!-- <resource-ref> ..</resource-ref> 두개 이상일 경우 -->


[스프링 설정파일]
1
2
3
<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">   
    <property name="jndiName" value="java:comp/env/jdbc/sd_sc">
</property></bean>
저작자 표시
신고


728x90
반응형