org.jkiss.dbeaver.DBException: SQL Error [102] [S0001]: Incorrect syntax near '06'.

GitHub | adrinjalali | 3 months ago
  1. 0

    mssqlserver, underscore in DB name results in errors.

    GitHub | 3 months ago | adrinjalali
    org.jkiss.dbeaver.DBException: SQL Error [102] [S0001]: Incorrect syntax near '06'.
  2. 0

    DBFit jdbc.SQLServerException: Incorrect syntax near the keyword 'as'

    Stack Overflow | 3 years ago | libran_6
    com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'as'.
  3. 0

    jpa/eclipselink getting data error

    Stack Overflow | 4 years ago | Serkan Alg├╝l
    com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'Personnel'. Error Code: 208 Call: SELECT IdentificationNumber, Age, Name, Surname FROM Personnel Query: ReadAllQuery(referenceClass=Personnel sql="SELECT IdentificationNumber, Age, Name, Surname FROM Personnel")
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Invalid Object Name for Hibernate Sequence Generator

    Stack Overflow | 2 years ago
    org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  6. 0

    setting default value for column in hibernate

    Stack Overflow | 2 years ago | Sharique
    org.hibernate.exception.SQLGrammarException: could not extract ResultSet

  1. muffinmannen 2 times, last 5 months ago
37 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 '06'.

    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError()
  2. com.microsoft.sqlserver
    SQLServerPreparedStatement.executeQuery
    1. com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216)
    2. com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1515)
    3. com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404)
    4. com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
    5. com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
    6. com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
    7. com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
    8. com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
    9. com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285)
    9 frames
  3. org.jkiss.dbeaver
    AbstractJob.run
    1. org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCPreparedStatementImpl.executeQuery(JDBCPreparedStatementImpl.java:224)
    2. org.jkiss.dbeaver.ext.mssql.model.SQLServerMetaModel.extractSource(SQLServerMetaModel.java:142)
    3. org.jkiss.dbeaver.ext.mssql.model.SQLServerMetaModel.getProcedureDDL(SQLServerMetaModel.java:62)
    4. org.jkiss.dbeaver.ext.generic.model.GenericProcedure.getObjectDefinitionText(GenericProcedure.java:270)
    5. org.jkiss.dbeaver.ui.editors.sql.SQLSourceViewer.getSourceText(SQLSourceViewer.java:54)
    6. org.jkiss.dbeaver.ui.editors.sql.SQLEditorNested$ObjectDocumentProvider$1.run(SQLEditorNested.java:233)
    7. org.jkiss.dbeaver.runtime.TasksJob.run(TasksJob.java:61)
    8. org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:103)
    8 frames
  4. Eclipse Jobs
    Worker.run
    1. org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
    1 frame