Information Link fails to execute with the error message Method Connection.prepareStatement is not yet implemented

Information Link fails to execute with the error message Method Connection.prepareStatement is not yet implemented

book

Article ID: KB0075566

calendar_today

Updated On:

Products Versions
Spotfire Server All Versions

Description

After successfully parsing the data source template followed by the setup of the data source in Information Designer, the created Information Link may fail with the error message: Method Connection.prepareStatement is not yet implemented. And the following stack trace is observed in the server logs. 
ERROR 2020-03-27T10:44:08,821+0000 [*pool-14-thread-1, admin123, #2, #35*] ws.dat.AbstractOperator: Start job failed.
com.spotfire.ws.dat.OperatorException: com.spotfire.ws.im.IMException: Failed to execute query: Method Connection.prepareStatement is not yet implemented
	at com.spotfire.ws.im.ds.sql.SQLDataSource.doStart(SQLDataSource.java:285) ~[spotfire-server-is.jar:?]
	at com.spotfire.ws.dat.AbstractOperator.start(AbstractOperator.java:144) ~[spotfire-server-is.jar:?] 
Caused by: com.spotfire.ws.im.IMException: Failed to execute query: Method Connection.prepareStatement is not yet implemented
	... 12 more
Caused by: com.facebook.presto.jdbc.NotImplementedException: Method Connection.prepareStatement is not yet implemented
	at com.facebook.presto.jdbc.PrestoConnection.prepareStatement(PrestoConnection.java:119) ~[presto-jdbc-0.204.jar:0.204]

 

Issue/Introduction

Information Link fails to execute with the error message Method Connection.prepareStatement is not yet implemented

Environment

All Supported Operating Systems

Resolution

Some JDBC drivers do not support the prepareStatement call for the JDBC connections.  Spotfire will always call prepareStatement unless told to do otherwise.  One can turn off this behavior by setting the attribute always-use-prepared-statement to false. The following attribute needs to be added in the data source template for which created Information link was failing. 
<always-use-prepared-statement>false</always-use-prepared-statement>
Make sure to save the configuration after adding this attribute and restart the Spotfire Server.
Powered by Wolken Software