com.microsoft.sqlserver.jdbc.SQLServerException: Line 1: Incorrect syntax near ' LOGIN'.         at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError (SQLServerException.java:196)         at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServ erStatement.java:1454)         at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQ LServerStatement.java:786)         at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute (SQLServerStatement.java:685)         at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)         at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLSe rverConnection.java:1416)         at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLSer verStatement.java:185)         at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLS erverStatement.java:160)         at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(SQLServ erStatement.java:642)         at org.opengts.dbtools.DBConnection.\_executeUpdate(DBConnection.java:716 )         at org.opengts.dbtools.DBConnection.executeUpdate(DBConnection.java:674)

opengts | kernal69 | 7 years ago
  1. 0

    Trouble creating databas on a sql 2000 server

    opengts | 7 years ago | kernal69
    com.microsoft.sqlserver.jdbc.SQLServerException: Line 1: Incorrect syntax near ' LOGIN'.         at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError (SQLServerException.java:196)         at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServ erStatement.java:1454)         at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQ LServerStatement.java:786)         at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute (SQLServerStatement.java:685)         at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)         at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLSe rverConnection.java:1416)         at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLSer verStatement.java:185)         at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLS erverStatement.java:160)         at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(SQLServ erStatement.java:642)         at org.opengts.dbtools.DBConnection.\_executeUpdate(DBConnection.java:716 )         at org.opengts.dbtools.DBConnection.executeUpdate(DBConnection.java:674)
  2. 0

    java Exception : converting date and/or time from character string

    Stack Overflow | 5 years ago | sush
    com.microsoft.sqlserver.jdbc.SQLServerException: Conversion failed when converti ng date and/or time from character string. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError (SQLServerException.java:197) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServ erStatement.java:1493) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQ LServerStatement.java:775) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute (SQLServerStatement.java:676)
  3. 0

    [Sqoop-user] sqoop2 export to microsoft SQL server - supported jdbc connectors - Grokbase

    grokbase.com | 1 year ago
    com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'SELECT'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:792) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:689)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    [SQOOP-1383] Sqoop2: MSSQL Export not working - ASF JIRA

    apache.org | 1 year ago
    com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'SELECT'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:792) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:689)
  6. 0

    [SQOOP-1507] Sqoop2 export to MSSQL fails - ASF JIRA

    apache.org | 1 year ago
    com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'SELECT'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:792) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:689)

    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

      Line 1: Incorrect syntax near ' LOGIN'.         at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError (SQLServerException.java:196)         at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServ erStatement.java:1454)         at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQ LServerStatement.java:786)         at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute (SQLServerStatement.java:685)         at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026)         at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLSe rverConnection.java:1416)         at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLSer verStatement.java:185)         at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLS erverStatement.java:160)         at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(SQLServ erStatement.java:642)         at org.opengts.dbtools.DBConnection.\_executeUpdate(DBConnection.java:716 )         at org.opengts.dbtools.DBConnection.executeUpdate(DBConnection.java:674)

      at org.opengts.dbtools.DBConnection.executeUpdate()
    2. org.opengts.dbtools
      DBProvider.grantDBUser
      1. org.opengts.dbtools.DBConnection.executeUpdate(DBConnection.java:655)
      2. org.opengts.dbtools.DBProvider.grantDBUser(DBProvider.java:1766)
      2 frames