[Nhibernate-commit] SF.net SVN: nhibernate:[4915] trunk/nhibernate/src/NHibernate

[<aye...@us...>]

Revision: 4915
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=4915&view=rev
Author:   ayenderahien
Date:     2010-01-08 10:09:47 +0000 (Fri, 08 Jan 2010)

Log Message:
-----------
Explicitly set parameter sizes - prevent query cache plan per each actual parameter size

Modified Paths:
--------------
    trunk/nhibernate/src/NHibernate/Driver/OdbcDriver.cs
    trunk/nhibernate/src/NHibernate/Driver/SqlClientDriver.cs
    trunk/nhibernate/src/NHibernate.Test/SqlTest/Identity/MsSQL/MSSQLIdentityInsertWithStoredProcsTest.cs

Modified: trunk/nhibernate/src/NHibernate/Driver/OdbcDriver.cs
===================================================================
--- trunk/nhibernate/src/NHibernate/Driver/OdbcDriver.cs	2010-01-08 06:57:28 UTC (rev 4914)
+++ trunk/nhibernate/src/NHibernate/Driver/OdbcDriver.cs	2010-01-08 10:09:47 UTC (rev 4915)
@@ -69,7 +69,7 @@
 		public override IDbCommand GenerateCommand(CommandType type, SqlString sqlString, SqlType[] parameterTypes)
 		{
 			IDbCommand command = base.GenerateCommand(type, sqlString, parameterTypes);
-			if (IsPrepareSqlEnabled)
+			//if (IsPrepareSqlEnabled)
 			{
 				SetParameterSizes(command.Parameters, parameterTypes);
 			}

Modified: trunk/nhibernate/src/NHibernate/Driver/SqlClientDriver.cs
===================================================================
--- trunk/nhibernate/src/NHibernate/Driver/SqlClientDriver.cs	2010-01-08 06:57:28 UTC (rev 4914)
+++ trunk/nhibernate/src/NHibernate/Driver/SqlClientDriver.cs	2010-01-08 10:09:47 UTC (rev 4915)
@@ -153,7 +153,7 @@
 		public override IDbCommand GenerateCommand(CommandType type, SqlString sqlString, SqlType[] parameterTypes)
 		{
 			IDbCommand command = base.GenerateCommand(type, sqlString, parameterTypes);
-			if (IsPrepareSqlEnabled)
+			//if (IsPrepareSqlEnabled)
 			{
 				SetParameterSizes(command.Parameters, parameterTypes);
 			}

Modified: trunk/nhibernate/src/NHibernate.Test/SqlTest/Identity/MsSQL/MSSQLIdentityInsertWithStoredProcsTest.cs
===================================================================
--- trunk/nhibernate/src/NHibernate.Test/SqlTest/Identity/MsSQL/MSSQLIdentityInsertWithStoredProcsTest.cs	2010-01-08 06:57:28 UTC (rev 4914)
+++ trunk/nhibernate/src/NHibernate.Test/SqlTest/Identity/MsSQL/MSSQLIdentityInsertWithStoredProcsTest.cs	2010-01-08 10:09:47 UTC (rev 4915)
@@ -14,7 +14,7 @@
 
 		protected override string GetExpectedInsertOrgLogStatement(string orgName)
 		{
-			return string.Format("exec nh_organization_native_id_insert @p0;@p0 = '{0}' [Type: String ({1})]", orgName, orgName.Length);
+			return string.Format("exec nh_organization_native_id_insert @p0;@p0 = '{0}' [Type: String (4000)]", orgName);
 		}
 
 		protected override IList Mappings


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.