com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '@P0'

Question

I have an SQL server 2008 procedure which is returning one out parameter, i am giving call to it from java. My code is given below

Stored procedure code is

Create PROCEDURE countInfected @infected int out
AS
Select @infected = COUNT(*) from userInfo
where userID NOT IN (Select userID from deletedInfo);

Java Calling Code is

CallableStatement infected = null;
infected = con.prepareCall("call countInfected(?)");
infected.registerOutParameter(1, java.sql.Types.INTEGER);
infected.execute();
System.out.println("Infected"+ infected.getInt(1));

but infected.execute(); is generating the following error

com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '@P0'

kindly guide me where is problem

This any good to you: groups.google.com/forum/#!msg/mybatis-user/DxLHOn8LZU0/… ?? Basically put braces around, like this "{ call countInfected(?) }" (my SQL Server is toasted so I can't check). — GregHNZ
– GregHNZ, Commented Jun 24, 2013 at 6:42

Donald.McLean · Accepted Answer · 2013-11-21 17:29:22Z

14

As suggested by this link offered up by @GregHNZ, SQL Server requires a set of curly braces around the call.

The line in your code would look like this:

infected = con.prepareCall("{ call countInfected(?) }");

answered Nov 21, 2013 at 17:29

Donald.McLean

89912 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '@P0'

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related