Transaction and Websphere - problems

[Rafal Mrozik]

Hi

I'am trying to use transaction in my webService which is installed on Websphere Application Server.

I've found pice of code

InitialContext initialContext = new InitialContext();
UserTransaction trans = ( UserTransaction ) initialContext.lookup ("java:comp/env/UserTransaction");
trans.begin();
// here is code which is connect to the Oracle database and selects some code
trans.commit();

Code which is connect to the database is working when i not use transaction.

When I invoke my service (with this code) i have error:
javax.naming.NameNotFoundException: Name "comp/env/UserTransaction" not found in context "java:"

What should I do else to start use transaction in my webService?

thanks
rafal

[Edvins Reisons]

The exception message suggests strongly that the JNDI name is wrong.
Try "java:comp/UserTransaction".

[Rafal Mrozik]

First thanks for replay

I have one JNDI which i have defined in my web.xml file

<resource-ref>
<res-ref-name>jdbc/OracleDB_JNDI</res-ref-name>
<res-type>javax.sql.Datasource</res-type>
<res-auth>Container</res-auth>
<res-sharing-scope>Shareable</res-sharing-scope>
</resource-ref>

In Webshere i configured this JNDI too (it was necessary) by
Resources -> JDBC Providers -> ...

I am using it to connect to the Oracle database and it works fine.

The JNDI name is wrong so where should i define them?
How should look inscription im my web.xml for this JNDI?

Thanks
Rafal

[Edvins Reisons]

I was trying to say that you are looking up the UserTransaction in a wrong place.

[Rafal Mrozik]

Thanks Edvins Reisons - it works!