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 tableI 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 Zajac, Ph.D. <blair@orcaware.com> 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 On 6/23/06, Blair Zajac <blair@orcaware.com> wrote:> 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 Zajac, Ph.D. > <blair@orcaware.com> > Subversion training, consulting and support > http://www.orcaware.com/svn/ > _______________________________________________ > Rails mailing list > Rails@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails >