Hi,
I have a fairly complex Pentaho (Kettle) ETL process that is now taking longer than 10 hours to complete. It opens up connections at different points to kerberos protected databases.
The kerberos authentication is fine and works, but only until the Kerberos ticket expires at 10 hours. We have an external process that refreshes the ticket cache file before the 10 hours is up so the actual cache file contains a non-expired ticket. However, Pentaho reads the Kerberos ticket cache at the start using the parameter:
-Doracle.net.kerberos5_cc_name=/tmp/myticket
Now I am not sure what is responsible for reading the Kerberos ticket cache... is it Java itself through java.security or is it the Oracle JDBC library through oracle.net (given that is where the ticket cache location is specified)? I have tried to find API documentation for oracle.net but have given up on Google and docs.oracle.com as they point me to Oracle .NET articles.
Is there a way to have Pentaho / Java re-read the ticket cache file every X hours or have the Oracle JDBC library re-read the ticket cache on every new connection?
Cheers,
P.