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> 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> 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 & 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
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
So what could have gone wrong?