How to redeploy VMJDBC driver
Hi folks,
I’d like to share with you steps that you may use in your test ME system in case you need to redeploy VMJDBC driver:
- Login to NW textconsole.
- Run command “add dbpool” – this will add more commands to console.
- Run command “REMOVE_DATA_SOURCE VMJDBC”. If NW says it cannot remove driver because it is not deployed – it is OK
- Run command “DEPLOY_JDBC_DRIVER VMJDBC <PATH TO SQLJDBC.jar>/sqljdbcX.jar” [the name\version of the file must be according to the installation guide]
- After it is deployed restart NW.
- Go to NWA.
- Open Configuration Management.
- Open Infrastructure.
- Open Application Resources.
- Find “VMJDBC” record and select it.
- Look at Settings parameter “Filename” – it should end with “sqljdbcX.jar” [should end with the name of the file from step 4]
In case of production system, please, follow strictly the installation guide, upgrade guide and correction Notes. Do not play with your production as I do sometimes with my test system 🙂
Br, Alex.
The simplest way to renew the existing VMJDBC driver of SAP ME is as follows:
Sergiy: true, however just yesterday I was trying to switch my VMJDBC from Oracle to SQL Server. I undeployed ME, MECTC, etc. I undeployed all db pools. Restarted the Java instance. I could _not_ delete the VMJDBC entry and it was pointing to a non-existent Oracle driver jar. Following Alex's steps solved the issue.