This week's giveaway is in the Programmer Certification (OCPJP) forum.
We're giving away four copies of Java Mock Exams (software) and have David Mayer on-line!
See this thread for details.
Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

insertRow() working but the result of the insert is not visible in the Java application

 
Steven Squeers
Ranch Hand
Posts: 62
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I have the following simple program, which successfully inserts a row into table T:



The problem is, the insert is not visible in the Java program. When I query the db, it's there, but inside the Java program, it isn't. In the example provided in the book that I'm using the inserted data is visible when the resultSet is printed out after the insert. They are using mySQL; I'm using Oracle.

My output is:

Before the insert:
X
10
Row not inserted
After the insert:
X
10

But querying the db:

ORCL> select * from t;

X
----------
10
1000


Thanks.
 
Happiness is not a goal ... it's a by-product of a life well lived - Eleanor Roosevelt. Tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!