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
  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 | 1 year 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.

  1. mortalman7 1 times, last 5 months ago
  2. tvrmsmith 1 times, last 3 weeks ago
  3. fima 24 times, last 2 months ago
  4. mauritius 6 times, last 2 months ago
  5. tvrmsmith 3 times, last 3 months ago
4 more registered users
38 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.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