com.sunopsis.tools.core.exception.SnpsSimpleMessageException: Exception getOption("TEMP_JAVA_DIR") : Exception getOption("TEMP_JAVA_DIR") : Option does not exist ("TEMP_JAVA_DIR") BSF info: Send_mail at line: 0 column: columnNo out.print("<SunopsisExport><Admin RepositoryVersion=\"04.03.04.02\"/><Object class=\"com.sunopsis.dwg.dbobj.SnpTrt\"><Field name=\"ExtVersion\" type=\"java.lang.String\">null</Field><Field name=\"FirstDate\" type=\"java.sql.Timestamp\">2012-12-20 14:28:40.0</Field><Field name=\"FirstUser\" type=\"java.lang.String\">SUPERVISOR</Field><Field name=\"IndChange\" type=\"java.lang.String\">U</Field><Field name=\"IndJrnMethod\" type=\"java.lang.String\">S</Field><Field name=\"IndSuppSetBased\" type=\"java.lang.String\">null</Field><Field name=\"IntVersion\" type=\"com.sunopsis.sql.DbInt\">7</Field><Field name=\"IFolder\" type=\"com.sunopsis.sql.DbInt\">9091</Field><Field name=\"IProject\" type=\"com.sunopsis.sql.DbInt\">7091</Field><Field name=\"IScBaseTrt\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"IScOrigTrt\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"IScTrt\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"IState\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"ITxtTrtTxt\" type=\"com.sunopsis.sql.DbInt\">3311091</Field><Field name=\"KimMultiDserver\" type=\"java.lang.String\">0</Field><Field name=\"KmDefault\" type=\"java.lang.String\">0</Field><Field name=\"KmSrcTechno\" type=\"java.lang.String\">null</Field><Field name=\"KmTechno\" type=\"java.lang.String\">null</Field><Field name=\"KmVersion\" type=\"java.lang.String\">null</Field><Field name=\"LastDate\" type=\"java.sql.Timestamp\">2012-12-20 14:40:22.0</Field><Field name=\"LastUser\" type=\"java.lang.String\">SUPERVISOR</Field><Field name=\"LChecksum\" type=\"com.sunopsis.sql.DbInt\">2221</Field><Field name=\"LCode\" type=\"java.lang.String\">null</Field><Field name=\"OrdFolder\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"TrtName\" type=\"java.lang.String\">SendGmailTLS</Field><Field name=\"TrtType\" type=\"java.lang.String\">U</Field><Field name=\"VLastDate\" type=\"java.sql.Timestamp\">null</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpTxtHeader\"><Field name=\"Enc\" type=\"java.lang.String\">null</Field><Field name=\"EncKey\" type=\"java.lang.String\">null</Field><Field name=\"ITxt\" type=\"com.sunopsis.sql.DbInt\">3311091</Field><Field name=\"ITxtOrig\" type=\"com.sunopsis.sql.DbInt\">107</Field><Field name=\"SqlIndGrp\" type=\"java.lang.String\">0</Field><Field name=\"Txt\" type=\"java.lang.String\">COMPONENT NAME: SendGmailTLSAUTHOR: Bhabani Ranjan MahapatraEMAIL : bhabaniranjan@gmail.com BLOG : http://dwteam.inDESCRIPTION:This procedure is required to send email using gmail credentials.</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpOrigTxt\"><Field name=\"ITxtOrig\" type=\"com.sunopsis.sql.DbInt\">107</Field><Field name=\"OrigineName\" type=\"java.lang.String\">Edit Command</Field><Field name=\"SnpsCol\" type=\"java.lang.String\">I_TXT_TRT_TXT</Field><Field name=\"SnpsTable\" type=\"java.lang.String\">SNP_TRT</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpUserExit\"><Field name=\"ExtVersion\" type=\"java.lang.String\">null</Field><Field name=\"IndChange\" type=\"java.lang.String\">I</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"ITxtUeHelp\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ITxtValue\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"IUserExit\" type=\"com.sunopsis.sql.DbInt\">756091</Field><Field name=\"Position\" type=\"com.sunopsis.sql.DbInt\">30</Field><Field name=\"ShortValue\" type=\"java.lang.String\">0</Field><Field name=\"UeName\" type=\"java.lang.String\">DELETE_TEMP_FILES</Field><Field name=\"UeSdesc\" type=\"java.lang.String\">Remove temp files</Field><Field name=\"UeType\" type=\"java.lang.String\">C</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpUserExit\"><Field name=\"ExtVersion\" type=\"java.lang.String\">null</Field><Field name=\"IndChange\" type=\"java.lang.String\">I</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"ITxtUeHelp\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ITxtValue\" type=\"com.sunopsis.sql.DbInt\">3312091</Field><Field name=\"IUserExit\" type=\"com.sunopsis.sql.DbInt\">758091</Field><Field name=\"Position\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ShortValue\" type=\"java.lang.String\">null</Field><Field name=\"UeName\" type=\"java.lang.String\">BODY</Field><Field name=\"UeSdesc\" type=\"java.lang.String\">null</Field><Field name=\"UeType\" type=\"java.lang.String\">T</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpTxtHeader\"><Field name=\"Enc\" type=\"java.lang.String\">null</Field><Field name=\"EncKey\" type=\"java.lang.String\">null</Field><Field name=\"ITxt\" type=\"com.sunopsis.sql.DbInt\">3312091</Field><Field name=\"ITxtOrig\" type=\"com.sunopsis.sql.DbInt\">110</Field><Field name=\"SqlIndGrp\" type=\"java.lang.String\">0</Field><Field name=\"Txt\" type=\"java.lang.String\">Its a Mail from ODI Studio.\Thank You</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpOrigTxt\"><Field name=\"ITxtOrig\" type=\"com.sunopsis.sql.DbInt\">110</Field><Field name=\"OrigineName\" type=\"java.lang.String\">Text value</Field><Field name=\"SnpsCol\" type=\"java.lang.String\">I_TXT_VALUE</Field><Field name=\"SnpsTable\" type=\"java.lang.String\">SNP_USER_EXIT</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpUserExit\"><Field name=\"ExtVersion\" type=\"java.lang.String\">null</Field><Field name=\"IndChange\" type=\"java.lang.String\">I</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"ITxtUeHelp\" type=\"com.sunopsis.sql.DbInt\">3313091</Field><Field name=\"ITxtValue\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"IUserExit\" type=\"com.sunopsis.sql.DbInt\">759091</Field><Field name=\"Position\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ShortValue\" type=\"java.lang.String\"><?= java.lang.System.getProperty(\"java.home\").matches(\".*jre\")?java.lang.System.getProperty(\"java.home\")+\"/..\":java.lang.System.getProperty(\"java.home\") ?></Field><Field name=\"UeName\" type=\"java.lang.String\">JAVA_HOME</Field><Field name=\"UeSdesc\" type=\"java.lang.String\">Location of the JDK</Field><Field name=\"UeType\" type=\"java.lang.String\">V</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpTxtHeader\"><Field name=\"Enc\" type=\"java.lang.String\">null</Field><Field name=\"EncKey\" type=\"java.lang.String\">null</Field><Field name=\"ITxt\" type=\"com.sunopsis.sql.DbInt\">3313091</Field><Field name=\"ITxtOrig\" type=\"com.sunopsis.sql.DbInt\">111</Field><Field name=\"SqlIndGrp\" type=\"java.lang.String\">0</Field><Field name=\"Txt\" type=\"java.lang.String\">Examples:\t$ODI_JAVA_HOME on Unix \t%ODI_JAVA_HOME% on Windows\t/usr/lib/jvm/java-7-openjdk-amd64</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpOrigTxt\"><Field name=\"ITxtOrig\" type=\"com.sunopsis.sql.DbInt\">111</Field><Field name=\"OrigineName\" type=\"java.lang.String\">User Exit help</Field><Field name=\"SnpsCol\" type=\"java.lang.String\">I_TXT_UE_HELP</Field><Field name=\"SnpsTable\" type=\"java.lang.String\">SNP_USER_EXIT</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpUserExit\"><Field name=\"ExtVersion\" type=\"java.lang.String\">null</Field><Field name=\"IndChange\" type=\"java.lang.String\">I</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"ITxtUeHelp\" type=\"com.sunopsis.sql.DbInt\">3314091</Field><Field name=\"ITxtValue\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"IUserExit\" type=\"com.sunopsis.sql.DbInt\">765091</Field><Field name=\"Position\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ShortValue\" type=\"java.lang.String\">C:/oracle/product/11.1.1/Oracle_ODI_1/oracledi.sdk/lib/mail.jar</Field><Field name=\"UeName\" type=\"java.lang.String\">JAVA_CP_JAR</Field><Field name=\"UeSdesc\" type=\"java.lang.String\">Provide the jar name with location</Field><Field name=\"UeType\" type=\"java.lang.String\">V</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpTxtHeader\"><Field name=\"Enc\" type=\"java.lang.String\">null</Field><Field name=\"EncKey\" type=\"java.lang.String\">null</Field><Field name=\"ITxt\" type=\"com.sunopsis.sql.DbInt\">3314091</Field><Field name=\"ITxtOrig\" type=\"com.sunopsis.sql.DbInt\">111</Field><Field name=\"SqlIndGrp\" type=\"java.lang.String\">0</Field><Field name=\"Txt\" type=\"java.lang.String\">mail.jar is required for this java file.</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpUserExit\"><Field name=\"ExtVersion\" type=\"java.lang.String\">null</Field><Field name=\"IndChange\" type=\"java.lang.String\">I</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"ITxtUeHelp\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ITxtValue\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"IUserExit\" type=\"com.sunopsis.sql.DbInt\">761091</Field><Field name=\"Position\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ShortValue\" type=\"java.lang.String\"> admin@odistudio.com </Field><Field name=\"UeName\" type=\"java.lang.String\">FROM</Field><Field name=\"UeSdesc\" type=\"java.lang.String\">FROM</Field><Field name=\"UeType\" type=\"java.lang.String\">V</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpUserExit\"><Field name=\"ExtVersion\" type=\"java.lang.String\">null</Field><Field name=\"IndChange\" type=\"java.lang.String\">I</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"ITxtUeHelp\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ITxtValue\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"IUserExit\" type=\"com.sunopsis.sql.DbInt\">762091</Field><Field name=\"Position\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ShortValue\" type=\"java.lang.String\">Mail From ODI</Field><Field name=\"UeName\" type=\"java.lang.String\">SUBJECT</Field><Field name=\"UeSdesc\" type=\"java.lang.String\">Subject</Field><Field name=\"UeType\" type=\"java.lang.String\">V</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpUserExit\"><Field name=\"ExtVersion\" type=\"java.lang.String\">null</Field><Field name=\"IndChange\" type=\"java.lang.String\">I</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"ITxtUeHelp\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ITxtValue\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"IUserExit\" type=\"com.sunopsis.sql.DbInt\">763091</Field><Field name=\"Position\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ShortValue\" type=\"java.lang.String\">C:/Users/Public</Field><Field name=\"UeName\" type=\"java.lang.String\">TEMP_JAVA_DIR</Field><Field name=\"UeSdesc\" type=\"java.lang.String\">Temp Java File Location</Field><Field name=\"UeType\" type=\"java.lang.String\">V</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpUserExit\"><Field name=\"ExtVersion\" type=\"java.lang.String\">null</Field><Field name=\"IndChange\" type=\"java.lang.String\">U</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"ITxtUeHelp\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ITxtValue\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"IUserExit\" type=\"com.sunopsis.sql.DbInt\">764091</Field><Field name=\"Position\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ShortValue\" type=\"java.lang.String\">null</Field><Field name=\"UeName\" type=\"java.lang.String\">USERNAME</Field><Field name=\"UeSdesc\" type=\"java.lang.String\">null</Field><Field name=\"UeType\" type=\"java.lang.String\">T</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpUserExit\"><Field name=\"ExtVersion\" type=\"java.lang.String\">null</Field><Field name=\"IndChange\" type=\"java.lang.String\">U</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"ITxtUeHelp\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ITxtValue\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"IUserExit\" type=\"com.sunopsis.sql.DbInt\">757091</Field><Field name=\"Position\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ShortValue\" type=\"java.lang.String\">null</Field><Field name=\"UeName\" type=\"java.lang.String\">PASSWORD</Field><Field name=\"UeSdesc\" type=\"java.lang.String\">null</Field><Field name=\"UeType\" type=\"java.lang.String\">T</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpUserExit\"><Field name=\"ExtVersion\" type=\"java.lang.String\">null</Field><Field name=\"IndChange\" type=\"java.lang.String\">I</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"ITxtUeHelp\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ITxtValue\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"IUserExit\" type=\"com.sunopsis.sql.DbInt\">760091</Field><Field name=\"Position\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ShortValue\" type=\"java.lang.String\"> bhabaniranjan@gmail.com </Field><Field name=\"UeName\" type=\"java.lang.String\">TO</Field><Field name=\"UeSdesc\" type=\"java.lang.String\">Target User ID</Field><Field name=\"UeType\" type=\"java.lang.String\">V</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpLineTrt\"><Field name=\"AlwaysExe\" type=\"java.lang.String\">0</Field><Field name=\"ColConnectId\" type=\"java.lang.String\">null</Field><Field name=\"ColContextCode\" type=\"java.lang.String\">null</Field><Field name=\"ColIndCommit\" type=\"java.lang.String\">null</Field><Field name=\"ColIsolLevel\" type=\"java.lang.String\">null</Field><Field name=\"ColITxt\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ColLschemaName\" type=\"java.lang.String\">null</Field><Field name=\"ColPlanComp\" type=\"java.lang.String\">null</Field><Field name=\"ColTechno\" type=\"java.lang.String\">null</Field><Field name=\"DefConnectId\" type=\"java.lang.String\">null</Field><Field name=\"DefContextCode\" type=\"java.lang.String\">null</Field><Field name=\"DefIndCommit\" type=\"java.lang.String\">null</Field><Field name=\"DefIsolLevel\" type=\"java.lang.String\">null</Field><Field name=\"DefITxt\" type=\"com.sunopsis.sql.DbInt\">3315091</Field><Field name=\"DefLschemaName\" type=\"java.lang.String\">null</Field><Field name=\"DefPlanComp\" type=\"java.lang.String\">null</Field><Field name=\"DefTechno\" type=\"java.lang.String\">SUNOPSIS_API</Field><Field name=\"FirstDate\" type=\"java.sql.Timestamp\">2012-12-20 14:28:40.0</Field><Field name=\"FirstUser\" type=\"java.lang.String\">SUPERVISOR</Field><Field name=\"IndErr\" type=\"java.lang.String\">0</Field><Field name=\"IndLogFinalCmd\" type=\"java.lang.String\">0</Field><Field name=\"IndLogMethod\" type=\"java.lang.String\">null</Field><Field name=\"IndLogNb\" type=\"java.lang.String\">null</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"KcmAk\" type=\"java.lang.String\">0</Field><Field name=\"KcmCond\" type=\"java.lang.String\">0</Field><Field name=\"KcmErrDel\" type=\"java.lang.String\">0</Field><Field name=\"KcmJoin\" type=\"java.lang.String\">0</Field><Field name=\"KcmNull\" type=\"java.lang.String\">0</Field><Field name=\"KcmPk\" type=\"java.lang.String\">0</Field><Field name=\"KimDrvdSel\" type=\"java.lang.String\">0</Field><Field name=\"KimIdx\" type=\"java.lang.String\">0</Field><Field name=\"KimJrn\" type=\"java.lang.String\">0</Field><Field name=\"KimJrnPop\" type=\"java.lang.String\">0</Field><Field name=\"KjmCreate\" type=\"java.lang.String\">0</Field><Field name=\"KjmDrop\" type=\"java.lang.String\">0</Field><Field name=\"KjmExtend\" type=\"java.lang.String\">0</Field><Field name=\"KjmLock\" type=\"java.lang.String\">0</Field><Field name=\"KjmPurge\" type=\"java.lang.String\">0</Field><Field name=\"KjmSetInstall\" type=\"java.lang.String\">0</Field><Field name=\"KjmSetUninstall\" type=\"java.lang.String\">0</Field><Field name=\"KjmSubscribe\" type=\"java.lang.String\">0</Field><Field name=\"KjmTableOrder\" type=\"java.lang.String\">0</Field><Field name=\"KjmUnlock\" type=\"java.lang.String\">0</Field><Field name=\"KjmUnsubscribe\" type=\"java.lang.String\">0</Field><Field name=\"KlmAfterInt\" type=\"java.lang.String\">0</Field><Field name=\"KlmIdx\" type=\"java.lang.String\">0</Field><Field name=\"KlmJrn\" type=\"java.lang.String\">0</Field><Field name=\"KxmUsed\" type=\"java.lang.String\">null</Field><Field name=\"LastDate\" type=\"java.sql.Timestamp\">2012-12-20 14:38:47.0</Field><Field name=\"LastUser\" type=\"java.lang.String\">SUPERVISOR</Field><Field name=\"LogLevDet\" type=\"java.lang.String\">3</Field><Field name=\"OrdTrt\" type=\"com.sunopsis.sql.DbInt\">30</Field><Field name=\"SqlName\" type=\"java.lang.String\">Delete temporary files</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpTxtHeader\"><Field name=\"Enc\" type=\"java.lang.String\">null</Field><Field name=\"EncKey\" type=\"java.lang.String\">null</Field><Field name=\"ITxt\" type=\"com.sunopsis.sql.DbInt\">3315091</Field><Field name=\"ITxtOrig\" type=\"com.sunopsis.sql.DbInt\">102</Field><Field name=\"SqlIndGrp\" type=\"java.lang.String\">0</Field><Field name=\"Txt\" type=\"java.lang.String\">OdiFileDelete \"-FILE=") ; out.print(odiRef.getOption("TEMP_JAVA_DIR")) ; out.print("/SendMailTLS*\"</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpOrigTxt\"><Field name=\"ITxtOrig\" type=\"com.sunopsis.sql.DbInt\">102</Field><Field name=\"OrigineName\" type=\"java.lang.String\">Target Technology</Field><Field name=\"SnpsCol\" type=\"java.lang.String\">DEF_I_TXT</Field><Field name=\"SnpsTable\" type=\"java.lang.String\">SNP_LINE_TRT</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpLineTrt\"><Field name=\"AlwaysExe\" type=\"java.lang.String\">1</Field><Field name=\"ColConnectId\" type=\"java.lang.String\">null</Field><Field name=\"ColContextCode\" type=\"java.lang.String\">null</Field><Field name=\"ColIndCommit\" type=\"java.lang.String\">null</Field><Field name=\"ColIsolLevel\" type=\"java.lang.String\">null</Field><Field name=\"ColITxt\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ColLschemaName\" type=\"java.lang.String\">null</Field><Field name=\"ColPlanComp\" type=\"java.lang.String\">null</Field><Field name=\"ColTechno\" type=\"java.lang.String\">null</Field><Field name=\"DefConnectId\" type=\"java.lang.String\">null</Field><Field name=\"DefContextCode\" type=\"java.lang.String\">null</Field><Field name=\"DefIndCommit\" type=\"java.lang.String\">null</Field><Field name=\"DefIsolLevel\" type=\"java.lang.String\">null</Field><Field name=\"DefITxt\" type=\"com.sunopsis.sql.DbInt\">3316091</Field><Field name=\"DefLschemaName\" type=\"java.lang.String\">null</Field><Field name=\"DefPlanComp\" type=\"java.lang.String\">null</Field><Field name=\"DefTechno\" type=\"java.lang.String\">SUNOPSIS_API</Field><Field name=\"FirstDate\" type=\"java.sql.Timestamp\">2012-12-20 14:28:40.0</Field><Field name=\"FirstUser\" type=\"java.lang.String\">SUPERVISOR</Field><Field name=\"IndErr\" type=\"java.lang.String\">0</Field><Field name=\"IndLogFinalCmd\" type=\"java.lang.String\">0</Field><Field name=\"IndLogMethod\" type=\"java.lang.String\">null</Field><Field name=\"IndLogNb\" type=\"java.lang.String\">null</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"KcmAk\" type=\"java.lang.String\">0</Field><Field name=\"KcmCond\" type=\"java.lang.String\">0</Field><Field name=\"KcmErrDel\" type=\"java.lang.String\">0</Field><Field name=\"KcmJoin\" type=\"java.lang.String\">0</Field><Field name=\"KcmNull\" type=\"java.lang.String\">0</Field><Field name=\"KcmPk\" type=\"java.lang.String\">0</Field><Field name=\"KimDrvdSel\" type=\"java.lang.String\">0</Field><Field name=\"KimIdx\" type=\"java.lang.String\">0</Field><Field name=\"KimJrn\" type=\"java.lang.String\">0</Field><Field name=\"KimJrnPop\" type=\"java.lang.String\">0</Field><Field name=\"KjmCreate\" type=\"java.lang.String\">0</Field><Field name=\"KjmDrop\" type=\"java.lang.String\">0</Field><Field name=\"KjmExtend\" type=\"java.lang.String\">0</Field><Field name=\"KjmLock\" type=\"java.lang.String\">0</Field><Field name=\"KjmPurge\" type=\"java.lang.String\">0</Field><Field name=\"KjmSetInstall\" type=\"java.lang.String\">0</Field><Field name=\"KjmSetUninstall\" type=\"java.lang.String\">0</Field><Field name=\"KjmSubscribe\" type=\"java.lang.String\">0</Field><Field name=\"KjmTableOrder\" type=\"java.lang.String\">0</Field><Field name=\"KjmUnlock\" type=\"java.lang.String\">0</Field><Field name=\"KjmUnsubscribe\" type=\"java.lang.String\">0</Field><Field name=\"KlmAfterInt\" type=\"java.lang.String\">0</Field><Field name=\"KlmIdx\" type=\"java.lang.String\">0</Field><Field name=\"KlmJrn\" type=\"java.lang.String\">0</Field><Field name=\"KxmUsed\" type=\"java.lang.String\">null</Field><Field name=\"LastDate\" type=\"java.sql.Timestamp\">2012-12-20 14:38:47.0</Field><Field name=\"LastUser\" type=\"java.lang.String\">SUPERVISOR</Field><Field name=\"LogLevDet\" type=\"java.lang.String\">3</Field><Field name=\"OrdTrt\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"SqlName\" type=\"java.lang.String\">Create Java File</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpTxtHeader\"><Field name=\"Enc\" type=\"java.lang.String\">null</Field><Field name=\"EncKey\" type=\"java.lang.String\">null</Field><Field name=\"ITxt\" type=\"com.sunopsis.sql.DbInt\">3316091</Field><Field name=\"ITxtOrig\" type=\"com.sunopsis.sql.DbInt\">102</Field><Field name=\"SqlIndGrp\" type=\"java.lang.String\">2</Field><Field name=\"Txt\" type=\"java.lang.String\">OdiOutFile \"-FILE=") ; out.print(odiRef.getOption("TEMP_JAVA_DIR")) ; out.print("/SendMailTLS.java\"import java.util.Properties;import javax.mail.Message;import javax.mail.MessagingException;import javax.mail.PasswordAuthentication;import javax.mail.Session;import javax.mail.Transport;import javax.mail.internet.InternetAddress;import javax.mail.internet.MimeMessage; public class SendMailTLS {\tpublic static void main(String[] args) {\t\tfinal String username = \"") ; out.print(odiRef.getOption("USERNAME")) ; out.print("\";\t\tfinal String password = \"") ; out.print(odiRef.getOption("PASSWORD")) ; out.print("\";\t\tProperties props = new Properties();\t\tprops.put(\"mail.smtp.auth\", \"true\");\t\tprops.put(\"mail.smtp.starttls.enable\", \"true\");\t\tprops.put(\"mail.smtp.host\", \"smtp.gmail.com\");\t\tprops.put(\"mail.smtp.port\", \"587\");props.put(\u201cmail.smtp.socketFactory.port\u201d, \u201c587\u2033);props.put(\u201cmail.smtp.socketFactory.class\u201d,\u201djavax.net.tls.TLSSocketFactory\u201d); \t\tSession session = Session.getInstance(props,\t\t new javax.mail.Authenticator() {\t\t\tprotected PasswordAuthentication getPasswordAuthentication() {\t\t\t\treturn new PasswordAuthentication(username, password);\t\t\t}\t\t }); \t\ttry { \t\t\tMessage message = new MimeMessage(session);\t\t\tmessage.setFrom(new InternetAddress(\"") ; out.print(odiRef.getOption("FROM")) ; out.print("\"));\t\t\tmessage.setRecipients(Message.RecipientType.TO,\t\t\t\t\tInternetAddress.parse(\"") ; out.print(odiRef.getOption("TO")) ; out.print("\"));\t\t\tmessage.setSubject(\"") ; out.print(odiRef.getOption("SUBJECT")) ; out.print("\");\t\t\tmessage.setText(\"") ; out.print(odiRef.getOption("BODY")) ; out.print("\"); \t\t\tTransport.send(message); \t\t\tSystem.out.println(\"Done\"); \t\t} catch (MessagingException e) {\t\t\tthrow new RuntimeException(e);\t\t}\t}}</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpLineTrt\"><Field name=\"AlwaysExe\" type=\"java.lang.String\">1</Field><Field name=\"ColConnectId\" type=\"java.lang.String\">null</Field><Field name=\"ColContextCode\" type=\"java.lang.String\">null</Field><Field name=\"ColIndCommit\" type=\"java.lang.String\">null</Field><Field name=\"ColIsolLevel\" type=\"java.lang.String\">null</Field><Field name=\"ColITxt\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ColLschemaName\" type=\"java.lang.String\">null</Field><Field name=\"ColPlanComp\" type=\"java.lang.String\">null</Field><Field name=\"ColTechno\" type=\"java.lang.String\">FILE</Field><Field name=\"DefConnectId\" type=\"java.lang.String\">null</Field><Field name=\"DefContextCode\" type=\"java.lang.String\">null</Field><Field name=\"DefIndCommit\" type=\"java.lang.String\">null</Field><Field name=\"DefIsolLevel\" type=\"java.lang.String\">null</Field><Field name=\"DefITxt\" type=\"com.sunopsis.sql.DbInt\">3317091</Field><Field name=\"DefLschemaName\" type=\"java.lang.String\">null</Field><Field name=\"DefPlanComp\" type=\"java.lang.String\">null</Field><Field name=\"DefTechno\" type=\"java.lang.String\">SUNOPSIS_API</Field><Field name=\"FirstDate\" type=\"java.sql.Timestamp\">2012-12-20 14:28:40.0</Field><Field name=\"FirstUser\" type=\"java.lang.String\">SUPERVISOR</Field><Field name=\"IndErr\" type=\"java.lang.String\">0</Field><Field name=\"IndLogFinalCmd\" type=\"java.lang.String\">0</Field><Field name=\"IndLogMethod\" type=\"java.lang.String\">null</Field><Field name=\"IndLogNb\" type=\"java.lang.String\">null</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"KcmAk\" type=\"java.lang.String\">0</Field><Field name=\"KcmCond\" type=\"java.lang.String\">0</Field><Field name=\"KcmErrDel\" type=\"java.lang.String\">0</Field><Field name=\"KcmJoin\" type=\"java.lang.String\">0</Field><Field name=\"KcmNull\" type=\"java.lang.String\">0</Field><Field name=\"KcmPk\" type=\"java.lang.String\">0</Field><Field name=\"KimDrvdSel\" type=\"java.lang.String\">0</Field><Field name=\"KimIdx\" type=\"java.lang.String\">0</Field><Field name=\"KimJrn\" type=\"java.lang.String\">0</Field><Field name=\"KimJrnPop\" type=\"java.lang.String\">0</Field><Field name=\"KjmCreate\" type=\"java.lang.String\">0</Field><Field name=\"KjmDrop\" type=\"java.lang.String\">0</Field><Field name=\"KjmExtend\" type=\"java.lang.String\">0</Field><Field name=\"KjmLock\" type=\"java.lang.String\">0</Field><Field name=\"KjmPurge\" type=\"java.lang.String\">0</Field><Field name=\"KjmSetInstall\" type=\"java.lang.String\">0</Field><Field name=\"KjmSetUninstall\" type=\"java.lang.String\">0</Field><Field name=\"KjmSubscribe\" type=\"java.lang.String\">0</Field><Field name=\"KjmTableOrder\" type=\"java.lang.String\">0</Field><Field name=\"KjmUnlock\" type=\"java.lang.String\">0</Field><Field name=\"KjmUnsubscribe\" type=\"java.lang.String\">0</Field><Field name=\"KlmAfterInt\" type=\"java.lang.String\">0</Field><Field name=\"KlmIdx\" type=\"java.lang.String\">0</Field><Field name=\"KlmJrn\" type=\"java.lang.String\">0</Field><Field name=\"KxmUsed\" type=\"java.lang.String\">null</Field><Field name=\"LastDate\" type=\"java.sql.Timestamp\">2012-12-20 14:38:47.0</Field><Field name=\"LastUser\" type=\"java.lang.String\">SUPERVISOR</Field><Field name=\"LogLevDet\" type=\"java.lang.String\">3</Field><Field name=\"OrdTrt\" type=\"com.sunopsis.sql.DbInt\">10</Field><Field name=\"SqlName\" type=\"java.lang.String\">Complie The java file</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpTxtHeader\"><Field name=\"Enc\" type=\"java.lang.String\">null</Field><Field name=\"EncKey\" type=\"java.lang.String\">null</Field><Field name=\"ITxt\" type=\"com.sunopsis.sql.DbInt\">3317091</Field><Field name=\"ITxtOrig\" type=\"com.sunopsis.sql.DbInt\">102</Field><Field name=\"SqlIndGrp\" type=\"java.lang.String\">0</Field><Field name=\"Txt\" type=\"java.lang.String\">OdiOSCommand \"-COMMAND=") ; out.print( odiRef.getOption("JAVA_HOME") ) ; out.print("/bin/javac -cp ") ; out.print(odiRef.getOption("JAVA_CP_JAR")) ; out.print(" ") ; out.print(odiRef.getOption("TEMP_JAVA_DIR")) ; out.print("/SendMailTLS.java\" \"-ERR_FILE=") ; out.print(odiRef.getOption("TEMP_JAVA_DIR")) ; out.print("/SendMailTLS_err.txt\" \"-OUT_FILE=") ; out.print(odiRef.getOption("TEMP_JAVA_DIR")) ; out.print("/SendMailTLS_out.txt\"</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpLineTrt\"><Field name=\"AlwaysExe\" type=\"java.lang.String\">1</Field><Field name=\"ColConnectId\" type=\"java.lang.String\">null</Field><Field name=\"ColContextCode\" type=\"java.lang.String\">null</Field><Field name=\"ColIndCommit\" type=\"java.lang.String\">null</Field><Field name=\"ColIsolLevel\" type=\"java.lang.String\">null</Field><Field name=\"ColITxt\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ColLschemaName\" type=\"java.lang.String\">null</Field><Field name=\"ColPlanComp\" type=\"java.lang.String\">null</Field><Field name=\"ColTechno\" type=\"java.lang.String\">FILE</Field><Field name=\"DefConnectId\" type=\"java.lang.String\">null</Field><Field name=\"DefContextCode\" type=\"java.lang.String\">null</Field><Field name=\"DefIndCommit\" type=\"java.lang.String\">null</Field><Field name=\"DefIsolLevel\" type=\"java.lang.String\">null</Field><Field name=\"DefITxt\" type=\"com.sunopsis.sql.DbInt\">3318091</Field><Field name=\"DefLschemaName\" type=\"java.lang.String\">null</Field><Field name=\"DefPlanComp\" type=\"java.lang.String\">null</Field><Field name=\"DefTechno\" type=\"java.lang.String\">SUNOPSIS_API</Field><Field name=\"FirstDate\" type=\"java.sql.Timestamp\">2012-12-20 14:28:40.0</Field><Field name=\"FirstUser\" type=\"java.lang.String\">SUPERVISOR</Field><Field name=\"IndErr\" type=\"java.lang.String\">0</Field><Field name=\"IndLogFinalCmd\" type=\"java.lang.String\">0</Field><Field name=\"IndLogMethod\" type=\"java.lang.String\">null</Field><Field name=\"IndLogNb\" type=\"java.lang.String\">null</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"KcmAk\" type=\"java.lang.String\">0</Field><Field name=\"KcmCond\" type=\"java.lang.String\">0</Field><Field name=\"KcmErrDel\" type=\"java.lang.String\">0</Field><Field name=\"KcmJoin\" type=\"java.lang.String\">0</Field><Field name=\"KcmNull\" type=\"java.lang.String\">0</Field><Field name=\"KcmPk\" type=\"java.lang.String\">0</Field><Field name=\"KimDrvdSel\" type=\"java.lang.String\">0</Field><Field name=\"KimIdx\" type=\"java.lang.String\">0</Field><Field name=\"KimJrn\" type=\"java.lang.String\">0</Field><Field name=\"KimJrnPop\" type=\"java.lang.String\">0</Field><Field name=\"KjmCreate\" type=\"java.lang.String\">0</Field><Field name=\"KjmDrop\" type=\"java.lang.String\">0</Field><Field name=\"KjmExtend\" type=\"java.lang.String\">0</Field><Field name=\"KjmLock\" type=\"java.lang.String\">0</Field><Field name=\"KjmPurge\" type=\"java.lang.String\">0</Field><Field name=\"KjmSetInstall\" type=\"java.lang.String\">0</Field><Field name=\"KjmSetUninstall\" type=\"java.lang.String\">0</Field><Field name=\"KjmSubscribe\" type=\"java.lang.String\">0</Field><Field name=\"KjmTableOrder\" type=\"java.lang.String\">0</Field><Field name=\"KjmUnlock\" type=\"java.lang.String\">0</Field><Field name=\"KjmUnsubscribe\" type=\"java.lang.String\">0</Field><Field name=\"KlmAfterInt\" type=\"java.lang.String\">0</Field><Field name=\"KlmIdx\" type=\"java.lang.String\">0</Field><Field name=\"KlmJrn\" type=\"java.lang.String\">0</Field><Field name=\"KxmUsed\" type=\"java.lang.String\">null</Field><Field name=\"LastDate\" type=\"java.sql.Timestamp\">2012-12-20 14:38:47.0</Field><Field name=\"LastUser\" type=\"java.lang.String\">SUPERVISOR</Field><Field name=\"LogLevDet\" type=\"java.lang.String\">3</Field><Field name=\"OrdTrt\" type=\"com.sunopsis.sql.DbInt\">20</Field><Field name=\"SqlName\" type=\"java.lang.String\">Run the java file</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpTxtHeader\"><Field name=\"Enc\" type=\"java.lang.String\">null</Field><Field name=\"EncKey\" type=\"java.lang.String\">null</Field><Field name=\"ITxt\" type=\"com.sunopsis.sql.DbInt\">3318091</Field><Field name=\"ITxtOrig\" type=\"com.sunopsis.sql.DbInt\">102</Field><Field name=\"SqlIndGrp\" type=\"java.lang.String\">0</Field><Field name=\"Txt\" type=\"java.lang.String\">OdiOSCommand \"-COMMAND=") ; out.print( odiRef.getOption("JAVA_HOME") ) ; out.print("/bin/java -cp ") ; out.print(odiRef.getOption("JAVA_CP_JAR")) ; out.print(";") ; out.print(odiRef.getOption("TEMP_JAVA_DIR")) ; out.print(" SendMailTLS\" \"-ERR_FILE=") ; out.print(odiRef.getOption("TEMP_JAVA_DIR")) ; out.print("/SendMailTLS_err.txt\" \"-OUT_FILE=") ; out.print(odiRef.getOption("TEMP_JAVA_DIR")) ; out.print("/SendMailTLS_out.txt\"</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpLineTrtUe\"><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"IUserExit\" type=\"com.sunopsis.sql.DbInt\">756091</Field><Field name=\"OrdTrt\" type=\"com.sunopsis.sql.DbInt\">30</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpImportRep\"><Field name=\"RepShortId\" type=\"com.sunopsis.sql.DbInt\">91</Field><Field name=\"RepTimestamp\" type=\"java.lang.String\">1334831213366</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpImportRep\"><Field name=\"RepShortId\" type=\"com.sunopsis.sql.DbInt\">92</Field><Field name=\"RepTimestamp\" type=\"java.lang.String\">1343117459745</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpImportRep\"><Field name=\"RepShortId\" type=\"com.sunopsis.sql.DbInt\">81</Field><Field name=\"RepTimestamp\" type=\"java.lang.String\">1334307846215</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpImportRep\"><Field name=\"RepShortId\" type=\"com.sunopsis.sql.DbInt\">3</Field><Field name=\"RepTimestamp\" type=\"java.lang.String\">1321309358956</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpImportRep\"><Field name=\"RepShortId\" type=\"com.sunopsis.sql.DbInt\">2</Field><Field name=\"RepTimestamp\" type=\"java.lang.String\">1277905827008</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpImportRep\"><Field name=\"RepShortId\" type=\"com.sunopsis.sql.DbInt\">11</Field><Field name=\"RepTimestamp\" type=\"java.lang.String\">1322240471835</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpImportRep\"><Field name=\"RepShortId\" type=\"com.sunopsis.sql.DbInt\">12</Field><Field name=\"RepTimestamp\" type=\"java.lang.String\">1330677667361</Field></Object><Object class=\"com.sunopsis.dwg.DwgExportSummary\"><Field name=\"ExpTxtNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"InstObjNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"JoinColNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"JoinNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"KeyColNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"KeyNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"LinkDiagNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"MorigTxtNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"MtxtNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"OrigTxtNb\" type=\"com.sunopsis.sql.DbInt\">4</Field><Field name=\"OtherObjectsNb\" type=\"com.sunopsis.sql.DbInt\">16</Field><Field name=\"PlanAgentNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"StepNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"TxtNb\" type=\"com.sunopsis.sql.DbInt\">8</Field><Field name=\"UeOrigNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"UeUsedNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"VarPlanAgentNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"ScenTxtNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"OdiVersion\" type=\"java.lang.String\">11.1.1.6.0 - 19/12/2011</Field><Field name=\"OriginRepositoryID\" type=\"com.sunopsis.sql.DbInt\">91</Field><Field name=\"RepositoryVersion\" type=\"java.lang.String\">04.03.04.02</Field></Object></SunopsisExport>") ; ****** ORIGINAL TEXT ****** <SunopsisExport><Admin RepositoryVersion="04.03.04.02"/><Object class="com.sunopsis.dwg.dbobj.SnpTrt"><Field name="ExtVersion" type="java.lang.String">null</Field><Field name="FirstDate" type="java.sql.Timestamp">2012-12-20 14:28:40.0</Field><Field name="FirstUser" type="java.lang.String">SUPERVISOR</Field><Field name="IndChange" type="java.lang.String">U</Field><Field name="IndJrnMethod" type="java.lang.String">S</Field><Field name="IndSuppSetBased" type="java.lang.String">null</Field><Field name="IntVersion" type="com.sunopsis.sql.DbInt">7</Field><Field name="IFolder" type="com.sunopsis.sql.DbInt">9091</Field><Field name="IProject" type="com.sunopsis.sql.DbInt">7091</Field><Field name="IScBaseTrt" type="com.sunopsis.sql.DbInt">null</Field><Field name="IScOrigTrt" type="com.sunopsis.sql.DbInt">null</Field><Field name="IScTrt" type="com.sunopsis.sql.DbInt">null</Field><Field name="IState" type="com.sunopsis.sql.DbInt">null</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="ITxtTrtTxt" type="com.sunopsis.sql.DbInt">3311091</Field><Field name="KimMultiDserver" type="java.lang.String">0</Field><Field name="KmDefault" type="java.lang.String">0</Field><Field name="KmSrcTechno" type="java.lang.String">null</Field><Field name="KmTechno" type="java.lang.String">null</Field><Field name="KmVersion" type="java.lang.String">null</Field><Field name="LastDate" type="java.sql.Timestamp">2012-12-20 14:40:22.0</Field><Field name="LastUser" type="java.lang.String">SUPERVISOR</Field><Field name="LChecksum" type="com.sunopsis.sql.DbInt">2221</Field><Field name="LCode" type="java.lang.String">null</Field><Field name="OrdFolder" type="com.sunopsis.sql.DbInt">null</Field><Field name="TrtName" type="java.lang.String">SendGmailTLS</Field><Field name="TrtType" type="java.lang.String">U</Field><Field name="VLastDate" type="java.sql.Timestamp">null</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpTxtHeader"><Field name="Enc" type="java.lang.String">null</Field><Field name="EncKey" type="java.lang.String">null</Field><Field name="ITxt" type="com.sunopsis.sql.DbInt">3311091</Field><Field name="ITxtOrig" type="com.sunopsis.sql.DbInt">107</Field><Field name="SqlIndGrp" type="java.lang.String">0</Field><Field name="Txt" type="java.lang.String">COMPONENT NAME: SendGmailTLS AUTHOR: Bhabani Ranjan Mahapatra EMAIL : bhabaniranjan@gmail.com BLOG : http://dwteam.in DESCRIPTION: This procedure is required to send email using gmail credentials.</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpOrigTxt"><Field name="ITxtOrig" type="com.sunopsis.sql.DbInt">107</Field><Field name="OrigineName" type="java.lang.String">Edit Command</Field><Field name="SnpsCol" type="java.lang.String">I_TXT_TRT_TXT</Field><Field name="SnpsTable" type="java.lang.String">SNP_TRT</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpUserExit"><Field name="ExtVersion" type="java.lang.String">null</Field><Field name="IndChange" type="java.lang.String">I</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="ITxtUeHelp" type="com.sunopsis.sql.DbInt">null</Field><Field name="ITxtValue" type="com.sunopsis.sql.DbInt">null</Field><Field name="IUserExit" type="com.sunopsis.sql.DbInt">756091</Field><Field name="Position" type="com.sunopsis.sql.DbInt">30</Field><Field name="ShortValue" type="java.lang.String">0</Field><Field name="UeName" type="java.lang.String">DELETE_TEMP_FILES</Field><Field name="UeSdesc" type="java.lang.String">Remove temp files</Field><Field name="UeType" type="java.lang.String">C</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpUserExit"><Field name="ExtVersion" type="java.lang.String">null</Field><Field name="IndChange" type="java.lang.String">I</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="ITxtUeHelp" type="com.sunopsis.sql.DbInt">null</Field><Field name="ITxtValue" type="com.sunopsis.sql.DbInt">3312091</Field><Field name="IUserExit" type="com.sunopsis.sql.DbInt">758091</Field><Field name="Position" type="com.sunopsis.sql.DbInt">null</Field><Field name="ShortValue" type="java.lang.String">null</Field><Field name="UeName" type="java.lang.String">BODY</Field><Field name="UeSdesc" type="java.lang.String">null</Field><Field name="UeType" type="java.lang.String">T</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpTxtHeader"><Field name="Enc" type="java.lang.String">null</Field><Field name="EncKey" type="java.lang.String">null</Field><Field name="ITxt" type="com.sunopsis.sql.DbInt">3312091</Field><Field name="ITxtOrig" type="com.sunopsis.sql.DbInt">110</Field><Field name="SqlIndGrp" type="java.lang.String">0</Field><Field name="Txt" type="java.lang.String">Its a Mail from ODI Studio.Thank You</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpOrigTxt"><Field name="ITxtOrig" type="com.sunopsis.sql.DbInt">110</Field><Field name="OrigineName" type="java.lang.String">Text value</Field><Field name="SnpsCol" type="java.lang.String">I_TXT_VALUE</Field><Field name="SnpsTable" type="java.lang.String">SNP_USER_EXIT</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpUserExit"><Field name="ExtVersion" type="java.lang.String">null</Field><Field name="IndChange" type="java.lang.String">I</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="ITxtUeHelp" type="com.sunopsis.sql.DbInt">3313091</Field><Field name="ITxtValue" type="com.sunopsis.sql.DbInt">null</Field><Field name="IUserExit" type="com.sunopsis.sql.DbInt">759091</Field><Field name="Position" type="com.sunopsis.sql.DbInt">null</Field><Field name="ShortValue" type="java.lang.String"><?= java.lang.System.getProperty("java.home").matches(".*jre")?java.lang.System.getProperty("java.home")+"/..":java.lang.System.getProperty("java.home") ?></Field><Field name="UeName" type="java.lang.String">JAVA_HOME</Field><Field name="UeSdesc" type="java.lang.String">Location of the JDK</Field><Field name="UeType" type="java.lang.String">V</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpTxtHeader"><Field name="Enc" type="java.lang.String">null</Field><Field name="EncKey" type="java.lang.String">null</Field><Field name="ITxt" type="com.sunopsis.sql.DbInt">3313091</Field><Field name="ITxtOrig" type="com.sunopsis.sql.DbInt">111</Field><Field name="SqlIndGrp" type="java.lang.String">0</Field><Field name="Txt" type="java.lang.String"> Examples: $ODI_JAVA_HOME on Unix %ODI_JAVA_HOME% on Windows /usr/lib/jvm/java-7-openjdk-amd64</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpOrigTxt"><Field name="ITxtOrig" type="com.sunopsis.sql.DbInt">111</Field><Field name="OrigineName" type="java.lang.String">User Exit help</Field><Field name="SnpsCol" type="java.lang.String">I_TXT_UE_HELP</Field><Field name="SnpsTable" type="java.lang.String">SNP_USER_EXIT</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpUserExit"><Field name="ExtVersion" type="java.lang.String">null</Field><Field name="IndChange" type="java.lang.String">I</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="ITxtUeHelp" type="com.sunopsis.sql.DbInt">3314091</Field><Field name="ITxtValue" type="com.sunopsis.sql.DbInt">null</Field><Field name="IUserExit" type="com.sunopsis.sql.DbInt">765091</Field><Field name="Position" type="com.sunopsis.sql.DbInt">null</Field><Field name="ShortValue" type="java.lang.String">C:/oracle/product/11.1.1/Oracle_ODI_1/oracledi.sdk/lib/mail.jar</Field><Field name="UeName" type="java.lang.String">JAVA_CP_JAR</Field><Field name="UeSdesc" type="java.lang.String">Provide the jar name with location</Field><Field name="UeType" type="java.lang.String">V</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpTxtHeader"><Field name="Enc" type="java.lang.String">null</Field><Field name="EncKey" type="java.lang.String">null</Field><Field name="ITxt" type="com.sunopsis.sql.DbInt">3314091</Field><Field name="ITxtOrig" type="com.sunopsis.sql.DbInt">111</Field><Field name="SqlIndGrp" type="java.lang.String">0</Field><Field name="Txt" type="java.lang.String">mail.jar is required for this java file.</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpUserExit"><Field name="ExtVersion" type="java.lang.String">null</Field><Field name="IndChange" type="java.lang.String">I</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="ITxtUeHelp" type="com.sunopsis.sql.DbInt">null</Field><Field name="ITxtValue" type="com.sunopsis.sql.DbInt">null</Field><Field name="IUserExit" type="com.sunopsis.sql.DbInt">761091</Field><Field name="Position" type="com.sunopsis.sql.DbInt">null</Field><Field name="ShortValue" type="java.lang.String"> admin@odistudio.com </Field><Field name="UeName" type="java.lang.String">FROM</Field><Field name="UeSdesc" type="java.lang.String">FROM</Field><Field name="UeType" type="java.lang.String">V</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpUserExit"><Field name="ExtVersion" type="java.lang.String">null</Field><Field name="IndChange" type="java.lang.String">I</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="ITxtUeHelp" type="com.sunopsis.sql.DbInt">null</Field><Field name="ITxtValue" type="com.sunopsis.sql.DbInt">null</Field><Field name="IUserExit" type="com.sunopsis.sql.DbInt">762091</Field><Field name="Position" type="com.sunopsis.sql.DbInt">null</Field><Field name="ShortValue" type="java.lang.String">Mail From ODI</Field><Field name="UeName" type="java.lang.String">SUBJECT</Field><Field name="UeSdesc" type="java.lang.String">Subject</Field><Field name="UeType" type="java.lang.String">V</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpUserExit"><Field name="ExtVersion" type="java.lang.String">null</Field><Field name="IndChange" type="java.lang.String">I</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="ITxtUeHelp" type="com.sunopsis.sql.DbInt">null</Field><Field name="ITxtValue" type="com.sunopsis.sql.DbInt">null</Field><Field name="IUserExit" type="com.sunopsis.sql.DbInt">763091</Field><Field name="Position" type="com.sunopsis.sql.DbInt">null</Field><Field name="ShortValue" type="java.lang.String">C:/Users/Public</Field><Field name="UeName" type="java.lang.String">TEMP_JAVA_DIR</Field><Field name="UeSdesc" type="java.lang.String">Temp Java File Location</Field><Field name="UeType" type="java.lang.String">V</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpUserExit"><Field name="ExtVersion" type="java.lang.String">null</Field><Field name="IndChange" type="java.lang.String">U</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="ITxtUeHelp" type="com.sunopsis.sql.DbInt">null</Field><Field name="ITxtValue" type="com.sunopsis.sql.DbInt">null</Field><Field name="IUserExit" type="com.sunopsis.sql.DbInt">764091</Field><Field name="Position" type="com.sunopsis.sql.DbInt">null</Field><Field name="ShortValue" type="java.lang.String">null</Field><Field name="UeName" type="java.lang.String">USERNAME</Field><Field name="UeSdesc" type="java.lang.String">null</Field><Field name="UeType" type="java.lang.String">T</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpUserExit"><Field name="ExtVersion" type="java.lang.String">null</Field><Field name="IndChange" type="java.lang.String">U</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="ITxtUeHelp" type="com.sunopsis.sql.DbInt">null</Field><Field name="ITxtValue" type="com.sunopsis.sql.DbInt">null</Field><Field name="IUserExit" type="com.sunopsis.sql.DbInt">757091</Field><Field name="Position" type="com.sunopsis.sql.DbInt">null</Field><Field name="ShortValue" type="java.lang.String">null</Field><Field name="UeName" type="java.lang.String">PASSWORD</Field><Field name="UeSdesc" type="java.lang.String">null</Field><Field name="UeType" type="java.lang.String">T</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpUserExit"><Field name="ExtVersion" type="java.lang.String">null</Field><Field name="IndChange" type="java.lang.String">I</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="ITxtUeHelp" type="com.sunopsis.sql.DbInt">null</Field><Field name="ITxtValue" type="com.sunopsis.sql.DbInt">null</Field><Field name="IUserExit" type="com.sunopsis.sql.DbInt">760091</Field><Field name="Position" type="com.sunopsis.sql.DbInt">null</Field><Field name="ShortValue" type="java.lang.String"> bhabaniranjan@gmail.com </Field><Field name="UeName" type="java.lang.String">TO</Field><Field name="UeSdesc" type="java.lang.String">Target User ID</Field><Field name="UeType" type="java.lang.String">V</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpLineTrt"><Field name="AlwaysExe" type="java.lang.String">0</Field><Field name="ColConnectId" type="java.lang.String">null</Field><Field name="ColContextCode" type="java.lang.String">null</Field><Field name="ColIndCommit" type="java.lang.String">null</Field><Field name="ColIsolLevel" type="java.lang.String">null</Field><Field name="ColITxt" type="com.sunopsis.sql.DbInt">null</Field><Field name="ColLschemaName" type="java.lang.String">null</Field><Field name="ColPlanComp" type="java.lang.String">null</Field><Field name="ColTechno" type="java.lang.String">null</Field><Field name="DefConnectId" type="java.lang.String">null</Field><Field name="DefContextCode" type="java.lang.String">null</Field><Field name="DefIndCommit" type="java.lang.String">null</Field><Field name="DefIsolLevel" type="java.lang.String">null</Field><Field name="DefITxt" type="com.sunopsis.sql.DbInt">3315091</Field><Field name="DefLschemaName" type="java.lang.String">null</Field><Field name="DefPlanComp" type="java.lang.String">null</Field><Field name="DefTechno" type="java.lang.String">SUNOPSIS_API</Field><Field name="FirstDate" type="java.sql.Timestamp">2012-12-20 14:28:40.0</Field><Field name="FirstUser" type="java.lang.String">SUPERVISOR</Field><Field name="IndErr" type="java.lang.String">0</Field><Field name="IndLogFinalCmd" type="java.lang.String">0</Field><Field name="IndLogMethod" type="java.lang.String">null</Field><Field name="IndLogNb" type="java.lang.String">null</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="KcmAk" type="java.lang.String">0</Field><Field name="KcmCond" type="java.lang.String">0</Field><Field name="KcmErrDel" type="java.lang.String">0</Field><Field name="KcmJoin" type="java.lang.String">0</Field><Field name="KcmNull" type="java.lang.String">0</Field><Field name="KcmPk" type="java.lang.String">0</Field><Field name="KimDrvdSel" type="java.lang.String">0</Field><Field name="KimIdx" type="java.lang.String">0</Field><Field name="KimJrn" type="java.lang.String">0</Field><Field name="KimJrnPop" type="java.lang.String">0</Field><Field name="KjmCreate" type="java.lang.String">0</Field><Field name="KjmDrop" type="java.lang.String">0</Field><Field name="KjmExtend" type="java.lang.String">0</Field><Field name="KjmLock" type="java.lang.String">0</Field><Field name="KjmPurge" type="java.lang.String">0</Field><Field name="KjmSetInstall" type="java.lang.String">0</Field><Field name="KjmSetUninstall" type="java.lang.String">0</Field><Field name="KjmSubscribe" type="java.lang.String">0</Field><Field name="KjmTableOrder" type="java.lang.String">0</Field><Field name="KjmUnlock" type="java.lang.String">0</Field><Field name="KjmUnsubscribe" type="java.lang.String">0</Field><Field name="KlmAfterInt" type="java.lang.String">0</Field><Field name="KlmIdx" type="java.lang.String">0</Field><Field name="KlmJrn" type="java.lang.String">0</Field><Field name="KxmUsed" type="java.lang.String">null</Field><Field name="LastDate" type="java.sql.Timestamp">2012-12-20 14:38:47.0</Field><Field name="LastUser" type="java.lang.String">SUPERVISOR</Field><Field name="LogLevDet" type="java.lang.String">3</Field><Field name="OrdTrt" type="com.sunopsis.sql.DbInt">30</Field><Field name="SqlName" type="java.lang.String">Delete temporary files</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpTxtHeader"><Field name="Enc" type="java.lang.String">null</Field><Field name="EncKey" type="java.lang.String">null</Field><Field name="ITxt" type="com.sunopsis.sql.DbInt">3315091</Field><Field name="ITxtOrig" type="com.sunopsis.sql.DbInt">102</Field><Field name="SqlIndGrp" type="java.lang.String">0</Field><Field name="Txt" type="java.lang.String">OdiFileDelete "-FILE=<%=odiRef.getOption("TEMP_JAVA_DIR")%>/SendMailTLS*"</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpOrigTxt"><Field name="ITxtOrig" type="com.sunopsis.sql.DbInt">102</Field><Field name="OrigineName" type="java.lang.String">Target Technology</Field><Field name="SnpsCol" type="java.lang.String">DEF_I_TXT</Field><Field name="SnpsTable" type="java.lang.String">SNP_LINE_TRT</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpLineTrt"><Field name="AlwaysExe" type="java.lang.String">1</Field><Field name="ColConnectId" type="java.lang.String">null</Field><Field name="ColContextCode" type="java.lang.String">null</Field><Field name="ColIndCommit" type="java.lang.String">null</Field><Field name="ColIsolLevel" type="java.lang.String">null</Field><Field name="ColITxt" type="com.sunopsis.sql.DbInt">null</Field><Field name="ColLschemaName" type="java.lang.String">null</Field><Field name="ColPlanComp" type="java.lang.String">null</Field><Field name="ColTechno" type="java.lang.String">null</Field><Field name="DefConnectId" type="java.lang.String">null</Field><Field name="DefContextCode" type="java.lang.String">null</Field><Field name="DefIndCommit" type="java.lang.String">null</Field><Field name="DefIsolLevel" type="java.lang.String">null</Field><Field name="DefITxt" type="com.sunopsis.sql.DbInt">3316091</Field><Field name="DefLschemaName" type="java.lang.String">null</Field><Field name="DefPlanComp" type="java.lang.String">null</Field><Field name="DefTechno" type="java.lang.String">SUNOPSIS_API</Field><Field name="FirstDate" type="java.sql.Timestamp">2012-12-20 14:28:40.0</Field><Field name="FirstUser" type="java.lang.String">SUPERVISOR</Field><Field name="IndErr" type="java.lang.String">0</Field><Field name="IndLogFinalCmd" type="java.lang.String">0</Field><Field name="IndLogMethod" type="java.lang.String">null</Field><Field name="IndLogNb" type="java.lang.String">null</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="KcmAk" type="java.lang.String">0</Field><Field name="KcmCond" type="java.lang.String">0</Field><Field name="KcmErrDel" type="java.lang.String">0</Field><Field name="KcmJoin" type="java.lang.String">0</Field><Field name="KcmNull" type="java.lang.String">0</Field><Field name="KcmPk" type="java.lang.String">0</Field><Field name="KimDrvdSel" type="java.lang.String">0</Field><Field name="KimIdx" type="java.lang.String">0</Field><Field name="KimJrn" type="java.lang.String">0</Field><Field name="KimJrnPop" type="java.lang.String">0</Field><Field name="KjmCreate" type="java.lang.String">0</Field><Field name="KjmDrop" type="java.lang.String">0</Field><Field name="KjmExtend" type="java.lang.String">0</Field><Field name="KjmLock" type="java.lang.String">0</Field><Field name="KjmPurge" type="java.lang.String">0</Field><Field name="KjmSetInstall" type="java.lang.String">0</Field><Field name="KjmSetUninstall" type="java.lang.String">0</Field><Field name="KjmSubscribe" type="java.lang.String">0</Field><Field name="KjmTableOrder" type="java.lang.String">0</Field><Field name="KjmUnlock" type="java.lang.String">0</Field><Field name="KjmUnsubscribe" type="java.lang.String">0</Field><Field name="KlmAfterInt" type="java.lang.String">0</Field><Field name="KlmIdx" type="java.lang.String">0</Field><Field name="KlmJrn" type="java.lang.String">0</Field><Field name="KxmUsed" type="java.lang.String">null</Field><Field name="LastDate" type="java.sql.Timestamp">2012-12-20 14:38:47.0</Field><Field name="LastUser" type="java.lang.String">SUPERVISOR</Field><Field name="LogLevDet" type="java.lang.String">3</Field><Field name="OrdTrt" type="com.sunopsis.sql.DbInt">0</Field><Field name="SqlName" type="java.lang.String">Create Java File</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpTxtHeader"><Field name="Enc" type="java.lang.String">null</Field><Field name="EncKey" type="java.lang.String">null</Field><Field name="ITxt" type="com.sunopsis.sql.DbInt">3316091</Field><Field name="ITxtOrig" type="com.sunopsis.sql.DbInt">102</Field><Field name="SqlIndGrp" type="java.lang.String">2</Field><Field name="Txt" type="java.lang.String">OdiOutFile "-FILE=<%=odiRef.getOption("TEMP_JAVA_DIR")%>/SendMailTLS.java" import java.util.Properties; import javax.mail.Message; import javax.mail.MessagingException; import javax.mail.PasswordAuthentication; import javax.mail.Session; import javax.mail.Transport; import javax.mail.internet.InternetAddress; import javax.mail.internet.MimeMessage; public class SendMailTLS { public static void main(String[] args) { final String username = "<%=odiRef.getOption("USERNAME")%>"; final String password = "<%=odiRef.getOption("PASSWORD")%>"; Properties props = new Properties(); props.put("mail.smtp.auth", "true"); props.put("mail.smtp.starttls.enable", "true"); props.put("mail.smtp.host", "smtp.gmail.com"); props.put("mail.smtp.port", "587"); props.put(“mail.smtp.socketFactory.port”, “587″); props.put(“mail.smtp.socketFactory.class”,”javax.net.tls.TLSSocketFactory”); Session session = Session.getInstance(props, new javax.mail.Authenticator() { protected PasswordAuthentication getPasswordAuthentication() { return new PasswordAuthentication(username, password); } }); try { Message message = new MimeMessage(session); message.setFrom(new InternetAddress("<%=odiRef.getOption("FROM")%>")); message.setRecipients(Message.RecipientType.TO, InternetAddress.parse("<%=odiRef.getOption("TO")%>")); message.setSubject("<%=odiRef.getOption("SUBJECT")%>"); message.setText("<%=odiRef.getOption("BODY")%>"); Transport.send(message); System.out.println("Done"); } catch (MessagingException e) { throw new RuntimeException(e); } } }</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpLineTrt"><Field name="AlwaysExe" type="java.lang.String">1</Field><Field name="ColConnectId" type="java.lang.String">null</Field><Field name="ColContextCode" type="java.lang.String">null</Field><Field name="ColIndCommit" type="java.lang.String">null</Field><Field name="ColIsolLevel" type="java.lang.String">null</Field><Field name="ColITxt" type="com.sunopsis.sql.DbInt">null</Field><Field name="ColLschemaName" type="java.lang.String">null</Field><Field name="ColPlanComp" type="java.lang.String">null</Field><Field name="ColTechno" type="java.lang.String">FILE</Field><Field name="DefConnectId" type="java.lang.String">null</Field><Field name="DefContextCode" type="java.lang.String">null</Field><Field name="DefIndCommit" type="java.lang.String">null</Field><Field name="DefIsolLevel" type="java.lang.String">null</Field><Field name="DefITxt" type="com.sunopsis.sql.DbInt">3317091</Field><Field name="DefLschemaName" type="java.lang.String">null</Field><Field name="DefPlanComp" type="java.lang.String">null</Field><Field name="DefTechno" type="java.lang.String">SUNOPSIS_API</Field><Field name="FirstDate" type="java.sql.Timestamp">2012-12-20 14:28:40.0</Field><Field name="FirstUser" type="java.lang.String">SUPERVISOR</Field><Field name="IndErr" type="java.lang.String">0</Field><Field name="IndLogFinalCmd" type="java.lang.String">0</Field><Field name="IndLogMethod" type="java.lang.String">null</Field><Field name="IndLogNb" type="java.lang.String">null</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="KcmAk" type="java.lang.String">0</Field><Field name="KcmCond" type="java.lang.String">0</Field><Field name="KcmErrDel" type="java.lang.String">0</Field><Field name="KcmJoin" type="java.lang.String">0</Field><Field name="KcmNull" type="java.lang.String">0</Field><Field name="KcmPk" type="java.lang.String">0</Field><Field name="KimDrvdSel" type="java.lang.String">0</Field><Field name="KimIdx" type="java.lang.String">0</Field><Field name="KimJrn" type="java.lang.String">0</Field><Field name="KimJrnPop" type="java.lang.String">0</Field><Field name="KjmCreate" type="java.lang.String">0</Field><Field name="KjmDrop" type="java.lang.String">0</Field><Field name="KjmExtend" type="java.lang.String">0</Field><Field name="KjmLock" type="java.lang.String">0</Field><Field name="KjmPurge" type="java.lang.String">0</Field><Field name="KjmSetInstall" type="java.lang.String">0</Field><Field name="KjmSetUninstall" type="java.lang.String">0</Field><Field name="KjmSubscribe" type="java.lang.String">0</Field><Field name="KjmTableOrder" type="java.lang.String">0</Field><Field name="KjmUnlock" type="java.lang.String">0</Field><Field name="KjmUnsubscribe" type="java.lang.String">0</Field><Field name="KlmAfterInt" type="java.lang.String">0</Field><Field name="KlmIdx" type="java.lang.String">0</Field><Field name="KlmJrn" type="java.lang.String">0</Field><Field name="KxmUsed" type="java.lang.String">null</Field><Field name="LastDate" type="java.sql.Timestamp">2012-12-20 14:38:47.0</Field><Field name="LastUser" type="java.lang.String">SUPERVISOR</Field><Field name="LogLevDet" type="java.lang.String">3</Field><Field name="OrdTrt" type="com.sunopsis.sql.DbInt">10</Field><Field name="SqlName" type="java.lang.String">Complie The java file</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpTxtHeader"><Field name="Enc" type="java.lang.String">null</Field><Field name="EncKey" type="java.lang.String">null</Field><Field name="ITxt" type="com.sunopsis.sql.DbInt">3317091</Field><Field name="ITxtOrig" type="com.sunopsis.sql.DbInt">102</Field><Field name="SqlIndGrp" type="java.lang.String">0</Field><Field name="Txt" type="java.lang.String">OdiOSCommand "-COMMAND=<%= odiRef.getOption("JAVA_HOME") %>/bin/javac -cp <%=odiRef.getOption("JAVA_CP_JAR")%> <%=odiRef.getOption("TEMP_JAVA_DIR")%>/SendMailTLS.java" "-ERR_FILE=<%=odiRef.getOption("TEMP_JAVA_DIR")%>/SendMailTLS_err.txt" "-OUT_FILE=<%=odiRef.getOption("TEMP_JAVA_DIR")%>/SendMailTLS_out.txt"</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpLineTrt"><Field name="AlwaysExe" type="java.lang.String">1</Field><Field name="ColConnectId" type="java.lang.String">null</Field><Field name="ColContextCode" type="java.lang.String">null</Field><Field name="ColIndCommit" type="java.lang.String">null</Field><Field name="ColIsolLevel" type="java.lang.String">null</Field><Field name="ColITxt" type="com.sunopsis.sql.DbInt">null</Field><Field name="ColLschemaName" type="java.lang.String">null</Field><Field name="ColPlanComp" type="java.lang.String">null</Field><Field name="ColTechno" type="java.lang.String">FILE</Field><Field name="DefConnectId" type="java.lang.String">null</Field><Field name="DefContextCode" type="java.lang.String">null</Field><Field name="DefIndCommit" type="java.lang.String">null</Field><Field name="DefIsolLevel" type="java.lang.String">null</Field><Field name="DefITxt" type="com.sunopsis.sql.DbInt">3318091</Field><Field name="DefLschemaName" type="java.lang.String">null</Field><Field name="DefPlanComp" type="java.lang.String">null</Field><Field name="DefTechno" type="java.lang.String">SUNOPSIS_API</Field><Field name="FirstDate" type="java.sql.Timestamp">2012-12-20 14:28:40.0</Field><Field name="FirstUser" type="java.lang.String">SUPERVISOR</Field><Field name="IndErr" type="java.lang.String">0</Field><Field name="IndLogFinalCmd" type="java.lang.String">0</Field><Field name="IndLogMethod" type="java.lang.String">null</Field><Field name="IndLogNb" type="java.lang.String">null</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="KcmAk" type="java.lang.String">0</Field><Field name="KcmCond" type="java.lang.String">0</Field><Field name="KcmErrDel" type="java.lang.String">0</Field><Field name="KcmJoin" type="java.lang.String">0</Field><Field name="KcmNull" type="java.lang.String">0</Field><Field name="KcmPk" type="java.lang.String">0</Field><Field name="KimDrvdSel" type="java.lang.String">0</Field><Field name="KimIdx" type="java.lang.String">0</Field><Field name="KimJrn" type="java.lang.String">0</Field><Field name="KimJrnPop" type="java.lang.String">0</Field><Field name="KjmCreate" type="java.lang.String">0</Field><Field name="KjmDrop" type="java.lang.String">0</Field><Field name="KjmExtend" type="java.lang.String">0</Field><Field name="KjmLock" type="java.lang.String">0</Field><Field name="KjmPurge" type="java.lang.String">0</Field><Field name="KjmSetInstall" type="java.lang.String">0</Field><Field name="KjmSetUninstall" type="java.lang.String">0</Field><Field name="KjmSubscribe" type="java.lang.String">0</Field><Field name="KjmTableOrder" type="java.lang.String">0</Field><Field name="KjmUnlock" type="java.lang.String">0</Field><Field name="KjmUnsubscribe" type="java.lang.String">0</Field><Field name="KlmAfterInt" type="java.lang.String">0</Field><Field name="KlmIdx" type="java.lang.String">0</Field><Field name="KlmJrn" type="java.lang.String">0</Field><Field name="KxmUsed" type="java.lang.String">null</Field><Field name="LastDate" type="java.sql.Timestamp">2012-12-20 14:38:47.0</Field><Field name="LastUser" type="java.lang.String">SUPERVISOR</Field><Field name="LogLevDet" type="java.lang.String">3</Field><Field name="OrdTrt" type="com.sunopsis.sql.DbInt">20</Field><Field name="SqlName" type="java.lang.String">Run the java file</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpTxtHeader"><Field name="Enc" type="java.lang.String">null</Field><Field name="EncKey" type="java.lang.String">null</Field><Field name="ITxt" type="com.sunopsis.sql.DbInt">3318091</Field><Field name="ITxtOrig" type="com.sunopsis.sql.DbInt">102</Field><Field name="SqlIndGrp" type="java.lang.String">0</Field><Field name="Txt" type="java.lang.String">OdiOSCommand "-COMMAND=<%= odiRef.getOption("JAVA_HOME") %>/bin/java -cp <%=odiRef.getOption("JAVA_CP_JAR")%>;<%=odiRef.getOption("TEMP_JAVA_DIR")%> SendMailTLS" "-ERR_FILE=<%=odiRef.getOption("TEMP_JAVA_DIR")%>/SendMailTLS_err.txt" "-OUT_FILE=<%=odiRef.getOption("TEMP_JAVA_DIR")%>/SendMailTLS_out.txt"</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpLineTrtUe"><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="IUserExit" type="com.sunopsis.sql.DbInt">756091</Field><Field name="OrdTrt" type="com.sunopsis.sql.DbInt">30</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpImportRep"><Field name="RepShortId" type="com.sunopsis.sql.DbInt">91</Field><Field name="RepTimestamp" type="java.lang.String">1334831213366</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpImportRep"><Field name="RepShortId" type="com.sunopsis.sql.DbInt">92</Field><Field name="RepTimestamp" type="java.lang.String">1343117459745</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpImportRep"><Field name="RepShortId" type="com.sunopsis.sql.DbInt">81</Field><Field name="RepTimestamp" type="java.lang.String">1334307846215</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpImportRep"><Field name="RepShortId" type="com.sunopsis.sql.DbInt">3</Field><Field name="RepTimestamp" type="java.lang.String">1321309358956</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpImportRep"><Field name="RepShortId" type="com.sunopsis.sql.DbInt">2</Field><Field name="RepTimestamp" type="java.lang.String">1277905827008</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpImportRep"><Field name="RepShortId" type="com.sunopsis.sql.DbInt">11</Field><Field name="RepTimestamp" type="java.lang.String">1322240471835</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpImportRep"><Field name="RepShortId" type="com.sunopsis.sql.DbInt">12</Field><Field name="RepTimestamp" type="java.lang.String">1330677667361</Field></Object><Object class="com.sunopsis.dwg.DwgExportSummary"><Field name="ExpTxtNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="InstObjNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="JoinColNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="JoinNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="KeyColNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="KeyNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="LinkDiagNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="MorigTxtNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="MtxtNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="OrigTxtNb" type="com.sunopsis.sql.DbInt">4</Field><Field name="OtherObjectsNb" type="com.sunopsis.sql.DbInt">16</Field><Field name="PlanAgentNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="StepNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="TxtNb" type="com.sunopsis.sql.DbInt">8</Field><Field name="UeOrigNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="UeUsedNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="VarPlanAgentNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="ScenTxtNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="OdiVersion" type="java.lang.String">11.1.1.6.0 - 19/12/2011</Field><Field name="OriginRepositoryID" type="com.sunopsis.sql.DbInt">91</Field><Field name="RepositoryVersion" type="java.lang.String">04.03.04.02</Field></Object></SunopsisExport>.

