• Post Reply Bookmark Topic Watch Topic
  • New Topic

Different results when running Store procedure from Java vs. running Stored Procedure directly.

 
Jeff Schuler
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


When I run the SP directly I do this:



When I run it from Java it's like this:




The connection info is:


The following SQL code is behaving differently when the SP is called from Java:



The SP is updating a table from another database on another server. Does anyone know why the results would be different?

 
Jan Cumps
Bartender
Posts: 2620
14
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


The proper way to call a stored procedure:


Use the proper brackets, use call before the procedure, use a callable statement, use prepareCall(),
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!