posted 16 years ago
Hi ,
I am using WebSphere community edition 1.0.1.2 Database Pools connection for my databaseTransaction ,everything works fine with my retrieve query but when i do a create or update the data is viewed in my application but its not committed got the database. After doing so when i try to alter the particular record in the database manually i get a ORA error - 'resource busy and acquire with NOWAIT specified'.But this problem exist only in the server machine but the same connection pooling works fine in my machine. the Commit is given form the apllication level and its also closed properly. what could be the problem can anyone help me .
And there is also another interesting problem which i found ,that is when i update data using the appliation deployed in my server machine the data is appearing in the Screen. Now i open the same application from some other system ,the data which i have updated in another session is existing in this session also but this data is not available in Database. I guess both are using the Same connection.But is it possible?
please help. thanks in advance
Prem