5 Replies Latest reply on Nov 29, 2013 2:27 AM by wdfink

Different driver versions in same datasource

gandja2005 Nov 27, 2013 4:05 PM

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.

1. Re: Different driver versions in same datasource

wdfink Nov 28, 2013 4:14 AM (in response to gandja2005)

If you use >AS7 it is possible.
Do you?
Actions
2. Re: Different driver versions in same datasource

gandja2005 Nov 28, 2013 2:26 PM (in response to wdfink)

No, AS6
Actions
3. Re: Different driver versions in same datasource

wdfink Nov 28, 2013 2:57 PM (in response to gandja2005)

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.
Actions
4. Re: Different driver versions in same datasource

gandja2005 Nov 28, 2013 7:44 PM (in response to wdfink)

I need be careful, in other times I had problem.
Actions
5. Re: Different driver versions in same datasource

wdfink Nov 29, 2013 2:27 AM (in response to gandja2005)

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
Actions

Go to original post