db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: Column Types in System Tables
Date Wed, 12 Jan 2005 18:47:07 GMT
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Derby doesn't allow using java classes as column types. Yes, some of
the system tables do have these java classes, but that is based on old,
non-standard implementation. Derby doesn't have any API for users to
create those.<br>
<br>
Satheesh<br>
<br>
Arda M wrote:<br>
<blockquote
 cite="mid20050112082903.21096.qmail@web90004.mail.scd.yahoo.com"
 type="cite">
  <div>Hello,</div>
  <div>&nbsp;</div>
  <div>Some system tables have column types of java classes. Can we use
java classes as column types? Are these types documented somewhere? Do
we just say ResultSet.getObject() and cast it to the type and use it? I
tried to create a table similar to sys.systriggers but it gives error:</div>
  <div>&nbsp;</div>
  <div>CREATE TABLE APP.SYSTRIGGERS2(<br>
&nbsp; TRIGGERID CHAR(36) NOT NULL,<br>
&nbsp; TRIGGERNAME VARCHAR(128) NOT NULL,<br>
&nbsp; SCHEMAID CHAR(36) NOT NULL,<br>
&nbsp; CREATIONTIMESTAMP TIMESTAMP NOT NULL,<br>
&nbsp; EVENT CHAR(1) NOT NULL,<br>
&nbsp; FIRINGTIME CHAR(1) NOT NULL,<br>
&nbsp; TYPE CHAR(1) NOT NULL,<br>
&nbsp; STATE CHAR(1) NOT NULL,<br>
&nbsp; TABLEID CHAR(36) NOT NULL,<br>
&nbsp; WHENSTMTID CHAR(36),<br>
&nbsp; ACTIONSTMTID CHAR(36),<br>
&nbsp; REFERENCEDCOLUMNS org.apache.derby.catalog.ReferencedColumns,<br>
&nbsp; TRIGGERDEFINITION LONG VARCHAR,<br>
&nbsp; REFERENCINGOLD BOOLEAN,<br>
&nbsp; REFERENCINGNEW BOOLEAN,<br>
&nbsp; OLDREFERENCINGNAME VARCHAR(128),<br>
&nbsp; NEWREFERENCINGNAME VARCHAR(128)<br>
)</div>
  <p> </p>
  <hr size="1">Do you Yahoo!?<br>
Yahoo! Mail - Easier than ever with enhanced search. <a
 href="http://us.rd.yahoo.com/evt=29916/*http://info.mail.yahoo.com/mail_250">Learn
more.</a>
</blockquote>
</body>
</html>

Mime
View raw message