phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Samarth Jain (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (PHOENIX-1500) Disallow mutations and queries using using PhoenixPreparedStatement.executeQuery() and executeUpdate() respectively.
Date Thu, 04 Dec 2014 01:19:12 GMT

     [ 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)

Mime
View raw message