File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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: 2491
    
    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: 14074
    
  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
 
Similar Threads
trigger to check if a row can be inserted or not
run without errors, but data not inserted in database
Inserting and retrieving LONG data
Sorting Strings in Oracle
why my oracle sequence id increases by 2 when I use hibernate to insert