theo.ponthieu

Hi guys, I need to know if JasperReport 7.8.0 can support Snwoflake data soure ? Anyone knows ? (I tried without success: https://community.jaspersoft.com/questions/1173906/jasperreports-jdbc-snowflake-connection-error) Have a good day !

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 ?

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

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.