oracle 10 oci driver

Ask a Question related to Coldfusion - Advanced Techniques, Design and Development.

  1. #1

    Default oracle 10 oci driver

    Anyone out there using the Oracle 10 OCI driver with their CFMX servers? I'm
    having a huge problem getting ours to work. Every time I set up a datasource
    using the OCI driver, my SESSION scope can no longer be locked and my JVM
    process spikes.

    Here's my setup:
    - Jboss 4.0 sp1 AS
    - ColdFusion 7
    - Oracle 10 OCI driver

    Here's the datasource props:
    Name: DEVX1
    JDBC URL: jdbc:oracle:oci:@devx1
    Driver Class: oracle.jdbc.driver.OracleDriver Username and password a set and
    correct

    Now the datasource is verified in the administrator and is used correctly in
    our application, but any time we hit code that attempts to lock the session
    scope, it times out. As soon as I change the driver to Oracle's thin or
    Macromedia's thin, everything's happy again.

    Anyone else seen anything resembling this or have a possible solution. So far
    this is a deal breaker in moving CF7 to our production boxes.

    - Steve


    orbwave Guest

  2. Similar Questions and Discussions

    1. oracle driver not showing up
      ColdFusion MX, Version: 6,1,0,63958 I want to add an oracle data source, but "oracle" does not show up in the driver drop down list for new data...
    2. Oracle Table Access With Oracle OLEDB Driver
      If I use the Oracle client to access the Oracle database with DW 2004, it does not display any tables. If I use the Microsoft client it does work. ...
    3. [Macromedia][Oracle JDBC Driver][Oracle]ORA-01000:maximum open cursors exceeded
      Here is the technote from Macromedia regarding this issue: http://www.macromedia.com/go/tn_17660 Hope this helps!
    4. cfstoredproc for oracle driver
      I am currently running on CF 5 Standard and an Oracle 9i db. The problem is that we had to use the oracle driver to run stored procs in CF 5. Is...
    5. Cannot connect with OCI driver and Oracle 9i (9.2)
      Hello all, I have been trying to use the OCI driver to connect to Oracle 9i, but have been getting the following error: java.sql.SQLException:...
  3. #2

    Default Re: oracle 10 oci driver

    Thanks for the very helpful posting, Steve. I'll take it into consideration.
    orbwave Guest

Posting Permissions

  • You may not post new threads
  • You may 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