nhibernate-commit

[Nhibernate-commit] SF.net SVN: nhibernate:[5106] trunk/nhibernate/src/NHibernate/Driver/ NpgsqlDriver.cs

[<fab...@us...>]

Revision: 5106
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=5106&view=rev
Author:   fabiomaulo
Date:     2010-08-04 11:57:46 +0000 (Wed, 04 Aug 2010)

Log Message:
-----------
Fix NH-2267 (by Patrick Earl)

Modified Paths:
--------------
    trunk/nhibernate/src/NHibernate/Driver/NpgsqlDriver.cs

Modified: trunk/nhibernate/src/NHibernate/Driver/NpgsqlDriver.cs
===================================================================
--- trunk/nhibernate/src/NHibernate/Driver/NpgsqlDriver.cs	2010-08-04 11:54:24 UTC (rev 5105)
+++ trunk/nhibernate/src/NHibernate/Driver/NpgsqlDriver.cs	2010-08-04 11:57:46 UTC (rev 5106)
@@ -58,10 +58,8 @@
 
 		protected override bool SupportsPreparingCommands
 		{
-			// NOTE: Npgsql1.0 and 2.0-preview apparently doesn't correctly  support prepared commands.
-			// The following exception is thrown on insert statements:
-			// Npgsql.NpgsqlException : ERROR: 42601: cannot insert multiple commands into a prepared statement
-			get { return false; }
+			// NH-2267 Patrick Earl
+			get { return true; }
 		}
 
 		public override bool SupportsMultipleQueries


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

[Nhibernate-commit] SF.net SVN: nhibernate:[5151] trunk/nhibernate/src/NHibernate/Driver/ NpgsqlDriver.cs

[<fab...@us...>]

Revision: 5151
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=5151&view=rev
Author:   fabiomaulo
Date:     2010-08-14 17:48:54 +0000 (Sat, 14 Aug 2010)

Log Message:
-----------
NpgsqlDriver using DbProviderFactories

Modified Paths:
--------------
    trunk/nhibernate/src/NHibernate/Driver/NpgsqlDriver.cs

Modified: trunk/nhibernate/src/NHibernate/Driver/NpgsqlDriver.cs
===================================================================
--- trunk/nhibernate/src/NHibernate/Driver/NpgsqlDriver.cs	2010-08-14 17:47:59 UTC (rev 5150)
+++ trunk/nhibernate/src/NHibernate/Driver/NpgsqlDriver.cs	2010-08-14 17:48:54 UTC (rev 5151)
@@ -31,6 +31,7 @@
 		/// </exception>
 		public NpgsqlDriver() : base(
 			"Npgsql",
+			"Npgsql",
 			"Npgsql.NpgsqlConnection",
 			"Npgsql.NpgsqlCommand")
 		{


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

[Nhibernate-commit] SF.net SVN: nhibernate:[5783] trunk/nhibernate/src/NHibernate/Driver/ NpgsqlDriver.cs

[<pa...@us...>]

Revision: 5783
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=5783&view=rev
Author:   patearl
Date:     2011-04-28 05:44:25 +0000 (Thu, 28 Apr 2011)

Log Message:
-----------
PostgreSQL: Fixed currency parameter type.

Modified Paths:
--------------
    trunk/nhibernate/src/NHibernate/Driver/NpgsqlDriver.cs

Modified: trunk/nhibernate/src/NHibernate/Driver/NpgsqlDriver.cs
===================================================================
--- trunk/nhibernate/src/NHibernate/Driver/NpgsqlDriver.cs	2011-04-28 04:20:33 UTC (rev 5782)
+++ trunk/nhibernate/src/NHibernate/Driver/NpgsqlDriver.cs	2011-04-28 05:44:25 UTC (rev 5783)
@@ -1,3 +1,5 @@
+using System.Data;
+
 namespace NHibernate.Driver
 {
 	/// <summary>
@@ -72,5 +74,13 @@
 		{
 			get { return true; }
 		}
+
+        protected override void InitializeParameter(IDbDataParameter dbParam, string name, SqlTypes.SqlType sqlType)
+        {
+            base.InitializeParameter(dbParam, name, sqlType);
+
+            if (sqlType.DbType == DbType.Currency)
+                dbParam.DbType = DbType.Decimal;
+        }
 	}
 }


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

[Nhibernate-commit] SF.net SVN: nhibernate:[5826] trunk/nhibernate/src/NHibernate/Driver/ NpgsqlDriver.cs

[<pa...@us...>]

Revision: 5826
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=5826&view=rev
Author:   patearl
Date:     2011-05-15 23:58:33 +0000 (Sun, 15 May 2011)

Log Message:
-----------
PostgreSQL: Added a comment.

Modified Paths:
--------------
    trunk/nhibernate/src/NHibernate/Driver/NpgsqlDriver.cs

Modified: trunk/nhibernate/src/NHibernate/Driver/NpgsqlDriver.cs
===================================================================
--- trunk/nhibernate/src/NHibernate/Driver/NpgsqlDriver.cs	2011-05-15 19:39:11 UTC (rev 5825)
+++ trunk/nhibernate/src/NHibernate/Driver/NpgsqlDriver.cs	2011-05-15 23:58:33 UTC (rev 5826)
@@ -79,6 +79,7 @@
         {
             base.InitializeParameter(dbParam, name, sqlType);
 
+            // Since the .NET currency type has 4 decimal places, we use a decimal type in PostgreSQL instead of its native 2 decimal currency type.
             if (sqlType.DbType == DbType.Currency)
                 dbParam.DbType = DbType.Decimal;
         }


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