Oracle Sessions Hanging

Question

I am developing a cold fusion application using Dreamweaver 8
that runs on a windows nt server and using an Oracle 10 g database
on a unix box. Everytime Dreamweaver is opened with a page that has
a cfquery in it, Dreamweaver creates a new oracle session.
Dreamweaver never closes the Oracle sessions when the cfm is closed
or when you exit Dreamweaver. This causes the oracle database to
run out of sessions and crash. I spoke with Adobe support and they
stated this is the way it works and advised me to close the
sessions in oracle. I can't believe the software works like this.
Our database has 50 sessions allowed so after we open Dreamweaver
50 times it crashes the project. Have any of you ran into this
problem before?

Newsgroup_User · Answer

spottedcow wrote:> Everytime Dreamweaver is opened with a page that has acfquery in it, Dreamweaver creates > a new oracle session. It does, really? I never know or noticed this.> Have any of you ran into this problem before? No, I open and close Dreamweaver and CFM files all day longthat have <cfquery...> tags connecting to Oracle databases and Ihave never caused any to crash. I do not know why. If I am creating sessions asyou describe, we must either have plenty to go around or they areexpiring or something.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded