Bug #28129 "Connection Reset" Property Can not afford any change

• Submitted: 27 Apr 2007 5:01
• Modified: 9 Jun 2007 15:08
• Reporter: jiang xun
• Status: No Feedback
• Category: Connector / NET
• Severity: S1 (Critical)
• Version: MySQL 4.0.1,MySQL 5.0
• OS: Windows (XP Sp1)
• CPU Architecture: Any

[27 Apr 2007 5:01] jiang xun

Description:
If a "Connection Reset" Property And a "CharSet" Property had been also Existed, "CharSet" Property will Lost it's role, It Can not afford any change 。I've tested with MySQL 4.0.1 and MySQL 5.0

That is My Function:
		public void Initilize() 
		{
			StringBuilder connStr = new StringBuilder();

			//keyword values 
			connStr.Append("Connection Timeout=").Append(nConnTimeOut).Append(";");
			connStr.Append("Host=").Append(strHost).Append(";");
			connStr.Append("Port=").Append(nPort).Append(";");
			connStr.Append("Protocol=").Append(strProtocol).Append(";");
			connStr.Append("CharSet=").Append(strCharset).Append(";");
			connStr.Append("Logging=").Append(bLogging).Append(";");
			connStr.Append("Allow Batch=").Append(bAllowBatch).Append(";");
			/* connStr.Append("Encrypt=").Append(bEncrypt).Append(";"); */ // Not Supported Yet
			connStr.Append("Database=").Append( strDatabase).Append(";");
			connStr.Append("pwd=").Append(strPwd).Append(";");
			connStr.Append("Persist Security Info=").Append(bPersistSecurityInfo).Append(";");
			connStr.Append("Uid=").Append(strUid).Append(";");
			connStr.Append("Shared Memory Name=").Append(strSharedMemoryName).Append(";");
			connStr.Append("Allow Zero Datetime=").Append(bAllowZeroDatetime).Append(";");
			connStr.Append("Convert Zero Datetime=").Append( bConvertZeroDatetime).Append(";");
			connStr.Append("Old Syntax=").Append(bOldSyntax).Append(";");
			connStr.Append("Pipe Name=").Append(strPipeName).Append(";");
			/* connStr.Append("Use Performance Monitor=").Append(bUsePerformanceMonitor).Append(";"); */ // Not Supported Yet
			connStr.Append("Procedure Cache Size=").Append(nProcedureCacheSize).Append(";");
			connStr.Append("Ignore Prepare=").Append(bIgnorePrepare).Append(";");
			/* connStr.Append("Use Procedure Bodies=").Append(bUseProcedureBodies).Append(";"); */ // Not Supported Yet

			//connection pooling values 
			connStr.Append("Connection Lifetime=").Append(nConnectLifeTime).Append(";");
			connStr.Append("Max Pool Size=").Append(nMaxPoolSize).Append(";");
			connStr.Append("Min Pool Size=").Append(nMinPoolSize).Append(";");
			connStr.Append("Pooling=").Append(bPooling).Append(";");
			connStr.Append("Connection Reset=").Append(bConnectionReset).Append(";");

			strConnStr = connStr.ToString();
		}

How to repeat:
JOB:[e-mail]
MSN:[e-mail]
Mail:[e-mail]

[27 Apr 2007 5:02] jiang xun

MySQL数据库连接源,支持MySQL5.0及前版本，.NET Framework2.0及前版本

Attachment: DataSource.cs (text/plain), 16.32 KiB.

[3 May 2007 8:18] Tonci Grgin

Hello Jiang and thanks for your report. As I can't read Chinese, can you tell me, please, which version of connector/NET are you using?

[8 May 2007 12:46] jiang xun

Hello tonci and thanks for your reply,The version of connector/NET was mysql-connector-net-1.0.9.All Environment as those are:
--------------------------------------------
OS:Windows XP Pro sp1（Chinese Version）
Database:MySQL 4.0.1,MySQL 5.0
connector/NET:mysql-connector-net-1.0.9
.net Framework:Microsoft .net Framework 1.1
Develop Toolkit:Visual Studio .net 2003
Develop Language:C#
--------------------------------------------
Look forward to your reply,Thank you.

[9 May 2007 15:08] Tonci Grgin

Hi Jiang. I have NET FW 2.0 / VS2005 and your class ManagedThreadPool can't be found there... Can you rewrite the test case so that it doesn't use it, or multi threading, at all?

[9 Jun 2007 23:00] Bugs System

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".