Deploy JDBC driver .

[Former Member]

Hi All,

I have closed my previous thread.

I have this Information with me to connect to Oracle Database.

The IP provided by my ISP is:62.234.221.193

port on which oracle running is:1521

Oracle global database name: BBB

Oracle SID: AAA

1. Where I will find Oracle JDBC driver and how and where will I deploy ?. Pls help

2. What I will give in JDBC driver in JDBC Adapter ?

3. In Connection jdbc:oracle:thin:@62.234.221.193:1521:BBB -- is this corrcet?

Pls help for the above points.

Regards

[Former Member]

> 1. Where I will find Oracle JDBC driver and how and where will I deploy ?. Pls help

If am not wrong then you can find it on Oracle DVD's, better to check this..

> 2. What I will give in JDBC driver in JDBC Adapter ?

Just search on SDN for file to JDBC and you will lots of blogs, there you will find all information regaarding adapter configuration.

> 3. In Connection jdbc:oracle:thin:@62.234.221.193:1521:BBB -- is this corrcet?

the string "jdbc:oracle:thin:" can vary with oracle version. So this may be correct or may be incorrect.

Regards,

Sarvesh

[Former Member]

HI,

Read this and you will find all the information..

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/70ffd890-0201-0010-708f-d5dad2df...

Regards,

Sarvesh

[Former Member]

Hi,

there exists a newer version of this guide too:

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

Regards

Patrick

[Former Member]

Hi Patrick/Sarvesh

After reading this document:

I added my Driver JARs to aii_af_jmsproviderlib.sda and deployed back to J2EE server.

I have 2 database Oracle and Microsoft SQL Server

So pls advice in JDBC Adapter:

What will come in JDBC Driver and Connection parameter ?

Regards

[Former Member]

This may help you..

File to JDBC

Regards,

Sarvesh