teiid | data virtualization system that allows applications | Storage library

I have a connection defined in standalone.xml to be able to release a connection upon idle timeout. I have noticed sometimes the connection is not releasing from SQL server DB even after the query has completed. The other scenario I would like to address is how to release a connection on a hung query even though its been cancelled from TEIID. Currently I have to manually kill the session to release the connection using the WILDFLY CLI.

If I have series of functions in python that I want to call from TEIID VDB as UDF. Is that possible without having to convert it to native Java based code ? Can this be done using Jython ?

I am trying out this starter for the first time using this example : rdbms

But i am getting the below exception: Cannot invoke "org.teiid.spring.common.ExternalSource.getTranslatorName()" because "es" is null

I have a default Teiid 12.2 installation on RHEL 8.

Now I'm trying to configure an ODBC connection that would be used by PHP.

This always results in an error "[unixODBC]received invalid response to GSSAPI negotiation: R"

This is my ODBC configuration

Where can I set the locale for translators and what is the accepted format. E.g. I have seen instances where the locale is set as nl_NL, nl-NL. I want to force the locale of Teiid Springboot to be UTF-8 in order to make sure that ORDER BY clauses are correctly pushed down to the source. I figured that I have to set org.teiid.collationLocale, but the documentation for the correct locale points to an outdated Java 6 page. https://teiid.github.io/teiid-documents/master/sb/admin/System_Properties.html

We use the default Teiid Oracle translator and use Hikari for our datasources. The documentation of the translators points to setting the collation for translators in the execution factory; As far as I know we don't use those right now. https://teiid.github.io/teiid-documents/master/sb/dev/Translator_Capabilities.html

What are the steps I should take to force the locale for the engine to UTF-8 and do the same for the translators?

Note: we use a DDL with data wrappers to specify our connection to our Oracle sources.

Please let me know if we can configure server side validation logic in vdb.xml file to validate the user input before insert values into database using teiid wildfly odata4 service.

Thanks.

I am using teiid-wildfly servers. I followed the user defined functions example provided in teiid documentation. Below is my vdb file. Please let me know if I need to import any additional properties to view/access user defined functions. Metadata URL(http://localhost:8080/odata4/UDFTest/JavaCall/$metadata) does not list user defined function and no error in the server log. I created jar file which contains TempConv file implementation and completed the setup under module directory.

While scouting the documentation we found the following properties that we want to set.

• max-source-rows-allowed
• exception-on-max-source-rows

Found on the following page: https://teiid.github.io/teiid-documents/16.0.x/content/admin/Other_Considerations.html

However, we have tried several ways to set these without avail. The properties are not listed on the following page. https://github.com/teiid/teiid-spring-boot/blob/master/docs/Reference.adoc

How can we set these properties?

For our Teiid Springboot project we use a row filter in a where clause to determine what results a user gets. Example: