Oracle drivers

[Former Member]

Hi ,

Good morning,

Integrating File to Oracle system , I got connection parameters & JDBC drivers , i configured and checked the data is not going to the receiver database.how can i know the format of the oracle drivers.points will be appreciated.

regards,

stephen

[Former Member · Accepted solution]

Follow below blog

Connection parameter & jdbc drivers changes

connection string : jdbc:oracle:oci8:userid/password@server

Note that this connection string is only if you use the Oracle OCI driver. The OCI driver requires a shared library or DLL on the server.

The thin driver for Oracle is more commonly used as it doesn't require any additional libraries. The connection string is as already listed above:

jdbc.oracle.thin:@server:port:SID

Follow this link

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f04ce027-934d-2a10-5a8f-fa0b1ed4...

For all type of Jdbc drivers

http://www.devx.com/tips/tip/28818