db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: [jira] Commented: (DERBY-296) Document error messages in the Derby Reference Manual
Date Tue, 14 Jun 2005 00:17:30 GMT
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<body bgcolor="#ffffff" text="#000000">
I am not sure if we should document this syntax. This is highly unusual
syntax and definitely not standard.<br>
An interesting enhancement to Derby would be to convert these
diagnostic VTIs into pseudo system tables. Derby has SYSCS_UTIL and
other system schemas and it would be great to provide a pseudo system
table interface to all diagnostic VTIs as system tables in one of these
system schemas. Would be a great project to learn and enhance Derby SQL
compilation and schema management areas.<br>
If there is any interest, I could file a Jira ENHANCEMENT request and
provide some information....<br>
<blockquote cite="midc25576af05061316175c0c0ee7@mail.gmail.com"
  <div>The way to get it to work currently I found in the tests
  <div>you do: (in ij:)</div>
  <div>&nbsp;&nbsp;&nbsp; select * from new org.apache.derby.diag.ErrorMessages()
  <div>and that dumps out all messages.</div>
  <div>To get just one particular message, you'd do:</div>
  <div>&nbsp;&nbsp;&nbsp; select * from new org.apache.derby.diag.ErrorMessages()
where sql_state='07000'; </div>
  <div><font size="1">&nbsp;</font></div>
  <div>I am wondering though, is it ok to document this? </div>
  <div>It's very non-standard way of doing things...</div>
  <div>At the same time, to recreate your doc with additional
comments,&nbsp;it must be possible to write&nbsp;a program that uses the
ErrorMessages vti in combination with an extra file(/extra files)&nbsp;&amp;
attaches the extra hints for each errormessage...And build the error
message doc up that way. So you'd miss a manual step to keep error
messages and debugging hints in sync.

View raw message