Question Re: Oracle drivers in Technology Q&A

Oracle drivers

Former Member — Fri, 19 Sep 2008 02:49:06 GMT

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

Re: Oracle drivers

Former Member — Fri, 19 Sep 2008 02:49:55 GMT

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-fa0b1ed4d88f

For all type of Jdbc drivers

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

Re: Oracle drivers

dharamveer_gaur2 — Fri, 19 Sep 2008 03:05:18 GMT

user name: <Oracle database user>

password: <Password>

driver: oracle.jdbc.driver.OracleDriver

url:jdbc:oracle:thin:@<ServerHost(IP)>:1521:<SID>

where SID is Oracle database server's name

if any problem let me know.

Re: Oracle drivers

Former Member — Fri, 19 Sep 2008 05:03:49 GMT

hi,

[/thread/748572 [original link is broken];

chk it out.

Regards.

Siddhesh Naik