Mantis Bugtracker

Viewing Issue Simple Details Jump to Notes ] View Advanced ] 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  
Status closed   Product Version 3.1.8
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));
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