org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'bookingRepository': Cannot create inner bean '(inner bean)#126f8f24' of type [org.springframework.orm.jpa.SharedEntityManagerCreator] while setting bean property 'entityManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '(inner bean)#126f8f24': Cannot resolve reference to bean 'entityManagerFactory' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory': Post-processing of FactoryBean's singleton object failed; nested exception is org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement #1 of URL [file:/C:/Users/Naveen/Documents/workspace-sts-3.8.0.RELEASE/BookingManagement/target/classes/data.sql]: insert into booking(booking_name) values("Chris"); nested exception is org.h2.jdbc.JdbcSQLException: Column "Chris" not found; SQL statement: insert into booking(booking_name) values("Chris") [42122-192]

  1. 0

    Spring boot application is failing to insert data

    Stack Overflow | 4 months ago | Hadrian Blackwater
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'bookingRepository': Cannot create inner bean '(inner bean)#126f8f24' of type [org.springframework.orm.jpa.SharedEntityManagerCreator] while setting bean property 'entityManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '(inner bean)#126f8f24': Cannot resolve reference to bean 'entityManagerFactory' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory': Post-processing of FactoryBean's singleton object failed; nested exception is org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement #1 of URL [file:/C:/Users/Naveen/Documents/workspace-sts-3.8.0.RELEASE/BookingManagement/target/classes/data.sql]: insert into booking(booking_name) values("Chris"); nested exception is org.h2.jdbc.JdbcSQLException: Column "Chris" not found; SQL statement: insert into booking(booking_name) values("Chris") [42122-192]
  2. 0

    Spring and Hibernate Database Tables Relationship Issues

    Stack Overflow | 5 months ago | Eddy Freeman
    org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement at line 1 of resource class path resource [test-data.sql]: insert into contact (first_name, last_name, birth_date) values ('Chris', 'Schaefer', '1981-05-03')
  3. 0

    H2.sql missing dist_reindex tables

    GitHub | 3 years ago | wezell
    com.dotmarketing.exception.DotDataException: Table "DIST_LOCK" not found; SQL statement: select * from dist_lock for update [42102-169]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Syntax error when you try to delete the pushed asset history from maintenance

    GitHub | 2 years ago | bryanboza
    com.dotmarketing.exception.DotDataException: Syntax error in SQL statement "TRUNCATE PUBLISHING_PUSHED_ASSETS[*] "; expected "TABLE"; SQL statement: TRUNCATE publishing_pushed_assets [42001-176]
  6. 0

    dbColumnName problem in Mapper, schemify, CRUDify in 1.1-M6 and 1.1-SHAPSHOT

    GitHub | 7 years ago | econoplas
    org.h2.jdbc.JdbcSQLException: Duplicate column name ACTIVE; SQL statement: ---> ALTER TABLE PROJECT_TYPE ADD COLUMN ACTIVE BOOLEAN [42121-121]
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. org.h2.jdbc.JdbcSQLException

    Column "Chris" not found; SQL statement: insert into booking(booking_name) values("Chris") [42122-192]

    at org.h2.message.DbException.getJdbcSQLException()
  2. H2 Database Engine
    JdbcStatement.execute
    1. org.h2.message.DbException.getJdbcSQLException(DbException.java:345)[h2-1.4.192.jar:1.4.192]
    2. org.h2.message.DbException.get(DbException.java:179)[h2-1.4.192.jar:1.4.192]
    3. org.h2.message.DbException.get(DbException.java:155)[h2-1.4.192.jar:1.4.192]
    4. org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:147)[h2-1.4.192.jar:1.4.192]
    5. org.h2.command.dml.Insert.prepare(Insert.java:270)[h2-1.4.192.jar:1.4.192]
    6. org.h2.command.Parser.prepareCommand(Parser.java:259)[h2-1.4.192.jar:1.4.192]
    7. org.h2.engine.Session.prepareLocal(Session.java:560)[h2-1.4.192.jar:1.4.192]
    8. org.h2.engine.Session.prepareCommand(Session.java:501)[h2-1.4.192.jar:1.4.192]
    9. org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1202)[h2-1.4.192.jar:1.4.192]
    10. org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:170)[h2-1.4.192.jar:1.4.192]
    11. org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:158)[h2-1.4.192.jar:1.4.192]
    11 frames
  3. org.springframework.jdbc
    DatabasePopulatorUtils.execute
    1. org.springframework.jdbc.datasource.init.ScriptUtils.executeSqlScript(ScriptUtils.java:473)[spring-jdbc-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    2. org.springframework.jdbc.datasource.init.ResourceDatabasePopulator.populate(ResourceDatabasePopulator.java:231)[spring-jdbc-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    3. org.springframework.jdbc.datasource.init.DatabasePopulatorUtils.execute(DatabasePopulatorUtils.java:48)[spring-jdbc-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    3 frames
  4. Spring Boot AutoConfigure
    DataSourceInitializer.onApplicationEvent
    1. org.springframework.boot.autoconfigure.jdbc.DataSourceInitializer.runScripts(DataSourceInitializer.java:169)[spring-boot-autoconfigure-1.4.0.RC1.jar:1.4.0.RC1]
    2. org.springframework.boot.autoconfigure.jdbc.DataSourceInitializer.runDataScripts(DataSourceInitializer.java:119)[spring-boot-autoconfigure-1.4.0.RC1.jar:1.4.0.RC1]
    3. org.springframework.boot.autoconfigure.jdbc.DataSourceInitializer.onApplicationEvent(DataSourceInitializer.java:110)[spring-boot-autoconfigure-1.4.0.RC1.jar:1.4.0.RC1]
    4. org.springframework.boot.autoconfigure.jdbc.DataSourceInitializer.onApplicationEvent(DataSourceInitializer.java:48)[spring-boot-autoconfigure-1.4.0.RC1.jar:1.4.0.RC1]
    4 frames
  5. Spring Context
    AbstractApplicationContext.publishEvent
    1. org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:166)[spring-context-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    2. org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:138)[spring-context-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    3. org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:382)[spring-context-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    4. org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:336)[spring-context-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    4 frames
  6. Spring Boot AutoConfigure
    DataSourceInitializedPublisher.postProcessAfterInitialization
    1. org.springframework.boot.autoconfigure.orm.jpa.DataSourceInitializedPublisher.postProcessAfterInitialization(DataSourceInitializedPublisher.java:70)[spring-boot-autoconfigure-1.4.0.RC1.jar:1.4.0.RC1]
    1 frame
  7. Spring Beans
    DefaultListableBeanFactory.preInstantiateSingletons
    1. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsAfterInitialization(AbstractAutowireCapableBeanFactory.java:422)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    2. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.postProcessObjectFromFactoryBean(AbstractAutowireCapableBeanFactory.java:1723)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    3. org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:113)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    4. org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1600)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    5. org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:254)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    6. org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    7. org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    8. org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    9. org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:634)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    10. org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:448)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    11. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1123)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    12. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1018)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    13. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:510)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    14. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    15. org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveInnerBean(BeanDefinitionValueResolver.java:299)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    16. org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:129)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    17. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1481)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    18. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1226)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    19. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    20. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    21. org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    22. org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    23. org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    24. org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    25. org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:187)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    26. org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:1213)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    27. org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1053)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    28. org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1018)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    29. org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:566)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    30. org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:88)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    31. org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:349)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    32. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1214)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    33. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    34. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    35. org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    36. org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    37. org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    38. org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    39. org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:775)[spring-beans-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    39 frames
  8. Spring Context
    AbstractApplicationContext.refresh
    1. org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:861)[spring-context-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    2. org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:541)[spring-context-4.3.1.RELEASE.jar:4.3.1.RELEASE]
    2 frames
  9. Spring Boot
    SpringApplication.run
    1. org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:122)[spring-boot-1.4.0.RC1.jar:1.4.0.RC1]
    2. org.springframework.boot.SpringApplication.refresh(SpringApplication.java:759)[spring-boot-1.4.0.RC1.jar:1.4.0.RC1]
    3. org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:369)[spring-boot-1.4.0.RC1.jar:1.4.0.RC1]
    4. org.springframework.boot.SpringApplication.run(SpringApplication.java:313)[spring-boot-1.4.0.RC1.jar:1.4.0.RC1]
    5. org.springframework.boot.SpringApplication.run(SpringApplication.java:1185)[spring-boot-1.4.0.RC1.jar:1.4.0.RC1]
    6. org.springframework.boot.SpringApplication.run(SpringApplication.java:1174)[spring-boot-1.4.0.RC1.jar:1.4.0.RC1]
    6 frames
  10. com.example
    BookingManagementApplication.main
    1. com.example.BookingManagementApplication.main(BookingManagementApplication.java:20)[classes/:na]
    1 frame