Johnathon Smith

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]
jdbc:microsoft:sqlserver://130.175.238.229:4078;DatabaseName=Equity;SelectMethod=cursor

[b]jdbc driver[/b]
com.microsoft.jdbc.sqlserver.SQLServerDriver

[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'm in the process of trying to upgrade from Weblogic 8.1 to 10.3. I've installed the new server verson and made the necessary adjustments to my weblogic.xml file. When I run the application, however, I'm running into an unusual error. Upon access of the application I check the user who is trying to access my application by retrieving the remote user from the request header like so...

userID = jspRequest.getRemoteUser(); (where jspRequest is an object of type HttpServletRequest)

This statement is returning null even though when I stop the app in debug mode in eclipse and review the values in jspRequest I can see that "remoteUser" has a valid value in it. It's just not being returned by the get. Since this statement worked in Weblogic 8.1 and isn't working in 10.3 I'm only assuming there is something I missed.

Any ideas?

I have been given the task of installing Weblogic 8.1 SP-6 on a new web server. This web server is running Windows Server 2003 64-bit as an OS. Installing Weblogic went fine and I followed the normal configuration steps. I even made sure to use the iisproxy.ddl and iisforward.dll files located in the <BEA Root>/weblogic81/server/bin/win64 directory. Unfortunately I am getting the following error in the Windows event log upon restarting IIS...

ISAPI Filter "E:\IIS_BEA_Plugins\iisforward.dll" could not be loaded due to a configuration problem. The current configuration only supports loading images built for AMD64 processor architecture. The data field contains the error number.

As an application developer, web server configuration is not my area of expertese. Any help that can be provided would be greatly appreciated. if you need additional details I can provide them.