Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <persistence xmlns="http://java.sun.com/xml/ns/persistence"
- xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
- xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence" version="1.0">
- <persistence-unit name="think" transaction-type="RESOURCE_LOCAL">
- <properties>
- <property name="hibernate.dialect" value="org.hibernate.dialect.HSQLDialect"/>
- <property name="hibernate.hbm2ddl.auto" value="update"/>
- <property name="hibernate.connection.driver_class" value="org.hsqldb.jdbcDriver"/>
- <property name="hibernate.connection.username" value="sa"/>
- <property name="hibernate.connection.password" value=""/>
- <property name="hibernate.connection.url" value="jdbc:hsqldb:file:data/db/db;shutdown=true;hsqldb.write_delay_millis=0"/>
- </properties>
- </persistence-unit>
- </persistence>
- package Opinie2.model;
- import lombok.Data;
- import javax.persistence.*;
- @Data
- @Entity //nazwa encji
- @Table(name = "User") //w bazie taka nazwa
- public class User {
- @Column(name = "userID")
- @Id
- @GeneratedValue(strategy=GenerationType.AUTO)
- private long userID;
- @Column(name = "nickname")
- private String nickname;
- }
- package Opinie2;
- import Opinie2.model.User;
- import javax.persistence.EntityManager;
- import javax.persistence.EntityManagerFactory;
- import javax.persistence.EntityTransaction;
- import javax.persistence.Persistence;
- public class App {
- public static void main(String[] args) throws Exception {
- System.out.println("hello world");
- //EntityManager em = Persistence.createEntityManagerFactory("zaraza").createEntityManager();
- EntityManagerFactory emf = Persistence.createEntityManagerFactory("think");
- EntityManager em = emf.createEntityManager();
- if (em != null) {
- System.out.println("************* EntityManager is obtained *****************");
- User user = new User();
- user.setNickname("dupa3");
- System.out.println("co ja wprowadzilem" + user);
- EntityTransaction tx = em.getTransaction();
- tx.begin();
- //em.persist(user);
- System.out.println(em.find(User.class,(long)1));
- //Save
- tx.commit();
- em.close();
- emf.close();
- }
- }
- }
- WARN: GenerationTarget encountered exception accepting command : Error executing DDL via JDBC Statement
- org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL via JDBC Statement
- at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
- at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:524)
- at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:470)
- at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.createTable(AbstractSchemaMigrator.java:273)
- at org.hibernate.tool.schema.internal.GroupedSchemaMigratorImpl.performTablesMigration(GroupedSchemaMigratorImpl.java:71)
- at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:203)
- at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:110)
- at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
- at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
- at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:309)
- at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:445)
- at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:889)
- at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:58)
- at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:55)
- at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:39)
- at Opinie2.App.main(App.java:19)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:498)
- at com.intellij.rt.execution.application.AppMain.main(AppMain.java:147)
- Caused by: java.sql.SQLException: Table already exists: USER in statement [create table User]
- at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
- at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
- at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source)
- at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
- ... 20 more
- ************* EntityManager is obtained *****************
- co ja wprowadzilemUser(userID=0, nickname=dupa3)
- null
- lis 27, 2016 2:30:55 AM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl stop
- INFO: HHH10001008: Cleaning up connection pool [jdbc:hsqldb:file:data/db/db;shutdown=true;hsqldb.write_delay_millis=0]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement