Hi,
I am using SQL Server 2000 database and i have some stored procedures to retrieve the data. I am using
JDBC driver for SQL Server 2000. After making some changes to one of the stored procedures i am getting SQLException although the query analyzer shows correct output for that stored procedure:-(
this is the exception i am getting:
INFO [STDOUT] SQLException in STT_Beans.STT_EntityBeans.SearchListEntity.loadTeamMembersRequests(): java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Incorrect syntax near the keyword 'in'.
ERROR [STDERR] java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Incorrect syntax near the keyword 'in'.
ERROR [STDERR] at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
ERROR [STDERR] at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
ERROR [STDERR] at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
ERROR [STDERR] at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
ERROR [STDERR] at com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source)