我正在嘗試使用Spring-JDBC連接到Presto,并且我正在使用Hikari CP作為數據源.

這是我的配置：

@Bean

public DataSource myDataSource() {

HikariDataSource hikariDataSource = new HikariDataSource();

hikariDataSource.setDriverClassName("com.facebook.presto.jdbc.PrestoDriver");

hikariDataSource.setJdbcUrl("xxxxxxx");

hikariDataSource.setMaximumPoolSize(10);

hikariDataSource.setMinimumIdle(5);

hikariDataSource.setIdleTimeout(10000);

hikariDataSource.setConnectionTimeout(60000);

hikariDataSource.setUsername("xxxx");

hikariDataSource.setPassword("xxxx");

hikariDataSource.setAutoCommit(false);

return hikariDataSource;

}

在服務類中自動裝配數據源時,出現以下錯誤：

java.sql.SQLFeatureNotSupportedException: Disabling auto-commit mode not supported

at com.facebook.presto.jdbc.PrestoConnection.setAutoCommit(PrestoConnection.java:126) ~[presto-jdbc-0.163.jar:0.163]

依賴關系：對于Springboot base 1.5.10.RELEASE

org.springframework.boot

spring-boot-starter-jdbc

com.zaxxer

HikariCP

2.7.8

com.facebook.presto

presto-jdbc

0.163