> 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!

> > 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