Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

oracle EM and sql*plus

 
Harshana Dias
Ranch Hand
Posts: 348
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 182
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Harsana,

Do you issue a commit after insert operation?

Regards,

Fatih.
 
Harshana Dias
Ranch Hand
Posts: 348
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 182
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
No, in sql*plus you still have to commit.
 
Harshana Dias
Ranch Hand
Posts: 348
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic