Hi Everybody, I'm trying to connect JasperReport Server Community Edition 7.8.0 with snowflake-jdbc-3.12.15 to a snowflakecomputing.com.
My tomcat version : 9.0.37
My java Version : openjdk version "11.0.8" 2020-07-14 LTS
OpenJDK Runtime Environment Corretto-184.108.40.206.1 (build 11.0.8+10-LTS)
OpenJDK 64-Bit Server VM Corretto-220.127.116.11.1 (build 11.0.8+10-LTS, mixed mode)
In the UI of Jasper I'm able to add the JDBC driver and the path to the drive "net.snowflake.client.jdbc.SnowflakeDriver" in order to add a new DataSource.
I add the URL : jdbc:snowflake://xxxxxxxx.eu-west-1.snowflakecomputing.com, UserName and password. JasperReports always send me : "ERROR SecureExceptionHandlerImpl,http-nio-8080-exec-6:116" in the container logs. My credentials are good (I tested it several times). I can use this driver with my own java project and it works.
I tried to activate log4j as explain here : https://community.jaspersoft.com/wiki/data-source-troubleshooting. But not working.
This errror usualy occur when host or credentials are false. It's not my case here ...
I don't understand what's going on. If you have an idea, I'll take it.