API tools faq
paste
Guest User

Untitled

a guest
Feb 13th, 2018
126
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.81 KB | None | 0 0
raw download clone embed print report
  1. @Entity
  2. @Table(name=""USER"")
  3. public class User {
  4.  
  5. @GeneratedValue(strategy = GenerationType.IDENTITY)
  6. @Column(name= "ID", columnDefinition = "serial")
  7. @Id
  8. public Long id;
  9.  
  10. @Column(name = "FIRSTNAME")
  11. public String firstname;
  12.  
  13. @Column(name = "LASTNAME")
  14. public String lastname;
  15.  
  16. }
  17.  
  18. spring.datasource.url=jdbc:hsqldb:mem:testdb
  19. spring.datasource.username=sa
  20. spring.datasource.password=
  21. spring.datasource.driverClassName=org.hsqldb.jdbc.JDBCDriver
  22. spring.jpa.hibernate.ddl-auto=create-drop
  23. spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.PostgreSQL94Dialect
  24. spring.datasource.data=import.sql
  25.  
  26. @RunWith(SpringRunner.class)
  27. @SpringBootTest
  28. @Transactional
  29. public class UserRepositoryTest {
  30.  
  31. @PersistenceContext
  32. private EntityManager entityManager;
  33. @Autowired
  34. private UserRepository repository;
  35.  
  36. @Test
  37. public void test1() {
  38. List<User> users = repository.findAll();
  39. Assert.assertEquals(3, users.size());
  40. }
  41. }
  42.  
  43. dependencies {
  44. compile('org.springframework.boot:spring-boot-starter-data-jpa')
  45. compile('org.springframework.boot:spring-boot-starter-security')
  46. compile('org.springframework.boot:spring-boot-starter-validation')
  47. runtime('org.hsqldb:hsqldb')
  48. runtime('org.postgresql:postgresql')
  49. testCompile('org.springframework.boot:spring-boot-starter-test')
  50. testCompile('org.springframework.security:spring-security-test')
  51. }
  52.  
  53. java.lang.IllegalStateException: Failed to load ApplicationContext
  54.  
  55. at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContext(DefaultCacheAwareContextLoaderDelegate.java:124)
  56. at org.springframework.test.context.support.DefaultTestContext.getApplicationContext(DefaultTestContext.java:83)
  57. at org.springframework.test.context.support.DependencyInjectionTestExecutionListener.injectDependencies(DependencyInjectionTestExecutionListener.java:117)
  58. at org.springframework.test.context.support.DependencyInjectionTestExecutionListener.prepareTestInstance(DependencyInjectionTestExecutionListener.java:83)
  59. at org.springframework.boot.test.autoconfigure.SpringBootDependencyInjectionTestExecutionListener.prepareTestInstance(SpringBootDependencyInjectionTestExecutionListener.java:44)
  60. at org.springframework.test.context.TestContextManager.prepareTestInstance(TestContextManager.java:230)
  61. at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.createTest(SpringJUnit4ClassRunner.java:228)
  62. at org.springframework.test.context.junit4.SpringJUnit4ClassRunner$1.runReflectiveCall(SpringJUnit4ClassRunner.java:287)
  63. at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
  64. at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.methodBlock(SpringJUnit4ClassRunner.java:289)
  65. at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:247)
  66. at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:94)
  67. at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290)
  68. at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71)
  69. at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288)
  70. at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58)
  71. at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268)
  72. at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)
  73. at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70)
  74. at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
  75. at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:191)
  76. at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
  77. at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)
  78. at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)
  79. at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)
  80. at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)
  81. Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'transactionManager' defined in class path resource [org/springframework/boot/autoconfigure/orm/jpa/HibernateJpaAutoConfiguration.class]: Initialization of bean failed; 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 class path resource [import.sql]: INSERT INTO "USER" (ID, FIRSTNAME, LASTNAME) VALUES (1, 'MARTIN', 'VOGUE'); nested exception is java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: USER
  82. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:564)
  83. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483)
  84. at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
  85. at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
  86. at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
  87. at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
  88. at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:761)
  89. at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:867)
  90. at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:543)
  91. at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:693)
  92. at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:360)
  93. at org.springframework.boot.SpringApplication.run(SpringApplication.java:303)
  94. at org.springframework.boot.test.context.SpringBootContextLoader.loadContext(SpringBootContextLoader.java:120)
  95. at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContextInternal(DefaultCacheAwareContextLoaderDelegate.java:98)
  96. at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContext(DefaultCacheAwareContextLoaderDelegate.java:116)
  97. ... 25 more
  98. Caused by: 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 class path resource [import.sql]: INSERT INTO "USER" (ID, FIRSTNAME, LASTNAME) VALUES (1, 'MARTIN', 'VOGUE'); nested exception is java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: USER
  99. at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:116)
  100. at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1634)
  101. at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:254)
  102. at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:220)
  103. at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveNamedBean(DefaultListableBeanFactory.java:1018)
  104. at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBean(DefaultListableBeanFactory.java:345)
  105. at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBean(DefaultListableBeanFactory.java:340)
  106. at org.springframework.orm.jpa.EntityManagerFactoryUtils.findEntityManagerFactory(EntityManagerFactoryUtils.java:143)
  107. at org.springframework.orm.jpa.JpaTransactionManager.setBeanFactory(JpaTransactionManager.java:292)
  108. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeAwareMethods(AbstractAutowireCapableBeanFactory.java:1647)
  109. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1615)
  110. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:555)
  111. ... 39 more
  112. Caused by: org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement #1 of class path resource [import.sql]: INSERT INTO "USER" (ID, FIRSTNAME, LASTNAME) VALUES (1, 'MARTIN', 'VOGUE'); nested exception is java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: USER
  113. at org.springframework.jdbc.datasource.init.ScriptUtils.executeSqlScript(ScriptUtils.java:491)
  114. at org.springframework.jdbc.datasource.init.ResourceDatabasePopulator.populate(ResourceDatabasePopulator.java:238)
  115. at org.springframework.jdbc.datasource.init.DatabasePopulatorUtils.execute(DatabasePopulatorUtils.java:48)
  116. at org.springframework.boot.autoconfigure.jdbc.DataSourceInitializer.runScripts(DataSourceInitializer.java:192)
  117. at org.springframework.boot.autoconfigure.jdbc.DataSourceInitializer.runDataScripts(DataSourceInitializer.java:128)
  118. at org.springframework.boot.autoconfigure.jdbc.DataSourceInitializer.onApplicationEvent(DataSourceInitializer.java:118)
  119. at org.springframework.boot.autoconfigure.jdbc.DataSourceInitializer.onApplicationEvent(DataSourceInitializer.java:51)
  120. at org.springframework.context.event.SimpleApplicationEventMulticaster.doInvokeListener(SimpleApplicationEventMulticaster.java:172)
  121. at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:165)
  122. at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:139)
  123. at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:393)
  124. at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:347)
  125. at org.springframework.boot.autoconfigure.orm.jpa.DataSourceInitializedPublisher.publishEventIfRequired(DataSourceInitializedPublisher.java:77)
  126. at org.springframework.boot.autoconfigure.orm.jpa.DataSourceInitializedPublisher.postProcessAfterInitialization(DataSourceInitializedPublisher.java:68)
  127. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsAfterInitialization(AbstractAutowireCapableBeanFactory.java:423)
  128. at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.postProcessObjectFromFactoryBean(AbstractAutowireCapableBeanFactory.java:1775)
  129. at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:113)
  130. ... 50 more
  131. Caused by: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: USER
  132. at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
  133. at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
  134. at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)
  135. at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)
  136. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  137. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  138. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  139. at java.lang.reflect.Method.invoke(Method.java:498)
  140. at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114)
  141. at com.sun.proxy.$Proxy68.execute(Unknown Source)
  142. at org.springframework.jdbc.datasource.init.ScriptUtils.executeSqlScript(ScriptUtils.java:470)
  143. ... 66 more
  144. Caused by: org.hsqldb.HsqlException: user lacks privilege or object not found: USER
  145. at org.hsqldb.error.Error.error(Unknown Source)
  146. at org.hsqldb.error.Error.error(Unknown Source)
  147. at org.hsqldb.ParserDQL.readTableName(Unknown Source)
  148. at org.hsqldb.ParserDQL.readRangeVariableForDataChange(Unknown Source)
  149. at org.hsqldb.ParserDML.compileInsertStatement(Unknown Source)
  150. at org.hsqldb.ParserCommand.compilePart(Unknown Source)
  151. at org.hsqldb.ParserCommand.compileStatements(Unknown Source)
  152. at org.hsqldb.Session.executeDirectStatement(Unknown Source)
  153. at org.hsqldb.Session.execute(Unknown Source)
  154. ... 75 more
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!