Hi John, Thanks for the quick response.. I tried the singlecon.rb at http://gist.github.com/112174 I tried to use it as is.. It had some errors such as
uninitialized class variable @@connection in OpenWFE::Extras::SingleConnectionMixin With my limited Ruby knowledge I tried a few things to do away with this error.. Once I was through I again received the same error of ActiveRecord::ConnectionNotEstablished in ProcessesController#show Also on the console It dumps this infinite times-------- [1, #<ActiveRecord::ConnectionAdapters::JdbcAdapter:0x1304a7c @connection=#<ActiveRecord::ConnectionAdapters::JdbcConnection: 0x1e1b0e7 @adapter=#<ActiveRecord::ConnectionAdapters::JdbcAdapter: 0x1304a7c ...>, @connection=#<Java::ComMysqlJdbc::Connection:0x2516dc @java_object=#<Java::JavaObject:0x1000323>> [2, #<ActiveRecord::ConnectionAdapters::JdbcAdapter:0x1304a7c @connection=#<ActiveRecord::ConnectionAdapters::JdbcConnection: 0x1e1b0e7 @adapter=#<ActiveRecord::ConnectionAdapters::JdbcAdapter: 0x1304a7c ...>, @connection=#<Java::ComMysqlJdbc::Connection:0x2516dc @java_object=#<Java::JavaObject:0x1000323>> -------------------------------------------------------------------------------------------------------- Am I missing anything? On a side note.. Is the MySQL version an issue?I am using MySQL 5.0.37.. Shall I update? Thanks, Pranav On May 15, 4:28 pm, John Mettraux <[email protected]> wrote: > On Fri, May 15, 2009 at 8:12 PM, pranav <[email protected]> wrote: > > > I apologize to have posted the same question on different thread. > > I am working on windows, JRuby 1.2.0, Rails 2.3.2. > > I am using ruote-web2 and trying to launch a process definition. > > The problem that I face is of activerecord losing connection when I > > launch a process. > > Previously when I was working with MS SQL Server, I thought it was > > because of it that I was facing that error. > > After reading on few threads I noticed that ruote-web2 is working fine > > with MySQL. > > So I now I am using MySQL as my DB. I have activerecord-jdbcmysql- > > adapter and jdbc-mysql driver gems installed. It performs db:migrate, > > data:populate correctly. I am able to create a new user, define a new > > process. > > But, I still get the same error when I try to launch any process > > definition (even SimpleSequence and LeaveRequest) > > Following is the error - > > > ActiveRecord::ConnectionNotEstablished in ProcessesController#show > > Hi Pranav, > > thanks for the detailed report, neat ! > > Could you please replace your lib/openwfe/extras/singlecon.rb with the one at > : > > http://gist.github.com/112174 > > and then observe the "reconnection" behaviour ? > > This twisted version of singlecon is meant to ouput to stdout its > attempts at connection to the database. It should be informative. > > Best regards, > > -- > John Mettraux - http://jmettraux.wordpress.com --~--~---------~--~----~------------~-------~--~----~ you received this message because you are subscribed to the "ruote users" group. to post : send email to [email protected] to unsubscribe : send email to [email protected] more options : http://groups.google.com/group/openwferu-users?hl=en -~----------~----~----~----~------~----~------~--~---
