///<summary>Turns "pooling" off, then opens the current database connection, adds that connection to the dictionary of MySqlConnections, then returns the unique ServerThread. ///The returned ServerThread can then be used later in order to stop the query in the middle of executing. ///A non-pooled connection will NOT attempt to re-use connections to the DB that already exist but are idle, ///rather it will create a brand new connection that no other connection can use. ///This is so that user queries can be safely cancelled if needed. ///Required as a first step for user queries (and ONLY user queries). ///Not currently Oracle compatible.</summary> public static int GetServerThread(bool isReportServer) { if (RemotingClient.RemotingRole == RemotingRole.ClientWeb) { return(Meth.GetInt(MethodBase.GetCurrentMethod(), isReportServer)); } MySqlConnection con = new MySqlConnection(); if (isReportServer) { con = new MySqlConnection(DataConnection.GetReportConnectionString() + ";pooling=false"); } else { //all connection details are the same, except pooling should be false. con = new MySqlConnection(DataConnection.GetCurrentConnectionString() + ";pooling=false"); } con.Open(); int serverThread = con.ServerThread; //If the dictionary already contains the ServerThread key, then something went wrong. Just stop and throw. if (_dictCons.ContainsKey(serverThread)) { con.Close(); throw new ApplicationException("Critical error in GetServerThread: A duplicate connection was found via the server thread ID."); } lock (_lockObj) { _dictCons[serverThread] = con; } return(serverThread); }
///<summary>Turns "pooling" off, then opens the current database connection, adds that connection to the dictionary of MySqlConnections, then returns the unique ServerThread. ///The returned ServerThread can then be used later in order to stop the query in the middle of executing. ///A non-pooled connection will NOT attempt to re-use connections to the DB that already exist but are idle, ///rather it will create a brand new connection that no other connection can use. ///This is so that user queries can be safely cancelled if needed. ///Required as a first step for user queries (and ONLY user queries). ///Not currently Oracle compatible.</summary> public static int GetServerThread(bool isReportServer) { if (RemotingClient.RemotingRole == RemotingRole.ClientWeb) { return(Meth.GetInt(MethodBase.GetCurrentMethod(), isReportServer)); } MySqlConnection con = new MySqlConnection(); if (isReportServer) { if (ODBuild.IsWeb() && PrefC.ReportingServer.Server != "" && PrefC.ReportingServer.Database != DataConnection.GetDatabaseName()) { //Security safeguard to prevent Web users from connecting to another office's database. throw new ODException("Report server database name must match current database."); } con = new MySqlConnection( DataConnection.GetReportConnectionString( PrefC.ReportingServer.Server , PrefC.ReportingServer.Database , PrefC.ReportingServer.MySqlUser , PrefC.ReportingServer.MySqlPass) + ";pooling=false"); } else { //Use the database user with lower permissions when in Middle Tier since this method is explicitly designed for the User Query window. string connectStr = (RemotingClient.RemotingRole == RemotingRole.ServerWeb ? DataConnection.GetLowConnectionString() : DataConnection.GetCurrentConnectionString()); //all connection details are the same, except pooling should be false. con = new MySqlConnection(connectStr + ";pooling=false"); } con.Open(); int serverThread = con.ServerThread; //If the dictionary already contains the ServerThread key, then something went wrong. Just stop and throw. if (_dictCons.ContainsKey(serverThread)) { con.Close(); throw new ApplicationException("Critical error in GetServerThread: A duplicate connection was found via the server thread ID."); } lock (_lockObj) { _dictCons[serverThread] = con; } return(serverThread); }