test.log

Example Hibernate and Java

/*C9*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
INSERT INTO PROVEEDOR VALUES(1,'PROVEEDOR 1','WEB PROVEEDOR 1')
INSERT INTO CONTACTO VALUES(1,'CONTACTO PRV 1','[e-mail]',1)
COMMIT
DISCONNECT
/*C10*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
DISCONNECT
/*C11*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
DISCONNECT
/*C12*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
INSERT INTO CONTACTO VALUES(2,'CONTACTO PRV 1','[e-mail]',1)
ROLLBACK
DISCONNECT
/*C13*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
INSERT INTO CONTACTO VALUES(3,'CONTACTO PRV 1','[e-mail]',1)
ROLLBACK
DISCONNECT
/*C14*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
INSERT INTO CONTACTO VALUES(4,'CONTACTO PRV 2','[e-mail]',1)
ROLLBACK
DISCONNECT
/*C15*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
DELETE FROM CONTACTO WHERE ID_CONTACTO=1
DELETE FROM PROVEEDOR WHERE ID_PROVEEDOR=1
ROLLBACK
DISCONNECT
/*C16*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
INSERT INTO PROVEEDOR VALUES(2,'PROVEEDOR 1','WEB PROVEEDOR 1')
INSERT INTO CONTACTO VALUES(5,'CONTACTO PRV 1','[e-mail]',2)
ROLLBACK
DISCONNECT
/*C17*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
INSERT INTO CONTACTO VALUES(6,'CONTACTO PRV 2','[e-mail]',1)
ROLLBACK
DISCONNECT
/*C18*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
DISCONNECT
/*C19*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
DISCONNECT
/*C20*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
DISCONNECT
/*C21*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
INSERT INTO PROVEEDOR VALUES(3,'PROVEEDOR 1','WEB PROVEEDOR 1')
INSERT INTO CONTACTO VALUES(7,'CONTACTO PRV 1','[e-mail]',3)
COMMIT
DISCONNECT
/*C22*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
INSERT INTO CONTACTO VALUES(8,'CONTACTO PRV 11','[e-mail]',1)
COMMIT
DISCONNECT
/*C23*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
DELETE FROM CONTACTO WHERE ID_CONTACTO=1
DELETE FROM CONTACTO WHERE ID_CONTACTO=8
DELETE FROM PROVEEDOR WHERE ID_PROVEEDOR=1
COMMIT
DISCONNECT
/*C24*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
DISCONNECT
/*C25*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
DISCONNECT
/*C26*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
INSERT INTO CONTACTO VALUES(9,'CONTACTO PRV 3','[e-mail]',3)
COMMIT
DISCONNECT
/*C27*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
INSERT INTO CONTACTO VALUES(10,'CONTACTO PRV 3','[e-mail]',3)
ROLLBACK
DISCONNECT
/*C28*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
INSERT INTO CONTACTO VALUES(11,'CONTACTO PRV 3','[e-mail]',3)
COMMIT
DISCONNECT
/*C29*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
INSERT INTO CONTACTO VALUES(12,'CONTACTO PRV 3','[e-mail]',3)
COMMIT
DISCONNECT
/*C30*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
INSERT INTO CONTACTO VALUES(13,'CONTACTO PRV 45','[e-mail]',3)
COMMIT
DISCONNECT
/*C31*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
DISCONNECT
/*C32*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
DISCONNECT
/*C33*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
DELETE FROM CONTACTO WHERE ID_CONTACTO=13
COMMIT
DISCONNECT
/*C34*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
DISCONNECT
/*C35*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
DELETE FROM CONTACTO WHERE ID_CONTACTO=7
COMMIT
DISCONNECT
/*C36*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
DELETE FROM CONTACTO WHERE ID_CONTACTO=9
COMMIT
DISCONNECT
/*C37*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
INSERT INTO CONTACTO VALUES(14,'CONTACTO PRV 45','[e-mail]',3)
COMMIT
DISCONNECT
/*C38*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
DELETE FROM CONTACTO WHERE ID_CONTACTO=11
COMMIT
DISCONNECT