aspose file tools*
The moose likes JDBC and the fly likes Bizzare behavior of Oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Bizzare behavior of Oracle" Watch "Bizzare behavior of Oracle" New topic
Author

Bizzare behavior of Oracle

jit singh
Greenhorn

Joined: Oct 21, 2007
Posts: 2
I have this small problem.

If i insert a row in a table (named employee) using the servlet then i am able to retrieve the row using the same servlet class.

But if i insert a row in same table using SQL plus then when i call select * from servlet it will only retrieve the row that was inserted by servlet and not the new row that was inserted using SQL plus.

I am using Oracle 9i, Java 1.6 and Tomcat 6.

Is it something related to privilages?
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2495
    
    8

using SQL plus
.You have to type commit , then <enter> in sql*plus to confirm your changes. From then on, they will be visible in other sessions.

Regards, Jan


OCUP UML fundamental and ITIL foundation
youtube channel
Jesper de Jong
Java Cowboy
Saloon Keeper

Joined: Aug 16, 2005
Posts: 14111
    
  16

"jit tij", please check your private messages. You can see them by clicking My Private Messages.


Java Beginners FAQ - JavaRanch SCJP FAQ - The Java Tutorial - Java SE 7 API documentation
Scala Notes - My blog about Scala
jit singh
Greenhorn

Joined: Oct 21, 2007
Posts: 2
thanks for reply, well i got it while by chance that what i was doing was closing the sql++ window by close button at top right, instead i should have typed EXIT to close the window, it does the same job as commit but also closes the window as it is obvious ;)

I have changed my name. Now is there something more to worry about or am all set for cruising forum?
Paul Campbell
Ranch Hand

Joined: Oct 06, 2007
Posts: 338
Originally posted by jitender singh:
thanks for reply, well i got it while by chance that what i was doing was closing the sql++ window by close button at top right, instead i should have typed EXIT to close the window, it does the same job as commit but also closes the window as it is obvious ;)

I have changed my name. Now is there something more to worry about or am all set for cruising forum?


That doesn't make any sense, entering EXIT should not issue a commit.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Bizzare behavior of Oracle