Skip to main content
Inspiring
March 14, 2007
Question

JDBC update 3.5 gives Oracle errors

  • March 14, 2007
  • 1 reply
  • 614 views
Running CF Enterprise Server 7.02 on win 2003 server. Installed the updated Data Direct JDBC drivers (version 3.5) and started getting following errors when run against Oracle 8i databases:

This from queries that call stored procedures:

Error Executing Database Query.[Macromedia][Oracle JDBC Driver][Oracle]ORA-02041: client database did not begin a transaction ORA-06512: at ""PAMOT.LATEST_LAB_DATA"", line 25 ORA-06512: at line 1 The specific sequence of files included...

This intermittently from queries that use cfqueryparam :

Error Executing Database Query.[Macromedia][Oracle JDBC Driver]Internal error: Net8 protocol error. The specific sequence of files included...

Have reverted to 3.4 drivers.

Any idea what's going wrong?
    This topic has been closed for replies.

    1 reply

    Known Participant
    June 13, 2007
    I just encountered this same error with CF Enterprise 7.02 on Win 2003 server connecting to an Oracle 8i database. On a whim I wrapped a <cftransaction> around the <cfquery> and the error went away. I have no idea why but it worked.