Hello,
We are using C3P0 to configure the Jdbc Connection with Impala, and when we try to execute queries, we have this error:
java.sql.SQLException: [Simba][ImpalaJDBCDriver](500151) Error setting/closing session: {0}.
This error, probably causes the next error:
SQL state [HY000]; error code [500051]; [Simba][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error Code: java.net.SocketException: Tubería rota (Write failed)
Our config:
ComboPooledDataSource dataSource = new ComboPooledDataSource();
dataSource.setJdbcUrl(dataSourceImpalaUrl);
dataSource.setDriverClass(dataSourceImpalaDriver);
dataSource.setIdleConnectionTestPeriod(60);
dataSource.setMaxPoolSize(20);
dataSource.setMaxStatements(50);
dataSource.setMinPoolSize(3);
return dataSource;
Our Libraries:
<dependency>
<groupId>com.mchange</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.5.2</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>4.3.3.RELEASE</version>
</dependency>
<dependency>
<groupId>com.cloudera.impala.jdbc</groupId>
<artifactId>ImpalaJDBC4</artifactId>
<version>2.5.36</version>
</dependency>
<dependency>
<groupId>com.cloudera</groupId>
<artifactId>TCLIServiceClient</artifactId>
<version>2.5.36</version>
</dependency>
<dependency>
<groupId>org.apache.thrift</groupId>
<artifactId>libfb303</artifactId>
<version>0.9.3</version>
</dependency>
Could you help us, please?
Thanks!
