wood burning stoves 2.0
The moose likes JDBC and Relational Databases and the fly likes Getting Exception as Could not find stored procedure 'sp_getNextMainGroup' Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA Java SE 8 Programmer I Study Guide 1Z0-808 this week in the OCAJP forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Getting Exception as Could not find stored procedure Watch "Getting Exception as Could not find stored procedure New topic
Author

Getting Exception as Could not find stored procedure 'sp_getNextMainGroup'

Krishna Gokidi
Greenhorn

Joined: Jul 02, 2008
Posts: 4
Hi All,
I tried to call the stored procedure from java but I am getting Exception as : [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Could not find stored procedure 'sp_getNextMainGroup'

I checked the DB there 'sp_getNextMainGroup' is already exist, even checked the permision of user for the DB every thing is fine.
I unable to get the root cause of this Issue, can any one help me please.

Following the PrintStackTrace of the above Exception,


java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Could not find stored procedure 'sp_getNextMainGroup'.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.postImplExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown Source)
at com.microsoft.jdbc.base.BaseStatement.executeInternal(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.execute(Unknown Source)
at com.fmgtech.reports.HorPackageGen.getNextMainGroup(HorPackageGen.java:372)
at com.fmgtech.reports.HorPackageGen.run(HorPackageGen.java:176)

Thanks in Advance
Scott Selikoff
author
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3736
    
  10

Please post the code you are using to make the connection. More often then not, its probably a permission/database issue; ergo, you're attempting to execute a stored procedure from a invalid context.


[OCA 8 Book] [Blog]
Sachin Joshi
Ranch Hand

Joined: Aug 06, 2008
Posts: 83

Also make sure the number of parameters are same for your procedure....If it returns some value then you may need to have extra param for registering outParam in your code.

As Scott mentioned we can provide better idea if you post the code


Web Development Tips and Tutorials - By Sachin
 
wood burning stoves
 
subject: Getting Exception as Could not find stored procedure 'sp_getNextMainGroup'