Displaying 2 results from an estimated 2 matches for "implicit_transactions".
2006 Jan 19
3
problems with migrations in sql server
...** Invoke migrate (first_time)
** Invoke environment (first_time)
** Execute environment
** Execute migrate
** Invoke db_schema_dump (first_time)
** Invoke environment
** Execute db_schema_dump
The following SQL is executed:
Audit Login -- network protocol: TCP/IP
set quoted_identifier on
set implicit_transactions off
set cursor_close_on_commit off
set ansi_warnings on
set ansi_padding on
set ansi_nulls on
set concat_null_yields_null on
set language us_english
set dateformat mdy
set datefirst 7
54
SQL:BatchCompleted set implicit_transactions on 54
SQL:BatchCompleted SELECT 1 54
SQL:BatchComp...
2006 Sep 18
1
SQLServer adapter fails to commit on save()
...es appear. Using the SQL Server profiler I
see
the line "IF @@TRANCOUNT > 0 COMMIT TRAN" for IRB, but not my test. If I
add
"report.connection.commit_db_transaction()" after report.save the record
does appear.
Although I never ask for transactions, it is turning on
"implicit_transactions" in SQLServer (in my test and IRB), but somehow
the commit is never happening.
Thanks for any assistance.
Regards,
Gary
--
Posted via http://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Grou...