powered by Jive Software

Packet Filter in Oracle?

Hello everyone

I’m a rookie with the theme of openfire and spark I wonder if I can create some Packet Filter with oracle or is required to use the bases stated in the document.

The problem is that the company I am currently only use oracle.

Thanks

Should work with oracle. Let me know if you run into any issues.

Hi

el problema que presentaba era que para poder ingresar los datos a la base tenia que crear un trigger para que me realizara la insercion de datos, les dejo el trigger por si alguien lo quiere implementar.

Gracias.

create or replace trigger TRG_OF_RULE
before insert on ofpfrules
for each row
declare
A_NEXTVAL NUMBER;
begin
SELECT SEQ_OFPFRULE.NEXTVAL INTO A_NEXTVAL FROM DUAL;
:NEW.ID := A_NEXTVAL;
end TRG_OF_RULE;

if is tables ofpfrules not exist??

Ok, I found.

CREATE TABLE ofPfRules(
   id           INT          NOT NULL,
   ruleorder    INT      ,
   type         varchar2(255)     ,
   tojid       varchar2(255)    ,
   fromjid     varchar2(255)    ,
   rulef         varchar2(255)   ,
   disabled     INT,
   log          INT,
   description  varchar2(255),
   sourcetype   varchar2(255),
   desttype     varchar2(255),
  CONSTRAINT ofPfRules_pk PRIMARY KEY (id)
);

CREATE SEQUENCE ofPfRules_seq
START WITH 1
INCREMENT BY 1
MINVALUE 1
NOCACHE
NOCYCLE
NOORDER;

CREATE OR REPLACE TRIGGER ofPfRules_pkcreate BEFORE INSERT ON ofPfRules FOR EACH ROW WHEN ( NEW.id IS NULL ) BEGIN SELECT ofPfRules_seq.NEXTVAL INTO :NEW.id FROM DUAL; END ofPfRules_pkcreate;

INSERT INTO ofVersion (name,version) values ('packetfilter',2);