Skip to Content

Cannot establish connection with the registered driver. com.mysql.jdbc.Driver returns: com.mysql.jdbc.Driver

Hi Experts,

I have developed fresh Soap to JDBC scenario in SAP PI 7.4[dual stack]. I have taken help from below link.

SAPTechnical.COM - Implementation of SOAP to JDBC Synchronous scenario

While testing the scenario with Alto as sender and MS SQL 2012 server as receiver I am getting below error.

com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error when attempting to get processing resources: com.sap.aii.af.lib.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection with the registered driver. com.mysql.jdbc.Driver returns: com.mysql.jdbc.Driver. : SAPClassNotFoundException: com.mysql.jdbc.Driver

I have installed required driver in PO.

I have provided usename and password in JDBC CC of receiver.

Please help..!!

Regards,

Vishnu Srivastava

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Jul 03, 2015 at 11:27 AM

    Hello Everyone,

    Thanks all for your valuable comments. It helped a lot. Issue is resolved by following below steps.

    1. Installing JDBC driver on correct path with correct version matching with installed JAVA version.

    for version details please refer to-- https://msdn.microsoft.com/en-us/library/ms378422(v=sql.110).aspx

    2. By changing the authentication mode of MS SQL sever from 'Windows Auth' Mode to SQL Server & Windows Auth' Mode.

    Adapter settings:

    JDBC Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver

    Connection : jdbc:sqlserver://<host>:1433;databaseName=<DB Name>

    Thanks,

    Vishnu Srivastava

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 01, 2015 at 10:13 AM

    Please find details of receiver JDBC adapter as attachment


    jdbc.PNG (17.3 kB)
    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Vishnu Srivastava

      Hi Srivastava,

      Since JDBC adapter resides on AAE, you need to deploy the drivers on java stack I guess.

      Regarding the driver information, check with the DB team, get the required driver using which PI system can establish the connectivity.

      Also, as Inaki said, check the snotes, whether the driver has been deployed in the PI java stack or not. For any issues, check with your basis team.

      Regards

      Vishnu

  • Posted on Jul 02, 2015 at 05:22 AM

    Hi Inaki/Pavan/Vishnu,

    Our Basis team had installed the driver and I just want to check the connectivity to DataBase.

    Can you please let me know the fields which needs to be filled in attached screenshot?

    PS: Database resides in my system only[localhost]

    Regards,

    Vishnu


    path.PNG (110.8 kB)
    test.PNG (28.6 kB)
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.