org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'equityHoldingsDAO' defined in class path resource \[EquityHoldings-beans.xml\]: Cannot resolve reference to bean 'hsqlDataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hsqlDataSource': FactoryBean threw exception on object creation; nested exception is java.lang.RuntimeException: SQL exception occurred exporting database schema

hsqldb | flame23 | 9 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

    Create table statement being truncated

    hsqldb | 9 years ago | flame23
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'equityHoldingsDAO' defined in class path resource \[EquityHoldings-beans.xml\]: Cannot resolve reference to bean 'hsqlDataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'hsqlDataSource': FactoryBean threw exception on object creation; nested exception is java.lang.RuntimeException: SQL exception occurred exporting database schema
  2. 0

    Got the following error on db start up.

    GitHub | 2 years ago | sztankatt
    java.sql.SQLException: Unexpected token: SEARCHNAME in statement [CREATE TABLE savedsearches ( id INTEGER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY searchName]
  3. 0

    How to set user classpath precedence when not a mapreduce job?

    Stack Overflow | 4 years ago | user2708246
    java.sql.SQLException: Unexpected token AS, requires ( in statement [create table click as]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    HSQL - Unexpected token: PROCEDURE in statement

    Stack Overflow | 3 years ago | emeraldjava
    org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement at line 19 of resource class path resource [hsql/attribution-hsqldb.sql]: CREATE PROCEDURE policy_Attribution(p_valDate Date) MODIFIES SQL DATA BEGIN ATOMIC CREATE TABLE #retvals ( Policy_ID INT, Attribution_Name CHAR(64), Attribution_Type CHAR(20), Risk CHAR(20), Revenue FLOAT, Claims FLOAT ) INSERT INTO #retvals VALUES (1, 'name', 'type', 'risk', 1.5, 1.6) INSERT INTO #retvals VALUES (2, 'name2', 'type2', 'risk2', 0.5, 0.6) INSERT INTO #retvals VALUES (3, 'name3', 'type3', 'risk3', 2.5, 2.6) SELECT * FROM #retvals END
  6. 0

    HSQLDB and Liquibase, Table already exists: DATABASECHANGELOGLOCK

    Stack Overflow | 3 years ago | Gleeb
    java.sql.SQLException: Table already exists: DATABASECHANGELOGLOCK in statement [CREATE TABLE PUBLIC.DATABASECHANGELOGLOCK]

    3 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. java.sql.SQLException

      Unexpected token:  in statement \[ CREATE TABLE client\_reporting.CLT\_user\_GIC\_secur ( gvkey integer NOT NULL, iid varchar(5) NOT NULL, dsci varchar(20) NOT NULL, exchg int NOT NULL, isin varchar(15) NOT NULL, secstat varchar(3) NOT NULL,\]

      at org.hsqldb.jdbc.Util.sqlException()
    2. HSQLDB
      jdbcStatement.execute
      1. org.hsqldb.jdbc.Util.sqlException(Unknown Source)
      2. org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
      3. org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source)
      3 frames
    3. com.datafeeds.testutils
      TestDataSourceFactory.getObject
      1. com.datafeeds.testutils.testdb.TestDataSourceFactory$TestDatabasePopulator.executeSql(TestDataSourceFactory.java:202)
      2. com.datafeeds.testutils.testdb.TestDataSourceFactory$TestDatabasePopulator.createDatabaseSchema(TestDataSourceFactory.java:163)
      3. com.datafeeds.testutils.testdb.TestDataSourceFactory$TestDatabasePopulator.populate(TestDataSourceFactory.java:145)
      4. com.datafeeds.testutils.testdb.TestDataSourceFactory.populateDataSource(TestDataSourceFactory.java:119)
      5. com.datafeeds.testutils.testdb.TestDataSourceFactory.initDataSource(TestDataSourceFactory.java:97)
      6. com.datafeeds.testutils.testdb.TestDataSourceFactory.getObject(TestDataSourceFactory.java:74)
      6 frames
    4. Spring Beans
      AbstractBeanFactory$3.run
      1. org.springframework.beans.factory.support.AbstractBeanFactory$3.run(AbstractBeanFactory.java:1304)
      1 frame
    5. Java RT
      AccessController.doPrivileged
      1. java.security.AccessController.doPrivileged(Native Method)
      1 frame
    6. Spring Beans
      AbstractAutowireCapableBeanFactory$1.run
      1. org.springframework.beans.factory.support.AbstractBeanFactory.getObjectFromFactoryBean(AbstractBeanFactory.java:1299)
      2. org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1272)
      3. org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:262)
      4. org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:170)
      5. org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:268)
      6. org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
      7. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1274)
      8. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1042)
      9. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
      10. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:485)
      10 frames
    7. Java RT
      AccessController.doPrivileged
      1. java.security.AccessController.doPrivileged(Native Method)
      1 frame
    8. Spring Beans
      AbstractBeanFactory.getBean
      1. org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:455)
      2. org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:251)
      3. org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:169)
      4. org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:248)
      5. org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:170)
      5 frames
    9. com.datafeeds.equityholdings
      EquityHoldingsReaderTest.setUp
      1. com.datafeeds.equityholdings.EquityHoldingsReaderTest.setUp(EquityHoldingsReaderTest.java:46)
      1 frame
    10. JUnit
      TestSuite.run
      1. junit.framework.TestCase.runBare(TestCase.java:125)
      2. junit.framework.TestResult$1.protect(TestResult.java:106)
      3. junit.framework.TestResult.runProtected(TestResult.java:124)
      4. junit.framework.TestResult.run(TestResult.java:109)
      5. junit.framework.TestCase.run(TestCase.java:118)
      6. junit.framework.TestSuite.runTest(TestSuite.java:208)
      7. junit.framework.TestSuite.run(TestSuite.java:203)
      7 frames
    11. JUnit3 Runner
      RemoteTestRunner.main
      1. org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130)
      2. org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
      3. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
      4. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
      5. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
      6. org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
      6 frames