DevForce Community Forum : Pervasive PSQL Provider and Enlist Transaction

DevForce Community Forum : Pervasive PSQL Provider and Enlist Transaction http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Pervasive PSQL Provider and Enlist Transaction Wed, 29 Jul 2026 14:03:56 -700 Fri, 21 Jan 2011 21:26:33 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2428 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Pervasive PSQL Provider and Enlist Transaction : I needed to make a PSQL connection... http://www.ideablade.com/forum/forum_posts.asp?TID=2428&PID=9752#9752 Author: thecotton
Subject: 2428
Posted: 21-Jan-2011 at 9:26pm

I needed to make a PSQL connection to the database before the save (and that's also where I needed to do the PSQL BeginTransaction, but that wouldn't have prevented saving changes). No hill for a climber. I'm just now beginning to get a feel for what needs to be done. I have just been making things too complicated....

]]> Fri, 21 Jan 2011 21:26:33 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2428&PID=9752#9752 Pervasive PSQL Provider and Enlist Transaction : Hi thecotton, I'm glad... http://www.ideablade.com/forum/forum_posts.asp?TID=2428&PID=9677#9677 Author: sbelini
Subject: 2428
Posted: 18-Jan-2011 at 10:35am

Hi thecotton,

I'm glad you solved the first issue.

What problem are you having while trying to save changes?

]]> Tue, 18 Jan 2011 10:35:36 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2428&PID=9677#9677 Pervasive PSQL Provider and Enlist Transaction : I am setting as follows: Imports... http://www.ideablade.com/forum/forum_posts.asp?TID=2428&PID=9656#9656 Author: thecotton
Subject: 2428
Posted: 14-Jan-2011 at 6:02pm

I am setting as follows:
Imports IbEm = IdeaBlade.EntityModel
Imports IbCore = IdeaBlade.Core
Imports DevForceTest.TrackerEntities
Public Class TrafficForm
Dim qts As New IbEm.TransactionSettings(Transactions.IsolationLevel.ReadCommitted, New TimeSpan(0, 0, 15), False)
Dim ts As New IbEm.TransactionSettings(Transactions.IsolationLevel.ReadCommitted, New TimeSpan(0, 0, 15), False)
Dim WithEvents Tracker As New DevForceTest.TrackerEntities
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
TrackerEntities.DefaultManager.DefaultQueryStrategy = TrackerEntities.DefaultManager.DefaultQueryStrategy.With(qts) ‘ adding this line fixed problem
TrackerEntities.DefaultManager.DefaultSaveOptions.TransactionSettings = ts
TrackerEntities.DefaultManager.Connect()
Try
Me.TrafficBindingSource.DataSource = _
Tracker.Traffics.OrderBy(Of Integer)(Function(Traffic) Traffic.TrafKey).ToList()
Catch ex As Exception
Debug.Print(ex.Message)
End Try
End Sub

Private Sub Tracker_Saving(ByVal sender As Object, ByVal e As IdeaBlade.EntityModel.EntitySavingEventArgs) Handles Tracker.Saving
Debug.Print("Saving")
End Sub
End Class
I discovered that I was setting DefaultSaveOptions.TransactionSettings, but had failed to set TransactionSettings for DefaultQueryStrategy. Now that I am setting both, the connection error has gone away. I also picked up your much-more-understandable TransactionSettings.Default, which would have done away with much of my code.

Now if I can only figure out why it is not saving changes, I may get this worked out....
]]> Fri, 14 Jan 2011 18:02:32 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2428&PID=9656#9656 Pervasive PSQL Provider and Enlist Transaction : Hi thecotton, Where... http://www.ideablade.com/forum/forum_posts.asp?TID=2428&PID=9647#9647 Author: sbelini
Subject: 2428
Posted: 13-Jan-2011 at 5:42pm

Hi thecotton,

Where are you setting UseTransactionScope?

(I'm assuming you are using

TransactionSettings.Default = new TransactionSettings (System.Transactions.IsolationLevel.ReadCommitted, new TimeSpan(0, 1, 0), false);

if not let me know how you are setting it)

Also, could you verify that UseTransactionScope is set to false right before the save/query throwing the exception?

(i.e.

var queryTransactional = mgr.DefaultQueryStrategy.TransactionSettings.UseTransactionScope;

var saveTransactional = mgr.DefaultSaveOptions.TransactionSettings.UseTransactionScope;

)

Silvio.

]]> Thu, 13 Jan 2011 17:42:58 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2428&PID=9647#9647 Pervasive PSQL Provider and Enlist Transaction : The Pervasive PSQL .Net provider... http://www.ideablade.com/forum/forum_posts.asp?TID=2428&PID=9598#9598 Author: thecotton
Subject: 2428
Posted: 08-Jan-2011 at 9:38pm

The Pervasive PSQL .Net provider 3.5 is compatible with EF2 and Framework 4 EXCEPT that it does not currently support distributed transactions - only local transactions. It works fine with the VS 2010 entity data model (ie, without Devforce EF), but I have had zero success getting it to work with Devforce. If I set the connection to enlist transactions, I get an exception of "The underlying provider failed on open" with inner exception "Specified method is not supported" as was expected from Pervasive documentation. When I set the connection NOT to enlist transactions, I get exception from Ideablade.EntityModel "The underlying provider failed on Enlist Transaction". I have tried setting TransactionSettings to change UseTransactionScope to false, but I srill get the same error. Checking the Pervasive trace log, it would appear that the Pervasive provider did not throw the error - it just shows to have opened the connection and then closed it when I stop the debugger.

What can I do to allow use of the PSQL provider without enlisting transactions? Again, when used with the entity framework modeler alone, it works OK.

]]> Sat, 08 Jan 2011 21:38:59 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2428&PID=9598#9598