0001932: DataSource casting

Viewing Issue Advanced Details [ Jump to Notes ]

[ View Simple ] [ Issue History ] [ Print ]

Category

Severity

Reproducibility

Date Submitted

Last Update

0001932

[Resin]

minor

always

08-07-07 08:56

11-05-07 14:55

Reporter

ferg

View Status

public

Assigned To

ferg

Priority

normal

Resolution

fixed

Platform

Status

closed

Projection

none

OS Version

ETA

none

Fixed in Version

3.1.4

Product Version

Product Build

Summary

0001932: DataSource casting

Description

(rep by Geoff Hendry)

I've got an interesting database pooling need. I have multiple databases, each with a different URL which is determined dynamically at runtime. Therefore, I cannot provide these URL (or associated database info) at configuration time.

I need to be able to dynamically instruct Derby's DataSource to provide a connection to a particular database, with particular parameters.

On Jetty web server, I cast the DataSource to a org.apache.derby.jdbc.ClientConnectionPoolDataSource and I can then call methods on that class to point it at the right database.

However, on resin, the DataSource returned to me is the DBPool. What I need is some way to get at the underlying ClientConnectionPoolDataSource and call methods on it. I was looking at the JDK 6/JDBC 4 Wrapper class as a possible way to get at the underlying DataSource implementation, but I don't kow if that's the rght aproach, or if Resin even supports it.

If I use a standard non-pooled org.apache.derby.jdbc.ClientDataSource then I don't have this problem since Resin just returns the ClientDataSource as expected. But then I don't get pooling, which I need. Please advise.

Steps To Reproduce

Additional Information

Attached Files

Relationships

Notes
(0002444) ferg 11-05-07 14:55	server/4504

Issue History
Date Modified	Username	Field	Change
08-07-07 08:56	ferg	New Issue
11-05-07 14:55	ferg	Note Added: 0002444
11-05-07 14:55	ferg	Assigned To	=> ferg
11-05-07 14:55	ferg	Status	new => closed
11-05-07 14:55	ferg	Resolution	open => fixed
11-05-07 14:55	ferg	Fixed in Version	=> 3.1.4

Mantis 1.0.0rc3[^]

28 total queries executed.
25 unique queries executed.