Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Data not always returned - Same code, Same query, Same data  RSS feed

 
Kristin Black
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Application: Java

Database: Oracle

Server: Tomcat 7

Using Spring JDBC template

Oracle's WebCenter Interaction

We have an Excel report that has roughly 6 worksheets. 5 of the 6 worksheets return data as expected, however, the one will intermittently not return any data. All 6 of the queries that generate this report use the same parameters selected on the screen by the user. When debugging the code we can see that the result set returned from the database is empty, so the data is not being lost during the generation of the report itself. When the query is run through Toad, data is always returned. When the issue first started, the code had not been changed in over a year and a half. Since then a lot of the code has been rewritten to try and fix the problem. We were using Prepared Statement and are now using the Spring JDBC Template. The server and database were not upgraded around the time that this was first reported. We have had Java patches, but no other queries in the application are being affected. We are looking for any and all suggestions to help us resolve this issue. Thank you.
 
Dave Tolls
Ranch Hand
Posts: 2504
27
  • Likes 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This is likely to be something a forum can't answer.
Anything intermittent is going to require quite a lot of investigation to find out what's going on.

Can you write a simple test app that only runs this query, in the same way it does in the real app, with whatever mix of parameters that represents the real life situation?
I'd set that up running against a DB copy for a while and see whether ti hits any issues.
Then start adding in things to represent load, other queries, inserts.

Essentially you need to find a way to cause the problem...which is most of the battle.
 
Kristin Black
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks, Dave. I know it is a long shot asking this question here, but any new ideas are helpful. I appreciate your response and I'm going to do what you suggested. Thanks again.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!