liquibase.exception.JDBCException: Error executing SQL INSERT INTO `InterviewLog` (`eventReason`, `dateTime`, `occurrence`, `actionType`, `comment`, `entit y_id`, `user`, `stage`) VALUES (NULL, '2009-10-15 13:14:40.0', 1, 'EXECUTE', NULL, '5918781446', 'ywilliams', 'Consent')

JIRA | Dwain Elson | 7 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    I get the following error after I added the Owen Sound data to the Opal Data Base. Mississauga created the Mart with no error C:\Program Files\opal\conf>opal extract -r jdbc-extract input.file.name=file:report.xml run=5 JAVA_HOME=C:\Program Files\Java\jre6 OPAL_HOME=C:\Program Files\opal 2009-11-16 16:26:42,978 - ERROR - core.step.AbstractStep - Encountered an error executing the step liquibase.exception.JDBCException: Error executing SQL INSERT INTO `InterviewLog` (`eventReason`, `dateTime`, `occurrence`, `actionType`, `comment`, `entit y_id`, `user`, `stage`) VALUES (NULL, '2009-10-15 13:14:40.0', 1, 'EXECUTE', NULL, '5918781446', 'ywilliams', 'Consent') at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:55) at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:86) at liquibase.change.AbstractChange.execute(AbstractChange.java:247) at liquibase.change.AbstractChange.executeStatements(AbstractChange.java:93) at org.obiba.opal.jdbcmart.batch.SchemaChangeWriter.write(SchemaChangeWriter.java:82) at org.springframework.batch.core.step.item.SimpleChunkProcessor.writeItems(SimpleChunkProcessor.java:156) at org.springframework.batch.core.step.item.SimpleChunkProcessor.doWrite(SimpleChunkProcessor.java:137) at org.springframework.batch.core.step.item.SimpleChunkProcessor.write(SimpleChunkProcessor.java:252) at org.springframework.batch.core.step.item.SimpleChunkProcessor.process(SimpleChunkProcessor.java:178) at org.springframework.batch.core.step.item.ChunkOrientedTasklet.execute(ChunkOrientedTasklet.java:70) at org.springframework.batch.core.step.tasklet.TaskletStep$2.doInChunkContext(TaskletStep.java:268) at org.springframework.batch.core.scope.context.StepContextRepeatCallback.doInIteration(StepContextRepeatCallback.java:81) at org.springframework.batch.repeat.support.RepeatTemplate.getNextResult(RepeatTemplate.java:367) at org.springframework.batch.repeat.support.RepeatTemplate.executeInternal(RepeatTemplate.java:215) at org.springframework.batch.repeat.support.RepeatTemplate.iterate(RepeatTemplate.java:143) at org.springframework.batch.core.step.tasklet.TaskletStep.doExecute(TaskletStep.java:242) at org.springframework.batch.core.step.AbstractStep.execute(AbstractStep.java:198) at org.springframework.batch.core.job.AbstractJob.handleStep(AbstractJob.java:348) at org.springframework.batch.core.job.flow.FlowJob.access$0(FlowJob.java:1) at org.springframework.batch.core.job.flow.FlowJob$JobFlowExecutor.executeStep(FlowJob.java:135) at org.springframework.batch.core.job.flow.support.state.StepState.handle(StepState.java:60) at org.springframework.batch.core.job.flow.support.SimpleFlow.resume(SimpleFlow.java:144) at org.springframework.batch.core.job.flow.support.SimpleFlow.start(SimpleFlow.java:124) at org.springframework.batch.core.job.flow.FlowJob.doExecute(FlowJob.java:103) at org.springframework.batch.core.job.AbstractJob.execute(AbstractJob.java:250) at org.springframework.batch.core.configuration.support.ApplicationContextJobFactory$ContextClosingJob.execute(ApplicationContextJobFactory.java:96 ) at org.springframework.batch.core.launch.support.SimpleJobLauncher$1.run(SimpleJobLauncher.java:110) at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49) at org.springframework.batch.core.launch.support.SimpleJobLauncher.run(SimpleJobLauncher.java:105) at org.springframework.batch.core.launch.support.SimpleJobOperator.start(SimpleJobOperator.java:299) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198) at $Proxy36.start(Unknown Source) at org.obiba.opal.cli.client.command.JobRunningCommand.executeWithContext(JobRunningCommand.java:60) at org.obiba.opal.cli.client.command.AbstractContextLoadingCommand.execute(AbstractContextLoadingCommand.java:27) at org.obiba.opal.cli.client.AbstractCliClient.executeCommand(AbstractCliClient.java:107) at org.obiba.opal.cli.client.impl.OpalClient.main(OpalClient.java:66) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Connection.close() has already been called. Invalid operation in this stat e. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) at com.mysql.jdbc.ConnectionImpl.getMutex(ConnectionImpl.java:3018) at com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:4827) at org.enhydra.jdbc.core.CoreConnection.setAutoCommit(CoreConnection.java:234) at org.enhydra.jdbc.standard.StandardXAConnectionHandle.setAutoCommit(StandardXAConnectionHandle.java:124) at org.enhydra.jdbc.standard.StandardXAConnectionHandle.createStatement(StandardXAConnectionHandle.java:452) at org.enhydra.jdbc.standard.StandardXAConnectionHandle.createStatement(StandardXAConnectionHandle.java:425) at liquibase.database.SQLConnectionDelegate.createStatement(SQLConnectionDelegate.java:44) at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:45) ... 40 more

    JIRA | 7 years ago | Dwain Elson
    liquibase.exception.JDBCException: Error executing SQL INSERT INTO `InterviewLog` (`eventReason`, `dateTime`, `occurrence`, `actionType`, `comment`, `entit y_id`, `user`, `stage`) VALUES (NULL, '2009-10-15 13:14:40.0', 1, 'EXECUTE', NULL, '5918781446', 'ywilliams', 'Consent')
  2. 0

    I get the following error after I added the Owen Sound data to the Opal Data Base. Mississauga created the Mart with no error C:\Program Files\opal\conf>opal extract -r jdbc-extract input.file.name=file:report.xml run=5 JAVA_HOME=C:\Program Files\Java\jre6 OPAL_HOME=C:\Program Files\opal 2009-11-16 16:26:42,978 - ERROR - core.step.AbstractStep - Encountered an error executing the step liquibase.exception.JDBCException: Error executing SQL INSERT INTO `InterviewLog` (`eventReason`, `dateTime`, `occurrence`, `actionType`, `comment`, `entit y_id`, `user`, `stage`) VALUES (NULL, '2009-10-15 13:14:40.0', 1, 'EXECUTE', NULL, '5918781446', 'ywilliams', 'Consent') at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:55) at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:86) at liquibase.change.AbstractChange.execute(AbstractChange.java:247) at liquibase.change.AbstractChange.executeStatements(AbstractChange.java:93) at org.obiba.opal.jdbcmart.batch.SchemaChangeWriter.write(SchemaChangeWriter.java:82) at org.springframework.batch.core.step.item.SimpleChunkProcessor.writeItems(SimpleChunkProcessor.java:156) at org.springframework.batch.core.step.item.SimpleChunkProcessor.doWrite(SimpleChunkProcessor.java:137) at org.springframework.batch.core.step.item.SimpleChunkProcessor.write(SimpleChunkProcessor.java:252) at org.springframework.batch.core.step.item.SimpleChunkProcessor.process(SimpleChunkProcessor.java:178) at org.springframework.batch.core.step.item.ChunkOrientedTasklet.execute(ChunkOrientedTasklet.java:70) at org.springframework.batch.core.step.tasklet.TaskletStep$2.doInChunkContext(TaskletStep.java:268) at org.springframework.batch.core.scope.context.StepContextRepeatCallback.doInIteration(StepContextRepeatCallback.java:81) at org.springframework.batch.repeat.support.RepeatTemplate.getNextResult(RepeatTemplate.java:367) at org.springframework.batch.repeat.support.RepeatTemplate.executeInternal(RepeatTemplate.java:215) at org.springframework.batch.repeat.support.RepeatTemplate.iterate(RepeatTemplate.java:143) at org.springframework.batch.core.step.tasklet.TaskletStep.doExecute(TaskletStep.java:242) at org.springframework.batch.core.step.AbstractStep.execute(AbstractStep.java:198) at org.springframework.batch.core.job.AbstractJob.handleStep(AbstractJob.java:348) at org.springframework.batch.core.job.flow.FlowJob.access$0(FlowJob.java:1) at org.springframework.batch.core.job.flow.FlowJob$JobFlowExecutor.executeStep(FlowJob.java:135) at org.springframework.batch.core.job.flow.support.state.StepState.handle(StepState.java:60) at org.springframework.batch.core.job.flow.support.SimpleFlow.resume(SimpleFlow.java:144) at org.springframework.batch.core.job.flow.support.SimpleFlow.start(SimpleFlow.java:124) at org.springframework.batch.core.job.flow.FlowJob.doExecute(FlowJob.java:103) at org.springframework.batch.core.job.AbstractJob.execute(AbstractJob.java:250) at org.springframework.batch.core.configuration.support.ApplicationContextJobFactory$ContextClosingJob.execute(ApplicationContextJobFactory.java:96 ) at org.springframework.batch.core.launch.support.SimpleJobLauncher$1.run(SimpleJobLauncher.java:110) at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49) at org.springframework.batch.core.launch.support.SimpleJobLauncher.run(SimpleJobLauncher.java:105) at org.springframework.batch.core.launch.support.SimpleJobOperator.start(SimpleJobOperator.java:299) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198) at $Proxy36.start(Unknown Source) at org.obiba.opal.cli.client.command.JobRunningCommand.executeWithContext(JobRunningCommand.java:60) at org.obiba.opal.cli.client.command.AbstractContextLoadingCommand.execute(AbstractContextLoadingCommand.java:27) at org.obiba.opal.cli.client.AbstractCliClient.executeCommand(AbstractCliClient.java:107) at org.obiba.opal.cli.client.impl.OpalClient.main(OpalClient.java:66) Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Connection.close() has already been called. Invalid operation in this stat e. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.Util.getInstance(Util.java:381) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) at com.mysql.jdbc.ConnectionImpl.getMutex(ConnectionImpl.java:3018) at com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:4827) at org.enhydra.jdbc.core.CoreConnection.setAutoCommit(CoreConnection.java:234) at org.enhydra.jdbc.standard.StandardXAConnectionHandle.setAutoCommit(StandardXAConnectionHandle.java:124) at org.enhydra.jdbc.standard.StandardXAConnectionHandle.createStatement(StandardXAConnectionHandle.java:452) at org.enhydra.jdbc.standard.StandardXAConnectionHandle.createStatement(StandardXAConnectionHandle.java:425) at liquibase.database.SQLConnectionDelegate.createStatement(SQLConnectionDelegate.java:44) at liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:45) ... 40 more

    JIRA | 7 years ago | Dwain Elson
    liquibase.exception.JDBCException: Error executing SQL INSERT INTO `InterviewLog` (`eventReason`, `dateTime`, `occurrence`, `actionType`, `comment`, `entit y_id`, `user`, `stage`) VALUES (NULL, '2009-10-15 13:14:40.0', 1, 'EXECUTE', NULL, '5918781446', 'ywilliams', 'Consent')
  3. 0

    [CONF-37360] Post-Upgrade Recovery File Generation Results in OOM If Size of BodyContent Is Really Large - Atlassian JIRA

    atlassian.com | 2 years ago
    com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Connection timed out using dbcp 2

    Stack Overflow | 1 year ago | Poulami Bhattacharyya
    com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Connection.close() has already been called. Invalid operation in this state.
  6. 0

    [CONF-37360] Post-Upgrade Recovery File Generation Results in OOM If Size of BodyContent Is Really Large - Atlassian JIRA

    atlassian.com | 1 year ago
    com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
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.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException

    Connection.close() has already been called. Invalid operation in this stat e.

    at sun.reflect.NativeConstructorAccessorImpl.newInstance0()
  2. Java RT
    Constructor.newInstance
    1. sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2. sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    3. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    4. java.lang.reflect.Constructor.newInstance(Unknown Source)
    4 frames
  3. MySQL jdbc
    ConnectionImpl.setAutoCommit
    1. com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
    2. com.mysql.jdbc.Util.getInstance(Util.java:381)
    3. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
    4. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
    5. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
    6. com.mysql.jdbc.ConnectionImpl.getMutex(ConnectionImpl.java:3018)
    7. com.mysql.jdbc.ConnectionImpl.setAutoCommit(ConnectionImpl.java:4827)
    7 frames
  4. XAPool
    StandardXAConnectionHandle.createStatement
    1. org.enhydra.jdbc.core.CoreConnection.setAutoCommit(CoreConnection.java:234)
    2. org.enhydra.jdbc.standard.StandardXAConnectionHandle.setAutoCommit(StandardXAConnectionHandle.java:124)
    3. org.enhydra.jdbc.standard.StandardXAConnectionHandle.createStatement(StandardXAConnectionHandle.java:452)
    4. org.enhydra.jdbc.standard.StandardXAConnectionHandle.createStatement(StandardXAConnectionHandle.java:425)
    4 frames
  5. Liquibase Core
    SQLConnectionDelegate.createStatement
    1. liquibase.database.SQLConnectionDelegate.createStatement(SQLConnectionDelegate.java:44)
    1 frame
  6. liquibase.database.template
    JdbcTemplate.execute
    1. liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:45)
    2. liquibase.database.template.JdbcTemplate.execute(JdbcTemplate.java:86)
    2 frames
  7. Liquibase Core
    AbstractChange.executeStatements
    1. liquibase.change.AbstractChange.execute(AbstractChange.java:247)
    2. liquibase.change.AbstractChange.executeStatements(AbstractChange.java:93)
    2 frames
  8. org.obiba.opal
    SchemaChangeWriter.write
    1. org.obiba.opal.jdbcmart.batch.SchemaChangeWriter.write(SchemaChangeWriter.java:82)
    1 frame
  9. Spring Batch Core
    StepContextRepeatCallback.doInIteration
    1. org.springframework.batch.core.step.item.SimpleChunkProcessor.writeItems(SimpleChunkProcessor.java:156)
    2. org.springframework.batch.core.step.item.SimpleChunkProcessor.doWrite(SimpleChunkProcessor.java:137)
    3. org.springframework.batch.core.step.item.SimpleChunkProcessor.write(SimpleChunkProcessor.java:252)
    4. org.springframework.batch.core.step.item.SimpleChunkProcessor.process(SimpleChunkProcessor.java:178)
    5. org.springframework.batch.core.step.item.ChunkOrientedTasklet.execute(ChunkOrientedTasklet.java:70)
    6. org.springframework.batch.core.step.tasklet.TaskletStep$2.doInChunkContext(TaskletStep.java:268)
    7. org.springframework.batch.core.scope.context.StepContextRepeatCallback.doInIteration(StepContextRepeatCallback.java:81)
    7 frames
  10. Spring Batch Infrastructure
    RepeatTemplate.iterate
    1. org.springframework.batch.repeat.support.RepeatTemplate.getNextResult(RepeatTemplate.java:367)
    2. org.springframework.batch.repeat.support.RepeatTemplate.executeInternal(RepeatTemplate.java:215)
    3. org.springframework.batch.repeat.support.RepeatTemplate.iterate(RepeatTemplate.java:143)
    3 frames
  11. Spring Batch Core
    SimpleJobLauncher$1.run
    1. org.springframework.batch.core.step.tasklet.TaskletStep.doExecute(TaskletStep.java:242)
    2. org.springframework.batch.core.step.AbstractStep.execute(AbstractStep.java:198)
    3. org.springframework.batch.core.job.AbstractJob.handleStep(AbstractJob.java:348)
    4. org.springframework.batch.core.job.flow.FlowJob.access$0(FlowJob.java:1)
    5. org.springframework.batch.core.job.flow.FlowJob$JobFlowExecutor.executeStep(FlowJob.java:135)
    6. org.springframework.batch.core.job.flow.support.state.StepState.handle(StepState.java:60)
    7. org.springframework.batch.core.job.flow.support.SimpleFlow.resume(SimpleFlow.java:144)
    8. org.springframework.batch.core.job.flow.support.SimpleFlow.start(SimpleFlow.java:124)
    9. org.springframework.batch.core.job.flow.FlowJob.doExecute(FlowJob.java:103)
    10. org.springframework.batch.core.job.AbstractJob.execute(AbstractJob.java:250)
    11. org.springframework.batch.core.configuration.support.ApplicationContextJobFactory$ContextClosingJob.execute(ApplicationContextJobFactory.java:96)
    12. org.springframework.batch.core.launch.support.SimpleJobLauncher$1.run(SimpleJobLauncher.java:110)
    12 frames
  12. Spring Core
    SyncTaskExecutor.execute
    1. org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)
    1 frame
  13. Spring Batch Core
    SimpleJobOperator.start
    1. org.springframework.batch.core.launch.support.SimpleJobLauncher.run(SimpleJobLauncher.java:105)
    2. org.springframework.batch.core.launch.support.SimpleJobOperator.start(SimpleJobOperator.java:299)
    2 frames
  14. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    4. java.lang.reflect.Method.invoke(Unknown Source)
    4 frames
  15. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
    2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:198)
    2 frames
  16. Unknown
    $Proxy36.start
    1. $Proxy36.start(Unknown Source)
    1 frame
  17. org.obiba.opal
    OpalClient.main
    1. org.obiba.opal.cli.client.command.JobRunningCommand.executeWithContext(JobRunningCommand.java:60)
    2. org.obiba.opal.cli.client.command.AbstractContextLoadingCommand.execute(AbstractContextLoadingCommand.java:27)
    3. org.obiba.opal.cli.client.AbstractCliClient.executeCommand(AbstractCliClient.java:107)
    4. org.obiba.opal.cli.client.impl.OpalClient.main(OpalClient.java:66)
    4 frames