|
| Hi,
1. Inserting a new record into the database.
2. After inserting the record trying to run the report.
The issue I am facing is the new records which are inserted are not showing up in the report. I am even unable to see the record by running a query on database side.
I am able to see those records, once after restarting the app server. Looks like app server is locking the newly inserted records.
'Auto commit' is on, Also trying to commit forcibly through the program. I really could not understand what is going on.
Can anybody please advice me what is going on here, or suggest me what should I do to solve this issue.
The Versions I am using are:
WAS:
Integrated Solutions Console, 6.1.0.0
Build Number: b0620.14
Build Date: 5/16/06
SQL:
sql 2005
I really appreciate your response/suggestions.
Thank you
|
|