Snowflake JDBC Driver class path

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"/>