Professional Web Applications Themes

cf 7 and mysql 5 stored procedures and temporary tables - Coldfusion Database Access

We developed some stored procedures in mysql 5.0.10a that work with coldfusion 7. We upgraded the mysql database to the GA Release of 5.0.15 and now the procedures return an error when called saying that the temporary table cannot be found. We are calling the stored procedures using the standard <cfquery> tag. The stored procedures seem to work fine, it seems to be a problem with how cf7 is executing them....

  1. #1

    Default cf 7 and mysql 5 stored procedures and temporary tables

    We developed some stored procedures in mysql 5.0.10a that work with coldfusion
    7. We upgraded the mysql database to the GA Release of 5.0.15 and now the
    procedures return an error when called saying that the temporary table cannot
    be found. We are calling the stored procedures using the standard <cfquery>
    tag. The stored procedures seem to work fine, it seems to be a problem with
    how cf7 is executing them.

    gnurulz Guest

  2. #2

    Default Re: cf 7 and mysql 5 stored procedures and temporarytables

    We have also encountered a problem with temporary tables. We are able to
    create the tables and retrieve data from them when the data is numeric. When
    trying to retrieve string data (varchar, text, mediumtext, etc.), CF throws an
    error saying that the temporary table could not be found. Trying to get
    information about the temporary table after the error indicates that the
    temporary table is still present -- it has not been dropped by MySQL.

    Using CF MX6 and MySQL 4.1, the temporary tables work fine.
    Using CF MX7 and MySQL 4.1, the temporary tables work fine.
    Using CF MX6 and MySQL 5.0, the temporary tables work fine.
    Using CF MX7 and MySQL 5.0, the temporary tables do not work.

    We have tested various JConnectors, and they do not seem to be the source of
    the problem. Creating and reading from temporary tables using Java (and the
    same JConnectors) works fine. See MySQL site:
    [url]http://bugs.mysql.com/bug.php?id=15060[/url]

    Baroti Guest

  3. #3

    Default Re: cf 7 and mysql 5 stored procedures and temporarytables

    I'm seeing different results with temporary tables:

    The Connect/J 3.0 driver - mysql-connector-java-3.0.17-ga-bin.jar works for
    me with both CFMX6.1 & CFMX7.0.1

    The Connect/J 3.1 driver - mysql-connector-java-3.1.9-bin.jar fails for me
    with CFMX7

    The 3.1 driver doesn't work at all with CFMX6.1. Note that you should avoid
    using Connect/J 3.1.10+ with CF7 because of
    [url]http://bugs.mysql.com/bug.php?id=13469[/url]. Once this gets fixed, later 3.1 drivers
    should be OK.

    I'm using mySQL 5.0.16 on Windows.

    TomDonovan Guest

Similar Threads

  1. Troubles in stored procedures (mySQL) in CFMX7
    By Euripide in forum Coldfusion Database Access
    Replies: 13
    Last Post: February 24th, 04:02 PM
  2. Replies: 7
    Last Post: January 31st, 05:24 PM
  3. Stored Procedures mySQl 5, CFMX 6.1
    By WeeJames in forum Coldfusion Database Access
    Replies: 3
    Last Post: December 20th, 07:00 PM
  4. MySql temporary tables
    By Andu in forum PHP Development
    Replies: 1
    Last Post: September 16th, 03:31 AM
  5. script to show last change date for stored procedures and tables?
    By Les Caudle in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 2nd, 04:50 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139