Product:TIBCO Spotfire Server
Versions:10.10 and higher
Summary:
This article provides resolution when transaction errors are seen connecting to Presto/Trino data source through Spotfire Analyst via Information Designer
Details:
You may notice following error when connecting to Presto/Trino data sources via Information Designer,
Error while connecting to Trino via JDBC: Error retrieving metadata: Query failed" "Client does not support transactions
Or
Error retrieving metadata: Query failed: Session properties cannot be overridden once a transaction is active
Resolution:
The value of autoCommit is false by default which doesn't support transactions.
To resolve this issue, please add the below line in the data source template and create a new data source and try it.
Versions:10.10 and higher
Summary:
This article provides resolution when transaction errors are seen connecting to Presto/Trino data source through Spotfire Analyst via Information Designer
Details:
You may notice following error when connecting to Presto/Trino data sources via Information Designer,
Error while connecting to Trino via JDBC: Error retrieving metadata: Query failed" "Client does not support transactions
Or
Error retrieving metadata: Query failed: Session properties cannot be overridden once a transaction is active
Resolution:
The value of autoCommit is false by default which doesn't support transactions.
To resolve this issue, please add the below line in the data source template and create a new data source and try it.
<autocommit>true</autocommit>
Comments
0 comments
Article is closed for comments.