com.microsoft.sqlserver.jdbc.SQLServerException: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'WHERE'.

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,
Expert tip

If you're not using yet, consider using the SQLServerDataSource to set your server configurations. Also, check if the server is accepting TCP/IP connections and if there's no firewall blocking the connections.

Solutions on the web

via Stack Overflow by domaru
, 1 year ago
com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'WHERE'.
via mulesoft.org by Unknown author, 2 years ago
com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'WHERE'.
via mulesoft.com by Unknown author, 1 year ago
com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'WHERE'.
via microsoft.com by Unknown author, 2 years ago
com.microsoft.sqlserver.jdbc.SQLServerException: The multi-part identifier could not be bound.
via Stack Overflow by TheStressMan
, 1 year ago
com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ','.
via Google Groups by kalakhr, 10 months ago
The multi-part identifier "a.id" could not be bound.
com.microsoft.sqlserver.jdbc.SQLServerException: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'WHERE'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:190)
at com.microsoft.sqlserver.jdbc.SQLServerParameterMetaData.(SQLServerParameterMetaData.java:426)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.getParameterMetaData(SQLServerPreparedStatement.java:1532)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Once, 1 month ago
6 times, 3 months ago
4 times, 5 months ago
Samebug visitor profile picture
Unknown user
Once, 10 months ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.