[DERBY-1828] Access rule violations should use a SQL state starting with '42' according to the SQL standard.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.2.1.6, 10.3.1.4
• Fix Version/s: 10.3.1.4
• Component/s: JDBC
• Issue & fix info: Release Note Needed
• Assignee: Jorgen Loland
• Reporter: Daniel John Debrunner
• Created: 07/Sep/06 20:59
• Updated: 30/Jun/09 16:12
• Resolved: 14/May/07 14:12

Description

The SQL standard says that SQL State '42' is for "syntax error or access
rule violation" (section 23.1).

There is a question of what JDBC 4.0 exception should be thrown for a access rule violation,
JDBC 4.0 maps '42' to SQLSyntaxErrorException which seems wrong for an access rule.

Message thread:

http://mail-archives.apache.org/mod_mbox/db-derby-dev/200609.mbox/[e-mail]%3e

Issue Links

• is blocked by: DERBY-1825 Errors 2850A,2850G,28508 are similar - can be combined into a single message.