ASE Database forum - Validating another user's login using connection pooling?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Validating another user's login using connection pooling?

Richard Mundell

2005-04-27, 7:24 am

We have an application (developed in J2EE) which uses JDBC
to communicate with Sybase.

We use connection pooling to give us good performance. The
pool of connections are established between application and
server using a generic login.

We use Sybase authentication as users log in - we establish
a new connection with their login and password to check the
user is valid, which we then close and use connection
pooling after that to perform the actual database calls.

We're seeing a performance overhead with establishing
connections specially for user validation - does anyone know
a way to validate a login and password for one user, while
using a connection established under another login's name?

Thanks,

Richard

Sponsored Links