• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Stored procedure not being refreshed while accessing through code

 
Ranch Hand
Posts: 34
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 41
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hello there,
Not sure if this thread is relevant in a JSP forum; Maybe you can try deleting and recreating the procedure, create it under a new name etc and then try to call it. Maybe check how you're connecting to the database to make sure you're going to the right table. This should not be related in any way to the fact that you're running JSP in Tomcat.

Cheers!
 
Sheriff
Posts: 13411
Firefox Browser VI Editor Redhat
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Moving to the JDBC forum where the database gurus hang out.
 
Saumya Nair
Ranch Hand
Posts: 34
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
tried deleting n recreating it too.. works fine with Query analyzer... but with code it says "could not find the stored procedure"
 
author
Posts: 4335
39
jQuery Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
It might be that the stored procedure is attached to a specific user or defined on both a user and system level. That's the most common case I've seen for the problem you're describing.

Query Analyzer does some nice things for you and figures out users whereas direct JDBC often only has access to specific items based on the user you logged in as. Try calling the procedure with the user's name.
 
Saumya Nair
Ranch Hand
Posts: 34
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Yes.. it did work.. Thank you
 
Those cherries would go best on cherry cheesecake. Don't put those cherries on this tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic