You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Samarth Jain (JIRA)" <ji...@apache.org> on 2014/12/04 02:19:12 UTC
[jira] [Updated] (PHOENIX-1500) Disallow mutations and queries
using using PhoenixPreparedStatement.executeQuery() and executeUpdate()
respectively.
[ https://issues.apache.org/jira/browse/PHOENIX-1500?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Samarth Jain updated PHOENIX-1500:
----------------------------------
Summary: Disallow mutations and queries using using PhoenixPreparedStatement.executeQuery() and executeUpdate() respectively. (was: Delete using PhoenixPreparedStatement.executeQuery() fails)
> Disallow mutations and queries using using PhoenixPreparedStatement.executeQuery() and executeUpdate() respectively.
> --------------------------------------------------------------------------------------------------------------------
>
> Key: PHOENIX-1500
> URL: https://issues.apache.org/jira/browse/PHOENIX-1500
> Project: Phoenix
> Issue Type: Bug
> Reporter: Samarth Jain
> Assignee: Samarth Jain
> Attachments: PHOENIX-1500.patch, PHOENIX-1500_v2.patch
>
>
> {code}
> @Test
> public void deleteUsingPreparedStatement() throws Exception {
> Connection conn = DriverManager.getConnection(getUrl());
> initTableValues(conn);
> assertTableCount(conn, "IntIntKeyTest", NUMBER_OF_ROWS);
> String deleteStmt = "DELETE FROM IntIntKeyTest WHERE j = ?";
> PreparedStatement stmt = conn.prepareStatement(deleteStmt);
> stmt.setInt(1, 20);
> stmt.executeQuery();
> conn.commit();
> assertTableCount(conn, "IntIntKeyTest", NUMBER_OF_ROWS - 1);
> }
> java.lang.ClassCastException: org.apache.phoenix.compile.DeleteCompiler$3 cannot be cast to org.apache.phoenix.compile.QueryPlan
> at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:221)
> at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:1)
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> at org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:216)
> at org.apache.phoenix.jdbc.PhoenixPreparedStatement.executeQuery(PhoenixPreparedStatement.java:183)
> at org.apache.phoenix.end2end.DeleteIT.deleteUsingPreparedStatement(DeleteIT.java:484)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)