Deploy MySQL JDBC driver in PI 7.0

[former_member242804]

Hi Experts,

I have to deploy MySQL JDBC driver in PI 7.0 which is also our production system. We got many JMS interfaces which used the MQ driver in SDA file. If we are gonna deploy the MySQL JDBC driver, we have to update SDA file, would this deployment have a big influence with our JMS interfaces?

Please help me with this, thanks!!

[Liz_ · Accepted solution]

Hi Chengcheng,

There is no impact to add new driver files to the existed .sda file and deploy it. Since every time, you need deploy a new driver, you just put the jars into the existed .sda file and deploy it from scratch. There should not affect the existed driver at all if the last deployment is successful.

Hope it makes you clear.

Guided answers for "How to deploy the external drivers for Axis/JDBC/JMS Adapter“ for you reference.

https://gad5158842f.us2.hana.ondemand.com/dtp/viewer/#/tree/1433/actions/17943

Regards,

Liz

[former_member242804 · Accepted solution]

Hi Liz
Thanks for the link you provided, it's very useful. If as what you said, the deployment of new driver will not affect the existing JMS interfaces which use MQ driver in our SDA file. And in case of anything goes wrong, what kinds of backup

should we perform before the deployment? Thank you!

[Liz_ · Accepted solution]

Hi Chengcheng,

Before deploying the new SDA, please backup the old SDA file. If there is something wrong with the new SDA, e.g. the wrong jars, then you can deploy the old SDA with telnet, nwds in force mode, so that the new SDA will be overwritten by old one.

Regards,

Liz

[MarioDeFelipe]

Hello, no, your driver will not collide with your existing driver as you add a new JAR file to the existing SDA, but you will need to reboot your system after the driver implementation

[former_member242804]

Really appreciate for your answer. By the way, what kinds of backup we need to perform before the deployment. And would all the JMS interfaces stop working during the process of deployment?

Thank you!

[Andrzej_Filusz]

Hi,

I've never had any issue after I deployed a new SDA file with an additional driver.

Regards,

Andrzej