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
ianinspainAsked:
Who is Participating?
 
existenz2Connect With a Mentor Commented:
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
All Courses

From novice to tech pro — start learning today.