Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.util.HashMap;
- import java.util.Map;
- import javax.persistence.EntityManager;
- import javax.persistence.EntityManagerFactory;
- import javax.persistence.Persistence;
- import javax.persistence.Column;
- import javax.persistence.Entity;
- import javax.persistence.GeneratedValue;
- import javax.persistence.GenerationType;
- import javax.persistence.Id;
- @Entity
- public class TestEntity {
- @Id
- @GeneratedValue(strategy = GenerationType.TABLE)
- private Long id;
- @Column public String name = "";
- public TestEntity() { }
- }
- public class TestWhyNotUnlockDatabase {
- public static void main(String[] args) throws Exception {
- Map<String, String> connProp = new HashMap<String,String>();
- connProp.put("javax.persistence.jdbc.url","jdbc:hsqldb:file:\Users\Bernd\.mld\0.2\solala.db");
- connProp.put("javax.persistence.schema-generation.database.action", "none");
- System.out.println("Creating DB");
- EntityManagerFactory entityManagerFactory = Persistence.createEntityManagerFactory("WhyNotUnLock",connProp);
- EntityManager entityManager = entityManagerFactory.createEntityManager();
- System.out.println("persisting");
- entityManager.getTransaction().begin();
- entityManager.persist(new TestEntity());
- entityManager.getTransaction().commit();
- System.out.println("closing");
- entityManager.clear();
- entityManager.close();
- entityManagerFactory.close();
- System.out.println("DB closed");
- }
- }
- Creating DB
- WARN 2017-02-36 12:59:29 [main] org.hibernate.orm.connections.pooling - HHH10001002: Using Hibernate built-in connection pool (not for production use!)
- persisting
- closing
- DB closed
- <persistence-unit name="WhyNotUnLock" transaction-type="RESOURCE_LOCAL">
- <provider>org.hibernate.jpa.HibernatePersistenceProvider</provider>
- <class>masterlist.trials.TestEntity</class>
- <exclude-unlisted-classes>true</exclude-unlisted-classes>
- <properties>
- <property name="javax.persistence.jdbc.driver" value="org.hsqldb.jdbcDriver" />
- <property name="connection.provider_class" value="org.hibernate.connection.C3P0ConnectionProvider" />
- <property name="javax.persistence.jdbc.user" value="SA" />
- <property name="javax.persistence.jdbc.password" value="" />
- <property name="javax.persistence.jdbc.url" value="jdbc:hsqldb:file://C:\Users\Bernd\.mld\0.1\smallDB.db"/>
- <property name="hibernate.dialect" value="org.hibernate.dialect.HSQLDialect" />
- <property name="hibernate.max_fetch_depth" value="3" />
- <property name="hibernate.hbm2ddl.auto" value="validate" />
- <property name="hibernate.max_fetch_depth" value="3" />
- <property name="hibernate.hbm2ddl.auto" value="create" />
- <!-- Echo all executed SQL to stdout -->
- <property name="hibernate.show_sql" value="false" />
- <property name="javax.persistence.schema-generation.database.action" value="none"/>
- </properties>
- </persistence-unit>
- compile group: 'org.hibernate', name: 'hibernate-core', version: '5.2.6.Final'
- compile group: 'org.hibernate', name: 'hibernate-ehcache', version: '5.2.6.Final'
- compile group: 'org.hibernate', name: 'hibernate-validator', version: '5.4.0.CR1'
- compile 'org.hibernate.javax.persistence:hibernate-jpa-2.1-api:1.0.0.Final'
- compile group: 'org.hibernate', name: 'hibernate-c3p0', version: '5.2.6.Final'
- compile 'com.enigmabridge:hibernate4-sqlite-dialect:0.1.2'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement