Well, just to be clear, it's true that the exception indicates a possible bug, but the bug *I* was talking about was an error message that made it difficult if not impossible for the user to know what to do to fix the problem.

For instance instead of saying "Execution failed due to a distribution protocol error that caused deallocation of the conversation" we could say something in English with the situation, the probable cause, and suggested course of action. Not that this is correct, but something like "connection to the database was lost because of a communication error between the Derby client and the Derby server. Please make sure the versions of the client and server are compatible. If this continues to be a problem, please contact support or send email to [email protected]"

David

Kathey Marsden wrote:
David W. Van Couvering wrote:


Bryan, I would love it if you logged this error message as a bug, we
need to clean up some of our error messages to be more meaningful.

And, no, sorry, I have no idea what this means.

David

Bryan Pendleton wrote:


I got this exception several times today, but I don't know
what it's trying to tell me.

Can anybody take a stab at explaining this error to me in more
"layman's" terms?

Is there a place where I should have gone to look up 0x2116?

thanks,

bryan

org.apache.derby.client.am.DisconnectException: Execution failed due
to a distribution protocol error that caused deallocation of the
conversation. A PROTOCOL Data Stream Syntax Error was detected.
Reason: 0x2116 at
org.apache.derby.client.net.Reply.doSyntaxrmSemantics(Unknown Source)
at
org.apache.derby.client.net.NetConnectionReply.parseSYNTAXRM(Unknown
Source) at
org.apache.derby.client.net.NetConnectionReply.parseCommonError(Unknown
Source) at
org.apache.derby.client.net.NetStatementReply.parsePrepareError(Unknown
Source) at
org.apache.derby.client.net.NetStatementReply.parsePRPSQLSTTreply(Unknown
Source) at
org.apache.derby.client.net.NetStatementReply.readPrepareDescribeOutput(Unknown
Source) at
org.apache.derby.client.net.StatementReply.readPrepareDescribeOutput(Unknown
Source) at
org.apache.derby.client.net.NetStatement.readPrepareDescribeOutput_(Unknown
Source) at
org.apache.derby.client.am.Statement.readPrepareDescribeOutput(Unknown
Source) at
org.apache.derby.client.am.PreparedStatement.readPrepareDescribeInputOutput(Unknown
Source) at
org.apache.derby.client.am.PreparedStatement.flowPrepareDescribeInputOutput(Unknown
Source) at
org.apache.derby.client.am.PreparedStatement.prepare(Unknown Source)
at org.apache.derby.client.am.Connection.prepareStatementX(Unknown
Source) at
org.apache.derby.client.am.Connection.prepareStatement(Unknown
Source) at
...



David is on target that  we probably need a bug to be filed.   Normally
when there is a protocol exception it means a bug.   SYNTAXRM means that
the server has spent a response to the client which the client doesn't
understand.     Here the client has sent a prepare and is expecting
statement description information back from the server but something
went wrong.

 Things that would be very helpful in the bug:

1) A reproducible case (some java code  or sql script that can be used
to show the error).
2) sysinfo output. org.apache.derby.tools.sysinfo
3) Any errors that appear in the derby.log or  network server console
output.

If it is not easy to reproduce, let us know and we can try to find other
ways to collect the needed info.

Thanks

Kathey




begin:vcard
fn:David W Van Couvering
n:Van Couvering;David W
org:Sun Microsystems, Inc.;Database Technology Group
email;internet:[EMAIL PROTECTED]
title:Senior Staff Software Engineer
tel;work:510-550-6819
tel;cell:510-684-7281
x-mozilla-html:TRUE
version:2.1
end:vcard

Reply via email to