my dog learned polymorphism*
The moose likes Oracle/OAS and the fly likes oracle EM and sql*plus Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "oracle EM and sql*plus" Watch "oracle EM and sql*plus" New topic
Author

oracle EM and sql*plus

Harshana Dias
Ranch Hand

Joined: Jun 11, 2007
Posts: 327
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

Joined: Sep 01, 2005
Posts: 182
Hi Harsana,

Do you issue a commit after insert operation?

Regards,

Fatih.
Harshana Dias
Ranch Hand

Joined: Jun 11, 2007
Posts: 327
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

Joined: Sep 01, 2005
Posts: 182
No, in sql*plus you still have to commit.
Harshana Dias
Ranch Hand

Joined: Jun 11, 2007
Posts: 327
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: oracle EM and sql*plus