'jeus jdbc'에 해당되는 글 1건

  1. 2009.01.21 Jeus 에서의 JDBC 설정.

[JEUSMain.xml]
   <resource>
        <data-source>
            <database>
                <vendor>oracle</vendor>
                <export-name>DS_HVS_TEST</export-name>             
                <data-source-class-name>oracle.jdbc.pool.OracleConnectionPoolDataSource</data-source-class-name>
                <data-source-type>ConnectionPoolDataSource</data-source-type>
                <database-name>ORAHAR</database-name>  
                <data-source-name>oracle.jdbc.pool.OracleConnectionPoolDataSource</data-source-name>          
                <port-number>1522</port-number>
                <server-name>127.0.0.1</server-name>                
                <user>tscm</user>    
                <password></password>    
                <driver-type>thin</driver-type>
                <connection-pool>
                    <pooling>
                        <min>5</min>  
                        <max>15</max>
                        <period>600000</period>
                    </pooling>
                    <wait-free-connection>
                        <enable-wait>true</enable-wait>
                        <wait-time>20000</wait-time>
                    </wait-free-connection>
                    <check-query>SELECT * FROM DUAL</check-query>
                </connection-pool>
            </database>
        <data-source>
   <resource>

[DBConnectionManager] : Initial Context 를 사용하는 경우.
Context ctx = new InitialContext();
DataSource ds = (DataSource) ctx.lookup("ds1");
Connection con = ds.getConnection();


[DBConnectionManager] : container web.xml 을 사용하는 경우.
1.
Class.forName("jeus.jdbc.pool.Driver");
Connection con = DriverManager.getConnection("jdbc:jeus:pool:oraclePool");

2.
Properties prop = new Properties();
prop.put("jeus.jdbc.pool.ConnectionPoolID", "oraclePool");
Connection con = DriverManager.getConnection("jdbc:jeus:pool", prop);

3. [recommanded]
Driver myDriver = (Driver)Class.forName("jeus.jdbc.pool.Driver").newInstance();
Connection conn = myDriver.connect("jdbc:jeus:pool:oraclPool", null);

[jeus-web-dd.xml]
<jndi-info>
    <ref-name>jdbc/DSHVST</ref-name>
    <export-name>DS_HVS_TEST[DataSourceName]</export-name>
</jndi-info>




Posted by [czar]
,