TransPB_dict.Item(1).Rollback() 'THIS THROWS THE ERROR This SqlTransaction has completed it is no longer usable If transPB_dict.ContainsKey(1) Then 'SUCCESSĭim transPBsite_dict = execDBTrans_valMod("transPBsite", failSubject, failBody, buildInsert_PBsite)Įlse 'Failed to create the tables for this user so rollback all the tables that were created in the previous transaction (all the old tables in panelbase)
VALMOD DOWNLOAD FOR SERVERS CODE
Then i have the following code in a function: Dim transPB_dict = execDBTrans_valMod("transPB", failSubject, failBody, buildInsert) ' This catch block will handle any errors that may have occurred on the server that would cause the rollback to fail, such as a closed connection. 'transaction.Commit() DO NOT COMMIT so that we can commit only after we verify that pbSite can be inserted If a server owner wants them, he/she should add them manually (and should be able to, otherwise running a modded server would be no the wisest choice). All those new Zombies and bandits, which are not really balanced and only partially ready to use, should be part of other mods. Using connection As New SqlConnection(ConfigurationManager.ConnectionStrings(connectionString).ToString) 'LATEST EXECĭim command As New SqlCommand(queryString, connection)ĭim transaction As SqlTransaction = connection.BeginTransaction(transactionName)Ĭommand.CommandTimeout = 3600 'Used for large updates My personal opinion, Valmod should focus on balancing and crafting. Public Function execDBTrans_valMod(transactionName As String, ByVal emailSubject As String, ByVal emailBody As String, ByVal queryString As String, Optional ByVal connectionString As String = "SQLConnectionHere") As Dictionary(Of Integer, SqlTransaction)ĭim trans_dict As New Dictionary(Of Integer, SqlTransaction) 1 (meaning transaction failed and didnt manage to rollback) -> sql transaction So I have the following function which returns a dictionary that can be one of the states:Ġ (meaning transaction failed but managed to rollback) -> sql transactionġ (meaning transaction was successful) -> sql transaction
I am trying to test the first transaction and if it is a SUCCESS, then i try the second one, if the second is also a SUCCESS then i commit both, if the second is a fail, i need to roll back the first.
0 kommentar(er)
