Advertisement
Guest User

Untitled

a guest
Mar 12th, 2018
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.37 KB | None | 0 0
  1. at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.persistenceException(EntityManagerFactoryBuilderImpl.java:970)
  2. at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:895)
  3. at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:58)
  4. at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:55)
  5. at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:39)
  6. at pl.edu.polsource.HibernateTest.init(HibernateTest.java:26)
  7. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  8. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  9. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  10. at java.lang.reflect.Method.invoke(Method.java:498)
  11. at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50)
  12. at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
  13. at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47)
  14. at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:24)
  15. at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27)
  16. at org.junit.runners.ParentRunner.run(ParentRunner.java:363)
  17. at org.junit.runner.JUnitCore.run(JUnitCore.java:137)
  18. at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68)
  19. at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47)
  20. at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242)
  21. at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70)
  22. Caused by: org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation: missing sequence [hibernate_sequence]
  23. at org.hibernate.tool.schema.internal.AbstractSchemaValidator.validateSequence(AbstractSchemaValidator.java:184)
  24. at org.hibernate.tool.schema.internal.AbstractSchemaValidator.performValidation(AbstractSchemaValidator.java:100)
  25. at org.hibernate.tool.schema.internal.AbstractSchemaValidator.doValidation(AbstractSchemaValidator.java:68)
  26. at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:191)
  27. at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
  28. at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:312)
  29. at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:460)
  30. at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:892)
  31. ... 19 more
  32.  
  33. emf = Persistence.createEntityManagerFactory("persistenceUnit");
  34.  
  35. public class HibernateTest {
  36.  
  37. protected static EntityManagerFactory emf;
  38. protected static EntityManager em;
  39.  
  40. @BeforeClass
  41. public static void init() throws FileNotFoundException, SQLException {
  42. emf = Persistence.createEntityManagerFactory("persistenceUnit");
  43. em = emf.createEntityManager();
  44. }
  45.  
  46. @AfterClass
  47. public static void tearDown() {
  48. em.clear();
  49. em.close();
  50. emf.close();
  51. }
  52.  
  53. @Before
  54. public void initializeDatabase() {
  55. Session session = em.unwrap(Session.class);
  56. session.doWork(new Work() {
  57. @Override
  58. public void execute(Connection connection) throws SQLException {
  59. try {
  60. File script = new File(getClass().getResource("/data.sql").getFile());
  61. RunScript.execute(connection, new FileReader(script));
  62. } catch (FileNotFoundException e) {
  63. throw new RuntimeException("could not initialize with script");
  64. }
  65. }
  66. });
  67. }
  68. }
  69.  
  70. public class HibernateCRUDTest extends HibernateTest {
  71.  
  72. @Test
  73. public void testGetObjectById_success() {
  74. Notes note = em.find(Notes.class, 1);
  75. assertNotNull(note);
  76. }
  77.  
  78. @Test
  79. public void testGetAll_success() {
  80.  
  81. List<Notes> note = em.createNamedQuery("Notes.getAll", Notes.class).getResultList();
  82. assertEquals(4, note.size());
  83. }
  84.  
  85. @Test
  86. public void testPersist_success() {
  87. em.getTransaction().begin();
  88. em.persist(new Notes("TestTitle", "Unit Test Hibernate/JPA with in memory H2 Database"));
  89. em.getTransaction().commit();
  90. List<Notes> note = em.createNamedQuery("Notes.getAll", Notes.class).getResultList();
  91.  
  92. assertNotNull(note);
  93. assertEquals(5, note.size());
  94. }
  95.  
  96. @Test
  97. public void testDelete_success(){
  98. Notes note = em.find(Notes.class, 1);
  99.  
  100. em.getTransaction().begin();
  101. em.remove(note);
  102. em.getTransaction().commit();
  103.  
  104. List<Notes> notes = em.createNamedQuery("Notes.getAll", Notes.class).getResultList();
  105.  
  106.  
  107. assertEquals(0, notes.size());
  108. }
  109. }
  110.  
  111. <?xml version="1.0" encoding="UTF-8"?>
  112. <persistence version="2.1" xmlns="http://xmlns.jcp.org/xml/ns/persistence"
  113. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  114. xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence
  115. http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd">
  116. <persistence-unit name="persistenceUnit" transaction-type="RESOURCE_LOCAL">
  117. <provider>org.hibernate.jpa.HibernatePersistenceProvider</provider>
  118. <!-- add classes -->
  119. <class>model.Notes</class>
  120.  
  121. <properties>
  122. <!-- Configuring JDBC properties -->
  123. <!--<property name="javax.persistence.jdbc.url" value="jdbc:h2:mem:test;INIT=RUNSCRIPT FROM 'classpath:create.sql';RUNSCRIPT FROM 'classpath:data.sql'"/>-->
  124. <property name="javax.persistence.jdbc.url" value="jdbc:h2:mem:/test;INIT=RUNSCRIPT FROM 'classpath:create.sql';RUNSCRIPT FROM 'classpath:data.sql'"/>
  125. <property name="javax.persistence.jdbc.driver" value="org.h2.Driver"/>
  126.  
  127. <!-- Hibernate properties -->
  128. <property name="hibernate.dialect" value="org.hibernate.dialect.H2Dialect"/>
  129. <property name="hibernate.hbm2ddl.auto" value="validate"/>
  130. <property name="hibernate.format_sql" value="false"/>
  131. <property name="hibernate.show_sql" value="true"/>
  132.  
  133. </properties>
  134. </persistence-unit>
  135. </persistence>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement