JasperReports JDBC Snowflake Connection ERROR

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-11.0.8.10.1 (build 11.0.8+10-LTS)
OpenJDK 64-Bit Server VM Corretto-11.0.8.10.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. 

 

theo.ponthieu's picture
Joined: Nov 9 2020 - 2:23am
Last seen: 1 year 5 months ago

I have a little more logs when the host is wrong :

19-Nov-2020 22:05:53.787 SEVERE [http-nio-8080-exec-8] net.snowflake.client.jdbc.RestRequest.execute Error response: HTTP Response code: 403, request: POST https://xx8342.eu-west-1.snowflakecomputing.com:443/session/v1/login-req... HTTP/1.1

theo.ponthieu - 1 year 7 months ago

If find this ligne in repo "jasper docker" 7.8.0. https://github.com/TIBCOSoftware/JS-Docker

# valid dbTypes are: postgresql, mysql, sqlserver, oracle, db2

So Snowflake is no longer supported ? 

theo.ponthieu - 1 year 7 months ago

0 Answers:

No answers yet
Feedback