JMS /JDBC

[Former Member]

If a new PI 7.1 install is in place and conenction made to ECC ,can jms and jdbc adapters also be used or some drivers need to be installed for using them the first time or these drivers are automatically installed once you do install?

thanks

[Former Member · Accepted solution]

Hi,

1. Download the drivers.

2. Deploy the drivers.

Explained below:

Procedure for 1:

Find out which drivers do you really need. In case you need JDBC drivers for MSSQL, download these from Microsoft's website.

This was an example, but you can obtain more information by following the guidelines in the SAP Note 1138877 - PI 7.1 : How to Deploy External Drivers JDBC/JMS Adapters.

Also, refer to notes 1145221, 639702 for JDBC.

Procedure for 2: Refer to the blog http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/19597. [original link is broken] [original link is broken] [original link is broken]

Simply include the .jar files into the lib subdirectory in com.sap.aii.adapter.lib.sda file. Edit provider.xml under server sub-dir in same sda file. Deploy this to the PI java stack using hotfixes option in JSPM, which you can launch using the following command for this purpose:

go "-config=/jspm/forceMode=true" "-config=/jspm/deployVersionRule=updateAll"

Regards,

Shitij

[Former Member]

Hello,

If you want to use JMS or JDBC Adapter you need to install its drivers on PI server.

Making connections with ECC doesnt mean tht you can use JMS or JDBC.

Please go through the link below for JMS:

http://help.sap.com/saphelp_nw04/helpdata/en/cd/d85a9d6fab7d4dbb7ae421f710626c/content.htm

Thanks,

Hetal

[Former Member]

ok...

but if we install PI ,do these drivers not get installed automatically?

if no then from where can we download drivers ?

Drivers are only needed for jms and jdbc or other adapters too?

thanks

[Former Member]

No.

Installing PI doesnt mean that these drivers will get installed automatically.

As a developer you wont be able to install them.

You can take help from your Basis team to install these drivers.

It is mentioned in PI Installation guide how to install these drivers and from where to get it, as i dont remember exactly from where you will get it.

It depends on what all adapters you are using, but majorly for these two adapters you will require drivers to be installed on PI.

Hope it helps.

Thanks,

Hetal