Daniel John Debrunner wrote:
> Lance J. Andersen wrote:
>
>
>> Daniel John Debrunner wrote:
>>
>>
>>> The SQL standard says that SQL State '42' is for "syntax error or access
>>> rule violation" (section 23.1).
>>>
>>> JDBC 4.0 states in section 6.5.1 that "TABLE 6-1 specifies which
>>> NonTransientSQLException subclass must be thrown
>>> for a a given SQLState class value:" and Table 6.1 has these two lines
>>> of interest:
>>>
>>> SQL State 42 ->> SQLSyntaxErrorException.
>>>
>
> The javadoc SQLSyntaxErrorException for says:
>
> The subclass of SQLException thrown when the SQLState class value is
> '42'. This indicates that the in-progress query has violated SQL syntax
> rules.
>
> This somewhat in-conflict with the SQL Standard.
>
> Can a JDBC driver thrown an exception with SQLState '42' and the
> exception not be a SQLSyntaxErrorException?
>
Whenever 42 is sent as the SQLState class value it should map to
SQLSyntaxErrorException.
I need to clarify the javadocs a bit, but it already indicates that this
is the exception when the value of 42 is returned.
> Thanks,
> Dan.
>
>
>
>
|