0 Replies Latest reply: Mar 2, 2012 10:27 AM by Jos de Jong RSS

    DDL Definition of the WLDF Tables for Oracle DB ?

    Jos de Jong
      Hi all,

      I'm trying to define tables in an Oracle Database for the WLDF Harvester. For the time being I use file based archives, but I'd like to switch to jdbc based.
      Only thing is, I cannot find the appropriate ddl for oracle databases. I can only find Derby ddl (even in oracle docs!).
      Can someone point me out how these ddls should look like for oracle db?

      Here are the ddl's for Derby:



      -- WLDF Instrumentation and Harvester archive DDLs using Derby

      AUTOCOMMIT OFF;

      -- DDL for creating wls_events table for instrumentation events

      DROP TABLE wls_events;

      CREATE TABLE wls_events (
      RECORDID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1),
      TIMESTAMP BIGINT default NULL,
      CONTEXTID varchar(128) default NULL,
      TXID varchar(32) default NULL,
      USERID varchar(32) default NULL,
      TYPE varchar(64) default NULL,
      DOMAIN varchar(64) default NULL,
      SERVER varchar(64) default NULL,
      SCOPE varchar(64) default NULL,
      MODULE varchar(64) default NULL,
      MONITOR varchar(64) default NULL,
      FILENAME varchar(64) default NULL,
      LINENUM INTEGER default NULL,
      CLASSNAME varchar(250) default NULL,
      METHODNAME varchar(64) default NULL,
      METHODDSC varchar(4000) default NULL,
      ARGUMENTS clob(100000) default NULL,
      RETVAL varchar(4000) default NULL,
      PAYLOAD blob(100000),
      CTXPAYLOAD VARCHAR(4000),
      DYES NUMERIC default NULL,
      THREADNAME varchar(128) default NULL
      );

      -- DDL for creating wls_events table for instrumentation events

      DROP TABLE wls_hvst;

      CREATE TABLE wls_hvst (
      RECORDID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1),
      TIMESTAMP BIGINT default NULL,
      DOMAIN varchar(64) default NULL,
      SERVER varchar(64) default NULL,
      TYPE varchar(64) default NULL,
      NAME varchar(250) default NULL,
      ATTRNAME varchar(64) default NULL,
      ATTRTYPE INTEGER default NULL,
      ATTRVALUE VARCHAR(4000)
      );

      COMMIT;