From cb2ae6eaed5b5038dc6239bebe30242687993027 Mon Sep 17 00:00:00 2001
From: Tleiades Hax
Date: Thu, 1 Nov 2007 21:36:47 +0000
Subject: 

---
 OpenSim/Framework/Data.MySQL/MySQLAssetData.cs | 24 ++++++++++++++----------
 1 file changed, 14 insertions(+), 10 deletions(-)

(limited to 'OpenSim/Framework')

diff --git a/OpenSim/Framework/Data.MySQL/MySQLAssetData.cs b/OpenSim/Framework/Data.MySQL/MySQLAssetData.cs
index 055cd92..114538d 100644
--- a/OpenSim/Framework/Data.MySQL/MySQLAssetData.cs
+++ b/OpenSim/Framework/Data.MySQL/MySQLAssetData.cs
@@ -101,16 +101,20 @@ namespace OpenSim.Framework.Data.MySQL
                     "REPLACE INTO assets(id, name, description, assetType, invType, local, temporary, data)" +
                     "VALUES(?id, ?name, ?description, ?assetType, ?invType, ?local, ?temporary, ?data)",
                     _dbConnection.Connection);
-            MySqlParameter p = cmd.Parameters.Add("?id", MySqlDbType.Binary, 16);
-            p.Value = asset.FullID.GetBytes();
-            cmd.Parameters.AddWithValue("?name", asset.Name);
-            cmd.Parameters.AddWithValue("?description", asset.Description);
-            cmd.Parameters.AddWithValue("?assetType", asset.Type);
-            cmd.Parameters.AddWithValue("?invType", asset.InvType);
-            cmd.Parameters.AddWithValue("?local", asset.Local);
-            cmd.Parameters.AddWithValue("?temporary", asset.Temporary);
-            cmd.Parameters.AddWithValue("?data", asset.Data);
-            cmd.ExecuteNonQuery();
+
+            using (cmd)
+            {
+                MySqlParameter p = cmd.Parameters.Add("?id", MySqlDbType.Binary, 16);
+                p.Value = asset.FullID.GetBytes();
+                cmd.Parameters.AddWithValue("?name", asset.Name);
+                cmd.Parameters.AddWithValue("?description", asset.Description);
+                cmd.Parameters.AddWithValue("?assetType", asset.Type);
+                cmd.Parameters.AddWithValue("?invType", asset.InvType);
+                cmd.Parameters.AddWithValue("?local", asset.Local);
+                cmd.Parameters.AddWithValue("?temporary", asset.Temporary);
+                cmd.Parameters.AddWithValue("?data", asset.Data);
+                cmd.ExecuteNonQuery();
+            }
         }
 
         public void UpdateAsset(AssetBase asset)
-- 
cgit v1.1