Oracle Sessions Hanging

[Guest]

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]

spottedcow wrote:
> Everytime Dreamweaver is opened with a page that has a cfquery 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 long that have
<cfquery...> tags connecting to Oracle databases and I have never caused
any to crash. I do not know why. If I am creating sessions as you
describe, we must either have plenty to go around or they are expiring
or something.