Posted by: piman007 | 02-05-2007

Oracle Thin Type 4 Driver for Oracle 9i and 10g Database

Oracle Thin Type 4 Driver for Oracle 9i and 10g Databases

The JAR file for the Oracle driver is ojdbc14.jar. Configure the connection pool using the following settings:

  • Name: Use this name when you configure the JDBC resource later.

  • Resource Type: Specify the appropriate value.

  • Database Vendor: Oracle

  • DataSource Classname:Specify one of the following:

    oracle.jdbc.pool.OracleDataSource
    oracle.jdbc.xa.client.OracleXADataSource
  • Properties:

    • user – Set as appropriate.

    • password – Set as appropriate.

    • URL – Specify the complete database URL using the following syntax:

      jdbc:oracle:thin:[user/password]@host[:port]/service
      

      For example:

      jdbc:oracle:thin:@localhost:1521:customer_db
    • xa-driver-does-not-support-non-tx-operations – Set to the value true. Optional: only needed if both non-XA and XA connections are retrieved from the same connection pool. Might degrade performance.

      As an alternative to setting this property, you can create two connection pools, one for non-XA connections and one for XA connections.


    Note –

    You must set the oracle-xa-recovery-workaround property in the Transaction Service for recovery of global transactions to work correctly. For details, see Workarounds for Specific Databases.

    When using this driver, it is not possible to insert more than 2000 bytes of data into a column. To circumvent this problem, use the OCI driver (JDBC type 2).

 

 

http://docs.sun.com/app/docs/doc/819-3658/6n5s5nklk?a=view#beamz


Responses

  1. Hi,Do you need ad players, advertisement player and LCD advertisings? Please go Here:www.amberdigital.com.hk(Amberdigital).we have explored and developed the international market with professionalism. We have built a widespread marketing network, and set up a capable management team dedicated to provide beyond-expectation services to our customers.
    amberdigital Contact Us

    E-mail:sstar@netvigator.com
    website:www.amberdigital.com.hk
    alibaba:amberdigital.en.alibaba.com[deibagchiea


ใส่ความเห็น

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / เปลี่ยนแปลง )

Twitter picture

You are commenting using your Twitter account. Log Out / เปลี่ยนแปลง )

Facebook photo

You are commenting using your Facebook account. Log Out / เปลี่ยนแปลง )

Google+ photo

You are commenting using your Google+ account. Log Out / เปลี่ยนแปลง )

Connecting to %s

หมวดหมู่

%d bloggers like this: