Professional Web Applications Themes

Oracle JDBC driver and CF MX 7 Standard edition - Coldfusion Database Access

hi, guys. is it possible to use Oracle JDBC driver with CF MX 7 Standard edition? all our CF servers are Enterprise edition so we never ran into any problems connecting to Oracle servers. however, there will be a couple of new CF servers with relatively simple jobs running and we're trying to determine if we can use the Standard edition instead. I'd like to test this on my own, but CF MX 7 Standard edition is not available as a trial download. if there's someone who's done this already, I'd love to hear from you. can anyone shed a ...

  1. #1

    Default Oracle JDBC driver and CF MX 7 Standard edition

    hi, guys.
    is it possible to use Oracle JDBC driver with CF MX 7
    Standard edition?
    all our CF servers are Enterprise edition so we never ran into any
    problems connecting to Oracle servers.
    however, there will be a couple of new CF servers with relatively
    simple jobs running and we're trying to determine if we can use the
    Standard edition instead.
    I'd like to test this on my own, but CF MX 7 Standard edition is not
    available as a trial download.
    if there's someone who's done this already, I'd love to hear from
    you.
    can anyone shed a little light on this?
    thank you very much!

    J

    cfskyline Guest

  2. #2

    Default Re: Oracle JDBC driver and CF MX 7 Standard edition

    Hi, J.

    We've used Oracle JDBC driver with CF7 std for our product.
    I believe that you can use Oracle 9i JDBC driver with CF7 std.
    But Oracle 10g JDBC driver with CF7 std has a problem.
    The problem is related to "Date" type of table column.
    ColdFusion can't convert from "Date field" of Oracle 10g driver to "Time" data
    ..
    For example, value of "06/14/2006 14:15:32" in DB is converted to "06/14/2006
    00:00:00".

    Shigeru@Linkcom Guest

  3. #3

    Default Re: Oracle JDBC driver and CF MX 7 Standard edition

    For the date/timestamp issue, you might check thread [url]http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?catid=6&threadid=1145825[/url]

    Phil
    paross1 Guest

  4. #4

    Default Re: Oracle JDBC driver and CF MX 7 Standard edition

    Thanks, paross1!!
    ( I didn't know about this. )
    Shigeru@Linkcom Guest

Similar Threads

  1. Oracle JDBC driver and CF Standard edition
    By maruchi70 in forum Coldfusion Database Access
    Replies: 0
    Last Post: June 13th, 11:18 PM
  2. CF 7 Standard + Oracle JDBC drivers + CLOB fields
    By Mustache2 in forum Coldfusion Database Access
    Replies: 2
    Last Post: February 15th, 04:24 PM
  3. [Macromedia][Oracle JDBC Driver]No more dataavailable to read.
    By BKBK in forum Coldfusion Database Access
    Replies: 1
    Last Post: January 25th, 03:22 PM
  4. Replies: 2
    Last Post: April 11th, 03:47 PM
  5. Installing DB2 JDBC Driver on CFMX 6.1 Standard
    By chuckjody in forum Coldfusion Server Administration
    Replies: 5
    Last Post: March 16th, 07:49 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