Skip to Content

idm 8.0 note 2355326 add jdbc

Hi all I'm trying to use the note

2355326 - How to add additional JDBC driver or other jar file to IDM 8.0 Runtime,

My database is SQL server, and I would like to use a from database passs connect to mysql database

on DSE Class path I'm putting the path of the jdbc (C:\usr\sap\IdM\Identity Center\mysql-connector-java-5.0.8\mysql-connector-java-5.0.8-bin.jar)

I've unistal and install againd the dispacther and regenerate the scripts, but it still give the error message

Fromsource Database.init got exception connecting to jdbc:mysql

on the driver class, name I tryed to put "; com.mysql.jdbc.Driver"

such bellow

com.microsoft.sqlserver.jdbc.SQLServerDriver; com.mysql.jdbc.Driver

but when I do this when I put the password of msmc_admin, it request the password again, as it looks like that do not acept the pasword

Any help?

Arivind

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 24, 2017 at 07:51 AM

    Arvind,

    the job log should contain the full Java exception stack trace. Could you please post that? If the stack trace and exception message do not show up inside the Eclipse job log viewer, take a note of the "Work area" value in the job log header and browse to that directory in the filesystem. Look for the job log text file (typically DSE.log) in this directory and open it in a text editor. It often contains more detailed information than the XML version of the log that will be stored in the database.

    One thing to check is whether the JDK version your IDM runtime uses is compatible with your version of MySQL Connector/J, and whether you can successfully compile and run a small sample program such as this using Connector/J with the same JDK version that the IDM runtime is using.

    Kind regards, Lambert

    Add comment
    10|10000 characters needed characters exceeded

    • Have you applied step 5 of the SAP note you mentioned above, i.e.

      Navigate to Identity Center home ./Service-Scripts and open <dispatcher_name>.prop file. Verify the JDBC driver file or other jar file is now added in section DSECLASSPATH.

      Can you post the content of your <dispatcher_name>.prop file here?

  • Oct 25, 2017 at 06:06 AM

    Arivind

    you can save the mysql jdbc jar file into the "identity center\java" folder, and then restart the dispatcher. You do not need to include the jdbc driver path in the classpath manually.

    Add comment
    10|10000 characters needed characters exceeded