similar to: SQLite concurrency, SQLite3::BusyException

All, I''ve written a simple job/opportunity tracking database app via RoR. I have about 10 internal users. Sometimes 2 people will want to update the same record at more or less the same time and they collide. In particular user 1 may edit a record, then get distracted, and finally an hour later they click save. During that hour user 2 may have pulled up the record, edited it, and

I get too often SQLite3::BusyException and after searching a bit I think I''d need to install a busy_hanlder to return true. That seems to be per connection, how would you do this in a global way in Rails? -- fxn

If do something like this: dbObj = MyTable.find_by_id(5) a = dbObj.name b = dbObj.name How many times will an SQL call be made to get the value of MyTable.name for id 5? In other words, are the values for dbObj cached in the object? Is there a way of controlling that? (I can imagine that sometimes you might not want to cache them if you wanted to be sure of having the latest

Just wondering if anyone is using a backend database other than sqlite, and if so, how easy/hard it was to configure. I''m constantly receiving "SQLite3::BusyException: database is locked..." which I presume is due to sqlite''s relatively coarse locking method. Cheers, James -- Senior Linux Platform Engineer Midrange Services AXA Technology Services - Asia Pacific

I use feedtools to generate the feeds and read them,and now they can not work well: This is the code for feed generating: class FeedsController < ApplicationController def userrss @user = User.find_by_id(params[:id]) @articles = @user.articles(:all,:order => ''updated_at desc'') @headers["Content-Type"] = "application/xml; charset=utf-8"

Hi, Strange behavior here. On my dev machine code works, but on the production machine I get the dreaded: SQLite3::BusyException: database is locked INSERT INTO "comments" [...] What kind of bug could yield such behavior? It''s impossible the database times out, there are no concurrent requests coming in, and the db is only 150kB. Is there a possible race condition? Caching

I have an application where speed is probably the #1 priority here. I am using MySQL 5.0.22. Would SQL be considerably faster than MySQL? I know this has been discussed before, but the search on the forums is not working. Thanks for your help. -- Posted via http://www.ruby-forum.com/.

Shouldn''t update_all be updating lock_version? As you can see from my console session below, it is upating the record (changed running attribute to true and returned 1 to show 1 recored was updated). But it did not increment lock_version. And optimistic locking is working correctly otherwise. As you can see below, lock version = 562 before and after the update_all call but it is

Hello, I do this a=c(10.2,0.4,0.2,5.2,8.6,1.6,0.0,1.0,6.3,1.4,0.4,0.2) b=matrix(a,nrow=4) rownames(b)=c("20/04/2002","21/04/2002","22/04/2002","23/04/2002") colnames(b)=c("p1","p2","p3") barplot(b,beside=T,col=(c("red","orange","yellow"))) then I have

Hi, First ,please excuse my poor English. Can someone help me on reading fortran binary object under R? I was trying to read mm5 data under R. However, I seem to stuck at reading fortran binary file storing met. data array. At the beginning, I used readBin() to read mm5 output directly with the following command. #mmout is a mmout file generated with mm5

Forgive me please if this has been answered previously, but the r-help archive doesn't have a "search" capability. It's a pity, as I'm sure that there's a wealth of informative help in there. I am unable to get the "cloud" function to produce a fundamental 3D scatterplot. I have a 3-column numeric matrix: >is.matrix(sanity.MIF); is.numeric(sanity.MIF);

I have a model named User. When running this application from the console I can call User.find_by_id(nil) and it returns nil. When running this application during testing or through WEBrick or Mongrel calling User.find_by_id(nil) returns the newest record in the database. But it only does this the first time you call it with nil. The second time you call User.find_by_id(nil) it returns nil.

I''m working on an app that makes use of rails'' optimistic locking feature and seeing some possibilities for improvements. It seems a bit tedious to have to add :lock_version to forms wherever the model is used. You also have to "hack" around rails'' UJS feature to add it as a URL parameter when using remote: true, method: [:put, :patch, :post, :delete].

Hello - 1. Is there any way to directly export R plots to MIF format for import into FrameMaker? 2. If not, how hard would it be to add such a device driver? I don't see device driver docs in the R extensions docs. Are drivers contained in their own source files with simple interfaces to the data structures with plot data? 3. If that's difficult, what workarounds are

Hi everyone, I have a order with order_lines use case. On changing the lines, I want to be sure no one else changed the order. So I use lock_version on the order. This works fine if something is changed on the order record. But now i have the situation that I delete, alter and add order lines without changing the order record itself. I have to check and increment the order#lock_version however

Hi All, I''m having some trouble deciding when and how to implement optimistic locking. Let''s say I have a multiuser Rails app, and let''s say it stores, among other things "vital" customer information. The standard methods created by the Rails generate scaffold script look like this: def edit @customer = Customer.find(params[:id]) end

Hi, Is there a way to tell Rails that the magic field name for optimistic database locking is not lock_version? I have a legacy database where the optimistic locking field is named "version". Thanks, Phil -- Posted via http://www.ruby-forum.com/.

Hello, to implement some some kind of optimistic locking, I want to build a view, where an object is displayed together with a link containing the data of the displayed object. My first try looked something like <%= object.object_discription %> <%= link_to "action", :action => "take_action", :data => object %> this won''t work because object is of

Hi all I have a Model like this: class Member < ActiveRecord::Base attr_accessible :username, :email, :first_name, :last_name end I have created a scaffold using script/generate scaffold member members Using the URL localhost:3000/members/edit/1 I can edit all attributes, including created_at, lock_version etc.! But it should only show the attributes I listed in attr_accessible! What

hi all, i got a problem of no such file to load -- sqlite3, after installing new rails version yesterday... the uninstallation gone through this way... $ gem uninstall rails successfully uninstalled rails-1.2.3 Remove executables and scrips for ''rails'' in addition to the gem ? [Y/n] - then i gave it ''Y'' *** as like it gone