Writing the Java Code required by the UDF

The number of input arguments and types must match the function metadata defined in Designer or on Dynamic VDB metadata.

Code Requirements For UDFs

• The java class containing the function method must be defined public.

• The function method must be public and static.

Code Requirements For UDAFs

• The java class containing the function method must be defined public and extend org.teiid.UserDefinedAggregate

• The function method must be public.

Other Considerations

• Any exception can be thrown, but Teiid will rethrow the exception as a FunctionExecutionException .

• You may optionally add an additional org.teiid.CommandContext argument as the first parameter. The CommandContext interface provides access to information about the current command, such as the executing user, Subject, the vdb, the session id, etc. This CommandContext parameter should not be declared in the function metadata.

package org.something;

public class TempConv
{
   /**
   * Converts the given Celsius temperature to Fahrenheit, and returns the
   * value.
   * @param doubleCelsiusTemp
   * @return Fahrenheit
   */
   public static Double celsiusToFahrenheit(Double doubleCelsiusTemp)
   {
      if (doubleCelsiusTemp == null)
      {
         return null;
      }
      return (doubleCelsiusTemp)*9/5 + 32;
   }
}

package org.something;

public static class SumAll implements UserDefinedAggregate<Integer> {

	private boolean isNull = true;
	private int result;

	public void addInput(Integer... vals) {
		isNull = false;
		for (int i : vals) {
			result += i;
		}
	}

	@Override
	public Integer getResult(org.teiid.CommandContext commandContext) {
		if (isNull) {
			return null;
		}
		return result;
	}

	@Override
	public void reset() {
		isNull = true;
		result = 0;
	}

}

package org.something;

public class SessionInfo
{
   /**
   * @param context
   * @return the created Timestamp
   */
   public static Timestamp sessionCreated(CommandContext context)
   {
      return new Timestamp(context.getSession().getCreatedTime());
   }
}

The corresponding UDF would be declared as Timestamp sessionCreated().

Zip Deployment

The JAR file may be placed in your VDB under the "/lib" directory. It will automatically be used for the VDB classloader classpath when deployed.

AS Module

Create a JBoss AS module with the JAR file under <jboss-as>/modules directory and define the module on the -vdb.xml file as shown below example

<vdb name="{vdb-name}" version="1">
    <property name ="lib" value ="{module-name}"></property>
     ...
</vdb>

The lib property value may contain a space delimited list of module names if more than one dependency is needed.