Different driver versions in same datasource

[gandja2005]

Hi,

I need configure in same datasource different versions of driver for oracle database, is it possible?

It's necessary because in the same instance in jboss I can have apps that use different versions of oracle. We are migrating our database to newer version of oracle and our apps will be migrate over a time.

[wdfink]

If you use >AS7 it is possible.

Do you?

[gandja2005]

No, AS6

[wdfink]

What you mean by same datasource different driver version.

In AS6 you can have only one driver in the lib directory. With AS7 you might have different driver versions, but you need to configure different datasources for that.

One possibility is to include the driver in your deployment and set the classloader for AS6 accordingly in the applications.

But why do you need it, mostly a new driver can handle older versions of Oracle without any problem.

[gandja2005]

I need be careful, in other times I had problem.

[wdfink]

For defined datasources (*-ds.xml) I see no chance to have several drivers with AS6 you need to migrate to AS7 or WildFly for that.

If you use JDBC direct from the application without pooling you might include the driver in the EAP file and separate the class loading, a good starting point for the documentation is here JBossClassLoadingUseCases