Hi Team,
I am referring to Saviynt doc to develop the jar.
docs-be.saviyntcloud.com/bundle/EIC-Admin-v23x/page/Content/Resources/Attachments/ConnectionUtlitySe...
I am attaching the Java code that I am using to develop the jar and preprocessor block and CSV file to upload the user in Saviynt.
I am trying using csv file-based import, but no data is updated in Saviynt.
Log Error:
Could you please assist here.
[Merged reply comment]
Hi Team,
I tried with a generated jar for the below Java code but received broken pipe error.
package com.saviynt.utility.tv;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Map;
public class TV {
public void removeAccents(Connection connection, Map<String,String> tempTableNamesMap) throws Exception {
String metaDataQuery="select firstname,lastname,username from "+ tempTableNamesMap.get("NEWUSERDATA");
//String existingUsernames="select username from "+ tempTableNamesMap.get("CURRENTUSERS");
ResultSet rs1;
CallableStatement cstmt=null;
try{
Statement statement=connection.createStatement();
rs1=statement.executeQuery(metaDataQuery);
while(rs1.next()){
String updateQry="UPDATE " + tempTableNamesMap.get("NEWUSERDATA") + " SET lastname = CONCAT(firstname,'-',lastname)";
cstmt=connection.prepareCall(updateQry);
cstmt.execute();
if (!connection.getAutoCommit()) {
connection.commit();
}
}
System.out.println("Preprocessor Logic Ending!");
}
catch (Exception e){
System.out.println("Exception Occurred: "+e);
}
}
}
could you please let me know where I made a mistake?
Thank you
Sandeep
[This message has been edited by moderator to merge reply comment]
Sunil
