db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathey Marsden (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-522) ERROR X0Y79 raised when adding comments using "--" before sql queries with Network Client
Date Mon, 17 Oct 2005 22:52:45 GMT
    [ http://issues.apache.org/jira/browse/DERBY-522?page=comments#action_12332304 ] 

Kathey Marsden commented on DERBY-522:
--------------------------------------

Committed this to the trunk:  Please submit the merge command for merge to 10.1 when ready.

Date: Mon Oct 17 15:41:03 2005
New Revision: 325993

URL: http://svn.apache.org/viewcvs?rev=325993&view=rev
Log:
DERBY-522

1) Updates client to look for statements that begin with comments and to ignore the comments
when deciding the kind of statement that is being executed.
2) Changes ij to only strip comments for client versions less than 10.2
3) Adds test cases for statements that begin with comments to the jdbcapi/nullSQLText.java
test
4) Updates masters


> ERROR X0Y79 raised when adding comments using "--" before sql queries with Network Client
> -----------------------------------------------------------------------------------------
>
>          Key: DERBY-522
>          URL: http://issues.apache.org/jira/browse/DERBY-522
>      Project: Derby
>         Type: Bug
>   Components: Network Client
>     Versions: 10.1.2.0, 10.1.1.0, 10.2.0.0
>     Reporter: Kathey Marsden
>     Assignee: A B
>      Fix For: 10.2.0.0, 10.1.2.0
>  Attachments: CommentBeforeSelect.java, d522_v3.patch, d522_v3.stat
>
> Comments before a  select statement Throws exception with Network Client
> For Example a statement like the one below in the attached program with throw an exception.
> stmt.execute("-- This is a comment \n Select c11 from TAB1");
> org.apache.derby.client.am.SqlException: Statement.executeUpdate() cannot be called with
a statement that returns a ResultSet.
>         at org.apache.derby.client.am.Statement.completeSqlca(Statement.java:1354)
>         at org.apache.derby.client.am.Statement.completeExecuteImmediate(Statement.java:964)
>         at org.apache.derby.client.net.NetStatementReply.parseEXCSQLIMMreply(NetStatementReply.java:199)
>         at org.apache.derby.client.net.NetStatementReply.readExecuteImmediate(NetStatementReply.java:50)
>         at org.apache.derby.client.net.StatementReply.readExecuteImmediate(StatementReply.java:44)
>         at org.apache.derby.client.net.NetStatement.readExecuteImmediate_(NetStatement.java:123)
>         at org.apache.derby.client.am.Statement.readExecuteImmediate(Statement.java:960)
>         at org.apache.derby.client.am.Statement.flowExecute(Statement.java:1587)
>         at org.apache.derby.client.am.Statement.executeX(Statement.java:631)
>         at org.apache.derby.client.am.Statement.execute(Statement.java:622)
>         at CommentBeforeSelect.createAndPopulateTable(CommentBeforeSelect.java:70)
>         at CommentBeforeSelect.main(CommentBeforeSelect.java:35)
> $
> To reproduce run the attached program 
> java CommentBeforeSelect

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message