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

Solutions on the web

via JIRA by Gary L. Klesczewski, 2 years ago
liquibase.exception.DatabaseExcepti on: Error executing SQL ALTER TABLE [dbo].[FLIGHT] DROP CONSTRAINT select d.name from syscolumns c,sysobjects d, sysobjects t where c.id=t.id AND d.parent_obj=t .id AND d.type='D' AND t.type='U' AND c.name='SEAT_QTY' AND t.name='FLIGHT': Inc orrect syntax near the keyword 'select'.
via JIRA by Gary L. Klesczewski, 1 year ago
liquibase.exception.DatabaseExcepti on: Error executing SQL ALTER TABLE [dbo].[FLIGHT] DROP CONSTRAINT select d.name from syscolumns c,sysobjects d, sysobjects t where c.id=t.id AND d.parent_obj=t .id AND d.type='D' AND t.type='U' AND c.name='SEAT_QTY' AND t.name='FLIGHT': Inc orrect syntax near the keyword 'select'.
liquibase.exception.RollbackFailedException: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE [dbo].[FLIGHT] DROP CONSTRAINT select d.name from syscolumns c,sysobjects d, sysobjects t where c.id=t.id AND d.parent_obj=t.id AND d.type='D' AND t.type='U' AND c.name='SEAT_QTY' AND t.name='FLIGHT': Incorrect syntax near the keyword 'select'. at liquibase.changelog.ChangeSet.rollback(ChangeSet.java:401) at liquibase.changelog.visitor.RollbackVisitor.visit(RollbackVisitor.java:23) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58) at liquibase.Liquibase.rollback(Liquibase.java:255) at liquibase.integration.commandline.Main.doMigration(Main.java:851) at liquibase.integration.commandline.Main.main(Main.java:134)Caused by: liquibase.exception.DatabaseException: Error executing SQL ALTER TABLE [dbo].[FLIGHT] DROP CONSTRAINT select d.name from syscolumns c,sysobjects d, sysobjects t where c.id=t.id AND d.parent_obj=t.id AND d.type='D' AND t.type='U'AND c.name='SEAT_QTY' AND t.name='FLIGHT': Incorrect syntax near the keyword 'select'. at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104) at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:1091) at liquibase.database.AbstractDatabase.executeRollbackStatements(AbstractDatabase.java:1115) at liquibase.changelog.ChangeSet.rollback(ChangeSet.java:388) ... 5 moreCaused by: 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) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:662) at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInStatement(JdbcExecutor.java:92) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55) ... 9 more