JDBC Adapter - Driver Problem

[Former Member]

Hi

I am sending data from SAP System to SQL System through JDBC. I can see success message in SXMB_MONI in XI and also the response as Success, but records are not updated in SQL Database table.

Checked Adapter Monitor and I found JDBC driver status as RED (No deployed JDBC Drivers found).

I had a look around and asked teh Basis team to deploy JDBC driver through SDM. Is there any other way to do the same. I guess it's through Visual Administrator.

Though XI is running on Unix System, so how can I invoke Visual Administrator

Also kindly let me if the JDBC drivers are not there, how do SXMB_MONI show Success reponse.

Best Regards

Swetank

[Former Member]

Hi Swetank,

You can deploy the JDBC drivers using SDM only.

You can find the jars in the following path if they are deployed correctly:

<b>\usr\sap\<SID>\DVEBMGS<Instance Number>\j2ee\cluster\server0\bin\ext\com.sap.aii.af.jmsproviderlib</b>

Check if the drivers for SQL are there, if no then u need to deploy.

Regards

Sunita

[Former Member]

Hi Sunita

Thanks for your response. Though our XI system is installed on Unix Platform. I am not sure whether the directory structure will be the same , but will find out.

Any way that was good Information to have the correct path for JDBC driver.

Also kindly let me know if my JDBC Adapter has the status RED in Adapter Framework Monitor then why I get the success response in SXMB_MONI even though the SQL database is not updated.

Regards

Swetank

[Former Member]

Hi Swetank,

in SXMB_MONI you see only the status for the INtegration Engine and for the Integration Engine it is success if it has successfully been sent to the Adapter engine. Now in your case the Adapter engine failed to send the message to the receiver so the Adapter Engine will show an error for this message. To verify this use Runtime Workbench --> Message Monitoring, choose your Adapter Engine and supply selection criteria (sometimes the date and time gets messed up, so you might need to change the standard selection) and then you should see all messages that arrived at the Adapter engine and here the status should be failed for the ones going to the JDBC receiver.

For the deployment of JDBC drivers there is a chapter in the config guide and in the online help for XI 3.0. Make sure, your basis guys follow this steps accordingly and adjust the deployment descriptor as described.

Best regards

Christine