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
  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 | 3 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 | 2 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 | 2 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