Hi Everybody,
I have a dumb issue i need to resolve,
I have a virtual directory mapped to an error log folder which simply simply holds xml error logs. When I browse to the site through IE, everything works fine and I can view the logs except they are sorted by name. What kind of configuration must i do in order to have them sorted by Date instead?
Thanks In Advance,
-Dave
jynxxxed
Last Activity: Jun 4 '07, 09:25 PM
Joined: Apr 26 '07
Location:
-
Well it turns out I needed to call the procedure with the fully qualified 4 part name. I wish the error was a little more descriptive, I thought it was a permissions issue, yet stumbled on the answer by accident. -
SQL Server Stored Proc Issue with Java
I've been reviewing some of the threads here and applying some of the advice and still getting the same error.
Code:15:50:26,935 INFO [STDOUT] java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Could not find stored procedure 'getName'.
I'm basically taking a variable coming to my servlet through a JSP page and using it as my search criteria. I know the stored proc... -
Well,
That's true, I am accessing the result set object after closing the connection and Callable statement, but I thought that since I set the ResultSet while they're still open, I could access it without worrying about the connection.
But I am still unsure why I can't execute the callable statement though, and why I would get the error, "Cannot Find Stored Procedure 'getName' ".. I'm definitely baffled....Leave a comment:
-
SQL Server Stored Proc Problem
I've been reviewing some of the threads here and applying some of the advice and still getting the same error.
I'm basically taking a variable coming to my servlet through a JSP page and using it as my search criteria. I know the stored proc will execute through query analyzer,...Code:15:50:26,935 INFO [STDOUT] java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Could not find stored procedure 'getName'.
No activity results to display
Leave a comment: