Hi
I am trying to integrate a new jdbc application into sailpoint. its a snowflake database. kindly help me know if sailpoint (version 8.0p2) supports jdbc driver for snowflake database?
if so kindly help me get its JDBC driver class path?
| Version | 8.0p2 b571b9dead1-20200329-164036 |
|---|---|
| E-Fixes | None |
| Schema Version | 8.0-09 |
I believe the driver path is net.snowflake.client.jdbc.SnowflakeDriver . You should get this driver directly from Snowflake and place it in the WEB-INF/lib folder and restart your server (been awhile since I’ve done this, so let me know if it doesn’t work).
Another thing that popped up when searching for this solution was this piece of advice, when configuring your app if you receive an error " ResultSet Type 1004 is not supported" :
Snowflake driver supports ‘TYPE_FORWARD_ONLY’, Please add below entry in the application XML and see if that resolves the issue.
<entry key="resultSetType" value="TYPE_FORWARD_ONLY"/>
Hi Adam
Thank you for your reply. So we are trying to add the jar thru build.xml and we keep getting below error. any thoughts on this?
No public execute() in class com.snowflake.client.jdbc.SnowflakeDriver
