JDBC Adpter as Sender Problem

[peter_jarsunek]

Hi,

I am running XI ver3.0 and I'm not able to configure JDBC Adapter as Sender correctly...

It seems, that all parameters are ok (since the Check option from the menu displays no error), but it doesn't work - When I check the database (Oracle 8.1.7), no session is there from the SAP.

So, where could be a problem?

a, JDBC Driver - I imported the .jar file with the JDBC classes into Imported Archives in the Repository. Is it correct? Or is it needed to be deployed in some special way on the server(as I read)?

b, What item exactly should I write in the text field for the driver? Should be there something lik 'oracle.jdbc.driver.OracleDriver' or is there used some Alias Name?

c, how can I test if the Adapter runs correctly? Is there any testing tool? Or just for testing the connection, if it's ok?

Thanx for your answers! Peter

[former_member185751 · Accepted solution]

Hi Peter,

> So, where could be a problem?

> a, JDBC Driver - I imported the .jar file with the

> JDBC classes into Imported Archives in the

> Repository. Is it correct? Or is it needed to be

> deployed in some special way on the server(as I

> read)?

What is the Jar file name that you have imported?

>

> b, What item exactly should I write in the text field

> for the driver? Should be there something lik

> 'oracle.jdbc.driver.OracleDriver' or is there used

> some Alias Name?

For e.g.

JDBC Driver: oracle.jdbc.driver.OracleDriver

Connection: jdbc:oracle:thin:@wbs045:1521:SAPE

> c, how can I test if the Adapter runs correctly? Is

> there any testing tool? Or just for testing the

> connection, if it's ok?

You can use the adapter monitor to check the status of the communication channel.

Depending on the SP you are in check the following URL for adapter monitor

http://server:port/mdt/amtServlet

or

http://hostname:portnumber/AdapterFramework/monitor/monitor.jsp

Regards,

Sridhar

Message was edited by: Sridhar Rajan Natarajan

[Former Member]

Hi Peter,

the jdbc classes must be deployed on the adapter engine. Please check How-to guide: "How To Install and Configure External Drivers for JDBC & JMS".

You find it: http://service.sap.com/netweaver -> media library -> How-to Guides -> exchange infrastructure.

Good luck

Holger