Re: org.postgresql.xa.PGXADataSource and compatible=8.2 in query string

[Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>]

Here is the "compatible" parameter-aware patch:

--- org/postgresql/ds/common/BaseDataSource.java.ORIG   2008-05-20 17:08:57.000000000 +0300
+++ org/postgresql/ds/common/BaseDataSource.java        2008-05-20 17:20:41.000000000 +0300
@@ -51,6 +51,7 @@
     private int loginTimeout; // in seconds
     private boolean ssl = false;
     private String sslfactory;
+    private String compatible;

     /**
      * Gets a connection to the PostgreSQL database.  The database is identified by the
@@ -154,6 +155,16 @@
         }
     }

+    public String getCompatible()
+    {
+        return compatible;
+    }
+
+    public void setCompatible(String compatible)
+    {
+        this.compatible = compatible;
+    }
+
     /**
      * Gets the name of the PostgreSQL database, running on the server identified
      * by the serverName property.
@@ -323,6 +334,7 @@
                 sb.append("&sslfactory=").append(sslfactory);
             }
         }
+       if (compatible != null) sb.append("&compatible="+compatible);

         return sb.toString();
     }


-- 
Achilleas Mantzios