connection time out error

[manish gupta]

I am using MDB with weblogic 8.1 sp server.
I also created connection pool and datasource in admin console of weblogic. I am creating a connection with the help of data source.
it works for one database call but if you call another database call from same method it is giving error

The transaction is no longer active - status: 'Marked rollback. [Reason=weblogic.transaction.internal.TimedOutException: Transaction timed out after 29 seconds.

Could any one help me in this,how to reolve this problem?

Thanks
Manish

[Anupam Sinha]

You have access to both the databases. Check the connection String. Check if there's any firewall blocking your access to the other db.

[manish gupta]

database call mean jdbc call on same database
I am using only one database

[Jan Cumps]

Did you check Investigating Transaction Problems on BEA's support site?

...it will get a TimedOutException which needs to be handled appropriately inside the application code. Information can be found in the API documentation: http://e-docs.bea.com/wls/docs81/javadocs/weblogic/transaction/TimedOutException.html

Regards, Jan