Is there a way to use python3 interpreter to access databases?

Matillion ETL
1

The Jython interpreter requires some access settings to be configured, as we get unnamed module error. I wanted to move away from Jython interpreter to python. The documentation says we cannot. Is this allowed now?

2

hi @Varada​

Could you please share sample code? to check if that can be moved?

3

@ASD​ Any script that uses cursor = context.cursor(), requires Jython interpreter. e.g

myCursor = context.cursor()

myQuery = "select * from example"

myResultSet = myCursor.execute(myQuery)

THe Jython interpreter fails while making REST API query if we use version of JVM more than 1.8. e.g

requests.get(url,headers). We get the following error:

requests.exceptions.ConnectionError: ('Connection aborted.', error(-1, u'Unmapped exception: java.lang.IllegalAccessException: class org.python.core.PyReflectedFunction cannot access class sun.security.x509.X509CertImpl (in module java.base) because module java.base does not export sun.security.x509 to unnamed module @36aa52d2')) in <script> at line number 101"

We have to set the following environment variable for JVM.

--add-exports java.base/sun.security.x509=ALL-UNNAMED