This discussion is archived
3 Replies Latest reply: Feb 4, 2013 10:47 AM by Gary Graham RSS

SQl Developer not fetching the latest database updates

988405 Newbie
Currently Being Moderated
Hi ,

I started SQL Developer just recently.

I had a connection file which I imported to connect to my oracle server .

I am encountering a weird Problem. I am unable to retrive any update done to the DB.

For example,

My DB server to which i connect has say 50 rows in a table , the day I connected to DB.

I am able to see all the details of those 50 rows details.This is fine.

Say today I added one more row .

I am unable to get the details of the row 51 which I added recently.

Please help and bear with my wordings.

Thanks
Ramesh
  • 1. Re: SQl Developer not fetching the latest database updates
    Gary Graham Expert
    Currently Being Moderated
    Hi Ramesh,
    I am unable to get the details of the row 51 which I added recently.
    Did you remember to commit the row you added? Both the worksheet and the object editor Data tab toolbars have a Commit icon. Also, from the worksheet, you can type and execute the commit statement.

    And once you commit, did check the Message - Log pane to verify that no error (e.g., constraint violation) prevented the commit from succeeding?

    Regards,
    Gary
  • 2. Re: SQl Developer not fetching the latest database updates
    988405 Newbie
    Currently Being Moderated
    Hi Gary,

    Thanks for the reply .

    The database is commited . As i can see the change in the UI .

    But my session is not able to interact with the current session of the DB .

    The out it gives corresponds to the old stat of the database.

    As I describesd earlier,The output from query is correct as of two months old.

    Is there any cache setting in the sql developer that I am missing ?

    Thanks
    Ramesh
  • 3. Re: SQl Developer not fetching the latest database updates
    Gary Graham Expert
    Currently Being Moderated
    Since your "magic number" is 50, the most likely reason is the following combination of configuration choices:

    1. Your Tools -> Preferences -> Database - Advanced -> Sql Array Fetch Size is 50 (the default)
    2. You choose to use a Java 1.7 rather than Java 1.6
    3. You are not using the latest production release of SQL Developer

    Either increase the Sql Array Fetch Size, downgrade to Java 1.6, or upgrade to the latest SQL Developer.

    Hope this helps,
    Gary

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points