-
1. Re: Teiid, Dynamic VDB and Jar Customize function
Ramesh Reddy Jun 26, 2017 2:48 PM (in response to parrotola)Look at "Post Code Activities" section in Support for User-Defined Functions(Non-Pushdown) · Teiid Documentation
-
2. Re: Teiid, Dynamic VDB and Jar Customize function
parrotola Jun 28, 2017 3:59 AM (in response to Ramesh Reddy)Hi Ramesh,
should I addd the configuration to standard-teiid-xml?
ty
-
3. Re: Teiid, Dynamic VDB and Jar Customize function
parrotola Jun 29, 2017 3:33 AM (in response to parrotola)Hi Ramesh,
thank you for you help. When I use my customize Jar, I have this problem:
Errore SQL [30328] [50000]: TEIID30328 Remote org.teiid.api.exception.query.ExpressionEvaluationException: TEIID30328 Unable to evaluate lookupdbpedia('http', '172.31.43.222', '1112', 'New York', 'PopulatedPlace', ''): TEIID30384 Error while evaluating function ViewModel.lookupdbpedia
TEIID30328 Remote org.teiid.api.exception.query.ExpressionEvaluationException: TEIID30328 Unable to evaluate lookupdbpedia('http', '172.31.43.222', '1112', 'New York, 'PopulatedPlace', ''): TEIID30384 Error while evaluating function ViewModel.lookupdbpedia
TEIID30328 Remote org.teiid.api.exception.query.ExpressionEvaluationException: TEIID30328 Unable to evaluate lookupdbpedia('http', '172.31.43.222', '1112', 'New York', 'PopulatedPlace', ''): TEIID30384 Error while evaluating function ViewModel.lookupdbpedia
TEIID30384 Remote org.teiid.api.exception.query.FunctionExecutionException: TEIID30384 Error while evaluating function ViewModel.lookupdbpedia
javax.xml.parsers.FactoryConfigurationError: Remote javax.xml.parsers.FactoryConfigurationError: Provider __redirected.__SAXParserFactory could not be instantiated: java.lang.ClassCastException: __redirected.__SAXParserFactory cannot be cast to javax.xml.parsers.SAXParserFactory
Jaxb library are used in customize Jar and hence I added that in the module.xml file:
<?xml version="1.0" ?>
<module xmlns="urn:jboss:module:1.1" name="lookup">
<resources>
<resource-root path="dbpediaLookUp.jar"/>
<resource-root path="rt.jar"/>
</resources>
</module>
If I used the dependences in the module.xml file, didn't work but If I add the rt.jar ( jaxb jar) it work! This library are already present in JVM.
thank you for all.
-
4. Re: Teiid, Dynamic VDB and Jar Customize function
Ramesh Reddy Jun 29, 2017 6:45 AM (in response to parrotola)In your module.xml file, you can also try
<dependencies>
<module name="com.sun.xml.bind" />
</dependencies>
That way you do not have to provide the "rt.jar" file. Most of the all the JVM related libraries are there in Wildfly module system, you just need to find it.