Symantec IGA

 View Only
  • 1.  Connector Xpress script driver JDBC MYSQL

    Posted Aug 02, 2022 03:17 AM
    Hello!

    We have developed a JDBC connector for MYSQL. Stored procedure calls are not supported by MYSQL, so we have created a script to connect directly to the database to execute some additional statements, but we get a driver error, even though it is copied in the paths:

    -C:\CA\Identity Manager\Connector Xpress\lib
    -C:\CA\Identity Manager\Connector Server\lib

    conn = java.sql.DriverManager.getConnection("URL", "user", "password");

    Error:

    "No suitable driver found for jdbc"

    Is it necessary to copy the jar in some additional path? The reading of data and writing works correctly, the problem occurs when the script tries to connect directly to MYSQL.



    We have added the driver with the following steps described below:

    1. To ConnXP: https://knowledge.broadcom.com/external/article/134411/no-suitable-driver-found-for-jdbc-mysql.html 
    2. To JCS: https://knowledge.broadcom.com/external/article/220590/adding-mysql-jdbc-driver-to-im-connector.html 

    Thank you,
    regards.


  • 2.  RE: Connector Xpress script driver JDBC MYSQL

    Posted Aug 02, 2022 03:37 AM
    Resolved. It is necessary to copy the jar to: 

    C:\CA\Identity Manager\Connector Server SDK\connectors\sdkws\resources\endpoint\jars