diff options
author | Charles Krinke | 2008-07-12 18:05:57 +0000 |
---|---|---|
committer | Charles Krinke | 2008-07-12 18:05:57 +0000 |
commit | 932ed5ec549ff3f6c4ea50963f9be1d9902e446b (patch) | |
tree | fa0cd300350e5383b9bb09100a9ddf1b59b102f9 /OpenSim/Data/MSSQL/MSSQLGridData.cs | |
parent | Mantis#1681. Thank you kindly, Vytek for a patch that: (diff) | |
download | opensim-SC_OLD-932ed5ec549ff3f6c4ea50963f9be1d9902e446b.zip opensim-SC_OLD-932ed5ec549ff3f6c4ea50963f9be1d9902e446b.tar.gz opensim-SC_OLD-932ed5ec549ff3f6c4ea50963f9be1d9902e446b.tar.bz2 opensim-SC_OLD-932ed5ec549ff3f6c4ea50963f9be1d9902e446b.tar.xz |
Mantis#1726. Thank you kindly, StrawberryFride for a patch that:
On an MSSQL-based Grid OpenSim installation, users could log in to the sim once,
then log off - after a short time before retrying users would be unable to log in,
and would see an empty alert box on the client with just a "close" button and no text.
Despite no users being logged into the sim, user server would report a higher number
of logins than logouts.
Diffstat (limited to 'OpenSim/Data/MSSQL/MSSQLGridData.cs')
-rw-r--r-- | OpenSim/Data/MSSQL/MSSQLGridData.cs | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/OpenSim/Data/MSSQL/MSSQLGridData.cs b/OpenSim/Data/MSSQL/MSSQLGridData.cs index e2b0dd6..1ed412b 100644 --- a/OpenSim/Data/MSSQL/MSSQLGridData.cs +++ b/OpenSim/Data/MSSQL/MSSQLGridData.cs | |||
@@ -149,6 +149,10 @@ namespace OpenSim.Data.MSSQL | |||
149 | IDataReader reader = null; | 149 | IDataReader reader = null; |
150 | try | 150 | try |
151 | { | 151 | { |
152 | if (database.getConnection().State == ConnectionState.Closed) | ||
153 | { | ||
154 | database.Reconnect(); | ||
155 | } | ||
152 | Dictionary<string, string> param = new Dictionary<string, string>(); | 156 | Dictionary<string, string> param = new Dictionary<string, string>(); |
153 | param["handle"] = handle.ToString(); | 157 | param["handle"] = handle.ToString(); |
154 | IDbCommand result = database.Query("SELECT * FROM " + m_regionsTableName + " WHERE regionHandle = @handle", param); | 158 | IDbCommand result = database.Query("SELECT * FROM " + m_regionsTableName + " WHERE regionHandle = @handle", param); |