[
https://issues.apache.org/jira/browse/IMPALA-10032?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tim Armstrong resolved IMPALA-10032.
------------------------------------
Resolution: Cannot Reproduce
I tried to understand what the issue was here. Attaching a test program after
doing the work to clean up and reformat your code (please try to actually
provide usable examples and don't make us poor maintainers work to understand
what you're talking about).
It works fine if the SQL statements succeed.
If you don't clean up the connections by calling close() on an error, it does
leave the connection open. The best practice is to have a finally() close that
will clean up connections in event of error.
> Unable to close the connection when fetching data from two databases
> --------------------------------------------------------------------
>
> Key: IMPALA-10032
> URL: https://issues.apache.org/jira/browse/IMPALA-10032
> Project: IMPALA
> Issue Type: Bug
> Components: Clients
> Reporter: jayashree
> Assignee: Tim Armstrong
> Priority: Blocker
> Attachments: JDBCExample2.java
>
>
> Hi Team,
> I am connecting two databases using cloudera.impala.jdbc41.Driver.
> I have two classes with two different connections, each having different SQLs
> to perform in respective database.
> When I am executing these two classes together, I am getting below error
> though I am closing first connection and then connecting to other Database.
> Error:
> j*ava.sql.SQLException: [Simba][ImpalaJDBCDriver](500051) ERROR processing
> query/statement. Error Code: 0, SQL state: TStatus(statusCode:ERROR_STATUS,
> sqlState:HY000, errorMessage:AnalysisException: Could not resolve table
> reference:*
> *Caused by: java.sql.SQLException:*
> *[Simba][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error
> Code: 0, SQL state: TStatus(statusCode:ERROR_STATUS, sqlState:HY000,
> errorMessage:AnalysisException: Could not resolve table reference:*
> *Caused by: com.cloudera.support.exceptions.GeneralException:*
> *[Simba][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error
> Code: 0, SQL state: TStatus(statusCode:ERROR_STATUS, sqlState:HY000,
> errorMessage:AnalysisException: Could not resolve table reference:*
>
> *Seems its not able to close first connection.*
> *Can you please check it*
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
