java.sql.SQLException: Incorrect syntax near the keyword 'is'.

Stack Overflow | Sandah Aung | 4 months ago
  1. 0

    Log4J JDBCAppender exception with MS SQL Server

    Stack Overflow | 4 months ago | Sandah Aung
    java.sql.SQLException: Incorrect syntax near the keyword 'is'.
  2. 0

    How to ignore double quotes in sql update query for changing column value( value is XML)

    Stack Overflow | 2 years ago | Ravichandra
    java.sql.SQLException: Incorrect syntax near '1.0'.
  3. 0

    fresh install: invalid column name 'scheme' - Atlassian Answers

    atlassian.com | 4 months ago
    java.sql.SQLException: Invalid column name 'scheme'.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    h3. Summary The upgrade from Bamboo 5.10.3 to 5.11.1.1 fails and the following error can be found in the logs: {{java.sql.SQLException: Invalid column name 'ID'.}} h3. Environment * Upgrade from Bamboo 5.10.3 to 5.11.1.1 * Backend database on SQL Server h3. Steps to Reproduce # Install Bamboo 5.10.3 and run the Setup Wizard # Follow the [Bamboo 5.11.1.1 upgrade guide|https://confluence.atlassian.com/display/BAMBOO/Bamboo+upgrade+guide] to upgrade to that version h3. Expected Results Once Tomcat is started, the upgrade begins and finishes successfully. h3. Actual Results # Once Tomcat is started, the upgrade begins, but upgrade task *51110 : Disallow duplicate trusted keys - remove duplicates* fails with the following exception in the log: {noformat} ERROR [localhost-startStop-1] [AbstractUpgradeManager] java.sql.SQLException: Invalid column name 'ID'. java.sql.SQLException: Invalid column name 'ID'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:613) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:572) at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:809) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1288) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1241) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64) at com.atlassian.bamboo.upgrade.tasks.v5_11.UpgradeTask51110DisallowDuplicateTrustedKeys.lambda$doUpgrade$20(UpgradeTask51110DisallowDuplicateTrustedKeys.java:46) at com.atlassian.bamboo.upgrade.tasks.v5_11.UpgradeTask51110DisallowDuplicateTrustedKeys$$Lambda$11/405586908.doInHibernateTransaction(Unknown Source) at com.atlassian.bamboo.upgrade.AbstractBootstrapUpgradeTask.withDatabaseConnection(AbstractBootstrapUpgradeTask.java:86) at com.atlassian.bamboo.upgrade.tasks.v5_11.UpgradeTask51110DisallowDuplicateTrustedKeys.doUpgrade(UpgradeTask51110DisallowDuplicateTrustedKeys.java:42) at com.atlassian.bamboo.upgrade.AbstractUpgradeManager.runUpgradeTask(AbstractUpgradeManager.java:206) at com.atlassian.bamboo.upgrade.BootstrapUpgradeManagerImpl.doUpgrade(BootstrapUpgradeManagerImpl.java:59) at com.atlassian.bamboo.setup.DefaultBootstrapManager.performPersistenceUpgrade(DefaultBootstrapManager.java:359) at com.atlassian.config.bootstrap.DefaultAtlassianBootstrapManager.init(DefaultAtlassianBootstrapManager.java:77) at com.atlassian.bamboo.setup.BootstrapLoaderListener.contextInitialized(BootstrapLoaderListener.java:117) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4812) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5255) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1408) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1398) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) {noformat} h3.Workaround # Stop Bamboo # Backup original {{$BAMBOO_INSTALL/WEB-INF/lib/atlassian-bamboo-deployments-5.11.*.jar}} # Copy attached [^atlassian-bamboo-deployments-5.11.1.1.jar] to {{$BAMBOO_INSTALL/WEB-INF/lib}} # Start Bamboo

    Atlassian JIRA | 7 months ago | Christian Glockner [Atlassian]
    java.sql.SQLException: Invalid column name 'ID'.
  6. 0

    h3. Summary The upgrade from Bamboo 5.10.3 to 5.11.1.1 fails and the following error can be found in the logs: {{java.sql.SQLException: Invalid column name 'ID'.}} h3. Environment * Upgrade from Bamboo 5.10.3 to 5.11.1.1 * Backend database on SQL Server h3. Steps to Reproduce # Install Bamboo 5.10.3 and run the Setup Wizard # Follow the [Bamboo 5.11.1.1 upgrade guide|https://confluence.atlassian.com/display/BAMBOO/Bamboo+upgrade+guide] to upgrade to that version h3. Expected Results Once Tomcat is started, the upgrade begins and finishes successfully. h3. Actual Results # Once Tomcat is started, the upgrade begins, but upgrade task *51110 : Disallow duplicate trusted keys - remove duplicates* fails with the following exception in the log: {noformat} ERROR [localhost-startStop-1] [AbstractUpgradeManager] java.sql.SQLException: Invalid column name 'ID'. java.sql.SQLException: Invalid column name 'ID'. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671) at net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:613) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:572) at net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:809) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1288) at net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1241) at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64) at com.atlassian.bamboo.upgrade.tasks.v5_11.UpgradeTask51110DisallowDuplicateTrustedKeys.lambda$doUpgrade$20(UpgradeTask51110DisallowDuplicateTrustedKeys.java:46) at com.atlassian.bamboo.upgrade.tasks.v5_11.UpgradeTask51110DisallowDuplicateTrustedKeys$$Lambda$11/405586908.doInHibernateTransaction(Unknown Source) at com.atlassian.bamboo.upgrade.AbstractBootstrapUpgradeTask.withDatabaseConnection(AbstractBootstrapUpgradeTask.java:86) at com.atlassian.bamboo.upgrade.tasks.v5_11.UpgradeTask51110DisallowDuplicateTrustedKeys.doUpgrade(UpgradeTask51110DisallowDuplicateTrustedKeys.java:42) at com.atlassian.bamboo.upgrade.AbstractUpgradeManager.runUpgradeTask(AbstractUpgradeManager.java:206) at com.atlassian.bamboo.upgrade.BootstrapUpgradeManagerImpl.doUpgrade(BootstrapUpgradeManagerImpl.java:59) at com.atlassian.bamboo.setup.DefaultBootstrapManager.performPersistenceUpgrade(DefaultBootstrapManager.java:359) at com.atlassian.config.bootstrap.DefaultAtlassianBootstrapManager.init(DefaultAtlassianBootstrapManager.java:77) at com.atlassian.bamboo.setup.BootstrapLoaderListener.contextInitialized(BootstrapLoaderListener.java:117) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4812) at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5255) at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1408) at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1398) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) {noformat} h3.Workaround # Stop Bamboo # Backup original {{$BAMBOO_INSTALL/WEB-INF/lib/atlassian-bamboo-deployments-5.11.*.jar}} # Copy attached [^atlassian-bamboo-deployments-5.11.1.1.jar] to {{$BAMBOO_INSTALL/WEB-INF/lib}} # Start Bamboo

    Atlassian JIRA | 7 months ago | Christian Glockner [Atlassian]
    java.sql.SQLException: Invalid column name 'ID'.

    1 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. java.sql.SQLException

      Incorrect syntax near the keyword 'is'.

      at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic()
    2. jTDS
      JtdsStatement.executeUpdate
      1. net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)
      2. net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)
      3. net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)
      4. net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671)
      5. net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:613)
      6. net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:572)
      7. net.sourceforge.jtds.jdbc.JtdsStatement.executeImpl(JtdsStatement.java:809)
      8. net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1288)
      9. net.sourceforge.jtds.jdbc.JtdsStatement.executeUpdate(JtdsStatement.java:1241)
      9 frames
    3. Apache Log4j
      Category.info
      1. org.apache.log4j.jdbc.JDBCAppender.execute(JDBCAppender.java:218)
      2. org.apache.log4j.jdbc.JDBCAppender.flushBuffer(JDBCAppender.java:289)
      3. org.apache.log4j.jdbc.JDBCAppender.append(JDBCAppender.java:186)
      4. org.apache.log4j.AppenderSkeleton.doAppend(AppenderSkeleton.java:251)
      5. org.apache.log4j.helpers.AppenderAttachableImpl.appendLoopOnAppenders(AppenderAttachableImpl.java:66)
      6. org.apache.log4j.Category.callAppenders(Category.java:206)
      7. org.apache.log4j.Category.forcedLog(Category.java:391)
      8. org.apache.log4j.Category.info(Category.java:666)
      8 frames
    4. com.nirvasoft.logging
      Main.main
      1. com.nirvasoft.logging.Main.main(Main.java:20)
      1 frame