wood burning stoves
The moose likes JDBC and Relational Databases and the fly likes Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark ""Could not find stored procedure" Error" Watch ""Could not find stored procedure" Error" New topic

"Could not find stored procedure" Error

Johnathon Smith

Joined: Jul 28, 2009
Posts: 3
I have a java application that access data from a SQL Server 2005 database. All of the sudden I'm getting a "Could not find stored procedure" exception when trying to run any stored procedure from within the application. The code hasn't changed. The database hasn't changed. This code used to work but now I keep getting this error. I've already verified that I can log into the database server and execute the stored procedure from within SQL Server Management Studio using the same credentials that the web app uses. So it doesn't appear to be a permissions issue. Here are some of the details from my code...

[b]connection string[/b]

[b]jdbc driver[/b]

[b]stack trace[/b]
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Could not find stored procedure 'uspCompanyList'.
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.TDSExecuteRequest.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.executeQueryInternal(Unknown Source)
at com.microsoft.jdbc.base.BasePreparedStatement.executeQuery(Unknown Source)

I'm at a loss as to how this code could just stop working. Any ideas?
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
subject: "Could not find stored procedure" Error
jQuery in Action, 3rd edition