Re: Connection Pooling across multiple SQL Data Maps

[Jose María Zaragoza]

2012/10/2 Glenn Barnard <barnar...@gmail.com>:
> I'm currently an Ibatis user, but looking to migrate to myBatis....am
> wondering if the behaviour I'm going to describe exists in both products???
>
> Our DBA's want seperate users for different types of applications. We have a
> java job manager tool that runs "jobs" on separate threads. But, each job
> creates it's own instance of Ibatis SqlMapClient. We're having mondo issues
> when 2 jobs run that have connections with user names that conflict their
> rights. For example, user A can write to DB Z, but read DB Y. User B can
> read DB Z, but write DB Y. When Ibatis runs a query or update, it's hit or
> miss that is grabs a connection with the corret rights....like the
> connection pool is not respecting which SqlMapClient created the
> connections.
>
> Would MyBatis have better controls over the connection pooling?
>
> Is there a configuration option that I should pay attention to?
>
> Should I write and inject my own pooling mechanism?
>
> I hope this makes sense and someone can help me.
>
> Thank you!


Hi

one question , how do you manage the rights? per user by GRANTS ?

Regards

[Glenn Barnard]

Correct, our DBA's handle that for our developers.

[Jose María Zaragoza]

2012/10/3 Glenn Barnard <barnar...@gmail.com>:

> Correct, our DBA's handle that for our developers.

Well, I think that pool should be create per SqlClient.
It doesn't have any sense if it works on other way
I'd check your code, if there is some bugs . Or you can paste that code
If I wrong, please, let me know it . I'm curious about this issue


Regards