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
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  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>.

    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