You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@juddi.apache.org by Steve Viens <st...@viens.net> on 2003/09/30 05:43:03 UTC

[juddi-Developers] FW: Verify MONITOR table works w/Oracle DDL

FYI, 

I've checked Peter's contribution (with my small change) into CVS (ddl
directory).

Steve

-----Original Message-----
From: Steve Viens [mailto:sviens@users.sourceforge.net] 
Sent: Tuesday, September 30, 2003 6:39 AM
To: pstorch@users.sourceforge.net
Cc: sviens@users.sourceforge.net
Subject: Verify MONITOR table works w/Oracle DDL

Thanks for the contribution Peter. Would you mind confirming that the
Table creation script below will funciton properly with Oracle?  This is
new in what should be an 0.8.1 release due out this month so I've added
it to your script but do not have an Oracle instance to verify it with.

CREATE TABLE MONITOR
(
  REMOTE_HOST VARCHAR2(51) NOT NULL,
  REQUEST_URI VARCHAR2(255) NOT NULL,
  CALLED_FUNCTION VARCHAR2(51) NOT NULL,
  UDDI_VERSION VARCHAR2(51) NOT NULL,
  LOG_TIME DATETIME NOT NULL,
  AUTH_TOKEN VARCHAR(51), 
  FAULT VARCHAR(255)
);

Steve