Eclipse Community Forums: EclipseLink » oracle database trigger and INSERT problem

Help

Home

Home » Eclipse Projects » EclipseLink » oracle database trigger and INSERT problem

Show: Today's Messages :: Show Polls :: Message Navigator

oracle database trigger and INSERT problem [message #545313]

Wed, 07 July 2010 12:23

No real name

Messages: 2
Registered: July 2010

Junior Member

Hi,

I do my first steps with eclipselink as JPA implementation in glassfish and I encountered a problem related to a trigger.

I have a table called TRACE in an oracle DB which I fill with JPA. As long as I have no trigger on this table all is fine. In particular I can INSERT records.

But when I enable a "BEFORE INSERT" trigger which fills a day_of_month field by a date (trace_date) inserted I get no error in log-file but the recods is not persisted in the database.

Entity Trace:
...
@Column(nullable = true)
@Temporal(TemporalType.TIMESTAMP)
private Date trace_date;
...
@Column(nullable = true)
private Byte day_of_month;
...

Trigger:
CREATE OR REPLACE TRIGGER TRACE_I_TR
BEFORE INSERT
ON cobra.trace
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
DECLARE
v_id number;
BEGIN
:new.day_of_month:= to_number(to_char(:new.trace_date,'DD'));
END;
/

What should I do to enable coexistence between database triggers and JPA?

Thomas

Report message to a moderator

Re: oracle database trigger and INSERT problem [message #545639 is a reply to message #545313]

Thu, 08 July 2010 13:34

James Sutherland

Messages: 1939
Registered: July 2009
Location: Ottawa, Canada

Senior Member

Are you sure your trigger is valid?

Can you insert through raw SQL, or raw JDBC?

Enable logging and ensure the SQL is sent, and the transaction is committed.

James : Wiki : Book : Blog : Twitter

Report message to a moderator

Re: oracle database trigger and INSERT problem [message #546375 is a reply to message #545639]

Mon, 12 July 2010 15:10

No real name

Messages: 2
Registered: July 2010

Junior Member

James wrote on Thu, 08 July 2010 09:34

Are you sure your trigger is valid?

Can you insert through raw SQL, or raw JDBC?

Enable logging and ensure the SQL is sent, and the transaction is committed.

Hi , thank you. The trigger was valid bit it was really my fault. The SELECT I checked the result was simply wrong Sad

.

Thomas

Report message to a moderator

Previous Topic:	JPA 2.0 and WebLogic 10
Next Topic:	BatchUpdateException: invalid batch command: invalid SELECT batch command 0

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Aug 20 12:18:16 GMT 2017

.:: Contact :: Home ::.