Mantis Bugtracker

Viewing Issue Advanced Details Jump to Notes ] View Simple ] Issue History ] Print ]
ID Category Severity Reproducibility Date Submitted Last Update
0003318 [Resin] major always 02-04-09 15:05 05-07-09 09:40
Reporter atifmk View Status public  
Assigned To ferg
Priority urgent Resolution fixed Platform
Status closed   OS
Projection none   OS Version
ETA none Fixed in Version 4.0.1 Product Version 3.1.8
  Product Build
Summary 0003318: Database connection pooling with Oracle RAC
Description The example given on wiki @ [^] is wrong. The oracle driver would now work with fast connection failover and caching enabled with OracleConnectionPoolDataSource. Oracle recommends using OracleDataSource instead.

The problem is that when the OracleDataSource is defined as the driver type in database configuration, Resin is not able to configure the connection pool and throws error. The exact error is:

com.caucho.sql.DriverConfig.setType(): 'oracle.jdbc.pool.OracleDataSource' is not a valid database type.

Here is the configuration in resin.conf:


The same exact configuration works in standalone Java program.

import java.sql.Connection;
import java.sql.ResultSet;

import oracle.jdbc.pool.OracleDataSource;

public class OracleRACTest {

     * @param args
     * @throws Throwable
    public static void main(String[] args) throws Throwable {
        OracleDataSource ds = new OracleDataSource();
        Connection conn = ds.getConnection();
        ResultSet rs = conn.createStatement().executeQuery("select count(*) from test");;
        System.out.println("Count#: " + rs.getInt(1));
Steps To Reproduce
Additional Information
Attached Files

- Relationships

- Notes
05-07-09 09:40


- Issue History
Date Modified Username Field Change
02-04-09 15:05 atifmk New Issue
02-09-09 09:33 ferg Priority normal => urgent
05-07-09 09:40 ferg Note Added: 0003987
05-07-09 09:40 ferg Assigned To  => ferg
05-07-09 09:40 ferg Status new => closed
05-07-09 09:40 ferg Resolution open => fixed
05-07-09 09:40 ferg Fixed in Version  => 4.0.1

Mantis 1.0.0rc3[^]
Copyright © 2000 - 2005 Mantis Group
29 total queries executed.
26 unique queries executed.
Powered by Mantis Bugtracker