- <!-- 
  <resources.jdbc:JDBCProvider xmi:id="JDBCProvider_1366787058604" name="Oracle JDBC Driver (XA)" description="Oracle JDBC Driver (XA)" providerType="Oracle JDBC Driver (XA)" isolatedClassLoader="false" implementationClassName="oracle.jdbc.xa.client.OracleXADataSource" xa="true">
    <classpath>c:\oracle\app\oracle\product\10\jdbc\lib\</classpath>
    <classpath>c:\oracle\app\oracle\product\10\jlib\</classpath>
    <nativepath></nativepath>
    <factories xmi:type="resources.jdbc:DataSource" xmi:id="DataSource_1366787305999" name="BTradeDB" jndiName="jdbs/BTradeDB" description="New JDBC Datasource" providerType="Oracle JDBC Driver (XA)" authMechanismPreference="BASIC_PASSWORD" manageCachedHandles="false" logMissingTransactionContext="true" diagnoseConnectionUsage="false" relationalResourceAdapter="builtin_rra" statementCacheSize="10" datasourceHelperClassname="com.ibm.websphere.rsadapter.Oracle11gDataStoreHelper">
      <propertySet xmi:id="J2EEResourcePropertySet_1366787305999">
        <resourceProperties xmi:id="J2EEResourceProperty_1366787305999" name="driverType" type="java.lang.String" value="" description="The type of the driver. The possible values are: thin, oci." required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306000" name="oracleLogFileSizeLimit" type="java.lang.Integer" value="0" description="Oracle10g and beyond: The oracleLogFileSizeLimit specifies the maximum number of bytes to be written to any one file.  Property is relevant only if trace file is specified. Default is unlimited" required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306001" name="oracleLogFileCount" type="java.lang.Integer" value="1" description="Oracle10g and beyond: The oracleLogFileCount specifies the number of files to use.  Property is relevant only if trace file is specified. Default is 1." required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306002" name="oracleLogFileName" type="java.lang.String" value="" description="Oracle10g and beyond: The oracleLogFileName indicates which file to write the traces to" required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306003" name="oracleLogTraceLevel" type="java.lang.String" value="INFO" description="Oracle10g and beyond: The oracleLogTraceLevel specifies which message levels will be logged .Default is INFO. Property is relevant only if trace file is specified.  Possible values from highest to lowest: SEVERE, WARNING, INFO, CONFIG, FINE, FINER ,FINEST.  Note that each value includes all above it, for example INFO includes SEVERE and WARNING" required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306004" name="oracleLogFormat" type="java.lang.String" value="SimpleFormat" description="Oracle10g and beyond: The trace output format. Default is SimpleFormat.  Property is relevant only if trace file is specified. Possible values (SimpleFormat/ XMLFormat)" required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306005" name="oracleLogPackageName" type="java.lang.String" value="oracle.jdbc.driver" description="Oracle10g and beyond: The Oracle package to trace. Default is oracle.jdbc.driver" required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306006" name="TNSEntryName" type="java.lang.String" value="" description="The entry name which is used for the Oracle OCI driver." required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306007" name="networkProtocol" type="java.lang.String" value="" description="Whether to use TCP/IP or IPC or any other protocol" required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306008" name="databaseName" type="java.lang.String" value="" description="The database name. For example, enter sample to make your Data Source point to sample.  used for thin driver setup" required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306009" name="serverName" type="java.lang.String" value="" description="The name of the server. used for thin driver setup" required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306010" name="portNumber" type="java.lang.Integer" value="1521" description="The TCP/IP port number where the jdbc driver resides. used for thin driver setup" required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306011" name="dataSourceName" type="java.lang.String" value="" description="The name of the Data Source." required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306012" name="URL" type="java.lang.String" value="jdbc:oracle:thin:@10.73.6.50:1521:BTRADE" description="This is a required property. The URL indicating the database from which the Data Source will obtain connections, such as 'jdbc:oracle:thin:@//localhost:1521/sample' for thin driver and 'jdbc:oracle:oci:@//localhost:1521/sample' for thick driver." required="true" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306013" name="loginTimeout" type="java.lang.Integer" value="" description="The maximum time to attempt to connect to the database. If this value is non-zero, the attempt to connect to the database will time out when this specified value is reached." required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306014" name="description" type="java.lang.String" value="" description="The description of this datasource." required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306015" name="transactionBranchesLooselyCoupled" type="java.lang.Boolean" value="false" description="This property is introduced as a result of Oraclebug 2511780, Oracle Patch for 2511780 must be installed before setting this property to true, failure to do that would cause a program error.  Please check the WebSphere readme file for more info ." required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306016" name="enableMultithreadedAccessDetection" type="java.lang.Boolean" value="false" description="Indicates whether or not to detect multithreaded access to a Connection and its corresponding Statements, ResultSets, and MetaDatas." required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306017" name="reauthentication" type="java.lang.Boolean" value="false" description="Specifies whether to allow reauthentication of connections.  This option requires implementation of the doConnectionSetupPerTransaction() method on the DataStoreHelper where the reauthentication is expected to take place." required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306018" name="preTestSQLString" type="java.lang.String" value="SELECT 1 FROM DUAL" description="This SQL statement is used for pre-test connection function. For example, SELECT 1 FROM [TESTTABLE]. If pre-testing of connection is enabled for the connection pool, this SQL statement will be executed to the connection to make sure the connection is good. If you leave this field blank, the default SQL statement, SELECT 1 FROM DUAL, will be used at runtime. This will slow down the execution because of the exception handling if table DUAL is not defined in the database. Users are recommended to provide their own SQL statement to improve the performance." required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306019" name="validateNewConnection" type="java.lang.Boolean" value="false" description="Setting this flag to true will cause to WebSphere Application Server to validate connections when they first get created and to keep trying to get a good connection from the database if the validation fails. Setting this flag to false prevents any additional validation from being performed - newly created connections are assumed to be valid and usable. " required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306020" name="validateNewConnectionRetryCount" type="java.lang.Integer" value="100" description="This is useful only if validateNewConnection flag is true.  This property controls how many times WebSphere will try to get a connection from the database before giving up" required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306021" name="validateNewConnectionRetryInterval" type="java.lang.Long" value="3" description="This is useful only if validateNewConnection flag is true.  This property controls the interval between retries to retrieve a connection from the database.  Unit is seconds" required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306022" name="validateNewConnectionTimeout" type="java.lang.Integer" value="" description="Specifies the timeout in seconds for testing connections (either new or pooled by the application server) to the database.  If the timeout expires before validating then the connection is considered unusable.  If retries are configured, the full value of the timeout applies to each retry.  A value of 0 indicates the JDBC driver does not impose a timeout on validation attempts. This data source attribute applies to JDBC 4.0 drivers and above. Unit is seconds" required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306023" name="dbFailOverEnabled" type="java.lang.Boolean" value="" description="Deprecated. Please use the validateNewConnection property instead. This flag should be set to true only if the backend database is configured with failover capability.  This flag will indicate to WebSphere to validate connections when they first get created and to keep trying to get a good connection from the database when the validation fails." required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306024" name="connRetriesDuringDBFailover" type="java.lang.Integer" value="" description="Deprecated. Please use the validateNewConnectionRetryCount property instead. This is useful only if dbFailOverEnabled flag is true.  This property controls how many times WebSphere will try to get a connection from the database before giving up" required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306025" name="connRetryIntervalDuringDBFailover" type="java.lang.Long" value="" description="Deprecated. Please use the validateNewConnectionRetryInterval instead. This is useful only if dbFailOverEnabled flag is true.  This property controls the interval between retries to retrieve a connection from the database." required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306026" name="errorDetectionModel" type="java.lang.String" value="ExceptionMapping" description="The error detection model determines how fatal connection and statement errors are detected, including which types of exceptions are raised to the application. Under the ExceptionChecking model, the application server uses the error mapping facility defined in the Data Store Helper only to identify errors. The application server does not replace exceptions thrown by the JDBC driver with exceptions defined in the error map of the Data Store Helper.  Under the ExceptionMapping model, the application server uses the error mapping facility defined in the Data Store Helper to detect fatal connection and statement errors. The application server overrides exceptions thrown by the JDBC driver with exceptions defined in the error map of the Data Store Helper. The ExceptionMapping setting is not compliant with JDBC 4.0 and above, but is necessary for applications written according to the WebSphere Application Server exception mapping model." required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306027" name="nonTransactionalDataSource" type="java.lang.Boolean" value="false" description="Setting this flag to true will cause the Application Server to never enlist the connections from this datasource in global or local transactions.  Applications must explicitly call setAutoCommit(false) on the connection if they want to start a local transaction on the connection and they must commit or rollback the transaction that they started." required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306028" name="freeResourcesOnClose" type="java.lang.Boolean" value="false" description="Controls whether or not the application server automatically frees Arrays, Blobs, Clobs, NClobs, SQLXMLs, InputStream, and Readers when the object that created them is closed. The ability to free resources is contingent on the JDBC driver supporting the free (or close) method." required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306029" name="userDefinedErrorMap" type="java.lang.String" value="" description="Overlays existing entries in the error map by invoking DataStoreHelper.setUserDefinedMap. The userDefinedErrorMap can be used to add, change, or remove entries from the error map. Entries are delimited by ; (semicolon). Each entry consists of a key and value, where the key is an error code (numeric value) or SQLState (text enclosed in double quotes). Keys and values are are separated by = (equals sign). For example, to remove the mapping of SQLState S1000, add a mapping of error code 1062 to DuplicateKeyException, and add a mapping of SQLState 08004 to StaleConnectionException, the following can be specified for userDefinedErrorMap: &quot;S1000&quot;=;1062=com.ibm.websphere.ce.cm.DuplicateKeyException;&quot;08004&quot;=com.ibm.websphere.ce.cm.StaleConnectionException" required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306030" name="beginTranForResultSetScrollingAPIs" type="java.lang.Boolean" value="false" description="If beginTranForResultSetScrollingAPIs is enabled, the application server attempts to begin a transaction or enlist in a transaction when the connection is not currently enlisted in a transaction and a result set scrolling operation is performed." required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306031" name="beginTranForVendorAPIs" type="java.lang.Boolean" value="false" description="If beginTranForVendorAPIs is enabled, the application server attempts to begin a transaction or enlist in a transaction when the connection is not currently enlisted in a transaction and a vendor API is invoked with the wrapper pattern or with WSCallHelper.jdbcCall or WSCallHelper.jdbcPass." required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306032" name="connectionSharing" type="java.lang.Integer" value="1" description="Determines whether connections are shared based on the current state of the connection (-1) or the original connection request (0). To specify with greater granularity which connection properties are matched based on the current state, you may combine the following constants by adding them together: 1=transaction isolation level, 2=read only, 4=holdability, 8=type map, 16=catalog." required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306033" name="oracleRACXARecoveryDelay" type="java.lang.Integer" value="0" description="Specifies the number of seconds for the application server, after detecting a stale connection, to defer two-phase xa.commit or xa.rollback operations that are made by the transaction manager. The application server defers XA operations by raising XAException with an error code of XA_RETRY. Use this property when an Oracle RAC node fails over after the xa.prepare method takes place. The delay allows time for the transaction to become visible to the node on which the failover occurs." required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306034" name="syncQueryTimeoutWithTransactionTimeout" type="java.lang.Boolean" value="" description="Use the time remaining (if any) in a JTA transaction as the default query timeout for SQL statements." required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306035" name="webSphereDefaultIsolationLevel" type="java.lang.Integer" value="" description="Specifies a default transaction isolation level for new connections. Resource References and Access Intents override this value. To configure a default transaction isolation level, use the constants defined by JDBC: 1 (READ UNCOMMITTED), 2 (READ COMMITTED), 4 (REPEATABLE READ), 8 (SERIALIZABLE)." required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306036" name="webSphereDefaultQueryTimeout" type="java.lang.Integer" value="" description="Sets a default query timeout, which is the number of seconds (0 means infinite) that a SQL statement may execute before timing out. This default value is overridden during a JTA transaction if custom property syncQueryTimeoutWithTransactionTimeout is enabled." required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
        <resourceProperties xmi:id="J2EEResourceProperty_1366787306037" name="enableClientInformation" type="java.lang.Boolean" value="false" description="Enables the implicit passing of client information on database connections. The client information provided on each connection is the same as for the WAS.clientinfo trace group. Whereas the WAS.clientinfo trace is configured on an application server, the enableClientInformation property applies to a data source configuration." required="false" ignore="false" confidential="false" supportsDynamicUpdates="false"/>
      </propertySet>
      <connectionPool xmi:id="ConnectionPool_1366787305999" connectionTimeout="180" maxConnections="10" minConnections="1" reapTime="180" unusedTimeout="1800" agedTimeout="0" purgePolicy="EntirePool" numberOfSharedPoolPartitions="0" numberOfUnsharedPoolPartitions="0" numberOfFreePoolPartitions="0" freePoolDistributionTableSize="0" surgeThreshold="-1" surgeCreationInterval="0" testConnection="false" testConnectionInterval="0" stuckTimerTime="0" stuckTime="0" stuckThreshold="0"/>
      <mapping xmi:id="MappingModule_1366787706602" mappingConfigAlias="" authDataAlias=""/>
    </factories>
  </resources.jdbc:JDBCProvider>
  -->