Single concurrent user access

[AlistairMonkeyFinger]

Hi all,

I have some data in a database and am about to start to write a simple querying / viewing application (probably Swing/webstart, maybe JSP). Because of the nature of the data, we are only licensed for a single concurrent user, so i have to make sure that not more than one person can use an instance of my app at the same time. Any ideas how i can acheive this?

Many thanks
Alistair

Alistair

 

[timw]

Won't the database jdbc connector have some licencing checks that make it throw exceptions if more than one connection is attempted?

Your software could propagate this to the client and then terminate.


Tim

 

[sedj]

Even easier than that is to write a "gateway" to which your queries must run - and then synchronize this method.

Or, most pooling systems allow you to specifiy how many concurrent connections are available - if you set it one, then this will work (as long as the pool implements a queueing system for requests for connections).

Click here to learn Ways to help with Tsunami Relief
--------------------------------------------------
Free Database Connection Pooling Software

http://www.primrose.org.uk

 

[timw]

The pooling configuration seems more flexible. If the query facade was synchronized and they bought some extra licences they wouldn't benefit.


Tim