I am using teiid embedded and i have some slow queries, need to use java logic to enhance the performance.
1- I have checked the documentation and found this:
"The use of the zip lib for dependency loading is not enabled in Embedded." what does it mean ?
2-I have tried to make a zip file as mentioned here: https://docs.jboss.org/author/display/TEIID/Dynamic+VDBs
My VDB looks like that:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<vdb name="udf" version="1">
<model name="custom-functions" type="VIRTUAL">
CREATE VIRTUAL FUNCTION celsiusToFahrenheit(celsius decimal) RETURNS decimal OPTIONS (JAVA_CLASS 'pocUDF.TempConv', JAVA_METHOD 'celsiusToFahrenheit'); ]]> </metadata>
and the class file jar is attached,
i get exception:
TEIID30387 Could not load UDF "celsiusToFahrenheit", since its invocation class "pocUDF.TempConv" could not be found.
What did i miss?
In server environment, the jar file can be packaged with your VDB and that will be loaded automatically by deployment process. In embedded this does not work, and you have to provide the jar on the classpath.