com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'spring_batch_tutorial.batch_job_execution_params' doesn't exist

  1. 0

    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'spring_batch_tutorial.batch_job_execution_params' doesn't exist - Spring Batch

    Stack Overflow | 3 months ago | javatechnology
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'spring_batch_tutorial.batch_job_execution_params' doesn't exist
  2. 0

    Reindexing fails when an entity has multiple references to the same categorical

    GitHub | 2 years ago | tommydeboer
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Not unique table/alias: 'diagnosis_code'
  3. 0

    Automatic reindexing fails

    GitHub | 2 years ago | erwinwinder
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'this.xcomputedxref' in 'field list'
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    JDBC error: Unknown column 'product0_.active' in 'field list'

    GitHub | 2 years ago | rhodebump
    org.quartz.JobExecutionException: org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select product0_.id as id19_, product0_.version as version19_, product0_.active as active19_, product0_.brand_name as brand4_19_, product0_.category_id as category5_19_, product0_.cold_chain as cold6_19_, product0_.controlled_substance as controlled7_19_, product0_.created_by_id as created8_19_, product0_.date_created as date9_19_, product0_.default_uom_id as default10_19_, product0_.description as descrip11_19_, product0_.essential as essential19_, product0_.hazardous_material as hazardous13_19_, product0_.last_updated as last14_19_, product0_.lot_control as lot15_19_, product0_.manufacturer as manufac16_19_, product0_.manufacturer_code as manufac17_19_, product0_.manufacturer_name as manufac18_19_, product0_.model_number as model19_19_, product0_.name as name19_, product0_.ndc as ndc19_, product0_.package_size as package22_19_, product0_.price_per_unit as price23_19_, product0_.product_code as product24_19_, product0_.reconditioned as recondi25_19_, product0_.serialized as serialized19_, product0_.unit_of_measure as unit27_19_, product0_.upc as upc19_, product0_.updated_by_id as updated29_19_, product0_.vendor as vendor19_, product0_.vendor_code as vendor31_19_, product0_.vendor_name as vendor32_19_ from product product0_ where product0_.product_code is null or product0_.product_code='']; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query [See nested exception: org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute query; SQL [select product0_.id as id19_, product0_.version as version19_, product0_.active as active19_, product0_.brand_name as brand4_19_, product0_.category_id as category5_19_, product0_.cold_chain as cold6_19_, product0_.controlled_substance as controlled7_19_, product0_.created_by_id as created8_19_, product0_.date_created as date9_19_, product0_.default_uom_id as default10_19_, product0_.description as descrip11_19_, product0_.essential as essential19_, product0_.hazardous_material as hazardous13_19_, product0_.last_updated as last14_19_, product0_.lot_control as lot15_19_, product0_.manufacturer as manufac16_19_, product0_.manufacturer_code as manufac17_19_, product0_.manufacturer_name as manufac18_19_, product0_.model_number as model19_19_, product0_.name as name19_, product0_.ndc as ndc19_, product0_.package_size as package22_19_, product0_.price_per_unit as price23_19_, product0_.product_code as product24_19_, product0_.reconditioned as recondi25_19_, product0_.serialized as serialized19_, product0_.unit_of_measure as unit27_19_, product0_.upc as upc19_, product0_.updated_by_id as updated29_19_, product0_.vendor as vendor19_, product0_.vendor_code as vendor31_19_, product0_.vendor_name as vendor32_19_ from product product0_ where product0_.product_code is null or product0_.product_code='']; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query]
  6. 0

    print all exception locations in java

    Stack Overflow | 4 years ago | p00ya00
    org.hibernate.exception.SQLGrammarException: could not execute query
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.MySQLSyntaxErrorException

    Table 'spring_batch_tutorial.batch_job_execution_params' doesn't exist

    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
    PreparedStatement.executeQuery
    1. com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
    2. com.mysql.jdbc.Util.getInstance(Util.java:387)
    3. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:942)
    4. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3966)
    5. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902)
    6. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2526)
    7. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2673)
    8. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2549)
    9. com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
    10. com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1962)
    10 frames
  4. c3p0:JDBC DataSources/Resource Pools
    NewProxyPreparedStatement.executeQuery
    1. com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:1392)
    1 frame
  5. Spring Framework
    JdbcTemplate.query
    1. org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:692)
    2. org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:633)
    3. org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:684)
    4. org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:716)
    5. org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:741)
    6. org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:751)
    6 frames
  6. Spring Batch Core
    JdbcJobExecutionDao$JobExecutionRowMapper.mapRow
    1. org.springframework.batch.core.repository.dao.JdbcJobExecutionDao.getJobParameters(JdbcJobExecutionDao.java:385)
    2. org.springframework.batch.core.repository.dao.JdbcJobExecutionDao$JobExecutionRowMapper.mapRow(JdbcJobExecutionDao.java:415)
    3. org.springframework.batch.core.repository.dao.JdbcJobExecutionDao$JobExecutionRowMapper.mapRow(JdbcJobExecutionDao.java:396)
    3 frames
  7. Spring Framework
    JdbcTemplate.query
    1. org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:93)
    2. org.springframework.jdbc.core.RowMapperResultSetExtractor.extractData(RowMapperResultSetExtractor.java:60)
    3. org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:697)
    4. org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:633)
    5. org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:684)
    6. org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:716)
    7. org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:726)
    8. org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:781)
    8 frames
  8. Spring Batch Core
    SimpleJobRepository.getStepExecutionCount
    1. org.springframework.batch.core.repository.dao.JdbcJobExecutionDao.findJobExecutions(JdbcJobExecutionDao.java:131)
    2. org.springframework.batch.core.repository.support.SimpleJobRepository.getStepExecutionCount(SimpleJobRepository.java:253)
    2 frames
  9. 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
  10. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
    3 frames
  11. Spring Tx
    TransactionInterceptor.invoke
    1. org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
    2. org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
    3. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
    3 frames
  12. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
    2 frames
  13. com.sun.proxy
    $Proxy28.getStepExecutionCount
    1. com.sun.proxy.$Proxy28.getStepExecutionCount(Unknown Source)
    1 frame
  14. Spring Batch Core
    SimpleJobLauncher$1.run
    1. org.springframework.batch.core.job.flow.JobFlowExecutor.isStepRestart(JobFlowExecutor.java:82)
    2. org.springframework.batch.core.job.flow.JobFlowExecutor.executeStep(JobFlowExecutor.java:63)
    3. org.springframework.batch.core.job.flow.support.state.StepState.handle(StepState.java:67)
    4. org.springframework.batch.core.job.flow.support.SimpleFlow.resume(SimpleFlow.java:169)
    5. org.springframework.batch.core.job.flow.support.SimpleFlow.start(SimpleFlow.java:144)
    6. org.springframework.batch.core.job.flow.FlowJob.doExecute(FlowJob.java:134)
    7. org.springframework.batch.core.job.AbstractJob.execute(AbstractJob.java:306)
    8. org.springframework.batch.core.launch.support.SimpleJobLauncher$1.run(SimpleJobLauncher.java:135)
    8 frames
  15. Java RT
    Thread.run
    1. java.lang.Thread.run(Unknown Source)
    1 frame