Where should I put the Oracle JDBC driver jar ?

[gchazalon]

Hi,

I have created a datasource on an Oracle 9i database with the Oracle thin JDBC driver. Of course I needed to add the oracle library containing the driver classes to JBoss classpath.

For now I have put the ojdbc14.jar right under the ${JBOSS_HOME}/server/${CONFIG_NAME}/lib directory, and it works fine.

But I don't know if this is the right way to do it... Maybe it's better to put the jar under the ${JBOSS_HOME}/lib directory directly ?

I'm waiting on your "best practice" advice.

Thanks,

Gregory

[bfolleas]

Hi,

It's better to put your jar under ${JBOSS_HOME}/server/${CONFIG_NAME}/lib because you can manage different config versions. You can have multiple server instance at one time, each with it's own datasource to different RDBMS.

The directory ${JBOSS_HOME}/lib is only for jboss core libs.

Bertrand

[gchazalon]

Thanks Bertrand,

I'll keep it that way for the moment. :-)

Regards,

Gregory