baztian
Improve documentation for novices
(See post on stackoverflow and Issue #67)
As stated in the REAMDE JayDeBeApi implements Python DB-API v2.0. Basically you have to call the execute on a cursor and pass the insert statement.
But you are right. Some more guidance for novices would be nice. Mybe the Python Wiki or the docs for the sqlite implementation give you some guidance.
I would also like to see improved documentation around what can be passed to the connect(). I'm running into this problem:
jpype._jexception.TeiidSQLExceptionPyRaisable: org.teiid.jdbc.TeiidSQLException: TEIID20020 Error establishing socket to host and port: [url]:[port]. Reason: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
Seems like this problem could be resolved by explicitly passing the path to the Java keystore, but I can't find any documentation about what arguments I can pass to the connect() and I'm not sure where jpype is looking for the key store.
Authenticating with Java is a pain. I couldn't pass the keystore to the JVM. I solved this with https://keystore-explorer.org/ adding the cert to the cacerts. To open cacerts you need to run keystore-explorer as root.
@swardlincoln - Even I am facing this exact issue. I tried adding certificates to the cacerts, it just works fine with other applications but I am also confused about the path that jPype is looking for the key store. Were you able to figure out any solution for it ?
