Eclipse data source explorer not showing Inserted table records (Oracle) After I installed Oracle database 11g, I went to Eclipse Database Development Perspective and successfully created a new database connection for Oracle.



Then I created a new account call "testing" and logged in with this new user "testing" through SQL Plus and created a new table.

Enter user-name: testing
Enter password:

SQL&gt; CREATE TABLE TBLSAMPLE (NAME varchar(50), EMAIL varchar(50), AGE integer);
Table created.


When refresh the Schema in Eclipse's Data source explorer. The table added from SQL Plus shows up. (All is working well so far)



I proceeded to insert some records from SQL Plus with the same user ("testing").
A check on the table shows that the records were indeed inserted.

SQL&gt; SELECT * from tblSample;
...
6 rows selected.


Now the problem is: The inserted records are not showing up in Eclipse's Data Source Explorer despite refreshing the schema &amp; the tables folder. 

I created a new SQL file and select the entire tblSample, and it shows 0 records as well. I then inserted 1 row of record from Eclipse SQL file. It does shows up in Eclipse, but it does not affect the 6 rows of records in Oracle SQL Plus.

Why are the inserted records not showing up in Eclipse? To troubleshoot the culprit, I created a NetBeans project using the same Oracle database and all 6 rows of records does show up in NetBeans.

So what could have gone wrong?
Modifications performed by a session are not visible to others until they are commited. Issue a commit after performing these changes.