Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

How to force Application Server to use the Oracle OCI driver instead of JDBC

Highlighted
Gerry Allardice
Honored Contributor

How to force Application Server to use the Oracle OCI driver instead of JDBC

My understanding is that the application server for SD4.5 can use either the JDBC or OCI driver for Oracle to connect to the database.
Can anyone shed some light on how to get it to use the OCI driver.
2 REPLIES
Akies
Occasional Visitor

Re: How to force Application Server to use the Oracle OCI driver instead of JDBC

Hi gerry,

Have you tried with the system window that comes while starting the application server? Don'nt know much about this but there you get oracle driver that you are using, here it is written JDBC driver..May be you need to do something with database settings here..

Regards,
Akhil
Gerry Allardice
Honored Contributor

Re: How to force Application Server to use the Oracle OCI driver instead of JDBC

Working with the OCI driver.
----------------------------

The choice between the Thin driver and the OCI driver is made when the database account specifics are set in the Server accounts dialog. Database accounts are defined under the tab ‘Database Accounts’,
using the button ‘Add’ or ‘Modify’. On the ‘Properties’ screen that appears, Oracle must obviously be chosen as the ‘Database type’. The choice of the driver to use is made under the Tab ‘Connection’.Service Desk Database

Normally, each database account is characterized by a ‘Host’, an ‘IP Port’ and an ‘Instance’. If all three are specified the connection pool will use the Thin driver.

The other option is that only the Oracle net service name is entered in the ‘Instance’ field.(or the entry in TNSNAMES.ORA if using TNSNAMES).
The connection pool will then create connections using the OCI driver. No checking is performed whether the proper OCI libraries are available in the library path.
(ie make sure you have the Orcale OCI drivers loaded)
//Add this to "OnDomLoad" event