?
Solved

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

Posted on 2006-10-24
1
Medium Priority
?
191 Views
Last Modified: 2010-04-16
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
Comment
Question by:ianinspain
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 14

Accepted Solution

by:
existenz2 earned 2000 total points
ID: 17794559
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

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question