[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 195
  • 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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone 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