oracle EM and sql*plus

[Harshana Dias]

Hi,

Why Oracle EM and spl*plus is not synchronized?
I mean for example I have enter some data to my table thorugh SQL*PLUS and from my hibernate java class? The oracle EM does not shows the rows i added through sql*plus. Also So when I retrive data from that table from hql from the pojo its only display the data there in the EM. But when i do a select * from table insql*plus all rows include in EM also display.

Thank you.

[Fatih Keles]

Hi Harsana,

Do you issue a commit after insert operation?

Regards,

Fatih.

[Harshana Dias]

Fatih Keles wrote:
Do you issue a commit after insert operation?

You mean in the pojo ? yes i did. We don't have to commit in the sql*plus right? just the insert into query right?

[Fatih Keles]

No, in sql*plus you still have to commit.

[Harshana Dias]

Fatih Keles wrote:No, in sql*plus you still have to commit.

thankx Fatih..i now understand By default, SQL*Plus has autocommit turned off and Autocommit can not be set at the database level. It is a requirement of the connecting application.