ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vijai Senthil Padmanabhan Kalaiyarasi" <vijaisenthil.padmanab...@kumaran.com>
Subject Re: Passing logged in Username and password to iBATIS
Date Wed, 28 Sep 2005 19:51:25 GMT
Hi Larry,

    I have included this piece of code before getting the DAO infstance from DAOManager.

        SqlMapDaoTransaction trans = (SqlMapDaoTransaction) daoManager.getTransaction(daoManager.getDao(daoClass));
        SqlMapClient sqlMapClient = trans.getSqlMap();
        Connection conTemp = sqlMapClient.getDataSource().getConnection("test", "test");


    I thought of substituting the connection in the sqlmap with my own connection.
    But it gave me error like

    Cause: com.ibatis.sqlmap.engine.transaction.TransactionException: TransactionManager could
not end this transaction.  A user provided connection     is currently being used by this
session.  You must call the rollback() method of the Connection directly.  The calling .setUserConnection
(null) will clear     the user provided transaction.
    at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.endTransaction(SqlMapExecutorDelegate.java:471)
    at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.endTransaction(SqlMapSessionImpl.java:134)
    at com.ibatis.sqlmap.engine.impl.SqlMapClientImpl.endTransaction(SqlMapClientImpl.java:107)

    Is there any other round about to do this? So that the SQL statements will be executed
with the user supplied connection.

Thanks and regards
Vijai Senthil P K

----- Original Message ----- 
From: "Larry Meadors" <larry.meadors@gmail.com>
To: <user-java@ibatis.apache.org>
Sent: Tuesday, September 27, 2005 3:05 PM
Subject: Re: Passing logged in Username and password to iBATIS

>I have been down that path, and used proxool to do it.
> I would *not* recommend doing this.
> It will be easier to change the procedures to allow passing in the user id.
> We did something similar, in that we made them default to USER if a
> user parameter is not passed in, and if the user is the iBATIS userid,
> they fail. That forces callers to use either a trusted (i.e., Oracle)
> connection, or supply a user.
> Larry
> On 9/27/05, Vijai Senthil Padmanabhan Kalaiyarasi
> <vijaisenthil.padmanabhan@kumaran.com> wrote:
>> Hi,
>>     I am working on a re-enginerring project from Oracle forms to J2EE.
>>     There are several DB procedures using the USER variable of  Oracle.
>>     So I am forced to get a connection for the logged in Username and
>> password.
>>     How can I tell the iBATIS to execute my statements in the connection
>> created by the logged in Username and password?
>>     Is there any method to do that?
>> Thanks and Regards
>> Vijai Senthil P K
View raw message