Hi I have complete working code to connect and update database sybase iq via JDBC. Currently I am giving user name and password of sybase iq database. But I would like to authenticate user with his Kerberos login details and not the login details of sybase iq database.
Is it possible to achieve Kerberos authentication through any JDBC driver especially pure java driver? I am new to JDBC. Please guide. Thanks in advance.
You can use Kerberos authentication with both the SQL Anywhere JDBC Driver and the jConnect JDBC Driver. jConnect is pure JAVA whereas the SQL Anywhere JDBC Driver is a Type-2 Driver. Note though that for both SQL Anywhere and IQ, the SQL Anywhere JDBC Driver quite often outperforms jConnect even though jConnect is a Type-4 Driver.
However, as I said above, both drivers can be used for Kerberos authentication. You can either consult your IQ documentation on how to prepare your database for Kerberos authentication or you can refer to the SQL Anywhere documentation since both apply. The SQL Anywhere Documentation can be found at:
The "See also" section of the above documentation has additional links for using jConnect. If you decide on the SQL Anywhere JDBC Driver instead, then in addition to reviewing the above link, you should also look at the following:
answered 11 Jul '13, 07:38