m-Power Manual

Sample External Object (Java) Source Code   package MRCWORKLIB; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import org.apache.log4j.Logger; import com.mrc.dbo.MrcConnection; /**  * Delete Order # from MRCWORKLIB.ORDDET  * 2011-09-22  * @author RH  *  * 2. Define external object  *  * Class Name: MRCWORKLIB.DELDETAIL  * Method Name: run  * Then define one object parm to Read the rest of this document »

Calling a Sample External Object (Java)   This document will explain how to create, register, and call a sample External Object written in Java. Recall from basic training that the purpose of an External Object is to call your back-end business logic directly through an m-Power web application. In this case, the purpose of this Read the rest of this document »

Validating via a Java External Object   This document will explain how to call an external object Java program for validity checking. For basic information regarding validity checking please see this document. The source code for the Java used in this example can be found here. The purpose of this object is to check to Read the rest of this document »

Validating via a Java External Object Source Code   package MRCWORKLIB; public class Validate {     public void valid_fields(String[] args)     {         String strdatex = args[1].replaceAll(“,”, “”);         String enddatex = args[2].replaceAll(“,”, “”);         int strdate = Integer.parseInt(strdatex);         int enddate= Integer.parseInt(enddatex);         if ((strdatex.compareTo(“0″) == 0 ) && (enddatex.compareTo(“0″) == 0 ))             {             args[0] = “You have not entered any Read the rest of this document »

Add/Subtract Dates using the Java Date Translator   The Java Date Translator is a very powerful tool, commonly used to determine the difference between two dates (Most date conversion can now be accomplished with a UDF). However, there is an often overlooked feature that has proved to be useful to a number of our clients, Read the rest of this document »

Java File Copy   The Java File Copy feature makes it simple to copy data tables from one DB to another. This feature works on any OS and any DB supported by m-Power. The JDBC connection property information is required for each execution of this feature and includes that as part of the parameters set. Read the rest of this document »

Java Date Translator (External Object)   mrc supplies a date translator specifically for use with generated Web/Servlet applications. This Java class is named mrc.servlet.MrcDateTranslator and resides in mrcextobj.jar. The object definition is shown below. If this object definition is not on your system, then a cumulative update from August 1, 2004 or later will install Read the rest of this document »