WEBrick hangs with OCI8?

Rails
1

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

2

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/

3

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

Bealach