badanakrishna
-
Posts
2 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Downloads
Posts posted by badanakrishna
-
-
Hi,
We have installed jasper server on EC2 machiine and placed snwoflake JDBC file in /apache-tomcat/lib/ folder.
And try to esblish Data source connection for Snowflake web client through jasper server web UI, this throws connection not esablished, contact to admin. But we have logged as admin.
We are able connect same snowflake client (data adapter) through Jasper Studio.
Can anyone help us in build snowflake data source on jasper server.
Thank you,
Krishna
Snowflake JDBC Driver Not installed
in Products
Posted
Hi,
Isseue Description: JDBC driver seems unable to install on the server. Here are steps:
#1. Creaded a data source for "Snowflake" by adding "snowflake-jdbc-3.5.4.jar"
#2. Teast failed with error message "There was an error on the server. Try again or contact site administrators. (Error UID: 93864d47-23bf-4ff3-8498-eb66fd1fc545)"
#3. Saved the connection and open it again then it shows the JDBC driver not installed as below
(NOT NSTALLED: com.snowflake.client.jdbc.SnowflakeDriver)
And below ois the error message from the server:
java.lang.NoClassDefFoundError: Could not initialize class net.snowflake.client.core.SFTrustManager
at net.snowflake.client.core.HttpUtil.buildHttpClient(HttpUtil.java:93)
at net.snowflake.client.core.HttpUtil.getHttpClient(HttpUtil.java:181)
at net.snowflake.client.core.SFSession.open(SFSession.java:318)
at net.snowflake.client.jdbc.SnowflakeConnectionV1.<init>(SnowflakeConnectionV1.java:143)
at net.snowflake.client.jdbc.SnowflakeDriver.connect(SnowflakeDriver.java:344)
at com.jaspersoft.jasperserver.api.common.util.JdbcDriverShim.connect(JdbcDriverShim.java:66)
at java.sql.DriverManager.getConnection(DriverManager.java:571)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:75)
at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDriverManagerConnectionFactory.createConnection(JdbcDriverManagerConnectionFactory.java:36)
Please help us if you have any solution to fix this.
Thank you,
Krishna