aspose file tools*
The moose likes JDBC 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
JavaRanch » Java Forums » Databases » JDBC
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
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3704
    
    5

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.


My Blog: Down Home Country Coding with Scott Selikoff
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Getting Exception as Could not find stored procedure 'sp_getNextMainGroup'