Rik Gammack wrote:
>
> I've been trying to set up a connection pool where the connections are
> via a JDBC-ODBC bridge,
> based on the examples in JH's book.
>
> I thought I'd got it working, but it appears not to have worked at all.
>
> The problem is that I'm making each connection with a different user name
> (to separate out the
> transactions) but a single ODBC DSN name.
A connection pool will not help you if each user must have their own
connection. A connection pool is, as the name implies, a set of connections
established using the same database account that can be used by any application
user.
Maybe I missed something, because I'm not sure what you mean with "different
user name" (the real user's database account?) and "separate out transactions".
Transactions are handled per connection, independent of the database account
name. So even with a pool of connections using the same account name, each
connection can execute a number of statements and then rollback or commit.
Just set auto commit to false.
--
Hans Bergsten [EMAIL PROTECTED]
Gefion Software http://www.gefionsoftware.com
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
