org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.jdbc.datasource.init.DataSourceInitializer#0': Invocation of init method failed; nested exception is org.springframework.dao.DataAccessResourceFailureException: Failed to populate database; nested exception is org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement at line 1 of resource class path resource [db/create-db.txt]: CREATE TABLE FIELD (  fieldID INT PRIMARY KEY,  name VARCHAR(200),  type VARCHAR(200) )

hsqldb | negroscuro | 4 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

    HSQL (in memmory) creation probelm

    hsqldb | 4 years ago | negroscuro
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.jdbc.datasource.init.DataSourceInitializer#0': Invocation of init method failed; nested exception is org.springframework.dao.DataAccessResourceFailureException: Failed to populate database; nested exception is org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement at line 1 of resource class path resource [db/create-db.txt]: CREATE TABLE FIELD (  fieldID INT PRIMARY KEY,  name VARCHAR(200),  type VARCHAR(200) )
  2. 0

    HSQL in memmory, creation database problem (JDBC and Relational Databases forum at Coderanch)

    coderanch.com | 9 months ago
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.springframework.jdbc.datasource.init.DataSourceInitializer#0': Invocation of init method failed; nested exception is org.springframework.dao.DataAccessResourceFailureException: Failed to populate database; nested exception is org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement at line 1 of resource class path resource [db/create-db.txt]: CREATE TABLE FIELD ( fieldID INT PRIMARY KEY, name VARCHAR(200), type VARCHAR(200) )
  3. 0

    Create a stored procedure in HSQLDB with Spring embedded databases API

    Stack Overflow | 5 years ago | Marc Carré
    java.sql.SQLSyntaxErrorException: unexpected end of statement: required: ;
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Issue with Spring Embedded database and stored procedure

    Stack Overflow | 4 years ago | Venkat Kasagani
    java.sql.SQLSyntaxErrorException: unexpected token: OR
  6. 0

    Client will not start. | StarMade

    star-made.org | 1 year ago
    java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: PUBLIC.ENTITIES

    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.SQLSyntaxErrorException

      nombre del objeto ya existe: FIELD in statement [CREATE TABLE FIELD (  fieldID INT PRIMARY KEY,  name VARCHAR(200),  type VARCHAR(200) )]

      at org.hsqldb.jdbc.Util.sqlException()
    2. HSQLDB
      JDBCStatement.executeUpdate
      1. org.hsqldb.jdbc.Util.sqlException(Unknown Source)
      2. org.hsqldb.jdbc.Util.sqlException(Unknown Source)
      3. org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
      4. org.hsqldb.jdbc.JDBCStatement.executeUpdate(Unknown Source)
      4 frames
    3. org.springframework.jdbc
      DataSourceInitializer.afterPropertiesSet
      1. org.springframework.jdbc.datasource.init.ResourceDatabasePopulator.executeSqlScript(ResourceDatabasePopulator.java:169)
      2. org.springframework.jdbc.datasource.init.ResourceDatabasePopulator.populate(ResourceDatabasePopulator.java:120)
      3. org.springframework.jdbc.datasource.init.DataSourceInitializer.afterPropertiesSet(DataSourceInitializer.java:80)
      3 frames
    4. Spring Beans
      DefaultListableBeanFactory.preInstantiateSingletons
      1. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1477)
      2. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1417)
      3. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
      4. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
      5. org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:291)
      6. org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
      7. org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:288)
      8. org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:190)
      9. org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:580)
      9 frames
    5. Spring Context
      AbstractApplicationContext.refresh
      1. org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:895)
      2. org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:425)
      2 frames
    6. Spring MVC
      HttpServletBean.init
      1. org.springframework.web.servlet.FrameworkServlet.createWebApplicationContext(FrameworkServlet.java:442)
      2. org.springframework.web.servlet.FrameworkServlet.createWebApplicationContext(FrameworkServlet.java:458)
      3. org.springframework.web.servlet.FrameworkServlet.initWebApplicationContext(FrameworkServlet.java:339)
      4. org.springframework.web.servlet.FrameworkServlet.initServletBean(FrameworkServlet.java:306)
      5. org.springframework.web.servlet.HttpServletBean.init(HttpServletBean.java:127)
      5 frames
    7. JavaServlet
      GenericServlet.init
      1. javax.servlet.GenericServlet.init(GenericServlet.java:212)
      1 frame
    8. Glassfish Core
      Catalina.start
      1. org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
      2. org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
      3. org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4420)
      4. org.apache.catalina.core.StandardContext.start(StandardContext.java:4733)
      5. org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
      6. org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
      7. org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
      8. org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
      9. org.apache.catalina.core.StandardService.start(StandardService.java:525)
      10. org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
      11. org.apache.catalina.startup.Catalina.start(Catalina.java:595)
      11 frames
    9. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    10. Glassfish Core
      Bootstrap.main
      1. org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
      2. org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
      2 frames