• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 199
  • Last Modified:

500pts: Keeping an Oracle connection open in web services?

Hi there,

I wonder if anyone can help?

I have built some web services, and i have been requested to keep a connection open, i always though that Opening a connection and closing it as soon as possible is a better way... anyway...

Because web services are technically web pages, i assume they a stateless ... so what would be the point of keeping a connection open...

and more to the point ... how would i do it?

I hope somebody can help

Thanks in advance

Ian
0
ianinspain
Asked:
ianinspain
1 Solution
 
existenz2Commented:
Webservices should be stateless built. How ever you can parts of them statefull by using static properties/classes. Making the SqlConnection static (public static OracleConnection connection = new OracleConnection(); f.e.) will solve these problems and every sql statement will use the same connection.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now