Oracle Community | 987467 | 2 years ago
  1. 0

    Sending mail on successful execution of Interface in ODI

    Oracle Community | 2 years ago | 987467
    com.sunopsis.tools.core.exception.SnpsSimpleMessageException: Exception getOption("TEMP_JAVA_DIR") : Exception getOption("TEMP_JAVA_DIR") : Option does not exist ("TEMP_JAVA_DIR") BSF info: Send_mail at line: 0 column: columnNo out.print("<SunopsisExport><Admin RepositoryVersion=\"04.03.04.02\"/><Object class=\"com.sunopsis.dwg.dbobj.SnpTrt\"><Field name=\"ExtVersion\" type=\"java.lang.String\">null</Field><Field name=\"FirstDate\" type=\"java.sql.Timestamp\">2012-12-20 14:28:40.0</Field><Field name=\"FirstUser\" type=\"java.lang.String\">SUPERVISOR</Field><Field name=\"IndChange\" type=\"java.lang.String\">U</Field><Field name=\"IndJrnMethod\" type=\"java.lang.String\">S</Field><Field name=\"IndSuppSetBased\" type=\"java.lang.String\">null</Field><Field name=\"IntVersion\" type=\"com.sunopsis.sql.DbInt\">7</Field><Field name=\"IFolder\" type=\"com.sunopsis.sql.DbInt\">9091</Field><Field name=\"IProject\" type=\"com.sunopsis.sql.DbInt\">7091</Field><Field name=\"IScBaseTrt\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"IScOrigTrt\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"IScTrt\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"IState\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"ITxtTrtTxt\" type=\"com.sunopsis.sql.DbInt\">3311091</Field><Field name=\"KimMultiDserver\" type=\"java.lang.String\">0</Field><Field name=\"KmDefault\" type=\"java.lang.String\">0</Field><Field name=\"KmSrcTechno\" type=\"java.lang.String\">null</Field><Field name=\"KmTechno\" type=\"java.lang.String\">null</Field><Field name=\"KmVersion\" type=\"java.lang.String\">null</Field><Field name=\"LastDate\" type=\"java.sql.Timestamp\">2012-12-20 14:40:22.0</Field><Field name=\"LastUser\" type=\"java.lang.String\">SUPERVISOR</Field><Field name=\"LChecksum\" type=\"com.sunopsis.sql.DbInt\">2221</Field><Field name=\"LCode\" type=\"java.lang.String\">null</Field><Field name=\"OrdFolder\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"TrtName\" type=\"java.lang.String\">SendGmailTLS</Field><Field name=\"TrtType\" type=\"java.lang.String\">U</Field><Field name=\"VLastDate\" type=\"java.sql.Timestamp\">null</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpTxtHeader\"><Field name=\"Enc\" type=\"java.lang.String\">null</Field><Field name=\"EncKey\" type=\"java.lang.String\">null</Field><Field name=\"ITxt\" type=\"com.sunopsis.sql.DbInt\">3311091</Field><Field name=\"ITxtOrig\" type=\"com.sunopsis.sql.DbInt\">107</Field><Field name=\"SqlIndGrp\" type=\"java.lang.String\">0</Field><Field name=\"Txt\" type=\"java.lang.String\">COMPONENT NAME: SendGmailTLSAUTHOR: Bhabani Ranjan MahapatraEMAIL : bhabaniranjan@gmail.com BLOG : http://dwteam.inDESCRIPTION:This procedure is required to send email using gmail credentials.</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpOrigTxt\"><Field name=\"ITxtOrig\" type=\"com.sunopsis.sql.DbInt\">107</Field><Field name=\"OrigineName\" type=\"java.lang.String\">Edit Command</Field><Field name=\"SnpsCol\" type=\"java.lang.String\">I_TXT_TRT_TXT</Field><Field name=\"SnpsTable\" type=\"java.lang.String\">SNP_TRT</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpUserExit\"><Field name=\"ExtVersion\" type=\"java.lang.String\">null</Field><Field name=\"IndChange\" type=\"java.lang.String\">I</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"ITxtUeHelp\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ITxtValue\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"IUserExit\" type=\"com.sunopsis.sql.DbInt\">756091</Field><Field name=\"Position\" type=\"com.sunopsis.sql.DbInt\">30</Field><Field name=\"ShortValue\" type=\"java.lang.String\">0</Field><Field name=\"UeName\" type=\"java.lang.String\">DELETE_TEMP_FILES</Field><Field name=\"UeSdesc\" type=\"java.lang.String\">Remove temp files</Field><Field name=\"UeType\" type=\"java.lang.String\">C</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpUserExit\"><Field name=\"ExtVersion\" type=\"java.lang.String\">null</Field><Field name=\"IndChange\" type=\"java.lang.String\">I</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"ITxtUeHelp\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ITxtValue\" type=\"com.sunopsis.sql.DbInt\">3312091</Field><Field name=\"IUserExit\" type=\"com.sunopsis.sql.DbInt\">758091</Field><Field name=\"Position\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ShortValue\" type=\"java.lang.String\">null</Field><Field name=\"UeName\" type=\"java.lang.String\">BODY</Field><Field name=\"UeSdesc\" type=\"java.lang.String\">null</Field><Field name=\"UeType\" type=\"java.lang.String\">T</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpTxtHeader\"><Field name=\"Enc\" type=\"java.lang.String\">null</Field><Field name=\"EncKey\" type=\"java.lang.String\">null</Field><Field name=\"ITxt\" type=\"com.sunopsis.sql.DbInt\">3312091</Field><Field name=\"ITxtOrig\" type=\"com.sunopsis.sql.DbInt\">110</Field><Field name=\"SqlIndGrp\" type=\"java.lang.String\">0</Field><Field name=\"Txt\" type=\"java.lang.String\">Its a Mail from ODI Studio.\Thank You</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpOrigTxt\"><Field name=\"ITxtOrig\" type=\"com.sunopsis.sql.DbInt\">110</Field><Field name=\"OrigineName\" type=\"java.lang.String\">Text value</Field><Field name=\"SnpsCol\" type=\"java.lang.String\">I_TXT_VALUE</Field><Field name=\"SnpsTable\" type=\"java.lang.String\">SNP_USER_EXIT</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpUserExit\"><Field name=\"ExtVersion\" type=\"java.lang.String\">null</Field><Field name=\"IndChange\" type=\"java.lang.String\">I</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"ITxtUeHelp\" type=\"com.sunopsis.sql.DbInt\">3313091</Field><Field name=\"ITxtValue\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"IUserExit\" type=\"com.sunopsis.sql.DbInt\">759091</Field><Field name=\"Position\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ShortValue\" type=\"java.lang.String\"><?= java.lang.System.getProperty(\"java.home\").matches(\".*jre\")?java.lang.System.getProperty(\"java.home\")+\"/..\":java.lang.System.getProperty(\"java.home\") ?></Field><Field name=\"UeName\" type=\"java.lang.String\">JAVA_HOME</Field><Field name=\"UeSdesc\" type=\"java.lang.String\">Location of the JDK</Field><Field name=\"UeType\" type=\"java.lang.String\">V</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpTxtHeader\"><Field name=\"Enc\" type=\"java.lang.String\">null</Field><Field name=\"EncKey\" type=\"java.lang.String\">null</Field><Field name=\"ITxt\" type=\"com.sunopsis.sql.DbInt\">3313091</Field><Field name=\"ITxtOrig\" type=\"com.sunopsis.sql.DbInt\">111</Field><Field name=\"SqlIndGrp\" type=\"java.lang.String\">0</Field><Field name=\"Txt\" type=\"java.lang.String\">Examples:\t$ODI_JAVA_HOME on Unix \t%ODI_JAVA_HOME% on Windows\t/usr/lib/jvm/java-7-openjdk-amd64</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpOrigTxt\"><Field name=\"ITxtOrig\" type=\"com.sunopsis.sql.DbInt\">111</Field><Field name=\"OrigineName\" type=\"java.lang.String\">User Exit help</Field><Field name=\"SnpsCol\" type=\"java.lang.String\">I_TXT_UE_HELP</Field><Field name=\"SnpsTable\" type=\"java.lang.String\">SNP_USER_EXIT</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpUserExit\"><Field name=\"ExtVersion\" type=\"java.lang.String\">null</Field><Field name=\"IndChange\" type=\"java.lang.String\">I</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"ITxtUeHelp\" type=\"com.sunopsis.sql.DbInt\">3314091</Field><Field name=\"ITxtValue\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"IUserExit\" type=\"com.sunopsis.sql.DbInt\">765091</Field><Field name=\"Position\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ShortValue\" type=\"java.lang.String\">C:/oracle/product/11.1.1/Oracle_ODI_1/oracledi.sdk/lib/mail.jar</Field><Field name=\"UeName\" type=\"java.lang.String\">JAVA_CP_JAR</Field><Field name=\"UeSdesc\" type=\"java.lang.String\">Provide the jar name with location</Field><Field name=\"UeType\" type=\"java.lang.String\">V</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpTxtHeader\"><Field name=\"Enc\" type=\"java.lang.String\">null</Field><Field name=\"EncKey\" type=\"java.lang.String\">null</Field><Field name=\"ITxt\" type=\"com.sunopsis.sql.DbInt\">3314091</Field><Field name=\"ITxtOrig\" type=\"com.sunopsis.sql.DbInt\">111</Field><Field name=\"SqlIndGrp\" type=\"java.lang.String\">0</Field><Field name=\"Txt\" type=\"java.lang.String\">mail.jar is required for this java file.</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpUserExit\"><Field name=\"ExtVersion\" type=\"java.lang.String\">null</Field><Field name=\"IndChange\" type=\"java.lang.String\">I</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"ITxtUeHelp\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ITxtValue\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"IUserExit\" type=\"com.sunopsis.sql.DbInt\">761091</Field><Field name=\"Position\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ShortValue\" type=\"java.lang.String\"> admin@odistudio.com </Field><Field name=\"UeName\" type=\"java.lang.String\">FROM</Field><Field name=\"UeSdesc\" type=\"java.lang.String\">FROM</Field><Field name=\"UeType\" type=\"java.lang.String\">V</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpUserExit\"><Field name=\"ExtVersion\" type=\"java.lang.String\">null</Field><Field name=\"IndChange\" type=\"java.lang.String\">I</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"ITxtUeHelp\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ITxtValue\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"IUserExit\" type=\"com.sunopsis.sql.DbInt\">762091</Field><Field name=\"Position\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ShortValue\" type=\"java.lang.String\">Mail From ODI</Field><Field name=\"UeName\" type=\"java.lang.String\">SUBJECT</Field><Field name=\"UeSdesc\" type=\"java.lang.String\">Subject</Field><Field name=\"UeType\" type=\"java.lang.String\">V</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpUserExit\"><Field name=\"ExtVersion\" type=\"java.lang.String\">null</Field><Field name=\"IndChange\" type=\"java.lang.String\">I</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"ITxtUeHelp\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ITxtValue\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"IUserExit\" type=\"com.sunopsis.sql.DbInt\">763091</Field><Field name=\"Position\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ShortValue\" type=\"java.lang.String\">C:/Users/Public</Field><Field name=\"UeName\" type=\"java.lang.String\">TEMP_JAVA_DIR</Field><Field name=\"UeSdesc\" type=\"java.lang.String\">Temp Java File Location</Field><Field name=\"UeType\" type=\"java.lang.String\">V</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpUserExit\"><Field name=\"ExtVersion\" type=\"java.lang.String\">null</Field><Field name=\"IndChange\" type=\"java.lang.String\">U</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"ITxtUeHelp\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ITxtValue\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"IUserExit\" type=\"com.sunopsis.sql.DbInt\">764091</Field><Field name=\"Position\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ShortValue\" type=\"java.lang.String\">null</Field><Field name=\"UeName\" type=\"java.lang.String\">USERNAME</Field><Field name=\"UeSdesc\" type=\"java.lang.String\">null</Field><Field name=\"UeType\" type=\"java.lang.String\">T</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpUserExit\"><Field name=\"ExtVersion\" type=\"java.lang.String\">null</Field><Field name=\"IndChange\" type=\"java.lang.String\">U</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"ITxtUeHelp\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ITxtValue\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"IUserExit\" type=\"com.sunopsis.sql.DbInt\">757091</Field><Field name=\"Position\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ShortValue\" type=\"java.lang.String\">null</Field><Field name=\"UeName\" type=\"java.lang.String\">PASSWORD</Field><Field name=\"UeSdesc\" type=\"java.lang.String\">null</Field><Field name=\"UeType\" type=\"java.lang.String\">T</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpUserExit\"><Field name=\"ExtVersion\" type=\"java.lang.String\">null</Field><Field name=\"IndChange\" type=\"java.lang.String\">I</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"ITxtUeHelp\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ITxtValue\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"IUserExit\" type=\"com.sunopsis.sql.DbInt\">760091</Field><Field name=\"Position\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ShortValue\" type=\"java.lang.String\"> bhabaniranjan@gmail.com </Field><Field name=\"UeName\" type=\"java.lang.String\">TO</Field><Field name=\"UeSdesc\" type=\"java.lang.String\">Target User ID</Field><Field name=\"UeType\" type=\"java.lang.String\">V</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpLineTrt\"><Field name=\"AlwaysExe\" type=\"java.lang.String\">0</Field><Field name=\"ColConnectId\" type=\"java.lang.String\">null</Field><Field name=\"ColContextCode\" type=\"java.lang.String\">null</Field><Field name=\"ColIndCommit\" type=\"java.lang.String\">null</Field><Field name=\"ColIsolLevel\" type=\"java.lang.String\">null</Field><Field name=\"ColITxt\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ColLschemaName\" type=\"java.lang.String\">null</Field><Field name=\"ColPlanComp\" type=\"java.lang.String\">null</Field><Field name=\"ColTechno\" type=\"java.lang.String\">null</Field><Field name=\"DefConnectId\" type=\"java.lang.String\">null</Field><Field name=\"DefContextCode\" type=\"java.lang.String\">null</Field><Field name=\"DefIndCommit\" type=\"java.lang.String\">null</Field><Field name=\"DefIsolLevel\" type=\"java.lang.String\">null</Field><Field name=\"DefITxt\" type=\"com.sunopsis.sql.DbInt\">3315091</Field><Field name=\"DefLschemaName\" type=\"java.lang.String\">null</Field><Field name=\"DefPlanComp\" type=\"java.lang.String\">null</Field><Field name=\"DefTechno\" type=\"java.lang.String\">SUNOPSIS_API</Field><Field name=\"FirstDate\" type=\"java.sql.Timestamp\">2012-12-20 14:28:40.0</Field><Field name=\"FirstUser\" type=\"java.lang.String\">SUPERVISOR</Field><Field name=\"IndErr\" type=\"java.lang.String\">0</Field><Field name=\"IndLogFinalCmd\" type=\"java.lang.String\">0</Field><Field name=\"IndLogMethod\" type=\"java.lang.String\">null</Field><Field name=\"IndLogNb\" type=\"java.lang.String\">null</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"KcmAk\" type=\"java.lang.String\">0</Field><Field name=\"KcmCond\" type=\"java.lang.String\">0</Field><Field name=\"KcmErrDel\" type=\"java.lang.String\">0</Field><Field name=\"KcmJoin\" type=\"java.lang.String\">0</Field><Field name=\"KcmNull\" type=\"java.lang.String\">0</Field><Field name=\"KcmPk\" type=\"java.lang.String\">0</Field><Field name=\"KimDrvdSel\" type=\"java.lang.String\">0</Field><Field name=\"KimIdx\" type=\"java.lang.String\">0</Field><Field name=\"KimJrn\" type=\"java.lang.String\">0</Field><Field name=\"KimJrnPop\" type=\"java.lang.String\">0</Field><Field name=\"KjmCreate\" type=\"java.lang.String\">0</Field><Field name=\"KjmDrop\" type=\"java.lang.String\">0</Field><Field name=\"KjmExtend\" type=\"java.lang.String\">0</Field><Field name=\"KjmLock\" type=\"java.lang.String\">0</Field><Field name=\"KjmPurge\" type=\"java.lang.String\">0</Field><Field name=\"KjmSetInstall\" type=\"java.lang.String\">0</Field><Field name=\"KjmSetUninstall\" type=\"java.lang.String\">0</Field><Field name=\"KjmSubscribe\" type=\"java.lang.String\">0</Field><Field name=\"KjmTableOrder\" type=\"java.lang.String\">0</Field><Field name=\"KjmUnlock\" type=\"java.lang.String\">0</Field><Field name=\"KjmUnsubscribe\" type=\"java.lang.String\">0</Field><Field name=\"KlmAfterInt\" type=\"java.lang.String\">0</Field><Field name=\"KlmIdx\" type=\"java.lang.String\">0</Field><Field name=\"KlmJrn\" type=\"java.lang.String\">0</Field><Field name=\"KxmUsed\" type=\"java.lang.String\">null</Field><Field name=\"LastDate\" type=\"java.sql.Timestamp\">2012-12-20 14:38:47.0</Field><Field name=\"LastUser\" type=\"java.lang.String\">SUPERVISOR</Field><Field name=\"LogLevDet\" type=\"java.lang.String\">3</Field><Field name=\"OrdTrt\" type=\"com.sunopsis.sql.DbInt\">30</Field><Field name=\"SqlName\" type=\"java.lang.String\">Delete temporary files</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpTxtHeader\"><Field name=\"Enc\" type=\"java.lang.String\">null</Field><Field name=\"EncKey\" type=\"java.lang.String\">null</Field><Field name=\"ITxt\" type=\"com.sunopsis.sql.DbInt\">3315091</Field><Field name=\"ITxtOrig\" type=\"com.sunopsis.sql.DbInt\">102</Field><Field name=\"SqlIndGrp\" type=\"java.lang.String\">0</Field><Field name=\"Txt\" type=\"java.lang.String\">OdiFileDelete \"-FILE=") ; out.print(odiRef.getOption("TEMP_JAVA_DIR")) ; out.print("/SendMailTLS*\"</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpOrigTxt\"><Field name=\"ITxtOrig\" type=\"com.sunopsis.sql.DbInt\">102</Field><Field name=\"OrigineName\" type=\"java.lang.String\">Target Technology</Field><Field name=\"SnpsCol\" type=\"java.lang.String\">DEF_I_TXT</Field><Field name=\"SnpsTable\" type=\"java.lang.String\">SNP_LINE_TRT</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpLineTrt\"><Field name=\"AlwaysExe\" type=\"java.lang.String\">1</Field><Field name=\"ColConnectId\" type=\"java.lang.String\">null</Field><Field name=\"ColContextCode\" type=\"java.lang.String\">null</Field><Field name=\"ColIndCommit\" type=\"java.lang.String\">null</Field><Field name=\"ColIsolLevel\" type=\"java.lang.String\">null</Field><Field name=\"ColITxt\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ColLschemaName\" type=\"java.lang.String\">null</Field><Field name=\"ColPlanComp\" type=\"java.lang.String\">null</Field><Field name=\"ColTechno\" type=\"java.lang.String\">null</Field><Field name=\"DefConnectId\" type=\"java.lang.String\">null</Field><Field name=\"DefContextCode\" type=\"java.lang.String\">null</Field><Field name=\"DefIndCommit\" type=\"java.lang.String\">null</Field><Field name=\"DefIsolLevel\" type=\"java.lang.String\">null</Field><Field name=\"DefITxt\" type=\"com.sunopsis.sql.DbInt\">3316091</Field><Field name=\"DefLschemaName\" type=\"java.lang.String\">null</Field><Field name=\"DefPlanComp\" type=\"java.lang.String\">null</Field><Field name=\"DefTechno\" type=\"java.lang.String\">SUNOPSIS_API</Field><Field name=\"FirstDate\" type=\"java.sql.Timestamp\">2012-12-20 14:28:40.0</Field><Field name=\"FirstUser\" type=\"java.lang.String\">SUPERVISOR</Field><Field name=\"IndErr\" type=\"java.lang.String\">0</Field><Field name=\"IndLogFinalCmd\" type=\"java.lang.String\">0</Field><Field name=\"IndLogMethod\" type=\"java.lang.String\">null</Field><Field name=\"IndLogNb\" type=\"java.lang.String\">null</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"KcmAk\" type=\"java.lang.String\">0</Field><Field name=\"KcmCond\" type=\"java.lang.String\">0</Field><Field name=\"KcmErrDel\" type=\"java.lang.String\">0</Field><Field name=\"KcmJoin\" type=\"java.lang.String\">0</Field><Field name=\"KcmNull\" type=\"java.lang.String\">0</Field><Field name=\"KcmPk\" type=\"java.lang.String\">0</Field><Field name=\"KimDrvdSel\" type=\"java.lang.String\">0</Field><Field name=\"KimIdx\" type=\"java.lang.String\">0</Field><Field name=\"KimJrn\" type=\"java.lang.String\">0</Field><Field name=\"KimJrnPop\" type=\"java.lang.String\">0</Field><Field name=\"KjmCreate\" type=\"java.lang.String\">0</Field><Field name=\"KjmDrop\" type=\"java.lang.String\">0</Field><Field name=\"KjmExtend\" type=\"java.lang.String\">0</Field><Field name=\"KjmLock\" type=\"java.lang.String\">0</Field><Field name=\"KjmPurge\" type=\"java.lang.String\">0</Field><Field name=\"KjmSetInstall\" type=\"java.lang.String\">0</Field><Field name=\"KjmSetUninstall\" type=\"java.lang.String\">0</Field><Field name=\"KjmSubscribe\" type=\"java.lang.String\">0</Field><Field name=\"KjmTableOrder\" type=\"java.lang.String\">0</Field><Field name=\"KjmUnlock\" type=\"java.lang.String\">0</Field><Field name=\"KjmUnsubscribe\" type=\"java.lang.String\">0</Field><Field name=\"KlmAfterInt\" type=\"java.lang.String\">0</Field><Field name=\"KlmIdx\" type=\"java.lang.String\">0</Field><Field name=\"KlmJrn\" type=\"java.lang.String\">0</Field><Field name=\"KxmUsed\" type=\"java.lang.String\">null</Field><Field name=\"LastDate\" type=\"java.sql.Timestamp\">2012-12-20 14:38:47.0</Field><Field name=\"LastUser\" type=\"java.lang.String\">SUPERVISOR</Field><Field name=\"LogLevDet\" type=\"java.lang.String\">3</Field><Field name=\"OrdTrt\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"SqlName\" type=\"java.lang.String\">Create Java File</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpTxtHeader\"><Field name=\"Enc\" type=\"java.lang.String\">null</Field><Field name=\"EncKey\" type=\"java.lang.String\">null</Field><Field name=\"ITxt\" type=\"com.sunopsis.sql.DbInt\">3316091</Field><Field name=\"ITxtOrig\" type=\"com.sunopsis.sql.DbInt\">102</Field><Field name=\"SqlIndGrp\" type=\"java.lang.String\">2</Field><Field name=\"Txt\" type=\"java.lang.String\">OdiOutFile \"-FILE=") ; out.print(odiRef.getOption("TEMP_JAVA_DIR")) ; out.print("/SendMailTLS.java\"import java.util.Properties;import javax.mail.Message;import javax.mail.MessagingException;import javax.mail.PasswordAuthentication;import javax.mail.Session;import javax.mail.Transport;import javax.mail.internet.InternetAddress;import javax.mail.internet.MimeMessage; public class SendMailTLS {\tpublic static void main(String[] args) {\t\tfinal String username = \"") ; out.print(odiRef.getOption("USERNAME")) ; out.print("\";\t\tfinal String password = \"") ; out.print(odiRef.getOption("PASSWORD")) ; out.print("\";\t\tProperties props = new Properties();\t\tprops.put(\"mail.smtp.auth\", \"true\");\t\tprops.put(\"mail.smtp.starttls.enable\", \"true\");\t\tprops.put(\"mail.smtp.host\", \"smtp.gmail.com\");\t\tprops.put(\"mail.smtp.port\", \"587\");props.put(\u201cmail.smtp.socketFactory.port\u201d, \u201c587\u2033);props.put(\u201cmail.smtp.socketFactory.class\u201d,\u201djavax.net.tls.TLSSocketFactory\u201d); \t\tSession session = Session.getInstance(props,\t\t new javax.mail.Authenticator() {\t\t\tprotected PasswordAuthentication getPasswordAuthentication() {\t\t\t\treturn new PasswordAuthentication(username, password);\t\t\t}\t\t }); \t\ttry { \t\t\tMessage message = new MimeMessage(session);\t\t\tmessage.setFrom(new InternetAddress(\"") ; out.print(odiRef.getOption("FROM")) ; out.print("\"));\t\t\tmessage.setRecipients(Message.RecipientType.TO,\t\t\t\t\tInternetAddress.parse(\"") ; out.print(odiRef.getOption("TO")) ; out.print("\"));\t\t\tmessage.setSubject(\"") ; out.print(odiRef.getOption("SUBJECT")) ; out.print("\");\t\t\tmessage.setText(\"") ; out.print(odiRef.getOption("BODY")) ; out.print("\"); \t\t\tTransport.send(message); \t\t\tSystem.out.println(\"Done\"); \t\t} catch (MessagingException e) {\t\t\tthrow new RuntimeException(e);\t\t}\t}}</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpLineTrt\"><Field name=\"AlwaysExe\" type=\"java.lang.String\">1</Field><Field name=\"ColConnectId\" type=\"java.lang.String\">null</Field><Field name=\"ColContextCode\" type=\"java.lang.String\">null</Field><Field name=\"ColIndCommit\" type=\"java.lang.String\">null</Field><Field name=\"ColIsolLevel\" type=\"java.lang.String\">null</Field><Field name=\"ColITxt\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ColLschemaName\" type=\"java.lang.String\">null</Field><Field name=\"ColPlanComp\" type=\"java.lang.String\">null</Field><Field name=\"ColTechno\" type=\"java.lang.String\">FILE</Field><Field name=\"DefConnectId\" type=\"java.lang.String\">null</Field><Field name=\"DefContextCode\" type=\"java.lang.String\">null</Field><Field name=\"DefIndCommit\" type=\"java.lang.String\">null</Field><Field name=\"DefIsolLevel\" type=\"java.lang.String\">null</Field><Field name=\"DefITxt\" type=\"com.sunopsis.sql.DbInt\">3317091</Field><Field name=\"DefLschemaName\" type=\"java.lang.String\">null</Field><Field name=\"DefPlanComp\" type=\"java.lang.String\">null</Field><Field name=\"DefTechno\" type=\"java.lang.String\">SUNOPSIS_API</Field><Field name=\"FirstDate\" type=\"java.sql.Timestamp\">2012-12-20 14:28:40.0</Field><Field name=\"FirstUser\" type=\"java.lang.String\">SUPERVISOR</Field><Field name=\"IndErr\" type=\"java.lang.String\">0</Field><Field name=\"IndLogFinalCmd\" type=\"java.lang.String\">0</Field><Field name=\"IndLogMethod\" type=\"java.lang.String\">null</Field><Field name=\"IndLogNb\" type=\"java.lang.String\">null</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"KcmAk\" type=\"java.lang.String\">0</Field><Field name=\"KcmCond\" type=\"java.lang.String\">0</Field><Field name=\"KcmErrDel\" type=\"java.lang.String\">0</Field><Field name=\"KcmJoin\" type=\"java.lang.String\">0</Field><Field name=\"KcmNull\" type=\"java.lang.String\">0</Field><Field name=\"KcmPk\" type=\"java.lang.String\">0</Field><Field name=\"KimDrvdSel\" type=\"java.lang.String\">0</Field><Field name=\"KimIdx\" type=\"java.lang.String\">0</Field><Field name=\"KimJrn\" type=\"java.lang.String\">0</Field><Field name=\"KimJrnPop\" type=\"java.lang.String\">0</Field><Field name=\"KjmCreate\" type=\"java.lang.String\">0</Field><Field name=\"KjmDrop\" type=\"java.lang.String\">0</Field><Field name=\"KjmExtend\" type=\"java.lang.String\">0</Field><Field name=\"KjmLock\" type=\"java.lang.String\">0</Field><Field name=\"KjmPurge\" type=\"java.lang.String\">0</Field><Field name=\"KjmSetInstall\" type=\"java.lang.String\">0</Field><Field name=\"KjmSetUninstall\" type=\"java.lang.String\">0</Field><Field name=\"KjmSubscribe\" type=\"java.lang.String\">0</Field><Field name=\"KjmTableOrder\" type=\"java.lang.String\">0</Field><Field name=\"KjmUnlock\" type=\"java.lang.String\">0</Field><Field name=\"KjmUnsubscribe\" type=\"java.lang.String\">0</Field><Field name=\"KlmAfterInt\" type=\"java.lang.String\">0</Field><Field name=\"KlmIdx\" type=\"java.lang.String\">0</Field><Field name=\"KlmJrn\" type=\"java.lang.String\">0</Field><Field name=\"KxmUsed\" type=\"java.lang.String\">null</Field><Field name=\"LastDate\" type=\"java.sql.Timestamp\">2012-12-20 14:38:47.0</Field><Field name=\"LastUser\" type=\"java.lang.String\">SUPERVISOR</Field><Field name=\"LogLevDet\" type=\"java.lang.String\">3</Field><Field name=\"OrdTrt\" type=\"com.sunopsis.sql.DbInt\">10</Field><Field name=\"SqlName\" type=\"java.lang.String\">Complie The java file</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpTxtHeader\"><Field name=\"Enc\" type=\"java.lang.String\">null</Field><Field name=\"EncKey\" type=\"java.lang.String\">null</Field><Field name=\"ITxt\" type=\"com.sunopsis.sql.DbInt\">3317091</Field><Field name=\"ITxtOrig\" type=\"com.sunopsis.sql.DbInt\">102</Field><Field name=\"SqlIndGrp\" type=\"java.lang.String\">0</Field><Field name=\"Txt\" type=\"java.lang.String\">OdiOSCommand \"-COMMAND=") ; out.print( odiRef.getOption("JAVA_HOME") ) ; out.print("/bin/javac -cp ") ; out.print(odiRef.getOption("JAVA_CP_JAR")) ; out.print(" ") ; out.print(odiRef.getOption("TEMP_JAVA_DIR")) ; out.print("/SendMailTLS.java\" \"-ERR_FILE=") ; out.print(odiRef.getOption("TEMP_JAVA_DIR")) ; out.print("/SendMailTLS_err.txt\" \"-OUT_FILE=") ; out.print(odiRef.getOption("TEMP_JAVA_DIR")) ; out.print("/SendMailTLS_out.txt\"</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpLineTrt\"><Field name=\"AlwaysExe\" type=\"java.lang.String\">1</Field><Field name=\"ColConnectId\" type=\"java.lang.String\">null</Field><Field name=\"ColContextCode\" type=\"java.lang.String\">null</Field><Field name=\"ColIndCommit\" type=\"java.lang.String\">null</Field><Field name=\"ColIsolLevel\" type=\"java.lang.String\">null</Field><Field name=\"ColITxt\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ColLschemaName\" type=\"java.lang.String\">null</Field><Field name=\"ColPlanComp\" type=\"java.lang.String\">null</Field><Field name=\"ColTechno\" type=\"java.lang.String\">FILE</Field><Field name=\"DefConnectId\" type=\"java.lang.String\">null</Field><Field name=\"DefContextCode\" type=\"java.lang.String\">null</Field><Field name=\"DefIndCommit\" type=\"java.lang.String\">null</Field><Field name=\"DefIsolLevel\" type=\"java.lang.String\">null</Field><Field name=\"DefITxt\" type=\"com.sunopsis.sql.DbInt\">3318091</Field><Field name=\"DefLschemaName\" type=\"java.lang.String\">null</Field><Field name=\"DefPlanComp\" type=\"java.lang.String\">null</Field><Field name=\"DefTechno\" type=\"java.lang.String\">SUNOPSIS_API</Field><Field name=\"FirstDate\" type=\"java.sql.Timestamp\">2012-12-20 14:28:40.0</Field><Field name=\"FirstUser\" type=\"java.lang.String\">SUPERVISOR</Field><Field name=\"IndErr\" type=\"java.lang.String\">0</Field><Field name=\"IndLogFinalCmd\" type=\"java.lang.String\">0</Field><Field name=\"IndLogMethod\" type=\"java.lang.String\">null</Field><Field name=\"IndLogNb\" type=\"java.lang.String\">null</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"KcmAk\" type=\"java.lang.String\">0</Field><Field name=\"KcmCond\" type=\"java.lang.String\">0</Field><Field name=\"KcmErrDel\" type=\"java.lang.String\">0</Field><Field name=\"KcmJoin\" type=\"java.lang.String\">0</Field><Field name=\"KcmNull\" type=\"java.lang.String\">0</Field><Field name=\"KcmPk\" type=\"java.lang.String\">0</Field><Field name=\"KimDrvdSel\" type=\"java.lang.String\">0</Field><Field name=\"KimIdx\" type=\"java.lang.String\">0</Field><Field name=\"KimJrn\" type=\"java.lang.String\">0</Field><Field name=\"KimJrnPop\" type=\"java.lang.String\">0</Field><Field name=\"KjmCreate\" type=\"java.lang.String\">0</Field><Field name=\"KjmDrop\" type=\"java.lang.String\">0</Field><Field name=\"KjmExtend\" type=\"java.lang.String\">0</Field><Field name=\"KjmLock\" type=\"java.lang.String\">0</Field><Field name=\"KjmPurge\" type=\"java.lang.String\">0</Field><Field name=\"KjmSetInstall\" type=\"java.lang.String\">0</Field><Field name=\"KjmSetUninstall\" type=\"java.lang.String\">0</Field><Field name=\"KjmSubscribe\" type=\"java.lang.String\">0</Field><Field name=\"KjmTableOrder\" type=\"java.lang.String\">0</Field><Field name=\"KjmUnlock\" type=\"java.lang.String\">0</Field><Field name=\"KjmUnsubscribe\" type=\"java.lang.String\">0</Field><Field name=\"KlmAfterInt\" type=\"java.lang.String\">0</Field><Field name=\"KlmIdx\" type=\"java.lang.String\">0</Field><Field name=\"KlmJrn\" type=\"java.lang.String\">0</Field><Field name=\"KxmUsed\" type=\"java.lang.String\">null</Field><Field name=\"LastDate\" type=\"java.sql.Timestamp\">2012-12-20 14:38:47.0</Field><Field name=\"LastUser\" type=\"java.lang.String\">SUPERVISOR</Field><Field name=\"LogLevDet\" type=\"java.lang.String\">3</Field><Field name=\"OrdTrt\" type=\"com.sunopsis.sql.DbInt\">20</Field><Field name=\"SqlName\" type=\"java.lang.String\">Run the java file</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpTxtHeader\"><Field name=\"Enc\" type=\"java.lang.String\">null</Field><Field name=\"EncKey\" type=\"java.lang.String\">null</Field><Field name=\"ITxt\" type=\"com.sunopsis.sql.DbInt\">3318091</Field><Field name=\"ITxtOrig\" type=\"com.sunopsis.sql.DbInt\">102</Field><Field name=\"SqlIndGrp\" type=\"java.lang.String\">0</Field><Field name=\"Txt\" type=\"java.lang.String\">OdiOSCommand \"-COMMAND=") ; out.print( odiRef.getOption("JAVA_HOME") ) ; out.print("/bin/java -cp ") ; out.print(odiRef.getOption("JAVA_CP_JAR")) ; out.print(";") ; out.print(odiRef.getOption("TEMP_JAVA_DIR")) ; out.print(" SendMailTLS\" \"-ERR_FILE=") ; out.print(odiRef.getOption("TEMP_JAVA_DIR")) ; out.print("/SendMailTLS_err.txt\" \"-OUT_FILE=") ; out.print(odiRef.getOption("TEMP_JAVA_DIR")) ; out.print("/SendMailTLS_out.txt\"</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpLineTrtUe\"><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"IUserExit\" type=\"com.sunopsis.sql.DbInt\">756091</Field><Field name=\"OrdTrt\" type=\"com.sunopsis.sql.DbInt\">30</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpImportRep\"><Field name=\"RepShortId\" type=\"com.sunopsis.sql.DbInt\">91</Field><Field name=\"RepTimestamp\" type=\"java.lang.String\">1334831213366</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpImportRep\"><Field name=\"RepShortId\" type=\"com.sunopsis.sql.DbInt\">92</Field><Field name=\"RepTimestamp\" type=\"java.lang.String\">1343117459745</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpImportRep\"><Field name=\"RepShortId\" type=\"com.sunopsis.sql.DbInt\">81</Field><Field name=\"RepTimestamp\" type=\"java.lang.String\">1334307846215</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpImportRep\"><Field name=\"RepShortId\" type=\"com.sunopsis.sql.DbInt\">3</Field><Field name=\"RepTimestamp\" type=\"java.lang.String\">1321309358956</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpImportRep\"><Field name=\"RepShortId\" type=\"com.sunopsis.sql.DbInt\">2</Field><Field name=\"RepTimestamp\" type=\"java.lang.String\">1277905827008</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpImportRep\"><Field name=\"RepShortId\" type=\"com.sunopsis.sql.DbInt\">11</Field><Field name=\"RepTimestamp\" type=\"java.lang.String\">1322240471835</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpImportRep\"><Field name=\"RepShortId\" type=\"com.sunopsis.sql.DbInt\">12</Field><Field name=\"RepTimestamp\" type=\"java.lang.String\">1330677667361</Field></Object><Object class=\"com.sunopsis.dwg.DwgExportSummary\"><Field name=\"ExpTxtNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"InstObjNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"JoinColNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"JoinNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"KeyColNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"KeyNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"LinkDiagNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"MorigTxtNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"MtxtNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"OrigTxtNb\" type=\"com.sunopsis.sql.DbInt\">4</Field><Field name=\"OtherObjectsNb\" type=\"com.sunopsis.sql.DbInt\">16</Field><Field name=\"PlanAgentNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"StepNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"TxtNb\" type=\"com.sunopsis.sql.DbInt\">8</Field><Field name=\"UeOrigNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"UeUsedNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"VarPlanAgentNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"ScenTxtNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"OdiVersion\" type=\"java.lang.String\">11.1.1.6.0 - 19/12/2011</Field><Field name=\"OriginRepositoryID\" type=\"com.sunopsis.sql.DbInt\">91</Field><Field name=\"RepositoryVersion\" type=\"java.lang.String\">04.03.04.02</Field></Object></SunopsisExport>") ; ****** ORIGINAL TEXT ****** <SunopsisExport><Admin RepositoryVersion="04.03.04.02"/><Object class="com.sunopsis.dwg.dbobj.SnpTrt"><Field name="ExtVersion" type="java.lang.String">null</Field><Field name="FirstDate" type="java.sql.Timestamp">2012-12-20 14:28:40.0</Field><Field name="FirstUser" type="java.lang.String">SUPERVISOR</Field><Field name="IndChange" type="java.lang.String">U</Field><Field name="IndJrnMethod" type="java.lang.String">S</Field><Field name="IndSuppSetBased" type="java.lang.String">null</Field><Field name="IntVersion" type="com.sunopsis.sql.DbInt">7</Field><Field name="IFolder" type="com.sunopsis.sql.DbInt">9091</Field><Field name="IProject" type="com.sunopsis.sql.DbInt">7091</Field><Field name="IScBaseTrt" type="com.sunopsis.sql.DbInt">null</Field><Field name="IScOrigTrt" type="com.sunopsis.sql.DbInt">null</Field><Field name="IScTrt" type="com.sunopsis.sql.DbInt">null</Field><Field name="IState" type="com.sunopsis.sql.DbInt">null</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="ITxtTrtTxt" type="com.sunopsis.sql.DbInt">3311091</Field><Field name="KimMultiDserver" type="java.lang.String">0</Field><Field name="KmDefault" type="java.lang.String">0</Field><Field name="KmSrcTechno" type="java.lang.String">null</Field><Field name="KmTechno" type="java.lang.String">null</Field><Field name="KmVersion" type="java.lang.String">null</Field><Field name="LastDate" type="java.sql.Timestamp">2012-12-20 14:40:22.0</Field><Field name="LastUser" type="java.lang.String">SUPERVISOR</Field><Field name="LChecksum" type="com.sunopsis.sql.DbInt">2221</Field><Field name="LCode" type="java.lang.String">null</Field><Field name="OrdFolder" type="com.sunopsis.sql.DbInt">null</Field><Field name="TrtName" type="java.lang.String">SendGmailTLS</Field><Field name="TrtType" type="java.lang.String">U</Field><Field name="VLastDate" type="java.sql.Timestamp">null</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpTxtHeader"><Field name="Enc" type="java.lang.String">null</Field><Field name="EncKey" type="java.lang.String">null</Field><Field name="ITxt" type="com.sunopsis.sql.DbInt">3311091</Field><Field name="ITxtOrig" type="com.sunopsis.sql.DbInt">107</Field><Field name="SqlIndGrp" type="java.lang.String">0</Field><Field name="Txt" type="java.lang.String">COMPONENT NAME: SendGmailTLS AUTHOR: Bhabani Ranjan Mahapatra EMAIL : bhabaniranjan@gmail.com BLOG : http://dwteam.in DESCRIPTION: This procedure is required to send email using gmail credentials.</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpOrigTxt"><Field name="ITxtOrig" type="com.sunopsis.sql.DbInt">107</Field><Field name="OrigineName" type="java.lang.String">Edit Command</Field><Field name="SnpsCol" type="java.lang.String">I_TXT_TRT_TXT</Field><Field name="SnpsTable" type="java.lang.String">SNP_TRT</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpUserExit"><Field name="ExtVersion" type="java.lang.String">null</Field><Field name="IndChange" type="java.lang.String">I</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="ITxtUeHelp" type="com.sunopsis.sql.DbInt">null</Field><Field name="ITxtValue" type="com.sunopsis.sql.DbInt">null</Field><Field name="IUserExit" type="com.sunopsis.sql.DbInt">756091</Field><Field name="Position" type="com.sunopsis.sql.DbInt">30</Field><Field name="ShortValue" type="java.lang.String">0</Field><Field name="UeName" type="java.lang.String">DELETE_TEMP_FILES</Field><Field name="UeSdesc" type="java.lang.String">Remove temp files</Field><Field name="UeType" type="java.lang.String">C</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpUserExit"><Field name="ExtVersion" type="java.lang.String">null</Field><Field name="IndChange" type="java.lang.String">I</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="ITxtUeHelp" type="com.sunopsis.sql.DbInt">null</Field><Field name="ITxtValue" type="com.sunopsis.sql.DbInt">3312091</Field><Field name="IUserExit" type="com.sunopsis.sql.DbInt">758091</Field><Field name="Position" type="com.sunopsis.sql.DbInt">null</Field><Field name="ShortValue" type="java.lang.String">null</Field><Field name="UeName" type="java.lang.String">BODY</Field><Field name="UeSdesc" type="java.lang.String">null</Field><Field name="UeType" type="java.lang.String">T</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpTxtHeader"><Field name="Enc" type="java.lang.String">null</Field><Field name="EncKey" type="java.lang.String">null</Field><Field name="ITxt" type="com.sunopsis.sql.DbInt">3312091</Field><Field name="ITxtOrig" type="com.sunopsis.sql.DbInt">110</Field><Field name="SqlIndGrp" type="java.lang.String">0</Field><Field name="Txt" type="java.lang.String">Its a Mail from ODI Studio.Thank You</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpOrigTxt"><Field name="ITxtOrig" type="com.sunopsis.sql.DbInt">110</Field><Field name="OrigineName" type="java.lang.String">Text value</Field><Field name="SnpsCol" type="java.lang.String">I_TXT_VALUE</Field><Field name="SnpsTable" type="java.lang.String">SNP_USER_EXIT</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpUserExit"><Field name="ExtVersion" type="java.lang.String">null</Field><Field name="IndChange" type="java.lang.String">I</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="ITxtUeHelp" type="com.sunopsis.sql.DbInt">3313091</Field><Field name="ITxtValue" type="com.sunopsis.sql.DbInt">null</Field><Field name="IUserExit" type="com.sunopsis.sql.DbInt">759091</Field><Field name="Position" type="com.sunopsis.sql.DbInt">null</Field><Field name="ShortValue" type="java.lang.String"><?= java.lang.System.getProperty("java.home").matches(".*jre")?java.lang.System.getProperty("java.home")+"/..":java.lang.System.getProperty("java.home") ?></Field><Field name="UeName" type="java.lang.String">JAVA_HOME</Field><Field name="UeSdesc" type="java.lang.String">Location of the JDK</Field><Field name="UeType" type="java.lang.String">V</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpTxtHeader"><Field name="Enc" type="java.lang.String">null</Field><Field name="EncKey" type="java.lang.String">null</Field><Field name="ITxt" type="com.sunopsis.sql.DbInt">3313091</Field><Field name="ITxtOrig" type="com.sunopsis.sql.DbInt">111</Field><Field name="SqlIndGrp" type="java.lang.String">0</Field><Field name="Txt" type="java.lang.String"> Examples: $ODI_JAVA_HOME on Unix %ODI_JAVA_HOME% on Windows /usr/lib/jvm/java-7-openjdk-amd64</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpOrigTxt"><Field name="ITxtOrig" type="com.sunopsis.sql.DbInt">111</Field><Field name="OrigineName" type="java.lang.String">User Exit help</Field><Field name="SnpsCol" type="java.lang.String">I_TXT_UE_HELP</Field><Field name="SnpsTable" type="java.lang.String">SNP_USER_EXIT</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpUserExit"><Field name="ExtVersion" type="java.lang.String">null</Field><Field name="IndChange" type="java.lang.String">I</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="ITxtUeHelp" type="com.sunopsis.sql.DbInt">3314091</Field><Field name="ITxtValue" type="com.sunopsis.sql.DbInt">null</Field><Field name="IUserExit" type="com.sunopsis.sql.DbInt">765091</Field><Field name="Position" type="com.sunopsis.sql.DbInt">null</Field><Field name="ShortValue" type="java.lang.String">C:/oracle/product/11.1.1/Oracle_ODI_1/oracledi.sdk/lib/mail.jar</Field><Field name="UeName" type="java.lang.String">JAVA_CP_JAR</Field><Field name="UeSdesc" type="java.lang.String">Provide the jar name with location</Field><Field name="UeType" type="java.lang.String">V</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpTxtHeader"><Field name="Enc" type="java.lang.String">null</Field><Field name="EncKey" type="java.lang.String">null</Field><Field name="ITxt" type="com.sunopsis.sql.DbInt">3314091</Field><Field name="ITxtOrig" type="com.sunopsis.sql.DbInt">111</Field><Field name="SqlIndGrp" type="java.lang.String">0</Field><Field name="Txt" type="java.lang.String">mail.jar is required for this java file.</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpUserExit"><Field name="ExtVersion" type="java.lang.String">null</Field><Field name="IndChange" type="java.lang.String">I</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="ITxtUeHelp" type="com.sunopsis.sql.DbInt">null</Field><Field name="ITxtValue" type="com.sunopsis.sql.DbInt">null</Field><Field name="IUserExit" type="com.sunopsis.sql.DbInt">761091</Field><Field name="Position" type="com.sunopsis.sql.DbInt">null</Field><Field name="ShortValue" type="java.lang.String"> admin@odistudio.com </Field><Field name="UeName" type="java.lang.String">FROM</Field><Field name="UeSdesc" type="java.lang.String">FROM</Field><Field name="UeType" type="java.lang.String">V</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpUserExit"><Field name="ExtVersion" type="java.lang.String">null</Field><Field name="IndChange" type="java.lang.String">I</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="ITxtUeHelp" type="com.sunopsis.sql.DbInt">null</Field><Field name="ITxtValue" type="com.sunopsis.sql.DbInt">null</Field><Field name="IUserExit" type="com.sunopsis.sql.DbInt">762091</Field><Field name="Position" type="com.sunopsis.sql.DbInt">null</Field><Field name="ShortValue" type="java.lang.String">Mail From ODI</Field><Field name="UeName" type="java.lang.String">SUBJECT</Field><Field name="UeSdesc" type="java.lang.String">Subject</Field><Field name="UeType" type="java.lang.String">V</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpUserExit"><Field name="ExtVersion" type="java.lang.String">null</Field><Field name="IndChange" type="java.lang.String">I</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="ITxtUeHelp" type="com.sunopsis.sql.DbInt">null</Field><Field name="ITxtValue" type="com.sunopsis.sql.DbInt">null</Field><Field name="IUserExit" type="com.sunopsis.sql.DbInt">763091</Field><Field name="Position" type="com.sunopsis.sql.DbInt">null</Field><Field name="ShortValue" type="java.lang.String">C:/Users/Public</Field><Field name="UeName" type="java.lang.String">TEMP_JAVA_DIR</Field><Field name="UeSdesc" type="java.lang.String">Temp Java File Location</Field><Field name="UeType" type="java.lang.String">V</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpUserExit"><Field name="ExtVersion" type="java.lang.String">null</Field><Field name="IndChange" type="java.lang.String">U</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="ITxtUeHelp" type="com.sunopsis.sql.DbInt">null</Field><Field name="ITxtValue" type="com.sunopsis.sql.DbInt">null</Field><Field name="IUserExit" type="com.sunopsis.sql.DbInt">764091</Field><Field name="Position" type="com.sunopsis.sql.DbInt">null</Field><Field name="ShortValue" type="java.lang.String">null</Field><Field name="UeName" type="java.lang.String">USERNAME</Field><Field name="UeSdesc" type="java.lang.String">null</Field><Field name="UeType" type="java.lang.String">T</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpUserExit"><Field name="ExtVersion" type="java.lang.String">null</Field><Field name="IndChange" type="java.lang.String">U</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="ITxtUeHelp" type="com.sunopsis.sql.DbInt">null</Field><Field name="ITxtValue" type="com.sunopsis.sql.DbInt">null</Field><Field name="IUserExit" type="com.sunopsis.sql.DbInt">757091</Field><Field name="Position" type="com.sunopsis.sql.DbInt">null</Field><Field name="ShortValue" type="java.lang.String">null</Field><Field name="UeName" type="java.lang.String">PASSWORD</Field><Field name="UeSdesc" type="java.lang.String">null</Field><Field name="UeType" type="java.lang.String">T</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpUserExit"><Field name="ExtVersion" type="java.lang.String">null</Field><Field name="IndChange" type="java.lang.String">I</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="ITxtUeHelp" type="com.sunopsis.sql.DbInt">null</Field><Field name="ITxtValue" type="com.sunopsis.sql.DbInt">null</Field><Field name="IUserExit" type="com.sunopsis.sql.DbInt">760091</Field><Field name="Position" type="com.sunopsis.sql.DbInt">null</Field><Field name="ShortValue" type="java.lang.String"> bhabaniranjan@gmail.com </Field><Field name="UeName" type="java.lang.String">TO</Field><Field name="UeSdesc" type="java.lang.String">Target User ID</Field><Field name="UeType" type="java.lang.String">V</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpLineTrt"><Field name="AlwaysExe" type="java.lang.String">0</Field><Field name="ColConnectId" type="java.lang.String">null</Field><Field name="ColContextCode" type="java.lang.String">null</Field><Field name="ColIndCommit" type="java.lang.String">null</Field><Field name="ColIsolLevel" type="java.lang.String">null</Field><Field name="ColITxt" type="com.sunopsis.sql.DbInt">null</Field><Field name="ColLschemaName" type="java.lang.String">null</Field><Field name="ColPlanComp" type="java.lang.String">null</Field><Field name="ColTechno" type="java.lang.String">null</Field><Field name="DefConnectId" type="java.lang.String">null</Field><Field name="DefContextCode" type="java.lang.String">null</Field><Field name="DefIndCommit" type="java.lang.String">null</Field><Field name="DefIsolLevel" type="java.lang.String">null</Field><Field name="DefITxt" type="com.sunopsis.sql.DbInt">3315091</Field><Field name="DefLschemaName" type="java.lang.String">null</Field><Field name="DefPlanComp" type="java.lang.String">null</Field><Field name="DefTechno" type="java.lang.String">SUNOPSIS_API</Field><Field name="FirstDate" type="java.sql.Timestamp">2012-12-20 14:28:40.0</Field><Field name="FirstUser" type="java.lang.String">SUPERVISOR</Field><Field name="IndErr" type="java.lang.String">0</Field><Field name="IndLogFinalCmd" type="java.lang.String">0</Field><Field name="IndLogMethod" type="java.lang.String">null</Field><Field name="IndLogNb" type="java.lang.String">null</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="KcmAk" type="java.lang.String">0</Field><Field name="KcmCond" type="java.lang.String">0</Field><Field name="KcmErrDel" type="java.lang.String">0</Field><Field name="KcmJoin" type="java.lang.String">0</Field><Field name="KcmNull" type="java.lang.String">0</Field><Field name="KcmPk" type="java.lang.String">0</Field><Field name="KimDrvdSel" type="java.lang.String">0</Field><Field name="KimIdx" type="java.lang.String">0</Field><Field name="KimJrn" type="java.lang.String">0</Field><Field name="KimJrnPop" type="java.lang.String">0</Field><Field name="KjmCreate" type="java.lang.String">0</Field><Field name="KjmDrop" type="java.lang.String">0</Field><Field name="KjmExtend" type="java.lang.String">0</Field><Field name="KjmLock" type="java.lang.String">0</Field><Field name="KjmPurge" type="java.lang.String">0</Field><Field name="KjmSetInstall" type="java.lang.String">0</Field><Field name="KjmSetUninstall" type="java.lang.String">0</Field><Field name="KjmSubscribe" type="java.lang.String">0</Field><Field name="KjmTableOrder" type="java.lang.String">0</Field><Field name="KjmUnlock" type="java.lang.String">0</Field><Field name="KjmUnsubscribe" type="java.lang.String">0</Field><Field name="KlmAfterInt" type="java.lang.String">0</Field><Field name="KlmIdx" type="java.lang.String">0</Field><Field name="KlmJrn" type="java.lang.String">0</Field><Field name="KxmUsed" type="java.lang.String">null</Field><Field name="LastDate" type="java.sql.Timestamp">2012-12-20 14:38:47.0</Field><Field name="LastUser" type="java.lang.String">SUPERVISOR</Field><Field name="LogLevDet" type="java.lang.String">3</Field><Field name="OrdTrt" type="com.sunopsis.sql.DbInt">30</Field><Field name="SqlName" type="java.lang.String">Delete temporary files</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpTxtHeader"><Field name="Enc" type="java.lang.String">null</Field><Field name="EncKey" type="java.lang.String">null</Field><Field name="ITxt" type="com.sunopsis.sql.DbInt">3315091</Field><Field name="ITxtOrig" type="com.sunopsis.sql.DbInt">102</Field><Field name="SqlIndGrp" type="java.lang.String">0</Field><Field name="Txt" type="java.lang.String">OdiFileDelete "-FILE=<%=odiRef.getOption("TEMP_JAVA_DIR")%>/SendMailTLS*"</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpOrigTxt"><Field name="ITxtOrig" type="com.sunopsis.sql.DbInt">102</Field><Field name="OrigineName" type="java.lang.String">Target Technology</Field><Field name="SnpsCol" type="java.lang.String">DEF_I_TXT</Field><Field name="SnpsTable" type="java.lang.String">SNP_LINE_TRT</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpLineTrt"><Field name="AlwaysExe" type="java.lang.String">1</Field><Field name="ColConnectId" type="java.lang.String">null</Field><Field name="ColContextCode" type="java.lang.String">null</Field><Field name="ColIndCommit" type="java.lang.String">null</Field><Field name="ColIsolLevel" type="java.lang.String">null</Field><Field name="ColITxt" type="com.sunopsis.sql.DbInt">null</Field><Field name="ColLschemaName" type="java.lang.String">null</Field><Field name="ColPlanComp" type="java.lang.String">null</Field><Field name="ColTechno" type="java.lang.String">null</Field><Field name="DefConnectId" type="java.lang.String">null</Field><Field name="DefContextCode" type="java.lang.String">null</Field><Field name="DefIndCommit" type="java.lang.String">null</Field><Field name="DefIsolLevel" type="java.lang.String">null</Field><Field name="DefITxt" type="com.sunopsis.sql.DbInt">3316091</Field><Field name="DefLschemaName" type="java.lang.String">null</Field><Field name="DefPlanComp" type="java.lang.String">null</Field><Field name="DefTechno" type="java.lang.String">SUNOPSIS_API</Field><Field name="FirstDate" type="java.sql.Timestamp">2012-12-20 14:28:40.0</Field><Field name="FirstUser" type="java.lang.String">SUPERVISOR</Field><Field name="IndErr" type="java.lang.String">0</Field><Field name="IndLogFinalCmd" type="java.lang.String">0</Field><Field name="IndLogMethod" type="java.lang.String">null</Field><Field name="IndLogNb" type="java.lang.String">null</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="KcmAk" type="java.lang.String">0</Field><Field name="KcmCond" type="java.lang.String">0</Field><Field name="KcmErrDel" type="java.lang.String">0</Field><Field name="KcmJoin" type="java.lang.String">0</Field><Field name="KcmNull" type="java.lang.String">0</Field><Field name="KcmPk" type="java.lang.String">0</Field><Field name="KimDrvdSel" type="java.lang.String">0</Field><Field name="KimIdx" type="java.lang.String">0</Field><Field name="KimJrn" type="java.lang.String">0</Field><Field name="KimJrnPop" type="java.lang.String">0</Field><Field name="KjmCreate" type="java.lang.String">0</Field><Field name="KjmDrop" type="java.lang.String">0</Field><Field name="KjmExtend" type="java.lang.String">0</Field><Field name="KjmLock" type="java.lang.String">0</Field><Field name="KjmPurge" type="java.lang.String">0</Field><Field name="KjmSetInstall" type="java.lang.String">0</Field><Field name="KjmSetUninstall" type="java.lang.String">0</Field><Field name="KjmSubscribe" type="java.lang.String">0</Field><Field name="KjmTableOrder" type="java.lang.String">0</Field><Field name="KjmUnlock" type="java.lang.String">0</Field><Field name="KjmUnsubscribe" type="java.lang.String">0</Field><Field name="KlmAfterInt" type="java.lang.String">0</Field><Field name="KlmIdx" type="java.lang.String">0</Field><Field name="KlmJrn" type="java.lang.String">0</Field><Field name="KxmUsed" type="java.lang.String">null</Field><Field name="LastDate" type="java.sql.Timestamp">2012-12-20 14:38:47.0</Field><Field name="LastUser" type="java.lang.String">SUPERVISOR</Field><Field name="LogLevDet" type="java.lang.String">3</Field><Field name="OrdTrt" type="com.sunopsis.sql.DbInt">0</Field><Field name="SqlName" type="java.lang.String">Create Java File</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpTxtHeader"><Field name="Enc" type="java.lang.String">null</Field><Field name="EncKey" type="java.lang.String">null</Field><Field name="ITxt" type="com.sunopsis.sql.DbInt">3316091</Field><Field name="ITxtOrig" type="com.sunopsis.sql.DbInt">102</Field><Field name="SqlIndGrp" type="java.lang.String">2</Field><Field name="Txt" type="java.lang.String">OdiOutFile "-FILE=<%=odiRef.getOption("TEMP_JAVA_DIR")%>/SendMailTLS.java" import java.util.Properties; import javax.mail.Message; import javax.mail.MessagingException; import javax.mail.PasswordAuthentication; import javax.mail.Session; import javax.mail.Transport; import javax.mail.internet.InternetAddress; import javax.mail.internet.MimeMessage; public class SendMailTLS { public static void main(String[] args) { final String username = "<%=odiRef.getOption("USERNAME")%>"; final String password = "<%=odiRef.getOption("PASSWORD")%>"; Properties props = new Properties(); props.put("mail.smtp.auth", "true"); props.put("mail.smtp.starttls.enable", "true"); props.put("mail.smtp.host", "smtp.gmail.com"); props.put("mail.smtp.port", "587"); props.put(“mail.smtp.socketFactory.port”, “587″); props.put(“mail.smtp.socketFactory.class”,”javax.net.tls.TLSSocketFactory”); Session session = Session.getInstance(props, new javax.mail.Authenticator() { protected PasswordAuthentication getPasswordAuthentication() { return new PasswordAuthentication(username, password); } }); try { Message message = new MimeMessage(session); message.setFrom(new InternetAddress("<%=odiRef.getOption("FROM")%>")); message.setRecipients(Message.RecipientType.TO, InternetAddress.parse("<%=odiRef.getOption("TO")%>")); message.setSubject("<%=odiRef.getOption("SUBJECT")%>"); message.setText("<%=odiRef.getOption("BODY")%>"); Transport.send(message); System.out.println("Done"); } catch (MessagingException e) { throw new RuntimeException(e); } } }</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpLineTrt"><Field name="AlwaysExe" type="java.lang.String">1</Field><Field name="ColConnectId" type="java.lang.String">null</Field><Field name="ColContextCode" type="java.lang.String">null</Field><Field name="ColIndCommit" type="java.lang.String">null</Field><Field name="ColIsolLevel" type="java.lang.String">null</Field><Field name="ColITxt" type="com.sunopsis.sql.DbInt">null</Field><Field name="ColLschemaName" type="java.lang.String">null</Field><Field name="ColPlanComp" type="java.lang.String">null</Field><Field name="ColTechno" type="java.lang.String">FILE</Field><Field name="DefConnectId" type="java.lang.String">null</Field><Field name="DefContextCode" type="java.lang.String">null</Field><Field name="DefIndCommit" type="java.lang.String">null</Field><Field name="DefIsolLevel" type="java.lang.String">null</Field><Field name="DefITxt" type="com.sunopsis.sql.DbInt">3317091</Field><Field name="DefLschemaName" type="java.lang.String">null</Field><Field name="DefPlanComp" type="java.lang.String">null</Field><Field name="DefTechno" type="java.lang.String">SUNOPSIS_API</Field><Field name="FirstDate" type="java.sql.Timestamp">2012-12-20 14:28:40.0</Field><Field name="FirstUser" type="java.lang.String">SUPERVISOR</Field><Field name="IndErr" type="java.lang.String">0</Field><Field name="IndLogFinalCmd" type="java.lang.String">0</Field><Field name="IndLogMethod" type="java.lang.String">null</Field><Field name="IndLogNb" type="java.lang.String">null</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="KcmAk" type="java.lang.String">0</Field><Field name="KcmCond" type="java.lang.String">0</Field><Field name="KcmErrDel" type="java.lang.String">0</Field><Field name="KcmJoin" type="java.lang.String">0</Field><Field name="KcmNull" type="java.lang.String">0</Field><Field name="KcmPk" type="java.lang.String">0</Field><Field name="KimDrvdSel" type="java.lang.String">0</Field><Field name="KimIdx" type="java.lang.String">0</Field><Field name="KimJrn" type="java.lang.String">0</Field><Field name="KimJrnPop" type="java.lang.String">0</Field><Field name="KjmCreate" type="java.lang.String">0</Field><Field name="KjmDrop" type="java.lang.String">0</Field><Field name="KjmExtend" type="java.lang.String">0</Field><Field name="KjmLock" type="java.lang.String">0</Field><Field name="KjmPurge" type="java.lang.String">0</Field><Field name="KjmSetInstall" type="java.lang.String">0</Field><Field name="KjmSetUninstall" type="java.lang.String">0</Field><Field name="KjmSubscribe" type="java.lang.String">0</Field><Field name="KjmTableOrder" type="java.lang.String">0</Field><Field name="KjmUnlock" type="java.lang.String">0</Field><Field name="KjmUnsubscribe" type="java.lang.String">0</Field><Field name="KlmAfterInt" type="java.lang.String">0</Field><Field name="KlmIdx" type="java.lang.String">0</Field><Field name="KlmJrn" type="java.lang.String">0</Field><Field name="KxmUsed" type="java.lang.String">null</Field><Field name="LastDate" type="java.sql.Timestamp">2012-12-20 14:38:47.0</Field><Field name="LastUser" type="java.lang.String">SUPERVISOR</Field><Field name="LogLevDet" type="java.lang.String">3</Field><Field name="OrdTrt" type="com.sunopsis.sql.DbInt">10</Field><Field name="SqlName" type="java.lang.String">Complie The java file</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpTxtHeader"><Field name="Enc" type="java.lang.String">null</Field><Field name="EncKey" type="java.lang.String">null</Field><Field name="ITxt" type="com.sunopsis.sql.DbInt">3317091</Field><Field name="ITxtOrig" type="com.sunopsis.sql.DbInt">102</Field><Field name="SqlIndGrp" type="java.lang.String">0</Field><Field name="Txt" type="java.lang.String">OdiOSCommand "-COMMAND=<%= odiRef.getOption("JAVA_HOME") %>/bin/javac -cp <%=odiRef.getOption("JAVA_CP_JAR")%> <%=odiRef.getOption("TEMP_JAVA_DIR")%>/SendMailTLS.java" "-ERR_FILE=<%=odiRef.getOption("TEMP_JAVA_DIR")%>/SendMailTLS_err.txt" "-OUT_FILE=<%=odiRef.getOption("TEMP_JAVA_DIR")%>/SendMailTLS_out.txt"</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpLineTrt"><Field name="AlwaysExe" type="java.lang.String">1</Field><Field name="ColConnectId" type="java.lang.String">null</Field><Field name="ColContextCode" type="java.lang.String">null</Field><Field name="ColIndCommit" type="java.lang.String">null</Field><Field name="ColIsolLevel" type="java.lang.String">null</Field><Field name="ColITxt" type="com.sunopsis.sql.DbInt">null</Field><Field name="ColLschemaName" type="java.lang.String">null</Field><Field name="ColPlanComp" type="java.lang.String">null</Field><Field name="ColTechno" type="java.lang.String">FILE</Field><Field name="DefConnectId" type="java.lang.String">null</Field><Field name="DefContextCode" type="java.lang.String">null</Field><Field name="DefIndCommit" type="java.lang.String">null</Field><Field name="DefIsolLevel" type="java.lang.String">null</Field><Field name="DefITxt" type="com.sunopsis.sql.DbInt">3318091</Field><Field name="DefLschemaName" type="java.lang.String">null</Field><Field name="DefPlanComp" type="java.lang.String">null</Field><Field name="DefTechno" type="java.lang.String">SUNOPSIS_API</Field><Field name="FirstDate" type="java.sql.Timestamp">2012-12-20 14:28:40.0</Field><Field name="FirstUser" type="java.lang.String">SUPERVISOR</Field><Field name="IndErr" type="java.lang.String">0</Field><Field name="IndLogFinalCmd" type="java.lang.String">0</Field><Field name="IndLogMethod" type="java.lang.String">null</Field><Field name="IndLogNb" type="java.lang.String">null</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="KcmAk" type="java.lang.String">0</Field><Field name="KcmCond" type="java.lang.String">0</Field><Field name="KcmErrDel" type="java.lang.String">0</Field><Field name="KcmJoin" type="java.lang.String">0</Field><Field name="KcmNull" type="java.lang.String">0</Field><Field name="KcmPk" type="java.lang.String">0</Field><Field name="KimDrvdSel" type="java.lang.String">0</Field><Field name="KimIdx" type="java.lang.String">0</Field><Field name="KimJrn" type="java.lang.String">0</Field><Field name="KimJrnPop" type="java.lang.String">0</Field><Field name="KjmCreate" type="java.lang.String">0</Field><Field name="KjmDrop" type="java.lang.String">0</Field><Field name="KjmExtend" type="java.lang.String">0</Field><Field name="KjmLock" type="java.lang.String">0</Field><Field name="KjmPurge" type="java.lang.String">0</Field><Field name="KjmSetInstall" type="java.lang.String">0</Field><Field name="KjmSetUninstall" type="java.lang.String">0</Field><Field name="KjmSubscribe" type="java.lang.String">0</Field><Field name="KjmTableOrder" type="java.lang.String">0</Field><Field name="KjmUnlock" type="java.lang.String">0</Field><Field name="KjmUnsubscribe" type="java.lang.String">0</Field><Field name="KlmAfterInt" type="java.lang.String">0</Field><Field name="KlmIdx" type="java.lang.String">0</Field><Field name="KlmJrn" type="java.lang.String">0</Field><Field name="KxmUsed" type="java.lang.String">null</Field><Field name="LastDate" type="java.sql.Timestamp">2012-12-20 14:38:47.0</Field><Field name="LastUser" type="java.lang.String">SUPERVISOR</Field><Field name="LogLevDet" type="java.lang.String">3</Field><Field name="OrdTrt" type="com.sunopsis.sql.DbInt">20</Field><Field name="SqlName" type="java.lang.String">Run the java file</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpTxtHeader"><Field name="Enc" type="java.lang.String">null</Field><Field name="EncKey" type="java.lang.String">null</Field><Field name="ITxt" type="com.sunopsis.sql.DbInt">3318091</Field><Field name="ITxtOrig" type="com.sunopsis.sql.DbInt">102</Field><Field name="SqlIndGrp" type="java.lang.String">0</Field><Field name="Txt" type="java.lang.String">OdiOSCommand "-COMMAND=<%= odiRef.getOption("JAVA_HOME") %>/bin/java -cp <%=odiRef.getOption("JAVA_CP_JAR")%>;<%=odiRef.getOption("TEMP_JAVA_DIR")%> SendMailTLS" "-ERR_FILE=<%=odiRef.getOption("TEMP_JAVA_DIR")%>/SendMailTLS_err.txt" "-OUT_FILE=<%=odiRef.getOption("TEMP_JAVA_DIR")%>/SendMailTLS_out.txt"</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpLineTrtUe"><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="IUserExit" type="com.sunopsis.sql.DbInt">756091</Field><Field name="OrdTrt" type="com.sunopsis.sql.DbInt">30</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpImportRep"><Field name="RepShortId" type="com.sunopsis.sql.DbInt">91</Field><Field name="RepTimestamp" type="java.lang.String">1334831213366</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpImportRep"><Field name="RepShortId" type="com.sunopsis.sql.DbInt">92</Field><Field name="RepTimestamp" type="java.lang.String">1343117459745</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpImportRep"><Field name="RepShortId" type="com.sunopsis.sql.DbInt">81</Field><Field name="RepTimestamp" type="java.lang.String">1334307846215</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpImportRep"><Field name="RepShortId" type="com.sunopsis.sql.DbInt">3</Field><Field name="RepTimestamp" type="java.lang.String">1321309358956</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpImportRep"><Field name="RepShortId" type="com.sunopsis.sql.DbInt">2</Field><Field name="RepTimestamp" type="java.lang.String">1277905827008</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpImportRep"><Field name="RepShortId" type="com.sunopsis.sql.DbInt">11</Field><Field name="RepTimestamp" type="java.lang.String">1322240471835</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpImportRep"><Field name="RepShortId" type="com.sunopsis.sql.DbInt">12</Field><Field name="RepTimestamp" type="java.lang.String">1330677667361</Field></Object><Object class="com.sunopsis.dwg.DwgExportSummary"><Field name="ExpTxtNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="InstObjNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="JoinColNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="JoinNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="KeyColNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="KeyNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="LinkDiagNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="MorigTxtNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="MtxtNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="OrigTxtNb" type="com.sunopsis.sql.DbInt">4</Field><Field name="OtherObjectsNb" type="com.sunopsis.sql.DbInt">16</Field><Field name="PlanAgentNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="StepNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="TxtNb" type="com.sunopsis.sql.DbInt">8</Field><Field name="UeOrigNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="UeUsedNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="VarPlanAgentNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="ScenTxtNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="OdiVersion" type="java.lang.String">11.1.1.6.0 - 19/12/2011</Field><Field name="OriginRepositoryID" type="com.sunopsis.sql.DbInt">91</Field><Field name="RepositoryVersion" type="java.lang.String">04.03.04.02</Field></Object></SunopsisExport>.
  2. 0

    Setting Up Data Services Problem!Urgent!:-(

    Oracle Community | 9 years ago | 627858
    com.sunopsis.tools.core.exception.SnpsSimpleMessageException: Unable to find a javac compiler; com.sun.tools.javac.Main is not on the classpath. Perhaps JAVA_HOME does not point to the JDK
  3. 0

    Errors While Migration

    Oracle Community | 7 years ago | 666728
    com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ### KEY com.sunopsis.res.object / DwgDuplicationTools.GeneralImportObjectFailureMsg### at com.sunopsis.dwg.i.a(i.java) at com.sunopsis.dwg.i.a(i.java) at com.sunopsis.dwg.DwgObject.a(DwgObject.java) at com.sunopsis.dwg.DwgObject.doImport(DwgObject.java) at com.sunopsis.dwg.DwgObject.importFromXml(DwgObject.java) at com.sunopsis.graphical.f.oy.f(oy.java) at com.sunopsis.graphical.f.lf.b(lf.java) at com.sunopsis.graphical.tools.utils.swingworker.v.call(v.java) at edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:176) at com.sunopsis.graphical.tools.utils.swingworker.l.run(l.java) at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:665) at edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:690) at java.lang.Thread.run(Unknown Source)Caused by: java.sql.SQLException: ORA-02291: integrity constraint (HYPWORK.FK_PACKAGE1) violated - parent key not found
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    ODI Error

    Oracle Community | 5 years ago | user10723402
    com.sunopsis.tools.core.exception.SnpsSimpleMessageException: ODI-10036: Importing object SNP_PROFMETH : Journal Data... failed.
  6. 0

    oracle DB table(source) to XML file(Target) , IKM XML control append

    Oracle Community | 6 years ago | Kumbar
    com.sunopsis.tools.core.exception.SnpsSimpleMessageException: Flow Control not possible if no Key is declared in your Target Datastore

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. com.sunopsis.tools.core.exception.SnpsSimpleMessageException

      Exception getOption("TEMP_JAVA_DIR") : Exception getOption("TEMP_JAVA_DIR") : Option does not exist ("TEMP_JAVA_DIR") BSF info: Send_mail at line: 0 column: columnNo out.print("<SunopsisExport><Admin RepositoryVersion=\"04.03.04.02\"/><Object class=\"com.sunopsis.dwg.dbobj.SnpTrt\"><Field name=\"ExtVersion\" type=\"java.lang.String\">null</Field><Field name=\"FirstDate\" type=\"java.sql.Timestamp\">2012-12-20 14:28:40.0</Field><Field name=\"FirstUser\" type=\"java.lang.String\">SUPERVISOR</Field><Field name=\"IndChange\" type=\"java.lang.String\">U</Field><Field name=\"IndJrnMethod\" type=\"java.lang.String\">S</Field><Field name=\"IndSuppSetBased\" type=\"java.lang.String\">null</Field><Field name=\"IntVersion\" type=\"com.sunopsis.sql.DbInt\">7</Field><Field name=\"IFolder\" type=\"com.sunopsis.sql.DbInt\">9091</Field><Field name=\"IProject\" type=\"com.sunopsis.sql.DbInt\">7091</Field><Field name=\"IScBaseTrt\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"IScOrigTrt\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"IScTrt\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"IState\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"ITxtTrtTxt\" type=\"com.sunopsis.sql.DbInt\">3311091</Field><Field name=\"KimMultiDserver\" type=\"java.lang.String\">0</Field><Field name=\"KmDefault\" type=\"java.lang.String\">0</Field><Field name=\"KmSrcTechno\" type=\"java.lang.String\">null</Field><Field name=\"KmTechno\" type=\"java.lang.String\">null</Field><Field name=\"KmVersion\" type=\"java.lang.String\">null</Field><Field name=\"LastDate\" type=\"java.sql.Timestamp\">2012-12-20 14:40:22.0</Field><Field name=\"LastUser\" type=\"java.lang.String\">SUPERVISOR</Field><Field name=\"LChecksum\" type=\"com.sunopsis.sql.DbInt\">2221</Field><Field name=\"LCode\" type=\"java.lang.String\">null</Field><Field name=\"OrdFolder\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"TrtName\" type=\"java.lang.String\">SendGmailTLS</Field><Field name=\"TrtType\" type=\"java.lang.String\">U</Field><Field name=\"VLastDate\" type=\"java.sql.Timestamp\">null</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpTxtHeader\"><Field name=\"Enc\" type=\"java.lang.String\">null</Field><Field name=\"EncKey\" type=\"java.lang.String\">null</Field><Field name=\"ITxt\" type=\"com.sunopsis.sql.DbInt\">3311091</Field><Field name=\"ITxtOrig\" type=\"com.sunopsis.sql.DbInt\">107</Field><Field name=\"SqlIndGrp\" type=\"java.lang.String\">0</Field><Field name=\"Txt\" type=\"java.lang.String\">COMPONENT NAME: SendGmailTLSAUTHOR: Bhabani Ranjan MahapatraEMAIL : bhabaniranjan@gmail.com BLOG : http://dwteam.inDESCRIPTION:This procedure is required to send email using gmail credentials.</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpOrigTxt\"><Field name=\"ITxtOrig\" type=\"com.sunopsis.sql.DbInt\">107</Field><Field name=\"OrigineName\" type=\"java.lang.String\">Edit Command</Field><Field name=\"SnpsCol\" type=\"java.lang.String\">I_TXT_TRT_TXT</Field><Field name=\"SnpsTable\" type=\"java.lang.String\">SNP_TRT</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpUserExit\"><Field name=\"ExtVersion\" type=\"java.lang.String\">null</Field><Field name=\"IndChange\" type=\"java.lang.String\">I</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"ITxtUeHelp\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ITxtValue\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"IUserExit\" type=\"com.sunopsis.sql.DbInt\">756091</Field><Field name=\"Position\" type=\"com.sunopsis.sql.DbInt\">30</Field><Field name=\"ShortValue\" type=\"java.lang.String\">0</Field><Field name=\"UeName\" type=\"java.lang.String\">DELETE_TEMP_FILES</Field><Field name=\"UeSdesc\" type=\"java.lang.String\">Remove temp files</Field><Field name=\"UeType\" type=\"java.lang.String\">C</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpUserExit\"><Field name=\"ExtVersion\" type=\"java.lang.String\">null</Field><Field name=\"IndChange\" type=\"java.lang.String\">I</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"ITxtUeHelp\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ITxtValue\" type=\"com.sunopsis.sql.DbInt\">3312091</Field><Field name=\"IUserExit\" type=\"com.sunopsis.sql.DbInt\">758091</Field><Field name=\"Position\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ShortValue\" type=\"java.lang.String\">null</Field><Field name=\"UeName\" type=\"java.lang.String\">BODY</Field><Field name=\"UeSdesc\" type=\"java.lang.String\">null</Field><Field name=\"UeType\" type=\"java.lang.String\">T</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpTxtHeader\"><Field name=\"Enc\" type=\"java.lang.String\">null</Field><Field name=\"EncKey\" type=\"java.lang.String\">null</Field><Field name=\"ITxt\" type=\"com.sunopsis.sql.DbInt\">3312091</Field><Field name=\"ITxtOrig\" type=\"com.sunopsis.sql.DbInt\">110</Field><Field name=\"SqlIndGrp\" type=\"java.lang.String\">0</Field><Field name=\"Txt\" type=\"java.lang.String\">Its a Mail from ODI Studio.\Thank You</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpOrigTxt\"><Field name=\"ITxtOrig\" type=\"com.sunopsis.sql.DbInt\">110</Field><Field name=\"OrigineName\" type=\"java.lang.String\">Text value</Field><Field name=\"SnpsCol\" type=\"java.lang.String\">I_TXT_VALUE</Field><Field name=\"SnpsTable\" type=\"java.lang.String\">SNP_USER_EXIT</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpUserExit\"><Field name=\"ExtVersion\" type=\"java.lang.String\">null</Field><Field name=\"IndChange\" type=\"java.lang.String\">I</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"ITxtUeHelp\" type=\"com.sunopsis.sql.DbInt\">3313091</Field><Field name=\"ITxtValue\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"IUserExit\" type=\"com.sunopsis.sql.DbInt\">759091</Field><Field name=\"Position\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ShortValue\" type=\"java.lang.String\"><?= java.lang.System.getProperty(\"java.home\").matches(\".*jre\")?java.lang.System.getProperty(\"java.home\")+\"/..\":java.lang.System.getProperty(\"java.home\") ?></Field><Field name=\"UeName\" type=\"java.lang.String\">JAVA_HOME</Field><Field name=\"UeSdesc\" type=\"java.lang.String\">Location of the JDK</Field><Field name=\"UeType\" type=\"java.lang.String\">V</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpTxtHeader\"><Field name=\"Enc\" type=\"java.lang.String\">null</Field><Field name=\"EncKey\" type=\"java.lang.String\">null</Field><Field name=\"ITxt\" type=\"com.sunopsis.sql.DbInt\">3313091</Field><Field name=\"ITxtOrig\" type=\"com.sunopsis.sql.DbInt\">111</Field><Field name=\"SqlIndGrp\" type=\"java.lang.String\">0</Field><Field name=\"Txt\" type=\"java.lang.String\">Examples:\t$ODI_JAVA_HOME on Unix \t%ODI_JAVA_HOME% on Windows\t/usr/lib/jvm/java-7-openjdk-amd64</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpOrigTxt\"><Field name=\"ITxtOrig\" type=\"com.sunopsis.sql.DbInt\">111</Field><Field name=\"OrigineName\" type=\"java.lang.String\">User Exit help</Field><Field name=\"SnpsCol\" type=\"java.lang.String\">I_TXT_UE_HELP</Field><Field name=\"SnpsTable\" type=\"java.lang.String\">SNP_USER_EXIT</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpUserExit\"><Field name=\"ExtVersion\" type=\"java.lang.String\">null</Field><Field name=\"IndChange\" type=\"java.lang.String\">I</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"ITxtUeHelp\" type=\"com.sunopsis.sql.DbInt\">3314091</Field><Field name=\"ITxtValue\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"IUserExit\" type=\"com.sunopsis.sql.DbInt\">765091</Field><Field name=\"Position\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ShortValue\" type=\"java.lang.String\">C:/oracle/product/11.1.1/Oracle_ODI_1/oracledi.sdk/lib/mail.jar</Field><Field name=\"UeName\" type=\"java.lang.String\">JAVA_CP_JAR</Field><Field name=\"UeSdesc\" type=\"java.lang.String\">Provide the jar name with location</Field><Field name=\"UeType\" type=\"java.lang.String\">V</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpTxtHeader\"><Field name=\"Enc\" type=\"java.lang.String\">null</Field><Field name=\"EncKey\" type=\"java.lang.String\">null</Field><Field name=\"ITxt\" type=\"com.sunopsis.sql.DbInt\">3314091</Field><Field name=\"ITxtOrig\" type=\"com.sunopsis.sql.DbInt\">111</Field><Field name=\"SqlIndGrp\" type=\"java.lang.String\">0</Field><Field name=\"Txt\" type=\"java.lang.String\">mail.jar is required for this java file.</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpUserExit\"><Field name=\"ExtVersion\" type=\"java.lang.String\">null</Field><Field name=\"IndChange\" type=\"java.lang.String\">I</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"ITxtUeHelp\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ITxtValue\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"IUserExit\" type=\"com.sunopsis.sql.DbInt\">761091</Field><Field name=\"Position\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ShortValue\" type=\"java.lang.String\"> admin@odistudio.com </Field><Field name=\"UeName\" type=\"java.lang.String\">FROM</Field><Field name=\"UeSdesc\" type=\"java.lang.String\">FROM</Field><Field name=\"UeType\" type=\"java.lang.String\">V</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpUserExit\"><Field name=\"ExtVersion\" type=\"java.lang.String\">null</Field><Field name=\"IndChange\" type=\"java.lang.String\">I</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"ITxtUeHelp\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ITxtValue\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"IUserExit\" type=\"com.sunopsis.sql.DbInt\">762091</Field><Field name=\"Position\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ShortValue\" type=\"java.lang.String\">Mail From ODI</Field><Field name=\"UeName\" type=\"java.lang.String\">SUBJECT</Field><Field name=\"UeSdesc\" type=\"java.lang.String\">Subject</Field><Field name=\"UeType\" type=\"java.lang.String\">V</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpUserExit\"><Field name=\"ExtVersion\" type=\"java.lang.String\">null</Field><Field name=\"IndChange\" type=\"java.lang.String\">I</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"ITxtUeHelp\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ITxtValue\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"IUserExit\" type=\"com.sunopsis.sql.DbInt\">763091</Field><Field name=\"Position\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ShortValue\" type=\"java.lang.String\">C:/Users/Public</Field><Field name=\"UeName\" type=\"java.lang.String\">TEMP_JAVA_DIR</Field><Field name=\"UeSdesc\" type=\"java.lang.String\">Temp Java File Location</Field><Field name=\"UeType\" type=\"java.lang.String\">V</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpUserExit\"><Field name=\"ExtVersion\" type=\"java.lang.String\">null</Field><Field name=\"IndChange\" type=\"java.lang.String\">U</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"ITxtUeHelp\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ITxtValue\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"IUserExit\" type=\"com.sunopsis.sql.DbInt\">764091</Field><Field name=\"Position\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ShortValue\" type=\"java.lang.String\">null</Field><Field name=\"UeName\" type=\"java.lang.String\">USERNAME</Field><Field name=\"UeSdesc\" type=\"java.lang.String\">null</Field><Field name=\"UeType\" type=\"java.lang.String\">T</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpUserExit\"><Field name=\"ExtVersion\" type=\"java.lang.String\">null</Field><Field name=\"IndChange\" type=\"java.lang.String\">U</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"ITxtUeHelp\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ITxtValue\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"IUserExit\" type=\"com.sunopsis.sql.DbInt\">757091</Field><Field name=\"Position\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ShortValue\" type=\"java.lang.String\">null</Field><Field name=\"UeName\" type=\"java.lang.String\">PASSWORD</Field><Field name=\"UeSdesc\" type=\"java.lang.String\">null</Field><Field name=\"UeType\" type=\"java.lang.String\">T</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpUserExit\"><Field name=\"ExtVersion\" type=\"java.lang.String\">null</Field><Field name=\"IndChange\" type=\"java.lang.String\">I</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"ITxtUeHelp\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ITxtValue\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"IUserExit\" type=\"com.sunopsis.sql.DbInt\">760091</Field><Field name=\"Position\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ShortValue\" type=\"java.lang.String\"> bhabaniranjan@gmail.com </Field><Field name=\"UeName\" type=\"java.lang.String\">TO</Field><Field name=\"UeSdesc\" type=\"java.lang.String\">Target User ID</Field><Field name=\"UeType\" type=\"java.lang.String\">V</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpLineTrt\"><Field name=\"AlwaysExe\" type=\"java.lang.String\">0</Field><Field name=\"ColConnectId\" type=\"java.lang.String\">null</Field><Field name=\"ColContextCode\" type=\"java.lang.String\">null</Field><Field name=\"ColIndCommit\" type=\"java.lang.String\">null</Field><Field name=\"ColIsolLevel\" type=\"java.lang.String\">null</Field><Field name=\"ColITxt\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ColLschemaName\" type=\"java.lang.String\">null</Field><Field name=\"ColPlanComp\" type=\"java.lang.String\">null</Field><Field name=\"ColTechno\" type=\"java.lang.String\">null</Field><Field name=\"DefConnectId\" type=\"java.lang.String\">null</Field><Field name=\"DefContextCode\" type=\"java.lang.String\">null</Field><Field name=\"DefIndCommit\" type=\"java.lang.String\">null</Field><Field name=\"DefIsolLevel\" type=\"java.lang.String\">null</Field><Field name=\"DefITxt\" type=\"com.sunopsis.sql.DbInt\">3315091</Field><Field name=\"DefLschemaName\" type=\"java.lang.String\">null</Field><Field name=\"DefPlanComp\" type=\"java.lang.String\">null</Field><Field name=\"DefTechno\" type=\"java.lang.String\">SUNOPSIS_API</Field><Field name=\"FirstDate\" type=\"java.sql.Timestamp\">2012-12-20 14:28:40.0</Field><Field name=\"FirstUser\" type=\"java.lang.String\">SUPERVISOR</Field><Field name=\"IndErr\" type=\"java.lang.String\">0</Field><Field name=\"IndLogFinalCmd\" type=\"java.lang.String\">0</Field><Field name=\"IndLogMethod\" type=\"java.lang.String\">null</Field><Field name=\"IndLogNb\" type=\"java.lang.String\">null</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"KcmAk\" type=\"java.lang.String\">0</Field><Field name=\"KcmCond\" type=\"java.lang.String\">0</Field><Field name=\"KcmErrDel\" type=\"java.lang.String\">0</Field><Field name=\"KcmJoin\" type=\"java.lang.String\">0</Field><Field name=\"KcmNull\" type=\"java.lang.String\">0</Field><Field name=\"KcmPk\" type=\"java.lang.String\">0</Field><Field name=\"KimDrvdSel\" type=\"java.lang.String\">0</Field><Field name=\"KimIdx\" type=\"java.lang.String\">0</Field><Field name=\"KimJrn\" type=\"java.lang.String\">0</Field><Field name=\"KimJrnPop\" type=\"java.lang.String\">0</Field><Field name=\"KjmCreate\" type=\"java.lang.String\">0</Field><Field name=\"KjmDrop\" type=\"java.lang.String\">0</Field><Field name=\"KjmExtend\" type=\"java.lang.String\">0</Field><Field name=\"KjmLock\" type=\"java.lang.String\">0</Field><Field name=\"KjmPurge\" type=\"java.lang.String\">0</Field><Field name=\"KjmSetInstall\" type=\"java.lang.String\">0</Field><Field name=\"KjmSetUninstall\" type=\"java.lang.String\">0</Field><Field name=\"KjmSubscribe\" type=\"java.lang.String\">0</Field><Field name=\"KjmTableOrder\" type=\"java.lang.String\">0</Field><Field name=\"KjmUnlock\" type=\"java.lang.String\">0</Field><Field name=\"KjmUnsubscribe\" type=\"java.lang.String\">0</Field><Field name=\"KlmAfterInt\" type=\"java.lang.String\">0</Field><Field name=\"KlmIdx\" type=\"java.lang.String\">0</Field><Field name=\"KlmJrn\" type=\"java.lang.String\">0</Field><Field name=\"KxmUsed\" type=\"java.lang.String\">null</Field><Field name=\"LastDate\" type=\"java.sql.Timestamp\">2012-12-20 14:38:47.0</Field><Field name=\"LastUser\" type=\"java.lang.String\">SUPERVISOR</Field><Field name=\"LogLevDet\" type=\"java.lang.String\">3</Field><Field name=\"OrdTrt\" type=\"com.sunopsis.sql.DbInt\">30</Field><Field name=\"SqlName\" type=\"java.lang.String\">Delete temporary files</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpTxtHeader\"><Field name=\"Enc\" type=\"java.lang.String\">null</Field><Field name=\"EncKey\" type=\"java.lang.String\">null</Field><Field name=\"ITxt\" type=\"com.sunopsis.sql.DbInt\">3315091</Field><Field name=\"ITxtOrig\" type=\"com.sunopsis.sql.DbInt\">102</Field><Field name=\"SqlIndGrp\" type=\"java.lang.String\">0</Field><Field name=\"Txt\" type=\"java.lang.String\">OdiFileDelete \"-FILE=") ; out.print(odiRef.getOption("TEMP_JAVA_DIR")) ; out.print("/SendMailTLS*\"</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpOrigTxt\"><Field name=\"ITxtOrig\" type=\"com.sunopsis.sql.DbInt\">102</Field><Field name=\"OrigineName\" type=\"java.lang.String\">Target Technology</Field><Field name=\"SnpsCol\" type=\"java.lang.String\">DEF_I_TXT</Field><Field name=\"SnpsTable\" type=\"java.lang.String\">SNP_LINE_TRT</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpLineTrt\"><Field name=\"AlwaysExe\" type=\"java.lang.String\">1</Field><Field name=\"ColConnectId\" type=\"java.lang.String\">null</Field><Field name=\"ColContextCode\" type=\"java.lang.String\">null</Field><Field name=\"ColIndCommit\" type=\"java.lang.String\">null</Field><Field name=\"ColIsolLevel\" type=\"java.lang.String\">null</Field><Field name=\"ColITxt\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ColLschemaName\" type=\"java.lang.String\">null</Field><Field name=\"ColPlanComp\" type=\"java.lang.String\">null</Field><Field name=\"ColTechno\" type=\"java.lang.String\">null</Field><Field name=\"DefConnectId\" type=\"java.lang.String\">null</Field><Field name=\"DefContextCode\" type=\"java.lang.String\">null</Field><Field name=\"DefIndCommit\" type=\"java.lang.String\">null</Field><Field name=\"DefIsolLevel\" type=\"java.lang.String\">null</Field><Field name=\"DefITxt\" type=\"com.sunopsis.sql.DbInt\">3316091</Field><Field name=\"DefLschemaName\" type=\"java.lang.String\">null</Field><Field name=\"DefPlanComp\" type=\"java.lang.String\">null</Field><Field name=\"DefTechno\" type=\"java.lang.String\">SUNOPSIS_API</Field><Field name=\"FirstDate\" type=\"java.sql.Timestamp\">2012-12-20 14:28:40.0</Field><Field name=\"FirstUser\" type=\"java.lang.String\">SUPERVISOR</Field><Field name=\"IndErr\" type=\"java.lang.String\">0</Field><Field name=\"IndLogFinalCmd\" type=\"java.lang.String\">0</Field><Field name=\"IndLogMethod\" type=\"java.lang.String\">null</Field><Field name=\"IndLogNb\" type=\"java.lang.String\">null</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"KcmAk\" type=\"java.lang.String\">0</Field><Field name=\"KcmCond\" type=\"java.lang.String\">0</Field><Field name=\"KcmErrDel\" type=\"java.lang.String\">0</Field><Field name=\"KcmJoin\" type=\"java.lang.String\">0</Field><Field name=\"KcmNull\" type=\"java.lang.String\">0</Field><Field name=\"KcmPk\" type=\"java.lang.String\">0</Field><Field name=\"KimDrvdSel\" type=\"java.lang.String\">0</Field><Field name=\"KimIdx\" type=\"java.lang.String\">0</Field><Field name=\"KimJrn\" type=\"java.lang.String\">0</Field><Field name=\"KimJrnPop\" type=\"java.lang.String\">0</Field><Field name=\"KjmCreate\" type=\"java.lang.String\">0</Field><Field name=\"KjmDrop\" type=\"java.lang.String\">0</Field><Field name=\"KjmExtend\" type=\"java.lang.String\">0</Field><Field name=\"KjmLock\" type=\"java.lang.String\">0</Field><Field name=\"KjmPurge\" type=\"java.lang.String\">0</Field><Field name=\"KjmSetInstall\" type=\"java.lang.String\">0</Field><Field name=\"KjmSetUninstall\" type=\"java.lang.String\">0</Field><Field name=\"KjmSubscribe\" type=\"java.lang.String\">0</Field><Field name=\"KjmTableOrder\" type=\"java.lang.String\">0</Field><Field name=\"KjmUnlock\" type=\"java.lang.String\">0</Field><Field name=\"KjmUnsubscribe\" type=\"java.lang.String\">0</Field><Field name=\"KlmAfterInt\" type=\"java.lang.String\">0</Field><Field name=\"KlmIdx\" type=\"java.lang.String\">0</Field><Field name=\"KlmJrn\" type=\"java.lang.String\">0</Field><Field name=\"KxmUsed\" type=\"java.lang.String\">null</Field><Field name=\"LastDate\" type=\"java.sql.Timestamp\">2012-12-20 14:38:47.0</Field><Field name=\"LastUser\" type=\"java.lang.String\">SUPERVISOR</Field><Field name=\"LogLevDet\" type=\"java.lang.String\">3</Field><Field name=\"OrdTrt\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"SqlName\" type=\"java.lang.String\">Create Java File</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpTxtHeader\"><Field name=\"Enc\" type=\"java.lang.String\">null</Field><Field name=\"EncKey\" type=\"java.lang.String\">null</Field><Field name=\"ITxt\" type=\"com.sunopsis.sql.DbInt\">3316091</Field><Field name=\"ITxtOrig\" type=\"com.sunopsis.sql.DbInt\">102</Field><Field name=\"SqlIndGrp\" type=\"java.lang.String\">2</Field><Field name=\"Txt\" type=\"java.lang.String\">OdiOutFile \"-FILE=") ; out.print(odiRef.getOption("TEMP_JAVA_DIR")) ; out.print("/SendMailTLS.java\"import java.util.Properties;import javax.mail.Message;import javax.mail.MessagingException;import javax.mail.PasswordAuthentication;import javax.mail.Session;import javax.mail.Transport;import javax.mail.internet.InternetAddress;import javax.mail.internet.MimeMessage; public class SendMailTLS {\tpublic static void main(String[] args) {\t\tfinal String username = \"") ; out.print(odiRef.getOption("USERNAME")) ; out.print("\";\t\tfinal String password = \"") ; out.print(odiRef.getOption("PASSWORD")) ; out.print("\";\t\tProperties props = new Properties();\t\tprops.put(\"mail.smtp.auth\", \"true\");\t\tprops.put(\"mail.smtp.starttls.enable\", \"true\");\t\tprops.put(\"mail.smtp.host\", \"smtp.gmail.com\");\t\tprops.put(\"mail.smtp.port\", \"587\");props.put(\u201cmail.smtp.socketFactory.port\u201d, \u201c587\u2033);props.put(\u201cmail.smtp.socketFactory.class\u201d,\u201djavax.net.tls.TLSSocketFactory\u201d); \t\tSession session = Session.getInstance(props,\t\t new javax.mail.Authenticator() {\t\t\tprotected PasswordAuthentication getPasswordAuthentication() {\t\t\t\treturn new PasswordAuthentication(username, password);\t\t\t}\t\t }); \t\ttry { \t\t\tMessage message = new MimeMessage(session);\t\t\tmessage.setFrom(new InternetAddress(\"") ; out.print(odiRef.getOption("FROM")) ; out.print("\"));\t\t\tmessage.setRecipients(Message.RecipientType.TO,\t\t\t\t\tInternetAddress.parse(\"") ; out.print(odiRef.getOption("TO")) ; out.print("\"));\t\t\tmessage.setSubject(\"") ; out.print(odiRef.getOption("SUBJECT")) ; out.print("\");\t\t\tmessage.setText(\"") ; out.print(odiRef.getOption("BODY")) ; out.print("\"); \t\t\tTransport.send(message); \t\t\tSystem.out.println(\"Done\"); \t\t} catch (MessagingException e) {\t\t\tthrow new RuntimeException(e);\t\t}\t}}</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpLineTrt\"><Field name=\"AlwaysExe\" type=\"java.lang.String\">1</Field><Field name=\"ColConnectId\" type=\"java.lang.String\">null</Field><Field name=\"ColContextCode\" type=\"java.lang.String\">null</Field><Field name=\"ColIndCommit\" type=\"java.lang.String\">null</Field><Field name=\"ColIsolLevel\" type=\"java.lang.String\">null</Field><Field name=\"ColITxt\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ColLschemaName\" type=\"java.lang.String\">null</Field><Field name=\"ColPlanComp\" type=\"java.lang.String\">null</Field><Field name=\"ColTechno\" type=\"java.lang.String\">FILE</Field><Field name=\"DefConnectId\" type=\"java.lang.String\">null</Field><Field name=\"DefContextCode\" type=\"java.lang.String\">null</Field><Field name=\"DefIndCommit\" type=\"java.lang.String\">null</Field><Field name=\"DefIsolLevel\" type=\"java.lang.String\">null</Field><Field name=\"DefITxt\" type=\"com.sunopsis.sql.DbInt\">3317091</Field><Field name=\"DefLschemaName\" type=\"java.lang.String\">null</Field><Field name=\"DefPlanComp\" type=\"java.lang.String\">null</Field><Field name=\"DefTechno\" type=\"java.lang.String\">SUNOPSIS_API</Field><Field name=\"FirstDate\" type=\"java.sql.Timestamp\">2012-12-20 14:28:40.0</Field><Field name=\"FirstUser\" type=\"java.lang.String\">SUPERVISOR</Field><Field name=\"IndErr\" type=\"java.lang.String\">0</Field><Field name=\"IndLogFinalCmd\" type=\"java.lang.String\">0</Field><Field name=\"IndLogMethod\" type=\"java.lang.String\">null</Field><Field name=\"IndLogNb\" type=\"java.lang.String\">null</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"KcmAk\" type=\"java.lang.String\">0</Field><Field name=\"KcmCond\" type=\"java.lang.String\">0</Field><Field name=\"KcmErrDel\" type=\"java.lang.String\">0</Field><Field name=\"KcmJoin\" type=\"java.lang.String\">0</Field><Field name=\"KcmNull\" type=\"java.lang.String\">0</Field><Field name=\"KcmPk\" type=\"java.lang.String\">0</Field><Field name=\"KimDrvdSel\" type=\"java.lang.String\">0</Field><Field name=\"KimIdx\" type=\"java.lang.String\">0</Field><Field name=\"KimJrn\" type=\"java.lang.String\">0</Field><Field name=\"KimJrnPop\" type=\"java.lang.String\">0</Field><Field name=\"KjmCreate\" type=\"java.lang.String\">0</Field><Field name=\"KjmDrop\" type=\"java.lang.String\">0</Field><Field name=\"KjmExtend\" type=\"java.lang.String\">0</Field><Field name=\"KjmLock\" type=\"java.lang.String\">0</Field><Field name=\"KjmPurge\" type=\"java.lang.String\">0</Field><Field name=\"KjmSetInstall\" type=\"java.lang.String\">0</Field><Field name=\"KjmSetUninstall\" type=\"java.lang.String\">0</Field><Field name=\"KjmSubscribe\" type=\"java.lang.String\">0</Field><Field name=\"KjmTableOrder\" type=\"java.lang.String\">0</Field><Field name=\"KjmUnlock\" type=\"java.lang.String\">0</Field><Field name=\"KjmUnsubscribe\" type=\"java.lang.String\">0</Field><Field name=\"KlmAfterInt\" type=\"java.lang.String\">0</Field><Field name=\"KlmIdx\" type=\"java.lang.String\">0</Field><Field name=\"KlmJrn\" type=\"java.lang.String\">0</Field><Field name=\"KxmUsed\" type=\"java.lang.String\">null</Field><Field name=\"LastDate\" type=\"java.sql.Timestamp\">2012-12-20 14:38:47.0</Field><Field name=\"LastUser\" type=\"java.lang.String\">SUPERVISOR</Field><Field name=\"LogLevDet\" type=\"java.lang.String\">3</Field><Field name=\"OrdTrt\" type=\"com.sunopsis.sql.DbInt\">10</Field><Field name=\"SqlName\" type=\"java.lang.String\">Complie The java file</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpTxtHeader\"><Field name=\"Enc\" type=\"java.lang.String\">null</Field><Field name=\"EncKey\" type=\"java.lang.String\">null</Field><Field name=\"ITxt\" type=\"com.sunopsis.sql.DbInt\">3317091</Field><Field name=\"ITxtOrig\" type=\"com.sunopsis.sql.DbInt\">102</Field><Field name=\"SqlIndGrp\" type=\"java.lang.String\">0</Field><Field name=\"Txt\" type=\"java.lang.String\">OdiOSCommand \"-COMMAND=") ; out.print( odiRef.getOption("JAVA_HOME") ) ; out.print("/bin/javac -cp ") ; out.print(odiRef.getOption("JAVA_CP_JAR")) ; out.print(" ") ; out.print(odiRef.getOption("TEMP_JAVA_DIR")) ; out.print("/SendMailTLS.java\" \"-ERR_FILE=") ; out.print(odiRef.getOption("TEMP_JAVA_DIR")) ; out.print("/SendMailTLS_err.txt\" \"-OUT_FILE=") ; out.print(odiRef.getOption("TEMP_JAVA_DIR")) ; out.print("/SendMailTLS_out.txt\"</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpLineTrt\"><Field name=\"AlwaysExe\" type=\"java.lang.String\">1</Field><Field name=\"ColConnectId\" type=\"java.lang.String\">null</Field><Field name=\"ColContextCode\" type=\"java.lang.String\">null</Field><Field name=\"ColIndCommit\" type=\"java.lang.String\">null</Field><Field name=\"ColIsolLevel\" type=\"java.lang.String\">null</Field><Field name=\"ColITxt\" type=\"com.sunopsis.sql.DbInt\">null</Field><Field name=\"ColLschemaName\" type=\"java.lang.String\">null</Field><Field name=\"ColPlanComp\" type=\"java.lang.String\">null</Field><Field name=\"ColTechno\" type=\"java.lang.String\">FILE</Field><Field name=\"DefConnectId\" type=\"java.lang.String\">null</Field><Field name=\"DefContextCode\" type=\"java.lang.String\">null</Field><Field name=\"DefIndCommit\" type=\"java.lang.String\">null</Field><Field name=\"DefIsolLevel\" type=\"java.lang.String\">null</Field><Field name=\"DefITxt\" type=\"com.sunopsis.sql.DbInt\">3318091</Field><Field name=\"DefLschemaName\" type=\"java.lang.String\">null</Field><Field name=\"DefPlanComp\" type=\"java.lang.String\">null</Field><Field name=\"DefTechno\" type=\"java.lang.String\">SUNOPSIS_API</Field><Field name=\"FirstDate\" type=\"java.sql.Timestamp\">2012-12-20 14:28:40.0</Field><Field name=\"FirstUser\" type=\"java.lang.String\">SUPERVISOR</Field><Field name=\"IndErr\" type=\"java.lang.String\">0</Field><Field name=\"IndLogFinalCmd\" type=\"java.lang.String\">0</Field><Field name=\"IndLogMethod\" type=\"java.lang.String\">null</Field><Field name=\"IndLogNb\" type=\"java.lang.String\">null</Field><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"KcmAk\" type=\"java.lang.String\">0</Field><Field name=\"KcmCond\" type=\"java.lang.String\">0</Field><Field name=\"KcmErrDel\" type=\"java.lang.String\">0</Field><Field name=\"KcmJoin\" type=\"java.lang.String\">0</Field><Field name=\"KcmNull\" type=\"java.lang.String\">0</Field><Field name=\"KcmPk\" type=\"java.lang.String\">0</Field><Field name=\"KimDrvdSel\" type=\"java.lang.String\">0</Field><Field name=\"KimIdx\" type=\"java.lang.String\">0</Field><Field name=\"KimJrn\" type=\"java.lang.String\">0</Field><Field name=\"KimJrnPop\" type=\"java.lang.String\">0</Field><Field name=\"KjmCreate\" type=\"java.lang.String\">0</Field><Field name=\"KjmDrop\" type=\"java.lang.String\">0</Field><Field name=\"KjmExtend\" type=\"java.lang.String\">0</Field><Field name=\"KjmLock\" type=\"java.lang.String\">0</Field><Field name=\"KjmPurge\" type=\"java.lang.String\">0</Field><Field name=\"KjmSetInstall\" type=\"java.lang.String\">0</Field><Field name=\"KjmSetUninstall\" type=\"java.lang.String\">0</Field><Field name=\"KjmSubscribe\" type=\"java.lang.String\">0</Field><Field name=\"KjmTableOrder\" type=\"java.lang.String\">0</Field><Field name=\"KjmUnlock\" type=\"java.lang.String\">0</Field><Field name=\"KjmUnsubscribe\" type=\"java.lang.String\">0</Field><Field name=\"KlmAfterInt\" type=\"java.lang.String\">0</Field><Field name=\"KlmIdx\" type=\"java.lang.String\">0</Field><Field name=\"KlmJrn\" type=\"java.lang.String\">0</Field><Field name=\"KxmUsed\" type=\"java.lang.String\">null</Field><Field name=\"LastDate\" type=\"java.sql.Timestamp\">2012-12-20 14:38:47.0</Field><Field name=\"LastUser\" type=\"java.lang.String\">SUPERVISOR</Field><Field name=\"LogLevDet\" type=\"java.lang.String\">3</Field><Field name=\"OrdTrt\" type=\"com.sunopsis.sql.DbInt\">20</Field><Field name=\"SqlName\" type=\"java.lang.String\">Run the java file</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpTxtHeader\"><Field name=\"Enc\" type=\"java.lang.String\">null</Field><Field name=\"EncKey\" type=\"java.lang.String\">null</Field><Field name=\"ITxt\" type=\"com.sunopsis.sql.DbInt\">3318091</Field><Field name=\"ITxtOrig\" type=\"com.sunopsis.sql.DbInt\">102</Field><Field name=\"SqlIndGrp\" type=\"java.lang.String\">0</Field><Field name=\"Txt\" type=\"java.lang.String\">OdiOSCommand \"-COMMAND=") ; out.print( odiRef.getOption("JAVA_HOME") ) ; out.print("/bin/java -cp ") ; out.print(odiRef.getOption("JAVA_CP_JAR")) ; out.print(";") ; out.print(odiRef.getOption("TEMP_JAVA_DIR")) ; out.print(" SendMailTLS\" \"-ERR_FILE=") ; out.print(odiRef.getOption("TEMP_JAVA_DIR")) ; out.print("/SendMailTLS_err.txt\" \"-OUT_FILE=") ; out.print(odiRef.getOption("TEMP_JAVA_DIR")) ; out.print("/SendMailTLS_out.txt\"</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpLineTrtUe\"><Field name=\"ITrt\" type=\"com.sunopsis.sql.DbInt\">123091</Field><Field name=\"IUserExit\" type=\"com.sunopsis.sql.DbInt\">756091</Field><Field name=\"OrdTrt\" type=\"com.sunopsis.sql.DbInt\">30</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpImportRep\"><Field name=\"RepShortId\" type=\"com.sunopsis.sql.DbInt\">91</Field><Field name=\"RepTimestamp\" type=\"java.lang.String\">1334831213366</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpImportRep\"><Field name=\"RepShortId\" type=\"com.sunopsis.sql.DbInt\">92</Field><Field name=\"RepTimestamp\" type=\"java.lang.String\">1343117459745</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpImportRep\"><Field name=\"RepShortId\" type=\"com.sunopsis.sql.DbInt\">81</Field><Field name=\"RepTimestamp\" type=\"java.lang.String\">1334307846215</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpImportRep\"><Field name=\"RepShortId\" type=\"com.sunopsis.sql.DbInt\">3</Field><Field name=\"RepTimestamp\" type=\"java.lang.String\">1321309358956</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpImportRep\"><Field name=\"RepShortId\" type=\"com.sunopsis.sql.DbInt\">2</Field><Field name=\"RepTimestamp\" type=\"java.lang.String\">1277905827008</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpImportRep\"><Field name=\"RepShortId\" type=\"com.sunopsis.sql.DbInt\">11</Field><Field name=\"RepTimestamp\" type=\"java.lang.String\">1322240471835</Field></Object><Object class=\"com.sunopsis.dwg.dbobj.SnpImportRep\"><Field name=\"RepShortId\" type=\"com.sunopsis.sql.DbInt\">12</Field><Field name=\"RepTimestamp\" type=\"java.lang.String\">1330677667361</Field></Object><Object class=\"com.sunopsis.dwg.DwgExportSummary\"><Field name=\"ExpTxtNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"InstObjNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"JoinColNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"JoinNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"KeyColNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"KeyNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"LinkDiagNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"MorigTxtNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"MtxtNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"OrigTxtNb\" type=\"com.sunopsis.sql.DbInt\">4</Field><Field name=\"OtherObjectsNb\" type=\"com.sunopsis.sql.DbInt\">16</Field><Field name=\"PlanAgentNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"StepNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"TxtNb\" type=\"com.sunopsis.sql.DbInt\">8</Field><Field name=\"UeOrigNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"UeUsedNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"VarPlanAgentNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"ScenTxtNb\" type=\"com.sunopsis.sql.DbInt\">0</Field><Field name=\"OdiVersion\" type=\"java.lang.String\">11.1.1.6.0 - 19/12/2011</Field><Field name=\"OriginRepositoryID\" type=\"com.sunopsis.sql.DbInt\">91</Field><Field name=\"RepositoryVersion\" type=\"java.lang.String\">04.03.04.02</Field></Object></SunopsisExport>") ; ****** ORIGINAL TEXT ****** <SunopsisExport><Admin RepositoryVersion="04.03.04.02"/><Object class="com.sunopsis.dwg.dbobj.SnpTrt"><Field name="ExtVersion" type="java.lang.String">null</Field><Field name="FirstDate" type="java.sql.Timestamp">2012-12-20 14:28:40.0</Field><Field name="FirstUser" type="java.lang.String">SUPERVISOR</Field><Field name="IndChange" type="java.lang.String">U</Field><Field name="IndJrnMethod" type="java.lang.String">S</Field><Field name="IndSuppSetBased" type="java.lang.String">null</Field><Field name="IntVersion" type="com.sunopsis.sql.DbInt">7</Field><Field name="IFolder" type="com.sunopsis.sql.DbInt">9091</Field><Field name="IProject" type="com.sunopsis.sql.DbInt">7091</Field><Field name="IScBaseTrt" type="com.sunopsis.sql.DbInt">null</Field><Field name="IScOrigTrt" type="com.sunopsis.sql.DbInt">null</Field><Field name="IScTrt" type="com.sunopsis.sql.DbInt">null</Field><Field name="IState" type="com.sunopsis.sql.DbInt">null</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="ITxtTrtTxt" type="com.sunopsis.sql.DbInt">3311091</Field><Field name="KimMultiDserver" type="java.lang.String">0</Field><Field name="KmDefault" type="java.lang.String">0</Field><Field name="KmSrcTechno" type="java.lang.String">null</Field><Field name="KmTechno" type="java.lang.String">null</Field><Field name="KmVersion" type="java.lang.String">null</Field><Field name="LastDate" type="java.sql.Timestamp">2012-12-20 14:40:22.0</Field><Field name="LastUser" type="java.lang.String">SUPERVISOR</Field><Field name="LChecksum" type="com.sunopsis.sql.DbInt">2221</Field><Field name="LCode" type="java.lang.String">null</Field><Field name="OrdFolder" type="com.sunopsis.sql.DbInt">null</Field><Field name="TrtName" type="java.lang.String">SendGmailTLS</Field><Field name="TrtType" type="java.lang.String">U</Field><Field name="VLastDate" type="java.sql.Timestamp">null</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpTxtHeader"><Field name="Enc" type="java.lang.String">null</Field><Field name="EncKey" type="java.lang.String">null</Field><Field name="ITxt" type="com.sunopsis.sql.DbInt">3311091</Field><Field name="ITxtOrig" type="com.sunopsis.sql.DbInt">107</Field><Field name="SqlIndGrp" type="java.lang.String">0</Field><Field name="Txt" type="java.lang.String">COMPONENT NAME: SendGmailTLS AUTHOR: Bhabani Ranjan Mahapatra EMAIL : bhabaniranjan@gmail.com BLOG : http://dwteam.in DESCRIPTION: This procedure is required to send email using gmail credentials.</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpOrigTxt"><Field name="ITxtOrig" type="com.sunopsis.sql.DbInt">107</Field><Field name="OrigineName" type="java.lang.String">Edit Command</Field><Field name="SnpsCol" type="java.lang.String">I_TXT_TRT_TXT</Field><Field name="SnpsTable" type="java.lang.String">SNP_TRT</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpUserExit"><Field name="ExtVersion" type="java.lang.String">null</Field><Field name="IndChange" type="java.lang.String">I</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="ITxtUeHelp" type="com.sunopsis.sql.DbInt">null</Field><Field name="ITxtValue" type="com.sunopsis.sql.DbInt">null</Field><Field name="IUserExit" type="com.sunopsis.sql.DbInt">756091</Field><Field name="Position" type="com.sunopsis.sql.DbInt">30</Field><Field name="ShortValue" type="java.lang.String">0</Field><Field name="UeName" type="java.lang.String">DELETE_TEMP_FILES</Field><Field name="UeSdesc" type="java.lang.String">Remove temp files</Field><Field name="UeType" type="java.lang.String">C</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpUserExit"><Field name="ExtVersion" type="java.lang.String">null</Field><Field name="IndChange" type="java.lang.String">I</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="ITxtUeHelp" type="com.sunopsis.sql.DbInt">null</Field><Field name="ITxtValue" type="com.sunopsis.sql.DbInt">3312091</Field><Field name="IUserExit" type="com.sunopsis.sql.DbInt">758091</Field><Field name="Position" type="com.sunopsis.sql.DbInt">null</Field><Field name="ShortValue" type="java.lang.String">null</Field><Field name="UeName" type="java.lang.String">BODY</Field><Field name="UeSdesc" type="java.lang.String">null</Field><Field name="UeType" type="java.lang.String">T</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpTxtHeader"><Field name="Enc" type="java.lang.String">null</Field><Field name="EncKey" type="java.lang.String">null</Field><Field name="ITxt" type="com.sunopsis.sql.DbInt">3312091</Field><Field name="ITxtOrig" type="com.sunopsis.sql.DbInt">110</Field><Field name="SqlIndGrp" type="java.lang.String">0</Field><Field name="Txt" type="java.lang.String">Its a Mail from ODI Studio.Thank You</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpOrigTxt"><Field name="ITxtOrig" type="com.sunopsis.sql.DbInt">110</Field><Field name="OrigineName" type="java.lang.String">Text value</Field><Field name="SnpsCol" type="java.lang.String">I_TXT_VALUE</Field><Field name="SnpsTable" type="java.lang.String">SNP_USER_EXIT</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpUserExit"><Field name="ExtVersion" type="java.lang.String">null</Field><Field name="IndChange" type="java.lang.String">I</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="ITxtUeHelp" type="com.sunopsis.sql.DbInt">3313091</Field><Field name="ITxtValue" type="com.sunopsis.sql.DbInt">null</Field><Field name="IUserExit" type="com.sunopsis.sql.DbInt">759091</Field><Field name="Position" type="com.sunopsis.sql.DbInt">null</Field><Field name="ShortValue" type="java.lang.String"><?= java.lang.System.getProperty("java.home").matches(".*jre")?java.lang.System.getProperty("java.home")+"/..":java.lang.System.getProperty("java.home") ?></Field><Field name="UeName" type="java.lang.String">JAVA_HOME</Field><Field name="UeSdesc" type="java.lang.String">Location of the JDK</Field><Field name="UeType" type="java.lang.String">V</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpTxtHeader"><Field name="Enc" type="java.lang.String">null</Field><Field name="EncKey" type="java.lang.String">null</Field><Field name="ITxt" type="com.sunopsis.sql.DbInt">3313091</Field><Field name="ITxtOrig" type="com.sunopsis.sql.DbInt">111</Field><Field name="SqlIndGrp" type="java.lang.String">0</Field><Field name="Txt" type="java.lang.String"> Examples: $ODI_JAVA_HOME on Unix %ODI_JAVA_HOME% on Windows /usr/lib/jvm/java-7-openjdk-amd64</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpOrigTxt"><Field name="ITxtOrig" type="com.sunopsis.sql.DbInt">111</Field><Field name="OrigineName" type="java.lang.String">User Exit help</Field><Field name="SnpsCol" type="java.lang.String">I_TXT_UE_HELP</Field><Field name="SnpsTable" type="java.lang.String">SNP_USER_EXIT</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpUserExit"><Field name="ExtVersion" type="java.lang.String">null</Field><Field name="IndChange" type="java.lang.String">I</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="ITxtUeHelp" type="com.sunopsis.sql.DbInt">3314091</Field><Field name="ITxtValue" type="com.sunopsis.sql.DbInt">null</Field><Field name="IUserExit" type="com.sunopsis.sql.DbInt">765091</Field><Field name="Position" type="com.sunopsis.sql.DbInt">null</Field><Field name="ShortValue" type="java.lang.String">C:/oracle/product/11.1.1/Oracle_ODI_1/oracledi.sdk/lib/mail.jar</Field><Field name="UeName" type="java.lang.String">JAVA_CP_JAR</Field><Field name="UeSdesc" type="java.lang.String">Provide the jar name with location</Field><Field name="UeType" type="java.lang.String">V</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpTxtHeader"><Field name="Enc" type="java.lang.String">null</Field><Field name="EncKey" type="java.lang.String">null</Field><Field name="ITxt" type="com.sunopsis.sql.DbInt">3314091</Field><Field name="ITxtOrig" type="com.sunopsis.sql.DbInt">111</Field><Field name="SqlIndGrp" type="java.lang.String">0</Field><Field name="Txt" type="java.lang.String">mail.jar is required for this java file.</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpUserExit"><Field name="ExtVersion" type="java.lang.String">null</Field><Field name="IndChange" type="java.lang.String">I</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="ITxtUeHelp" type="com.sunopsis.sql.DbInt">null</Field><Field name="ITxtValue" type="com.sunopsis.sql.DbInt">null</Field><Field name="IUserExit" type="com.sunopsis.sql.DbInt">761091</Field><Field name="Position" type="com.sunopsis.sql.DbInt">null</Field><Field name="ShortValue" type="java.lang.String"> admin@odistudio.com </Field><Field name="UeName" type="java.lang.String">FROM</Field><Field name="UeSdesc" type="java.lang.String">FROM</Field><Field name="UeType" type="java.lang.String">V</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpUserExit"><Field name="ExtVersion" type="java.lang.String">null</Field><Field name="IndChange" type="java.lang.String">I</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="ITxtUeHelp" type="com.sunopsis.sql.DbInt">null</Field><Field name="ITxtValue" type="com.sunopsis.sql.DbInt">null</Field><Field name="IUserExit" type="com.sunopsis.sql.DbInt">762091</Field><Field name="Position" type="com.sunopsis.sql.DbInt">null</Field><Field name="ShortValue" type="java.lang.String">Mail From ODI</Field><Field name="UeName" type="java.lang.String">SUBJECT</Field><Field name="UeSdesc" type="java.lang.String">Subject</Field><Field name="UeType" type="java.lang.String">V</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpUserExit"><Field name="ExtVersion" type="java.lang.String">null</Field><Field name="IndChange" type="java.lang.String">I</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="ITxtUeHelp" type="com.sunopsis.sql.DbInt">null</Field><Field name="ITxtValue" type="com.sunopsis.sql.DbInt">null</Field><Field name="IUserExit" type="com.sunopsis.sql.DbInt">763091</Field><Field name="Position" type="com.sunopsis.sql.DbInt">null</Field><Field name="ShortValue" type="java.lang.String">C:/Users/Public</Field><Field name="UeName" type="java.lang.String">TEMP_JAVA_DIR</Field><Field name="UeSdesc" type="java.lang.String">Temp Java File Location</Field><Field name="UeType" type="java.lang.String">V</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpUserExit"><Field name="ExtVersion" type="java.lang.String">null</Field><Field name="IndChange" type="java.lang.String">U</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="ITxtUeHelp" type="com.sunopsis.sql.DbInt">null</Field><Field name="ITxtValue" type="com.sunopsis.sql.DbInt">null</Field><Field name="IUserExit" type="com.sunopsis.sql.DbInt">764091</Field><Field name="Position" type="com.sunopsis.sql.DbInt">null</Field><Field name="ShortValue" type="java.lang.String">null</Field><Field name="UeName" type="java.lang.String">USERNAME</Field><Field name="UeSdesc" type="java.lang.String">null</Field><Field name="UeType" type="java.lang.String">T</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpUserExit"><Field name="ExtVersion" type="java.lang.String">null</Field><Field name="IndChange" type="java.lang.String">U</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="ITxtUeHelp" type="com.sunopsis.sql.DbInt">null</Field><Field name="ITxtValue" type="com.sunopsis.sql.DbInt">null</Field><Field name="IUserExit" type="com.sunopsis.sql.DbInt">757091</Field><Field name="Position" type="com.sunopsis.sql.DbInt">null</Field><Field name="ShortValue" type="java.lang.String">null</Field><Field name="UeName" type="java.lang.String">PASSWORD</Field><Field name="UeSdesc" type="java.lang.String">null</Field><Field name="UeType" type="java.lang.String">T</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpUserExit"><Field name="ExtVersion" type="java.lang.String">null</Field><Field name="IndChange" type="java.lang.String">I</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="ITxtUeHelp" type="com.sunopsis.sql.DbInt">null</Field><Field name="ITxtValue" type="com.sunopsis.sql.DbInt">null</Field><Field name="IUserExit" type="com.sunopsis.sql.DbInt">760091</Field><Field name="Position" type="com.sunopsis.sql.DbInt">null</Field><Field name="ShortValue" type="java.lang.String"> bhabaniranjan@gmail.com </Field><Field name="UeName" type="java.lang.String">TO</Field><Field name="UeSdesc" type="java.lang.String">Target User ID</Field><Field name="UeType" type="java.lang.String">V</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpLineTrt"><Field name="AlwaysExe" type="java.lang.String">0</Field><Field name="ColConnectId" type="java.lang.String">null</Field><Field name="ColContextCode" type="java.lang.String">null</Field><Field name="ColIndCommit" type="java.lang.String">null</Field><Field name="ColIsolLevel" type="java.lang.String">null</Field><Field name="ColITxt" type="com.sunopsis.sql.DbInt">null</Field><Field name="ColLschemaName" type="java.lang.String">null</Field><Field name="ColPlanComp" type="java.lang.String">null</Field><Field name="ColTechno" type="java.lang.String">null</Field><Field name="DefConnectId" type="java.lang.String">null</Field><Field name="DefContextCode" type="java.lang.String">null</Field><Field name="DefIndCommit" type="java.lang.String">null</Field><Field name="DefIsolLevel" type="java.lang.String">null</Field><Field name="DefITxt" type="com.sunopsis.sql.DbInt">3315091</Field><Field name="DefLschemaName" type="java.lang.String">null</Field><Field name="DefPlanComp" type="java.lang.String">null</Field><Field name="DefTechno" type="java.lang.String">SUNOPSIS_API</Field><Field name="FirstDate" type="java.sql.Timestamp">2012-12-20 14:28:40.0</Field><Field name="FirstUser" type="java.lang.String">SUPERVISOR</Field><Field name="IndErr" type="java.lang.String">0</Field><Field name="IndLogFinalCmd" type="java.lang.String">0</Field><Field name="IndLogMethod" type="java.lang.String">null</Field><Field name="IndLogNb" type="java.lang.String">null</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="KcmAk" type="java.lang.String">0</Field><Field name="KcmCond" type="java.lang.String">0</Field><Field name="KcmErrDel" type="java.lang.String">0</Field><Field name="KcmJoin" type="java.lang.String">0</Field><Field name="KcmNull" type="java.lang.String">0</Field><Field name="KcmPk" type="java.lang.String">0</Field><Field name="KimDrvdSel" type="java.lang.String">0</Field><Field name="KimIdx" type="java.lang.String">0</Field><Field name="KimJrn" type="java.lang.String">0</Field><Field name="KimJrnPop" type="java.lang.String">0</Field><Field name="KjmCreate" type="java.lang.String">0</Field><Field name="KjmDrop" type="java.lang.String">0</Field><Field name="KjmExtend" type="java.lang.String">0</Field><Field name="KjmLock" type="java.lang.String">0</Field><Field name="KjmPurge" type="java.lang.String">0</Field><Field name="KjmSetInstall" type="java.lang.String">0</Field><Field name="KjmSetUninstall" type="java.lang.String">0</Field><Field name="KjmSubscribe" type="java.lang.String">0</Field><Field name="KjmTableOrder" type="java.lang.String">0</Field><Field name="KjmUnlock" type="java.lang.String">0</Field><Field name="KjmUnsubscribe" type="java.lang.String">0</Field><Field name="KlmAfterInt" type="java.lang.String">0</Field><Field name="KlmIdx" type="java.lang.String">0</Field><Field name="KlmJrn" type="java.lang.String">0</Field><Field name="KxmUsed" type="java.lang.String">null</Field><Field name="LastDate" type="java.sql.Timestamp">2012-12-20 14:38:47.0</Field><Field name="LastUser" type="java.lang.String">SUPERVISOR</Field><Field name="LogLevDet" type="java.lang.String">3</Field><Field name="OrdTrt" type="com.sunopsis.sql.DbInt">30</Field><Field name="SqlName" type="java.lang.String">Delete temporary files</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpTxtHeader"><Field name="Enc" type="java.lang.String">null</Field><Field name="EncKey" type="java.lang.String">null</Field><Field name="ITxt" type="com.sunopsis.sql.DbInt">3315091</Field><Field name="ITxtOrig" type="com.sunopsis.sql.DbInt">102</Field><Field name="SqlIndGrp" type="java.lang.String">0</Field><Field name="Txt" type="java.lang.String">OdiFileDelete "-FILE=<%=odiRef.getOption("TEMP_JAVA_DIR")%>/SendMailTLS*"</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpOrigTxt"><Field name="ITxtOrig" type="com.sunopsis.sql.DbInt">102</Field><Field name="OrigineName" type="java.lang.String">Target Technology</Field><Field name="SnpsCol" type="java.lang.String">DEF_I_TXT</Field><Field name="SnpsTable" type="java.lang.String">SNP_LINE_TRT</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpLineTrt"><Field name="AlwaysExe" type="java.lang.String">1</Field><Field name="ColConnectId" type="java.lang.String">null</Field><Field name="ColContextCode" type="java.lang.String">null</Field><Field name="ColIndCommit" type="java.lang.String">null</Field><Field name="ColIsolLevel" type="java.lang.String">null</Field><Field name="ColITxt" type="com.sunopsis.sql.DbInt">null</Field><Field name="ColLschemaName" type="java.lang.String">null</Field><Field name="ColPlanComp" type="java.lang.String">null</Field><Field name="ColTechno" type="java.lang.String">null</Field><Field name="DefConnectId" type="java.lang.String">null</Field><Field name="DefContextCode" type="java.lang.String">null</Field><Field name="DefIndCommit" type="java.lang.String">null</Field><Field name="DefIsolLevel" type="java.lang.String">null</Field><Field name="DefITxt" type="com.sunopsis.sql.DbInt">3316091</Field><Field name="DefLschemaName" type="java.lang.String">null</Field><Field name="DefPlanComp" type="java.lang.String">null</Field><Field name="DefTechno" type="java.lang.String">SUNOPSIS_API</Field><Field name="FirstDate" type="java.sql.Timestamp">2012-12-20 14:28:40.0</Field><Field name="FirstUser" type="java.lang.String">SUPERVISOR</Field><Field name="IndErr" type="java.lang.String">0</Field><Field name="IndLogFinalCmd" type="java.lang.String">0</Field><Field name="IndLogMethod" type="java.lang.String">null</Field><Field name="IndLogNb" type="java.lang.String">null</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="KcmAk" type="java.lang.String">0</Field><Field name="KcmCond" type="java.lang.String">0</Field><Field name="KcmErrDel" type="java.lang.String">0</Field><Field name="KcmJoin" type="java.lang.String">0</Field><Field name="KcmNull" type="java.lang.String">0</Field><Field name="KcmPk" type="java.lang.String">0</Field><Field name="KimDrvdSel" type="java.lang.String">0</Field><Field name="KimIdx" type="java.lang.String">0</Field><Field name="KimJrn" type="java.lang.String">0</Field><Field name="KimJrnPop" type="java.lang.String">0</Field><Field name="KjmCreate" type="java.lang.String">0</Field><Field name="KjmDrop" type="java.lang.String">0</Field><Field name="KjmExtend" type="java.lang.String">0</Field><Field name="KjmLock" type="java.lang.String">0</Field><Field name="KjmPurge" type="java.lang.String">0</Field><Field name="KjmSetInstall" type="java.lang.String">0</Field><Field name="KjmSetUninstall" type="java.lang.String">0</Field><Field name="KjmSubscribe" type="java.lang.String">0</Field><Field name="KjmTableOrder" type="java.lang.String">0</Field><Field name="KjmUnlock" type="java.lang.String">0</Field><Field name="KjmUnsubscribe" type="java.lang.String">0</Field><Field name="KlmAfterInt" type="java.lang.String">0</Field><Field name="KlmIdx" type="java.lang.String">0</Field><Field name="KlmJrn" type="java.lang.String">0</Field><Field name="KxmUsed" type="java.lang.String">null</Field><Field name="LastDate" type="java.sql.Timestamp">2012-12-20 14:38:47.0</Field><Field name="LastUser" type="java.lang.String">SUPERVISOR</Field><Field name="LogLevDet" type="java.lang.String">3</Field><Field name="OrdTrt" type="com.sunopsis.sql.DbInt">0</Field><Field name="SqlName" type="java.lang.String">Create Java File</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpTxtHeader"><Field name="Enc" type="java.lang.String">null</Field><Field name="EncKey" type="java.lang.String">null</Field><Field name="ITxt" type="com.sunopsis.sql.DbInt">3316091</Field><Field name="ITxtOrig" type="com.sunopsis.sql.DbInt">102</Field><Field name="SqlIndGrp" type="java.lang.String">2</Field><Field name="Txt" type="java.lang.String">OdiOutFile "-FILE=<%=odiRef.getOption("TEMP_JAVA_DIR")%>/SendMailTLS.java" import java.util.Properties; import javax.mail.Message; import javax.mail.MessagingException; import javax.mail.PasswordAuthentication; import javax.mail.Session; import javax.mail.Transport; import javax.mail.internet.InternetAddress; import javax.mail.internet.MimeMessage; public class SendMailTLS { public static void main(String[] args) { final String username = "<%=odiRef.getOption("USERNAME")%>"; final String password = "<%=odiRef.getOption("PASSWORD")%>"; Properties props = new Properties(); props.put("mail.smtp.auth", "true"); props.put("mail.smtp.starttls.enable", "true"); props.put("mail.smtp.host", "smtp.gmail.com"); props.put("mail.smtp.port", "587"); props.put(“mail.smtp.socketFactory.port”, “587″); props.put(“mail.smtp.socketFactory.class”,”javax.net.tls.TLSSocketFactory”); Session session = Session.getInstance(props, new javax.mail.Authenticator() { protected PasswordAuthentication getPasswordAuthentication() { return new PasswordAuthentication(username, password); } }); try { Message message = new MimeMessage(session); message.setFrom(new InternetAddress("<%=odiRef.getOption("FROM")%>")); message.setRecipients(Message.RecipientType.TO, InternetAddress.parse("<%=odiRef.getOption("TO")%>")); message.setSubject("<%=odiRef.getOption("SUBJECT")%>"); message.setText("<%=odiRef.getOption("BODY")%>"); Transport.send(message); System.out.println("Done"); } catch (MessagingException e) { throw new RuntimeException(e); } } }</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpLineTrt"><Field name="AlwaysExe" type="java.lang.String">1</Field><Field name="ColConnectId" type="java.lang.String">null</Field><Field name="ColContextCode" type="java.lang.String">null</Field><Field name="ColIndCommit" type="java.lang.String">null</Field><Field name="ColIsolLevel" type="java.lang.String">null</Field><Field name="ColITxt" type="com.sunopsis.sql.DbInt">null</Field><Field name="ColLschemaName" type="java.lang.String">null</Field><Field name="ColPlanComp" type="java.lang.String">null</Field><Field name="ColTechno" type="java.lang.String">FILE</Field><Field name="DefConnectId" type="java.lang.String">null</Field><Field name="DefContextCode" type="java.lang.String">null</Field><Field name="DefIndCommit" type="java.lang.String">null</Field><Field name="DefIsolLevel" type="java.lang.String">null</Field><Field name="DefITxt" type="com.sunopsis.sql.DbInt">3317091</Field><Field name="DefLschemaName" type="java.lang.String">null</Field><Field name="DefPlanComp" type="java.lang.String">null</Field><Field name="DefTechno" type="java.lang.String">SUNOPSIS_API</Field><Field name="FirstDate" type="java.sql.Timestamp">2012-12-20 14:28:40.0</Field><Field name="FirstUser" type="java.lang.String">SUPERVISOR</Field><Field name="IndErr" type="java.lang.String">0</Field><Field name="IndLogFinalCmd" type="java.lang.String">0</Field><Field name="IndLogMethod" type="java.lang.String">null</Field><Field name="IndLogNb" type="java.lang.String">null</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="KcmAk" type="java.lang.String">0</Field><Field name="KcmCond" type="java.lang.String">0</Field><Field name="KcmErrDel" type="java.lang.String">0</Field><Field name="KcmJoin" type="java.lang.String">0</Field><Field name="KcmNull" type="java.lang.String">0</Field><Field name="KcmPk" type="java.lang.String">0</Field><Field name="KimDrvdSel" type="java.lang.String">0</Field><Field name="KimIdx" type="java.lang.String">0</Field><Field name="KimJrn" type="java.lang.String">0</Field><Field name="KimJrnPop" type="java.lang.String">0</Field><Field name="KjmCreate" type="java.lang.String">0</Field><Field name="KjmDrop" type="java.lang.String">0</Field><Field name="KjmExtend" type="java.lang.String">0</Field><Field name="KjmLock" type="java.lang.String">0</Field><Field name="KjmPurge" type="java.lang.String">0</Field><Field name="KjmSetInstall" type="java.lang.String">0</Field><Field name="KjmSetUninstall" type="java.lang.String">0</Field><Field name="KjmSubscribe" type="java.lang.String">0</Field><Field name="KjmTableOrder" type="java.lang.String">0</Field><Field name="KjmUnlock" type="java.lang.String">0</Field><Field name="KjmUnsubscribe" type="java.lang.String">0</Field><Field name="KlmAfterInt" type="java.lang.String">0</Field><Field name="KlmIdx" type="java.lang.String">0</Field><Field name="KlmJrn" type="java.lang.String">0</Field><Field name="KxmUsed" type="java.lang.String">null</Field><Field name="LastDate" type="java.sql.Timestamp">2012-12-20 14:38:47.0</Field><Field name="LastUser" type="java.lang.String">SUPERVISOR</Field><Field name="LogLevDet" type="java.lang.String">3</Field><Field name="OrdTrt" type="com.sunopsis.sql.DbInt">10</Field><Field name="SqlName" type="java.lang.String">Complie The java file</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpTxtHeader"><Field name="Enc" type="java.lang.String">null</Field><Field name="EncKey" type="java.lang.String">null</Field><Field name="ITxt" type="com.sunopsis.sql.DbInt">3317091</Field><Field name="ITxtOrig" type="com.sunopsis.sql.DbInt">102</Field><Field name="SqlIndGrp" type="java.lang.String">0</Field><Field name="Txt" type="java.lang.String">OdiOSCommand "-COMMAND=<%= odiRef.getOption("JAVA_HOME") %>/bin/javac -cp <%=odiRef.getOption("JAVA_CP_JAR")%> <%=odiRef.getOption("TEMP_JAVA_DIR")%>/SendMailTLS.java" "-ERR_FILE=<%=odiRef.getOption("TEMP_JAVA_DIR")%>/SendMailTLS_err.txt" "-OUT_FILE=<%=odiRef.getOption("TEMP_JAVA_DIR")%>/SendMailTLS_out.txt"</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpLineTrt"><Field name="AlwaysExe" type="java.lang.String">1</Field><Field name="ColConnectId" type="java.lang.String">null</Field><Field name="ColContextCode" type="java.lang.String">null</Field><Field name="ColIndCommit" type="java.lang.String">null</Field><Field name="ColIsolLevel" type="java.lang.String">null</Field><Field name="ColITxt" type="com.sunopsis.sql.DbInt">null</Field><Field name="ColLschemaName" type="java.lang.String">null</Field><Field name="ColPlanComp" type="java.lang.String">null</Field><Field name="ColTechno" type="java.lang.String">FILE</Field><Field name="DefConnectId" type="java.lang.String">null</Field><Field name="DefContextCode" type="java.lang.String">null</Field><Field name="DefIndCommit" type="java.lang.String">null</Field><Field name="DefIsolLevel" type="java.lang.String">null</Field><Field name="DefITxt" type="com.sunopsis.sql.DbInt">3318091</Field><Field name="DefLschemaName" type="java.lang.String">null</Field><Field name="DefPlanComp" type="java.lang.String">null</Field><Field name="DefTechno" type="java.lang.String">SUNOPSIS_API</Field><Field name="FirstDate" type="java.sql.Timestamp">2012-12-20 14:28:40.0</Field><Field name="FirstUser" type="java.lang.String">SUPERVISOR</Field><Field name="IndErr" type="java.lang.String">0</Field><Field name="IndLogFinalCmd" type="java.lang.String">0</Field><Field name="IndLogMethod" type="java.lang.String">null</Field><Field name="IndLogNb" type="java.lang.String">null</Field><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="KcmAk" type="java.lang.String">0</Field><Field name="KcmCond" type="java.lang.String">0</Field><Field name="KcmErrDel" type="java.lang.String">0</Field><Field name="KcmJoin" type="java.lang.String">0</Field><Field name="KcmNull" type="java.lang.String">0</Field><Field name="KcmPk" type="java.lang.String">0</Field><Field name="KimDrvdSel" type="java.lang.String">0</Field><Field name="KimIdx" type="java.lang.String">0</Field><Field name="KimJrn" type="java.lang.String">0</Field><Field name="KimJrnPop" type="java.lang.String">0</Field><Field name="KjmCreate" type="java.lang.String">0</Field><Field name="KjmDrop" type="java.lang.String">0</Field><Field name="KjmExtend" type="java.lang.String">0</Field><Field name="KjmLock" type="java.lang.String">0</Field><Field name="KjmPurge" type="java.lang.String">0</Field><Field name="KjmSetInstall" type="java.lang.String">0</Field><Field name="KjmSetUninstall" type="java.lang.String">0</Field><Field name="KjmSubscribe" type="java.lang.String">0</Field><Field name="KjmTableOrder" type="java.lang.String">0</Field><Field name="KjmUnlock" type="java.lang.String">0</Field><Field name="KjmUnsubscribe" type="java.lang.String">0</Field><Field name="KlmAfterInt" type="java.lang.String">0</Field><Field name="KlmIdx" type="java.lang.String">0</Field><Field name="KlmJrn" type="java.lang.String">0</Field><Field name="KxmUsed" type="java.lang.String">null</Field><Field name="LastDate" type="java.sql.Timestamp">2012-12-20 14:38:47.0</Field><Field name="LastUser" type="java.lang.String">SUPERVISOR</Field><Field name="LogLevDet" type="java.lang.String">3</Field><Field name="OrdTrt" type="com.sunopsis.sql.DbInt">20</Field><Field name="SqlName" type="java.lang.String">Run the java file</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpTxtHeader"><Field name="Enc" type="java.lang.String">null</Field><Field name="EncKey" type="java.lang.String">null</Field><Field name="ITxt" type="com.sunopsis.sql.DbInt">3318091</Field><Field name="ITxtOrig" type="com.sunopsis.sql.DbInt">102</Field><Field name="SqlIndGrp" type="java.lang.String">0</Field><Field name="Txt" type="java.lang.String">OdiOSCommand "-COMMAND=<%= odiRef.getOption("JAVA_HOME") %>/bin/java -cp <%=odiRef.getOption("JAVA_CP_JAR")%>;<%=odiRef.getOption("TEMP_JAVA_DIR")%> SendMailTLS" "-ERR_FILE=<%=odiRef.getOption("TEMP_JAVA_DIR")%>/SendMailTLS_err.txt" "-OUT_FILE=<%=odiRef.getOption("TEMP_JAVA_DIR")%>/SendMailTLS_out.txt"</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpLineTrtUe"><Field name="ITrt" type="com.sunopsis.sql.DbInt">123091</Field><Field name="IUserExit" type="com.sunopsis.sql.DbInt">756091</Field><Field name="OrdTrt" type="com.sunopsis.sql.DbInt">30</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpImportRep"><Field name="RepShortId" type="com.sunopsis.sql.DbInt">91</Field><Field name="RepTimestamp" type="java.lang.String">1334831213366</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpImportRep"><Field name="RepShortId" type="com.sunopsis.sql.DbInt">92</Field><Field name="RepTimestamp" type="java.lang.String">1343117459745</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpImportRep"><Field name="RepShortId" type="com.sunopsis.sql.DbInt">81</Field><Field name="RepTimestamp" type="java.lang.String">1334307846215</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpImportRep"><Field name="RepShortId" type="com.sunopsis.sql.DbInt">3</Field><Field name="RepTimestamp" type="java.lang.String">1321309358956</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpImportRep"><Field name="RepShortId" type="com.sunopsis.sql.DbInt">2</Field><Field name="RepTimestamp" type="java.lang.String">1277905827008</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpImportRep"><Field name="RepShortId" type="com.sunopsis.sql.DbInt">11</Field><Field name="RepTimestamp" type="java.lang.String">1322240471835</Field></Object><Object class="com.sunopsis.dwg.dbobj.SnpImportRep"><Field name="RepShortId" type="com.sunopsis.sql.DbInt">12</Field><Field name="RepTimestamp" type="java.lang.String">1330677667361</Field></Object><Object class="com.sunopsis.dwg.DwgExportSummary"><Field name="ExpTxtNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="InstObjNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="JoinColNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="JoinNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="KeyColNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="KeyNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="LinkDiagNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="MorigTxtNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="MtxtNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="OrigTxtNb" type="com.sunopsis.sql.DbInt">4</Field><Field name="OtherObjectsNb" type="com.sunopsis.sql.DbInt">16</Field><Field name="PlanAgentNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="StepNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="TxtNb" type="com.sunopsis.sql.DbInt">8</Field><Field name="UeOrigNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="UeUsedNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="VarPlanAgentNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="ScenTxtNb" type="com.sunopsis.sql.DbInt">0</Field><Field name="OdiVersion" type="java.lang.String">11.1.1.6.0 - 19/12/2011</Field><Field name="OriginRepositoryID" type="com.sunopsis.sql.DbInt">91</Field><Field name="RepositoryVersion" type="java.lang.String">04.03.04.02</Field></Object></SunopsisExport>.

      at com.sunopsis.dwg.dbobj.SnpSessStep.createTaskLogs()
    2. com.sunopsis.dwg
      SnpSession.treatSession
      1. com.sunopsis.dwg.dbobj.SnpSessStep.createTaskLogs(SnpSessStep.java:764)
      2. com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:465)
      3. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)
      3 frames
    3. oracle.odi.runtime
      StartSessRequestProcessor$2.doAction
      1. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:366)
      1 frame
    4. oracle.odi.core
      DwgObjectTemplate.execute
      1. oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
      1 frame
    5. oracle.odi.runtime
      DefaultAgentTaskExecutor$2.run
      1. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:300)
      2. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:292)
      3. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:855)
      4. oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
      5. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
      5 frames
    6. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:745)
      1 frame