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