db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Update of "SqlPsmSupport" by DanDebrunner
Date Wed, 16 Nov 2005 04:35:23 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The following page has been changed by DanDebrunner:
http://wiki.apache.org/db-derby/SqlPsmSupport

------------------------------------------------------------------------------
  }
  }}}
  
+ Possible storage of the generated class in SYSSTATEMENTS. This table already supports
+ the storage of generated classes for stored prepared statements.
+ 
+ || Column || type || nullable || use for PSM ||
+ || STMTID || CHAR(36) || false || unique identifier for the statement (?) ||
+ || STMTNAME || VARCHAR(128) ||false || name of the routine (?)||
+ || SCHEMAID || CHAR(36) || false || the schema in which the routine resides (?) ||
+ || TYPE || CHAR(1) || false || 'P' procedure, 'F' function  ||
+ || VALID || BOOLEAN 	|| false || TRUE if valid, FALSE if invalid  (?) ||
+ || TEXT || LONG VARCHAR || false || text of the create routine statement ||
+ || LASTCOMPILED || TIMESTAMP || true ||	time that the routine was compiled ||
+ || COMPILATION SCHEMAID || CHAR(36) || false || id of the schema containing the statement
(?) ||
+ || USINGTEXT || LONG VARCHAR || true || NULL ||
+ || CONSTANTSTATE (hidden) || Derby Prepared Statement (plan) || ?? || Bytecode of generated
routine ||
+ || INITIALLY_COMPILABLE (hidden) || BOOLEAN || true || True or Null ||
+ 
+ * Issue with existing index on STMTNAME,SCHEMAID. Would conflict name space with statements
(which only currently exist for JDBC metadata statements). Could upgrade index to include
TYPE.
+ 

Mime
View raw message