java.sql.SQLException: The TDS protocol does not support JDBC datatype 2000.

Atlassian JIRA | Pawel Niewiadomski [Atlassian] | 3 years ago
  1. 0

    When upgrading JIRA 5.1.5 to 6.3 (using MS SQL Server) user reported a following exception: {code} An error occurred performing JIRA upgrade task 2014-05-29 09:59:20 error Exception thrown during upgrade: while inserting: [GenericEntity:JQRTZJobDetails][requestsRecovery,false][jobGroup,TIMESHEET_SUBSCRIPTION][className,jira.timesheet.plugin.job.TimesheetJob][isDurable,true][jobName,TIMESHEET_SUBSCRIPTION][isVolatile,false][isStateful,false] (SQL Exception while executing the following:INSERT INTO JQUARTZ_JOB_DETAILS (SCHED_NAME, JOB_NAME, JOB_GROUP, DESCRIPTION, JOB_CLASS_NAME, IS_DURABLE, IS_VOLATILE, IS_STATEFUL, IS_NONCONCURRENT, IS_UPDATE_DATA, REQUESTS_RECOVERY, JOB_DATA) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The TDS protocol does not support JDBC datatype 2000.)) org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:JQRTZJobDetails][requestsRecovery,false][jobGroup,TIMESHEET_SUBSCRIPTION][className,jira.timesheet.plugin.job.TimesheetJob][isDurable,true][jobName,TIMESHEET_SUBSCRIPTION][isVolatile,false][isStateful,false] (SQL Exception while executing the following:INSERT INTO JQUARTZ_JOB_DETAILS (SCHED_NAME, JOB_NAME, JOB_GROUP, DESCRIPTION, JOB_CLASS_NAME, IS_DURABLE, IS_VOLATILE, IS_STATEFUL, IS_NONCONCURRENT, IS_UPDATE_DATA, REQUESTS_RECOVERY, JOB_DATA) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The TDS protocol does not support JDBC datatype 2000.)) at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:200) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:165) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:83) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:554) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:540) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:98) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6302.upgradeJobDetails(UpgradeTask_Build6302.java:93) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6302.doUpgrade(UpgradeTask_Build6302.java:61) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSuccess(UpgradeManagerImpl.java:687) at com.atlassian.jira.upgrade.UpgradeManagerImpl.runUpgradeTasks(UpgradeManagerImpl.java:536) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:465) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeeded(UpgradeManagerImpl.java:407) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeededAndAllowed(UpgradeManagerImpl.java:342) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.upgradeJira(DefaultDataImportService.java:823) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:711) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:299) at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:66) at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:29) at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:179) at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:150) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO JQUARTZ_JOB_DETAILS (SCHED_NAME, JOB_NAME, JOB_GROUP, DESCRIPTION, JOB_CLASS_NAME, IS_DURABLE, IS_VOLATILE, IS_STATEFUL, IS_NONCONCURRENT, IS_UPDATE_DATA, REQUESTS_RECOVERY, JOB_DATA) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The TDS protocol does not support JDBC datatype 2000.) at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:650) at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:192) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:165) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:83) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:554) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:540) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:98) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6302.upgradeJobDetails(UpgradeTask_Build6302.java:93) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6302.doUpgrade(UpgradeTask_Build6302.java:61) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSuccess(UpgradeManagerImpl.java:687) at com.atlassian.jira.upgrade.UpgradeManagerImpl.runUpgradeTasks(UpgradeManagerImpl.java:536) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:465) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeeded(UpgradeManagerImpl.java:407) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeededAndAllowed(UpgradeManagerImpl.java:342) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.upgradeJira(DefaultDataImportService.java:823) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:711) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:299) at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:66) at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:29) at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:179) at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:150) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) java.sql.SQLException: The TDS protocol does not support JDBC datatype 2000. at net.sourceforge.jtds.jdbc.TdsData.getNativeType(TdsData.java:1537) at net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareSQL(ConnectionJDBC2.java:654) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:505) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:640) at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:192) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:165) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:83) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:554) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:540) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:98) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6302.upgradeJobDetails(UpgradeTask_Build6302.java:93) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6302.doUpgrade(UpgradeTask_Build6302.java:61) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSuccess(UpgradeManagerImpl.java:687) at com.atlassian.jira.upgrade.UpgradeManagerImpl.runUpgradeTasks(UpgradeManagerImpl.java:536) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:465) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeeded(UpgradeManagerImpl.java:407) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeededAndAllowed(UpgradeManagerImpl.java:342) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.upgradeJira(DefaultDataImportService.java:823) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:711) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:299) at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:66) at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:29) at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:179) at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:150) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) {code}

    Atlassian JIRA | 3 years ago | Pawel Niewiadomski [Atlassian]
    java.sql.SQLException: The TDS protocol does not support JDBC datatype 2000.
  2. 0

    When upgrading JIRA 5.1.5 to 6.3 (using MS SQL Server) user reported a following exception: {code} An error occurred performing JIRA upgrade task 2014-05-29 09:59:20 error Exception thrown during upgrade: while inserting: [GenericEntity:JQRTZJobDetails][requestsRecovery,false][jobGroup,TIMESHEET_SUBSCRIPTION][className,jira.timesheet.plugin.job.TimesheetJob][isDurable,true][jobName,TIMESHEET_SUBSCRIPTION][isVolatile,false][isStateful,false] (SQL Exception while executing the following:INSERT INTO JQUARTZ_JOB_DETAILS (SCHED_NAME, JOB_NAME, JOB_GROUP, DESCRIPTION, JOB_CLASS_NAME, IS_DURABLE, IS_VOLATILE, IS_STATEFUL, IS_NONCONCURRENT, IS_UPDATE_DATA, REQUESTS_RECOVERY, JOB_DATA) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The TDS protocol does not support JDBC datatype 2000.)) org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:JQRTZJobDetails][requestsRecovery,false][jobGroup,TIMESHEET_SUBSCRIPTION][className,jira.timesheet.plugin.job.TimesheetJob][isDurable,true][jobName,TIMESHEET_SUBSCRIPTION][isVolatile,false][isStateful,false] (SQL Exception while executing the following:INSERT INTO JQUARTZ_JOB_DETAILS (SCHED_NAME, JOB_NAME, JOB_GROUP, DESCRIPTION, JOB_CLASS_NAME, IS_DURABLE, IS_VOLATILE, IS_STATEFUL, IS_NONCONCURRENT, IS_UPDATE_DATA, REQUESTS_RECOVERY, JOB_DATA) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The TDS protocol does not support JDBC datatype 2000.)) at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:200) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:165) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:83) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:554) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:540) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:98) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6302.upgradeJobDetails(UpgradeTask_Build6302.java:93) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6302.doUpgrade(UpgradeTask_Build6302.java:61) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSuccess(UpgradeManagerImpl.java:687) at com.atlassian.jira.upgrade.UpgradeManagerImpl.runUpgradeTasks(UpgradeManagerImpl.java:536) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:465) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeeded(UpgradeManagerImpl.java:407) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeededAndAllowed(UpgradeManagerImpl.java:342) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.upgradeJira(DefaultDataImportService.java:823) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:711) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:299) at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:66) at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:29) at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:179) at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:150) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO JQUARTZ_JOB_DETAILS (SCHED_NAME, JOB_NAME, JOB_GROUP, DESCRIPTION, JOB_CLASS_NAME, IS_DURABLE, IS_VOLATILE, IS_STATEFUL, IS_NONCONCURRENT, IS_UPDATE_DATA, REQUESTS_RECOVERY, JOB_DATA) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (The TDS protocol does not support JDBC datatype 2000.) at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:650) at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:192) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:165) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:83) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:554) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:540) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:98) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6302.upgradeJobDetails(UpgradeTask_Build6302.java:93) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6302.doUpgrade(UpgradeTask_Build6302.java:61) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSuccess(UpgradeManagerImpl.java:687) at com.atlassian.jira.upgrade.UpgradeManagerImpl.runUpgradeTasks(UpgradeManagerImpl.java:536) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:465) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeeded(UpgradeManagerImpl.java:407) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeededAndAllowed(UpgradeManagerImpl.java:342) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.upgradeJira(DefaultDataImportService.java:823) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:711) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:299) at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:66) at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:29) at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:179) at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:150) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) java.sql.SQLException: The TDS protocol does not support JDBC datatype 2000. at net.sourceforge.jtds.jdbc.TdsData.getNativeType(TdsData.java:1537) at net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareSQL(ConnectionJDBC2.java:654) at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:505) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:640) at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:192) at org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:165) at org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:83) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:554) at org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:540) at org.ofbiz.core.entity.GenericValue.create(GenericValue.java:98) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6302.upgradeJobDetails(UpgradeTask_Build6302.java:93) at com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6302.doUpgrade(UpgradeTask_Build6302.java:61) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSuccess(UpgradeManagerImpl.java:687) at com.atlassian.jira.upgrade.UpgradeManagerImpl.runUpgradeTasks(UpgradeManagerImpl.java:536) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:465) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeeded(UpgradeManagerImpl.java:407) at com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeededAndAllowed(UpgradeManagerImpl.java:342) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.upgradeJira(DefaultDataImportService.java:823) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:711) at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:299) at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:66) at com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:29) at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:179) at com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:150) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) {code}

    Atlassian JIRA | 3 years ago | Pawel Niewiadomski [Atlassian]
    java.sql.SQLException: The TDS protocol does not support JDBC datatype 2000.
  3. 0

    Scheduler stopped when deadlock happened in Spring Transaction

    Stack Overflow | 4 years ago | rifo pangemanan
    org.springframework.dao.CannotAcquireLockException: could not update: [com.btpn.custody.entity.MasterData#00176ed4-b7a2-4da5-a266-ffaab3654050]; SQL [update T_CIF set __UPDATED_DATE=?, STATUS_MD=? where __SID=?]; nested exception is org.hibernate.exception.LockAcquisitionException: could not update: [com.btpn.custody.entity.MasterData#00176ed4-b7a2-4da5-a266-ffaab3654050]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    [SPR-1690] SQL Server Error Code 1205 = DeadlockLoser - Spring JIRA

    spring.io | 1 year ago
    java.sql.SQLException: Transaction (Process ID 51) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

  1. vmuller 2 times, last 10 months ago
5 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

    The TDS protocol does not support JDBC datatype 2000.

    at net.sourceforge.jtds.jdbc.TdsData.getNativeType()
  2. jTDS
    JtdsPreparedStatement.executeUpdate
    1. net.sourceforge.jtds.jdbc.TdsData.getNativeType(TdsData.java:1537)
    2. net.sourceforge.jtds.jdbc.ConnectionJDBC2.prepareSQL(ConnectionJDBC2.java:654)
    3. net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeUpdate(JtdsPreparedStatement.java:505)
    3 frames
  3. Commons DBCP
    DelegatingPreparedStatement.executeUpdate
    1. org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    2. org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    2 frames
  4. org.ofbiz.core
    GenericValue.create
    1. org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:640)
    2. org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:192)
    3. org.ofbiz.core.entity.GenericDAO.insert(GenericDAO.java:165)
    4. org.ofbiz.core.entity.GenericHelperDAO.create(GenericHelperDAO.java:83)
    5. org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:554)
    6. org.ofbiz.core.entity.GenericDelegator.create(GenericDelegator.java:540)
    7. org.ofbiz.core.entity.GenericValue.create(GenericValue.java:98)
    7 frames
  5. com.atlassian.jira
    ImportTaskManagerImpl$TaskCallableDecorator.call
    1. com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6302.upgradeJobDetails(UpgradeTask_Build6302.java:93)
    2. com.atlassian.jira.upgrade.tasks.UpgradeTask_Build6302.doUpgrade(UpgradeTask_Build6302.java:61)
    3. com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeTaskSuccess(UpgradeManagerImpl.java:687)
    4. com.atlassian.jira.upgrade.UpgradeManagerImpl.runUpgradeTasks(UpgradeManagerImpl.java:536)
    5. com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgrade(UpgradeManagerImpl.java:465)
    6. com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeeded(UpgradeManagerImpl.java:407)
    7. com.atlassian.jira.upgrade.UpgradeManagerImpl.doUpgradeIfNeededAndAllowed(UpgradeManagerImpl.java:342)
    8. com.atlassian.jira.bc.dataimport.DefaultDataImportService.upgradeJira(DefaultDataImportService.java:823)
    9. com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:711)
    10. com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:299)
    11. com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:66)
    12. com.atlassian.jira.web.action.setup.DataImportAsyncCommand.call(DataImportAsyncCommand.java:29)
    13. com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:179)
    14. com.atlassian.jira.task.ImportTaskManagerImpl$TaskCallableDecorator.call(ImportTaskManagerImpl.java:150)
    14 frames
  6. Java RT
    Thread.run
    1. java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
    2. java.util.concurrent.FutureTask.run(Unknown Source)
    3. java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    4. java.util.concurrent.FutureTask$Sync.innerRun(Unknown Source)
    5. java.util.concurrent.FutureTask.run(Unknown Source)
    6. java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    7. java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    8. java.lang.Thread.run(Unknown Source)
    8 frames