Skip to Content
0

idm 8.0 note 2355326 add jdbc

Oct 23, 2017 at 07:52 PM

77

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Lambert Boskamp Oct 24, 2017 at 07:51 AM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Lambert,

I'm checking the version of jdk, but the the log is bellow, and I could not found what should be

http://www.maxware.com/EMS"> 24.10.2017 09:11:12 DSE.JAR version: 8.0.4.4 Built: 19.01.2017 10:50:47 - 227947 (c) Copyright 2012 SAP AG. All rights reserved. Identity Management JobID:1 Read HR_legacy 8.0.4.5-SQL-2017-01-19 Schema update:1665 jdbc:sqlserver://SERVER:1433;authenticationScheme=nativeAuthentication;xopenStates=false;sendTimeAsDatetime=true;trustServerCertificate=false;sendStringParametersAsUnicode=true;selectMethod=direct;responseBuffering=adaptive;packetSize=8000;multiSubnetFailover=false;loginTimeout=15;lockTimeout=-1;lastUpdateCount=true;encrypt=false;disableStatementPooling=true;databaseName=MXMC_db;applicationName=Microsoft JDBC Driver for SQL Server;applicationIntent=readwrite; IDM_dispatcher E9330413-AFCE-4331-951C-BB172107CA61 C:/usr/sap/IdM/Identity Center/Jobs/E9330413-AFCE-4331-951C-BB172107CA61 Identity Center SAP customer : f9c1c5cd66189d133765ac44ea6c127a 0 2 0 0 Fromsource Database.init got exception connecting to jdbc:mysql://SERVER/System_legacy?user=RFC_USER&password=*********************** java.lang.Throwable: No suitable driver found for jdbc:mysql://SERVER/System_legacy?user=RFC_USER&password=****** Init failed 0 0 0 2 0

0

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?

0
Chenyang Xiong Oct 25, 2017 at 06:06 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded