Jump to content
We've recently updated our Privacy Statement, available here ×

JasperReports JDBC Snowflake Connection ERROR


theo.ponthieu

Recommended Posts

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. 

 

Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...