• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Devaka Cooray
  • Paul Clapham
  • Tim Cooke
  • Knute Snortum
  • Bear Bibeault
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • Piet Souris
  • Ganesh Patekar
  • Frits Walraven
  • Carey Brown
  • Tim Holloway

Problem refreshing a Stored Procedure

Ranch Hand
Posts: 34
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello all,

I m using Tomacat to run a web-application. Used stored procedure to access data from MSSQL Server. But when i re-run the application, it always calls the old stored procedure,while the result displayed in the Query Analyser is the modified one. Tried restarting the server as well as deleting the work folder and the generated class files too. But no change.

Even if i add/remove a parameter in the already created stored procedure it refuses to accept it. Gives an SQLException sayin the parameter is coded.Checked the code.. No errors with the code..

Plz help
Posts: 13411
Firefox Browser VI Editor Redhat
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Duplicate of:

Saumya Nair,
Please take a moment to read: CarefullyChooseOneForum
and find out why cross-posting your question in multiple forums and repeatedly posting the same question in the same forum will actually lower your chances of getting a quality answer.

Besides making your issue confusing and hard to read, spreading the conversation across multiple threads and multiple forums has the potential to really infuriate the very people who are most capable of helping you.

I can tell you from first hand experience that there are few things more aggravating that reading a question, thinking about it, guessing at an answer, looking things up and possibly running the solution to insure that you don't post a bad answer, then posting it; only to find out that the question had already been answered in another thread.
[ July 13, 2006: Message edited by: Ben Souther ]
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!