wood burning stoves 2.0*
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 Android Security Essentials Live Lessons this week in the Android 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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: oracle EM and sql*plus
 
Similar Threads
JSP creating html rows for displaying data
OrindaBuild 4.0 - Writes Java to access Tables, PL/SQL and SQL Files
OrindaBuild Now Supports Oracle 10G and JDeveloper 10G
JTable -- Help please
MS Access/Oracle