I have a high priority production Issue.
In my application I am using Hibernate framework oracle 10g. daily I am running a job at 8PM to get data from database to generate a report.
Here job is nothing but a java class. Everyday I am running a job to get data between yesterday's 7:30 PM to today 7:30 pm. Here the problem is everyday I am missing the data at 12AM to 1 AM This problem is in Production only If I am doing same thing on dev regions it's working fine. One more update is from my local workspace I connected to Production datatbase and run the job locally I am getting the entire data without missing any data. I dont know it's a database issue or java code issue or environment issue.
Here is the code I used to get the data