RE: Using iBATIS.NET with user-specific connectionstrings

[Henrik Uffe Jensen]

And then we should just call OpenConnection before BeginTransaction or do

BeginTransaction take a connectionstring as parameter too ?

 

regards

 

Henrik Uffe Jensen

 

---

From: Gilles Bayon [mailto:[EMAIL PROTECTED]
Sent: 13. september 2005 19:16
To: user-cs@ibatis.apache.org
Subject: Re: Using iBATIS.NET with user-specific connectionstrings

You can't.

The best solution will be to add method as

public OpenConnection(
   string connectionString
);

I have open a Jira ticket IBATISNET-112 and closed it, you can find implementation in SVN.

 

Cheers,

-Gilles

 

 

On 9/13/05, Henrik Uffe Jensen <[EMAIL PROTECTED]> wrote:

        Hi

We would like to use iBATIS (as we have done for the last two-three of our projects) on a project where we are porting an existing solution, but are facing a little problem regarding the connections to the database.

On this existing solution every user of the system is created as a oracle-user and the connection to the database is done using the username/password of that user. So we are not using Integrated Security here, but are actually using a dynamic connectionstring created with the username/password of the specific user. Let's not start discussing if this is the right solution or not :-), but this is the way it works today and the customer expect the new solution to work in the same way.

Can we just use the DaoManager.DataSource.ConnectionString with our dynamic connectionstring ? Any drawbacks - thread-safety etc. ? Or are there any better solution for this problem ?

Henrik Uffe Jensen
Ementor Denmark A/S