theo.ponthieu Posted November 19, 2020 Share Posted November 19, 2020 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.37My java Version : openjdk version "11.0.8" 2020-07-14 LTSOpenJDK 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. Link to comment Share on other sites More sharing options...
theo.ponthieu Posted November 19, 2020 Author Share Posted November 19, 2020 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-request?requestId=909ee179-b173-437a-bed5-7c0ee03bd07b HTTP/1.1 Link to comment Share on other sites More sharing options...
theo.ponthieu Posted November 19, 2020 Author Share Posted November 19, 2020 If find this ligne in repo "jasper docker" 7.8.0. https://github.com/TIBCOSoftware/JS-Docker# valid dbTypes are: postgresql, mysql, sqlserver, oracle, db2So Snowflake is no longer supported ? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now