Updateing oracle table Emp usering JDBC Adapter

[Former Member]

Hi,

IS any one can help me what is the Format of JDBC Driver and Connection type.When we update a oracle table useing JDBC Adpater.

Thanks in advance

Regd's

Raj

[moorthy]

Hi,

For the Drivers~

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

For the e.g

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

Refer this SAP note about JDBC adapter-

831162

REgards,

Moorthy

[Former Member]

Try the following:

JDBC Driver:oracle.jdbc.driver.OracleDriver

Connection:jdbc:oracle:thin:@kopmdcval:1523:kopd40

Let me know if you have questions.

[Former Member]

Hi Venkat,

Can you please explain bref about the driver..

JDBC Driver:oracle.jdbc.driver.OracleDriver

Connection:jdbc:oracle:thin:@kopmdcval:1523:kopd40

the Driver of ip is Kopmdval i uderstand these

1523 is a port Number

what is Kopd40 can you please explain me these..

Regd's

Raj

[Former Member]

Hi Raj,

To access any Database from XI, you will have to install the corresponding Driver on your XI server.

To install oracle driver, just check this link,

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

The details that have to be entered while adapter configuration if you are using the OJDBC14.jar

The parameters should be mentioned as follows.

Connection : <b>jdbc:oracle:thin:@<IP adress>:<listener port>:<instance name (database name)></b>

Driver : <b>oracle.jdbc.driver.OracleDriver</b>

Also go through these links for more information regarding the same:

http://help.sap.com/saphelp_nw2004s/helpdata/en/80/4f34c587f05048adee640f4c346417/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/1d/756b3c0d592c7fe10000000a11405a/frameset.htm

Regards,

Abhy