WooYun.org

eth0      Link encap:Ethernet  HWaddr 00:22:19:7C:17:EE  
          inet addr:10.11.101.12  Bcast:10.11.101.255  Mask:255.255.255.0
          inet6 addr: fe80::222:19ff:fe7c:17ee/64 Scope:Link
          UP BROADCAST RUNNING MULTICAST  MTU:1500  Metric:1
          RX packets:3139641 errors:0 dropped:0 overruns:0 frame:0
          TX packets:3168161 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:1000 
          RX bytes:799244245 (762.2 MiB)  TX bytes:1653100713 (1.5 GiB)
          Interrupt:169 Memory:f8000000-f8012800 
lo        Link encap:Local Loopback  
          inet addr:127.0.0.1  Mask:255.0.0.0
          inet6 addr: ::1/128 Scope:Host
          UP LOOPBACK RUNNING  MTU:16436  Metric:1
          RX packets:29392 errors:0 dropped:0 overruns:0 frame:0
          TX packets:29392 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0 
          RX bytes:6302053 (6.0 MiB)  TX bytes:6302053 (6.0 MiB)

# Do not remove the following line, or various programs
# that require network functionality will fail.
::1     localhost.localdomain   localhost    js-12
127.0.0.1       js-12  js-12
10.20.222.21    song
10.11.101.22    ssms_vip2
10.11.101.21    ssms_vip1
10.10.20.65     nbuserver

<?xml version="1.0" encoding="UTF-8"?>
<!-- ===================================================================== -->
<!--                                                                       -->
<!--  JBoss Server Configuration                                           -->
<!--                                                                       -->
<!-- ===================================================================== -->
<!-- $Id: oracle-ds.xml 63175 2007-05-21 16:26:06Z rrajesh $ -->
<!-- ==================================================================== -->
<!--  Datasource config for Oracle originally from Steven Coy             -->
<!-- ==================================================================== -->
<datasources>
  <local-tx-datasource>
    <jndi-name>jdbc/ssmsdb</jndi-name>
    <connection-url>jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(FAILOVER = ON)(ADDRESS=(PROTOCOL=TCP)(HOST=ssms_vip1) (PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=ssms_vip2) (PORT=1521))(CONNECT_DATA=(SERVER = DEDICATED)(SERVICE_NAME=biz)(FAILOVER_MODE =(TYPE = SELECT)(METHOD = BASIC)(RETRIES = 30)(DELAY = 5))))</connection-url>
	<!--
		Here are a couple of the possible OCI configurations.
		For more information, see http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/java.920/a96654/toc.htm
jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(FAILOVER = ON)(ADDRESS=(PROTOCOL=TCP)(HOST=ssms_vip1) (PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=ssms_vip2) (PORT=1521))(CONNECT_DATA=(SERVER = DEDICATED)(SERVICE_NAME=biz)(FAILOVER_MODE =(TYPE = SELECT)(METHOD = BASIC)(RETRIES = 30)(DELAY = 5))))
	<connection-url>jdbc:oracle:oci:@youroracle-tns-name</connection-url>
		or
	<connection-url>jdbc:oracle:oci:@(description=(address=(host=youroraclehost)(protocol=tcp)(port=1521))(connect_data=(SERVICE_NAME=yourservicename)))</connection-url>
		Clearly, its better to have TNS set up properly.
	 -->
    <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
    <user-name>ssmsenter</user-name>
    <password>jsxx09</password>
    <min-pool-size>50</min-pool-size>
		<max-pool-size>200</max-pool-size>
    <!-- Uses the pingDatabase method to check a connection is still valid before handing it out from the pool -->
    <!--valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name-->
    <!-- Checks the Oracle error codes and messages for fatal errors -->
    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
        <!-- sql to call when connection is created
        <new-connection-sql>some arbitrary sql</new-connection-sql>
        -->
        <!-- sql to call on an existing pooled connection when it is obtained from pool - the OracleValidConnectionChecker is prefered
        <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
        -->
      <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml -->
      <metadata>
         <type-mapping>Oracle9i</type-mapping>
      </metadata>
  </local-tx-datasource>
</datasources>