Reply
Explorer
Posts: 6
Registered: ‎10-14-2016

Impala Jdbc connection

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!