Date Posted:
Product: TIBCO Spotfire®
Product: TIBCO Spotfire®
Problem:
Information Link fails to execute with the error message Method Connection.prepareStatement is not yet implemented
Solution:
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]
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.
Comments
0 comments
Article is closed for comments.