Tags "transactions" Result

C# transactions v SQL transactions

I''ve been using C# transactions for a while and had no problems with them. Using try catch blocks I can trap basically all possible errors and rollback all necessary data. Over the last few days I''ve been trying to convert some of this code to SQL Server stored procedures, but it seems to lack many of the benefits of C# transactions - a lot of

it1352 2 2019-07-04

Seeing only your own data in Grails

This seems like a fundamental question, but I haven't found a clear answer. I'm using the spring-security-core plugin with Grails, and I have S2Users who have many Portfolios, and Portfolios have many Transactions. When I go to a scaffolded view to examine Transactions, how do I know that each user is only seeing his own Transactions? Conversely

it1352 0 2019-05-19

MongoDB transactions?

Playing around with MongoDB and NoRM in .NET. Thing that confused me - there are no transactions (can't just tell MongoConnection.Begin/EndTransaction or something like that). I want to use Unit of work pattern and rollback changes in case something fails. Is there still a clean way how to enrich my repository with ITransaction? Solution MongoD

it1352 1 2019-05-06

Rails transactions

I am trying to use ActiveRecord::Base.transaction. I figured that rollback doesn't work by default using Rails 1.2.6 and mysql 5.0. Playing with it a little bit more I found out that autocommit is not set to 0 in mysql connection. Questions: 1) How do I disable autocommit in rails for all connections? 2) Will it have some negative impact on the

it1352 1 2019-05-07

Codeigniter Transactions

I'm using Codeigniter transactions : $this->db->trans_start(); $this->db->query('AN SQL QUERY...'); $this->db->trans_complete(); This works fine , the problem I have is that inside the trans_start and trans_complete I'm calling other functions and those functions deals with database so they contains inserts and update and some

it1352 3 2019-05-13

Ruby on Rails Join Table Associations

I have a Ruby on Rails application setup like so: User Model has_and_belongs_to_many :roles Role Model has_many :transactions has_and_belongs_to_many :users Transaction Model belongs_to :role This means that a join table is used called roles_users and it also means that a user can only see the transactions that have been assigned to them

it1352 0 2019-05-07