WEBrick hangs with OCI8?

Has anyone experienced “hangs” with the WEBrick/OCI8 combination?

The sequence of actions I perform to consistently get WEBrick to hang
is:

  1. start WEBrick
  2. list a table form my Oracle 10g DB
  3. startup sqlplus and update a few records in the table
  4. go back to my browser and reload the table
    Here none of the chances I made directly to the table are reflected
    in the listing.
    Restarting WEBrick and/or the browser does not help either.
  5. hit the “edit” button for a record that I know I’ve changed with
    sqlplus
  6. make a change and hit “update”. Now WEBrick goes into thinking mode
    and will not respond.

Warm regards,

Bealach

Bealach Na Bo wrote:

Has anyone experienced “hangs” with the WEBrick/OCI8 combination?

The sequence of actions I perform to consistently get WEBrick to hang is:

  1. start WEBrick
  2. list a table form my Oracle 10g DB
  3. startup sqlplus and update a few records in the table

I think you need to type

COMMIT;

at this point, otherwise you’re still in a transaction in sqlplus and
any other
connections will block for the transaction to be committed or rolled
back.

Regards,
Blair


Blair Z., Ph.D.
[email protected]
Subversion training, consulting and support
http://www.orcaware.com/svn/

Of course! Thank you Blair. I normally have AUTOCOMMIT set, but forgot
all about it this time.

Bealach

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs