Win a copy of Testing JavaScript Applications this week in the HTML Pages with CSS and JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Carey Brown

oracle EM and sql*plus

 
Ranch Hand
Posts: 352
  • 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.
 
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: 352
  • 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: 352
  • 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.
 
Don't get me started about those stupid light bulbs.
    Bookmark Topic Watch Topic
  • New Topic