Changes between Version 18 and Version 19 of HowToConnectToMSSQLServer

Author:

KRavEN (IP: 199.67.140.44)

Timestamp:

09/15/10 15:05:25 (3 years ago)

Comment:

--

HowToConnectToMSSQLServer

@@ +1 @@
+For symfony 1.4 it is best to use the sfPropel15Plugin http://www.symfony-project.org/plugins/sfPropel15Plugin as it has MANY MSSQL fixes over the Propel 1.4 that comes with symfony 1.4.
+
+Before starting look at the propel docs for using MSSQL and get everything setup correctly: http://www.propelorm.org/wiki/Documentation/1.5/MSSQL-Server
+
-== Linux Host ==
-
-2 the PDO driver 
+4 the PDO driver pdo_
-
-Do a php -m from the command line and make sure you have pdo_dblib listed.
-config/databases.yml
-{{{
+dev:
+  propel:
+    param:
+      classname:  MssqlDebugPDO
+      debug:
+        realmemoryusage: true
+        details:
+          time:       { enabled: true }
+          slow:       { enabled: true, threshold: 0.1 }
+          mem:        { enabled: true }
+          mempeak:    { enabled: true }
+          memdelta:   { enabled: true }  
+
+test:
+  propel:
+    param:
+      classname:  MssqlDebugPDO   
+
-all:
-  propel:
-propel.database             = mssql
-propel.database.driver      = dblib
-createUrl
+url      
-propel.database.user        = xxx
-propel.database.creole.url  = ${propel.database.url}
-propel.database.password    = xxx
-propel.database.encoding    = utf8
-propel.dateTimeClass        = MssqlDateTime
-}}}
-'''MSSQL Server returns datetimes in a format that strtotime doesn't handle so we need to extend DateTime to account for it.'''
-
-lib/MssqlDateTime.class.php
-{{{
-<?php
-class MssqlDateTime extends DateTime
-{
-  public function __construct($datetime='now', DateTimeZone $tz = null)
-  {
-    //if the date is bad account for Mssql datetime format
-    if ($datetime != 'now' && strtotime($datetime) === false)
-    {
-      $datetime = substr($datetime,0, -6).substr($datetime,-2);
-    }
-
-    if($tz instanceof DateTimeZone)
-    {
-      parent::__construct($datetime,$tz);
-    }
-    else
-    {
-      parent::__construct($datetime);
-    }
-  }
-}
-}}}
-'''dblib doesn't support transactions so we need to add a workaround for transactions, last insert ID, and quoting'''
-
-Fix by sarhugo in ticket [http://trac.symfony-project.org/ticket/5577]
-
-lib/MssqlPropelPDO
-{{{
-<?php
-
-class MssqlPropelPDO extends PropelPDO {
-  /**
-   * Begin a transaction.
-   *
-   * It is necessary to override the abstract PDO transaction functions here, as
-   * the PDO driver for MSSQL does not support transactions.
-   */
-  public function beginTransaction()
-  {
-    $return = true;
-    $opcount = $this->getNestedTransactionCount();
-    if ( $opcount === 0 ) {
-      $return = self::exec('BEGIN TRANSACTION');
-    }
-    $this->incrementNestedTransactionCount();
-    return $return;
-  }
-
-  /**
-   * Commit a transaction.
-   *
-   * It is necessary to override the abstract PDO transaction functions here, as
-   * the PDO driver for MSSQL does not support transactions.
-   */
-  public function commit()
-  {
-    $return = true;
-    $opcount = $this->getNestedTransactionCount();
-    if ($opcount > 0) {
-      if ($opcount === 1) {
-        $return = self::exec('COMMIT TRANSACTION');
-      }
-      $this->decrementNestedTransactionCount();
-    }
-    return $return;
-  }
-
-  /**
-   * Roll-back a transaction.
-   *
-   * It is necessary to override the abstract PDO transaction functions here, as
-   * the PDO driver for MSSQL does not support transactions.
-   */
-  public function rollBack()
-  {
-    $return = true;
-    $opcount = $this->getNestedTransactionCount();
-    if ($opcount > 0) {
-      // If we're in a transaction, always roll it back
-      // regardless of nesting level.
-      $return = self::exec('ROLLBACK TRANSACTION');
-
-      // reset nested transaction count to 0 so that we don't
-      // try to commit (or rollback) the transaction outside this scope.
-      $this->nestedTransactionCount = 0;
-    }
-    return $return;
-  }
-
-  public function lastInsertId($seqname = null) {
-    $result = self::query('SELECT SCOPE_IDENTITY()');
-    return (int)$result->fetchColumn();
-  }
-
-  public function quoteIdentifier($text)
-  {
-    return '[' . $text . ']';
-  }
-
-  public function useQuoteIdentifier()
-  {
-    return true;
-  }
-}
-}}}
-
-Note: As of symfony 1.3, the files under the lib/vendor/ directory are not autoloaded anymore by default.
-Add a new entry in the autoload.yml configuration file (if above classes were placed in %SF_LIB_DIR%/vendor/mssql):
-{{{
-autoload:
-  mssql:
-    name:      mssql
-    path:      %SF_LIB_DIR%/vendor/mssql
-    recursive: on
-}}}
-
-There is also a bug in the propel-generator when setting datetime it is using a timestamp format that isn't accepted my MSSQL.
-
-Propel ticket http://propel.phpdb.org/trac/ticket/714
-
-To fix it edit plugins/sfPropelPlugin/lib/vendor/propel-generator/classes/propel/engine/platform/MssqlPlatform.php and add this method:
-
-{{{
-        /**
-         * Gets the preferred timestamp formatter for setting date/time values.
-         * @return     string
-         */
-        public function getTimestampFormatter()
-        {
-                return 'Ymd H:i:s';
-        }
-}}}
-'''NB : It's a little mistake in Propel ticket. Waiting date format by SQL Server is 'Ymd' and not 'Y-m-d''''
-
-There is another propel bug in sfPropelPlugin/lib/vendor/propel/adapter/DBMSSQL.php
-
-The bug causes problems when trying to page joined tables.
-Propel ticket http://propel.phpdb.org/trac/ticket/453 with patch.
-
-Another propel bug with inserts.  Propel tries to set the auto-increment value to null.  This isn't valid.
-Propel ticket http://propel.phpdb.org/trac/ticket/736 with patch.
-
-Clear the cache and then build the model
-== Windows Host ==
-
-
-
+
-
-
+
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
-
+
+
+
+
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
-}}}
-
-
-
-
-
-
-
-
-
-
-
-
-
+
-{{{
-
+
+
+
+
+
-}}}
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+