com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '2'.

tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    syntax errors executeSQLQuery and AWT-EventQueue-0

    Stack Overflow | 8 months ago | George Kontonikolaou
    com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '2'.
  2. 0

    SQLException: DB grant error

    opengts | 7 years ago | gtssam08
    com.microsoft.sqlserver.jdbc.SQLServerException: Line 1: Incorrect syntax near 'LOGIN'.
  3. 0

    Error sql server 2005

    opengts | 7 years ago | gonzaloperu
    com.microsoft.sqlserver.jdbc.SQLServerException: Error de validaci├│n de contrase├▒a. La contrase├▒a no cumple los requisitos de direct iva de Windows porque no es bastante compleja.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    com.microsoft.sqlserver.jdbc.SQLServerException: There are more columns in the INSERT statement than values specified in the VALUES clause

    Stack Overflow | 8 months ago | George Kontonikolaou
    com.microsoft.sqlserver.jdbc.SQLServerException: There are more columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.
  6. 0

    MS SQL 2005 :: Error calling Stored Procedures. | SQL Server Performance Forums

    sql-server-performance.com | 2 years ago
    com.microsoft.sqlserver.jdbc.SQLServerException: Server failed to resume the transaction, desc: 37000000b7.

  1. SteVio1989 2 times, last 4 months ago
6 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. com.microsoft.sqlserver.jdbc.SQLServerException

    Incorrect syntax near '2'.

    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError()
  2. com.microsoft.sqlserver
    SQLServerStatement.executeUpdate
    1. com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:196)
    2. com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1454)
    3. com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:786)
    4. com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:685)
    5. com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)
    6. com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1416)
    7. com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:185)
    8. com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:160)
    9. com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(SQLServerStatement.java:642)
    9 frames
  3. mylogin
    Orders$2.actionPerformed
    1. mylogin.Orders.executeSQLQuery(Orders.java:144)
    2. mylogin.Orders.Make_OrderActionPerformed(Orders.java:385)
    3. mylogin.Orders.access$100(Orders.java:23)
    4. mylogin.Orders$2.actionPerformed(Orders.java:205)
    4 frames
  4. Java RT
    EventDispatchThread.run
    1. javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
    2. javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)
    3. javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
    4. javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
    5. javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
    6. java.awt.Component.processMouseEvent(Component.java:6535)
    7. javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
    8. java.awt.Component.processEvent(Component.java:6300)
    9. java.awt.Container.processEvent(Container.java:2236)
    10. java.awt.Component.dispatchEventImpl(Component.java:4891)
    11. java.awt.Container.dispatchEventImpl(Container.java:2294)
    12. java.awt.Component.dispatchEvent(Component.java:4713)
    13. java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4888)
    14. java.awt.LightweightDispatcher.processMouseEvent(Container.java:4525)
    15. java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466)
    16. java.awt.Container.dispatchEventImpl(Container.java:2280)
    17. java.awt.Window.dispatchEventImpl(Window.java:2750)
    18. java.awt.Component.dispatchEvent(Component.java:4713)
    19. java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)
    20. java.awt.EventQueue.access$500(EventQueue.java:97)
    21. java.awt.EventQueue$3.run(EventQueue.java:709)
    22. java.awt.EventQueue$3.run(EventQueue.java:703)
    23. java.security.AccessController.doPrivileged(Native Method)
    24. java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
    25. java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86)
    26. java.awt.EventQueue$4.run(EventQueue.java:731)
    27. java.awt.EventQueue$4.run(EventQueue.java:729)
    28. java.security.AccessController.doPrivileged(Native Method)
    29. java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
    30. java.awt.EventQueue.dispatchEvent(EventQueue.java:728)
    31. java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
    32. java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
    33. java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
    34. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
    35. java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
    36. java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
    36 frames