You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "David Van Couvering (JIRA)" <de...@db.apache.org> on 2005/06/14 09:51:50 UTC
[jira] Created: (DERBY-357) Document how to run ErrorMessages VTI
Document how to run ErrorMessages VTI
-------------------------------------
Key: DERBY-357
URL: http://issues.apache.org/jira/browse/DERBY-357
Project: Derby
Type: New Feature
Components: Documentation
Versions: 10.0.2.1, 10.0.2.0, 10.1.0.0
Reporter: David Van Couvering
Priority: Trivial
It would be very useful to let users know how to look for specific error messages or get the whole list through the ErrorMessages VTI.
The columns of the VTI are
SQL_STATE -- varchar(5)
MESSAGE -- varchar(32672)
SEVERITY -- integer
The syntax is
SELECT <columns> FROM new org.apache.derby.diag.ErrorMessages() vti
SELECT SQL
--
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
[jira] Closed: (DERBY-357) Document how to run ErrorMessages VTI
Posted by "David Van Couvering (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-357?page=all ]
David Van Couvering closed DERBY-357:
-------------------------------------
Resolution: Won't Fix
Comment by Satheesh - we shouldn't document VTIs, their syntax is non-standard
Comment by Dan - SQLSTATE is a reserved word, so this isn't really a bug
> Document how to run ErrorMessages VTI
> -------------------------------------
>
> Key: DERBY-357
> URL: http://issues.apache.org/jira/browse/DERBY-357
> Project: Derby
> Type: New Feature
> Components: Documentation
> Versions: 10.0.2.0, 10.0.2.1, 10.1.0.0
> Reporter: David Van Couvering
> Priority: Trivial
>
> It would be very useful to let users know how to look for specific error messages or get the whole list through the ErrorMessages VTI.
> The columns of the VTI are
> SQL_STATE -- varchar(5)
> MESSAGE -- varchar(32672)
> SEVERITY -- integer
> The syntax is
> SELECT <columns> FROM new org.apache.derby.diag.ErrorMessages() vti
> SELECT SQL
--
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