[Sommaire] [Imprimer]

   1  <?php
   2  /*
   3   *  $Id: CodeBaseAdapter.php,v 1.3 2005/10/17 19:03:51 dlawson_mi Exp $
   4   *
   5   * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
   6   * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
   7   * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
   8   * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
   9   * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
  10   * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
  11   * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
  12   * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
  13   * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
  14   * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
  15   * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
  16   *
  17   * This software consists of voluntary contributions made by many individuals
  18   * and is licensed under the LGPL. For more information please see
  19   * <http://creole.phpdb.org>.
  20   */
  21  
  22  require_once 'creole/drivers/odbc/adapters/ODBCAdapter.php';
  23  
  24  /**
  25   * CodeBase driver-specific behavior.
  26   *
  27   * This adapter is for Sequiter's CodeBaseSQL product. It is a dBase ODBC
  28   * driver. The driver only supports forward-only cursor scrolling so this
  29   * adapter causes the ODBCCachedResultSet to be used.
  30   *
  31   * A couple other quirks exist: 
  32   * 
  33   * 1) Cannot get blobs to work correctly. If I try writing one to a 
  34   *    LONGVARBINARY typed field, only the first few bytes are written.
  35   *    This will cause the ResultSetTest::testGetBlob() test case to fail
  36   *    when running tests for the driver.
  37   *
  38   * 2) For some reason the character count is off for the 
  39   *    ResultSetTest::testSetClob() test case _only_ when running from the 
  40   *    command line. If I run the same test through a web server it works fine.
  41   *    Looks like it has something to do with line endings in Windows. The 
  42   *    difference in file sizes is 9803 vs 10090.
  43   *
  44   * 3) Setting a clob field to null writes a space to the field in the table. 
  45   *    This causes the PreparedStatementTest::testSetNull() test case to fail 
  46   *    when running tests for the driver.
  47   *
  48   * @author    Dave Lawson <dlawson@masterytech.com>
  49   * @version   $Revision: 1.3 $
  50   * @package   creole.drivers.odbc
  51   */
  52  class CodeBaseAdapter extends ODBCAdapter
  53  {
  54      /**
  55       * @see ODBCAdapter::createResultSet()
  56       */
  57      public function preservesColumnCase()
  58      {
  59          return false;
  60      }
  61  
  62      /**
  63       * @see ODBCAdapter::createResultSet()
  64       */
  65      public function createResultSet($conn, $odbcresult, $fetchmode)
  66      {
  67          require_once 'creole/drivers/odbc/ODBCResultSet.php';
  68          return new ODBCResultSet($conn, $odbcresult, $fetchmode, true);
  69      }
  70  
  71  }
  72  
  73  ?>