Issue Details (XML | Word | Printable)

Key: DERBY-522
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: A B
Reporter: Kathey Marsden
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Derby

ERROR X0Y79 raised when adding comments using "--" before sql queries with Network Client

Created: 20/Aug/05 07:19 AM   Updated: 26/Jan/06 01:58 AM
Return to search
Component/s: Network Client
Affects Version/s: 10.1.1.0, 10.1.2.1, 10.2.1.6
Fix Version/s: 10.1.2.1, 10.2.1.6

Time Tracking:
Not Specified

File Attachments:
  File Name Date Attached Attached By Size
Java Source File Licensed for inclusion in ASF works CommentBeforeSelect.java 2005-08-20 07:28 AM Kathey Marsden 5 kB
Text File Licensed for inclusion in ASF works d10_1Master.patch 2005-10-19 08:40 AM A B 1 kB
Text File Licensed for inclusion in ASF works d522_v3.patch 2005-10-15 11:58 PM A B 21 kB
File Licensed for inclusion in ASF works d522_v3.stat 2005-10-15 11:58 PM A B 0.7 kB

Resolution Date: 20/Oct/05 03:56 AM


 Description  « Hide
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

 All   Comments   Work Log   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Kathey Marsden made changes - 20/Aug/05 07:27 AM
Field Original Value New Value
Description
// Bug 5398 - comments in select statement Throws exception
stmt.execute("-- This is a comment \n Select c11 from TAB1");
ResultSet rs = stmt.getResultSet(); 		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
Summary ERROR X0Y79 raised when adding comments using "--" before sql queries with Network Cleint ERROR X0Y79 raised when adding comments using "--" before sql queries with Network Client
Kathey Marsden made changes - 20/Aug/05 07:28 AM
Attachment CommentBeforeSelect.java [ 12311857 ]
A B made changes - 01/Oct/05 06:08 AM
Assignee A B [ army ]
A B made changes - 06/Oct/05 08:29 AM
Status Open [ 1 ] In Progress [ 3 ]
A B made changes - 06/Oct/05 08:33 AM
Fix Version/s 10.2.0.0 [ 11187 ]
Fix Version/s 10.1.2.0 [ 12310270 ]
A B made changes - 08/Oct/05 01:25 AM
Attachment d522.stat [ 12314770 ]
Attachment d522.patch [ 12314769 ]
A B made changes - 13/Oct/05 08:10 AM
Attachment d522.patch [ 12314769 ]
A B made changes - 13/Oct/05 08:10 AM
Attachment d522.stat [ 12314770 ]
A B made changes - 14/Oct/05 01:19 AM
Attachment d522_v2.stat [ 12314864 ]
Attachment d522_v2.patch [ 12314863 ]
A B made changes - 15/Oct/05 05:45 AM
Attachment d522_v2.patch [ 12314863 ]
A B made changes - 15/Oct/05 05:45 AM
Attachment d522_v2.stat [ 12314864 ]
A B made changes - 15/Oct/05 11:58 PM
Attachment d522_v3.stat [ 12314902 ]
Attachment d522_v3.patch [ 12314901 ]
A B made changes - 19/Oct/05 08:40 AM
Attachment d10_1Master.patch [ 12314946 ]
A B made changes - 20/Oct/05 03:56 AM
Resolution Fixed [ 1 ]
Status In Progress [ 3 ] Resolved [ 5 ]
Kathey Marsden made changes - 26/Jan/06 01:58 AM
Status Resolved [ 5 ] Closed [ 6 ]

Powered by a free Atlassian JIRA open source license for Apache Software Foundation. Try JIRA - bug tracking software for your team.
Atlassian JIRA the Professional Issue Tracker. (Enterprise Edition, Version: 3.13.2-#335) - Bug/feature request - Atlassian news - Contact Administrators