Library for Eclipse H2 development

Nils_Tolleshaug · June 30, 2022, 5:54pm

I am using Eclipse IDE 2022-6 for java programmers. I have installed Hibernate Tools for Eclipse Version: 5.4.16.v20220330-1129 and have in ClassPath Hibernate version 6.1.0.Final. Trying to set up a Java Hibernate annotation file for a H2 database and have problems finding to the needed library to be included in ClassPath.

In test program running:
// Create Session Factory
SessionFactory factory = new Configuration()
.configure(“hibernate.cfg.xml”)
.addAnnotatedClass(T131_Users.class)
.buildSessionFactory();

The line buildSessionFactory(); produce the following error message:

jun. 30, 2022 6:22:18 P.M. org.hibernate.Version logVersion
INFO: HHH000412: Hibernate ORM core version 6.1.0.Final
jun. 30, 2022 6:22:20 P.M. org.hibernate.spatial.integration.SpatialService
INFO: HHH80000001: hibernate-spatial integration enabled : true
jun. 30, 2022 6:22:20 P.M. org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
WARN: HHH10001002: Using built-in connection pool (not intended for production use)
jun. 30, 2022 6:22:20 P.M. org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH10001005: Loaded JDBC driver class: org.h2.Driver
jun. 30, 2022 6:22:20 P.M. org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH10001012: Connecting with JDBC URL [jdbc:h2:file:C:/Users/nils/HRE/HibernateH2]
jun. 30, 2022 6:22:20 P.M. org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH10001001: Connection properties: {password=****, user=SA}
jun. 30, 2022 6:22:20 P.M. org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH10001003: Autocommit mode: false
jun. 30, 2022 6:22:20 P.M. org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl$PooledConnections
INFO: HHH10001115: Connection pool size: 1 (min=1)
jun. 30, 2022 6:22:20 P.M. org.hibernate.engine.jdbc.dialect.internal.DialectFactoryImpl logSelectedDialect
INFO: HHH000400: Using dialect: org.hibernate.dialect.H2Dialect
jun. 30, 2022 6:22:20 P.M. org.hibernate.envers.boot.internal.EnversServiceImpl configure
INFO: Envers integration enabled? : true
jun. 30, 2022 6:22:20 P.M. org.hibernate.spatial.dialect.h2gis.H2GisDialectContributor contributeJdbcTypes
INFO: HHH80000003: hibernate-spatial adding type contributions from : org.hibernate.spatial.dialect.h2gis.H2GisDialectContributor
jun. 30, 2022 6:22:21 P.M. org.hibernate.spatial.dialect.h2gis.H2GisDialectContributor contributeFunctions
INFO: HHH80000004: hibernate-spatial adding function contributions from : org.hibernate.spatial.dialect.h2gis.H2GisDialectContributor
jun. 30, 2022 6:22:21 P.M. org.hibernate.engine.transaction.jta.platform.internal.JtaPlatformInitiator initiateService
INFO: HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform]
jun. 30, 2022 6:22:21 P.M. org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl$PoolState stop
INFO: HHH10001008: Cleaning up connection pool [jdbc:h2:file:C:/Users/nils/HRE/HibernateH2]
Exception in thread “main” org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jndi.spi.JndiService]
at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:267)
at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:230)
at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:207)
at org.hibernate.service.internal.SessionFactoryServiceRegistryImpl.getService(SessionFactoryServiceRegistryImpl.java:100)
at org.hibernate.internal.SessionFactoryImpl.(SessionFactoryImpl.java:388)
at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:415)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:754)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:773)
at hre.hibernate.test.HibernateTestHRE.main(HibernateTestHRE.java:27)
Caused by: java.lang.StringIndexOutOfBoundsException: begin 15, end 14, length 14
at java.base/java.lang.String.checkBoundsBeginEnd(String.java:4604)
at java.base/java.lang.String.substring(String.java:2707)
at java.base/java.lang.String.substring(String.java:2680)
at org.hibernate.engine.jndi.internal.JndiServiceImpl.extractJndiProperties(JndiServiceImpl.java:82)
at org.hibernate.engine.jndi.internal.JndiServiceImpl.(JndiServiceImpl.java:49)
at org.hibernate.engine.jndi.internal.JndiServiceInitiator.initiateService(JndiServiceInitiator.java:33)
at org.hibernate.engine.jndi.internal.JndiServiceInitiator.initiateService(JndiServiceInitiator.java:20)
at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:119)
at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:255)
… 8 more

Any advice appreciated

Nils

dreab8 · July 1, 2022, 10:28am

Hi @Nils_Tolleshaug ,

Can you pleas provide the content of the hibernate.cfg.xml file?

Nils_Tolleshaug · July 1, 2022, 10:41am

Thanks for the answer and my intention was to include, but had problems with editor.
The hibernate.cfg.xml:

<?xml version="1.0" encoding="UTF-8"?> org.h2.Driver jdbc:h2:file:C:/Users/nils/HRE/HibernateH2 SA http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd org.hibernate.dialect.H2Dialect 1 hre.hibernate.annotation.T131_Users HRE-Annotation

I suspect I have a problem with the “hibernate.jndi” setting?

Here is also the Java annotation file:
package hre.hibernate.annotation;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;

import org.antlr.v4.runtime.misc.NotNull;

/**
 * @author NTo
 * CREATE TABLE T131_USERS(
	PID BIGINT NOT NULL,
	CL_COMMIT_RPID BIGINT NOT NULL,
	LOGON_NAME VARCHAR(100) NOT NULL,
	USER_NAME VARCHAR(100) NOT NULL,
	PASSWORD VARCHAR(100) NOT NULL,
	EMAIL VARCHAR(100) NOT NULL,
	USER_GROUP_RPID BIGINT NOT NULL
	);
 */
@Entity
@Table(name="T131_USERS")
public class T131_Users {
	
    long proOffset = 1000000000000000L;
    long null_RPID  = 1999999999999999L;

	@Id
	@GeneratedValue(strategy=GenerationType.IDENTITY)
	@Column(name="PID")
	@NotNull
	private long pid;
	
	@Column(name="CL_COMMIT_RPID")
	@NotNull
	private long clCommit;
	
	@Column(name="LOGON_NAME")
	@NotNull
	private String logonName;
	
	@Column(name="USER_NAME")
	@NotNull
	private String userName;
	
	@Column(name="PASSWORD")
	@NotNull
	private String password;
	
	@Column(name="EMAIL")
	@NotNull
	private String email;
	
	@Column(name="USER_GROUP_RPID")
	@NotNull
	private long userGroupRPID;
	
	public T131_Users() {
		System.out.println("T131_Users constructor");
	}

	public T131_Users(String logonName, String userName, String password, String email) {
		//super();
		this.clCommit = null_RPID;
		this.logonName = logonName;
		this.userName = userName;
		this.password = password;
		this.email = email;
		this.userGroupRPID = null_RPID;
		
	}

	public long getPid() {
		return pid;
	}

	public void setPid(long pid) {
		this.pid = pid;
	}

	public long getClCommit() {
		return clCommit;
	}

	public void setClCommit(long clCommit) {
		this.clCommit = clCommit;
	}

	public String getLogonName() {
		return logonName;
	}

	public void setLogonName(String logonName) {
		this.logonName = logonName;
	}

	public String getUserName() {
		return userName;
	}

	public void setUserName(String userName) {
		this.userName = userName;
	}

	public String getPassword() {
		return password;
	}

	public void setPassword(String password) {
		this.password = password;
	}

	public String getEmail() {
		return email;
	}

	public void setEmail(String email) {
		this.email = email;
	}

	public long getUserGroupRPID() {
		return userGroupRPID;
	}

	public void setUserGroupRPID(long userGroupRPID) {
		this.userGroupRPID = userGroupRPID;
	}

	@Override
	public String toString() {
		return "T131_Users [pid=" + pid + ", clCommit=" + clCommit + ", logonName=" + logonName + ", userName="
				+ userName + ", password=" + password + ", email=" + email + ", userGroupRPID=" + userGroupRPID + "]";
	}
}

Thanks for assistance!
Nils

Nils_Tolleshaug · July 1, 2022, 10:45am

No success with hibernate.cfg.xml:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
                                         "https://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
 <session-factory name="HRE-Hibernate">
  <property name="hibernate.connection.driver_class">org.h2.Driver</property>
  <property name="hibernate.connection.url">jdbc:h2:file:C:/Users/nils/HRE/HibernateH2</property>
  <property name="hibernate.connection.username">SA</property>
  <property name="hibernate.default_schema">http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd</property>
  <property name="hibernate.dialect">org.hibernate.dialect.H2Dialect</property>
  <property name="hibernate.connection.password"/>
  <property name="hibernate.connection.pool_size">1</property>
  <property name="hibernate.jndi.class">hre.hibernate.annotation.T131_Users</property>
  <property name="hibernate.jndi">HRE-Annotation</property>
 </session-factory>
</hibernate-configuration>

I suspect I have a problem with the “hibernate.jndi” setting?

Any advice appreciated.

Rgs Nils

dreab8 · July 1, 2022, 11:17am

not sure why you want to specify a hibernate.jndi.class but as specified in the doc 8. JNDI | hibernate it should name the javax.naming.InitialContext implementation class to use. See javax.naming.Context#INITIAL_CONTEXT_FACTORY

Nils_Tolleshaug · July 1, 2022, 4:34pm

Thanks!
It was not my intention to specify hibernate.jndi.class and the following hibernate config worked:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
                                         "https://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
 <session-factory>
  <property name="hibernate.connection.driver_class">org.h2.Driver</property>
  <property name="hibernate.connection.url">jdbc:h2:file:C:/Users/nils/HRE/HibernateH2</property>
  <property name="hibernate.connection.username">SA</property>
  <property name="hibernate.default_schema">http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd</property>
  <property name="hibernate.dialect">org.hibernate.dialect.H2Dialect</property>
  <property name="hibernate.connection.password"/>
  <property name="hibernate.connection.pool_size">1</property>
  <property name="hibernate.jndi.class"></property>
 </session-factory>
</hibernate-configuration>

Now I have a new problem in the test setup:

Create newUser object!!
Begin save user object!!
Exception: Unable to locate persister: hre.hibernate.annotation.T131_Users
java.lang.IllegalArgumentException: Unable to locate persister: hre.hibernate.annotation.T131_Users
	at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:736)
	at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:717)
	at hre.hibernate.test.HibernateTestHRE.main(HibernateTestHRE.java:45)

The test program looks like this:

package hre.hibernate.test;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
import hre.hibernate.annotation.T131_Users;

public class HibernateTestHRE {
	
	public HibernateTestHRE() {		
		
	}

	public static void main(String[] args) {

		// Create Session Factory
		SessionFactory factory = new Configuration()
				.configure("hibernate.cfg.xml")
				.addAnnotatedClass(T131_Users.class)
				.buildSessionFactory(); 
		
		// Create Session
		//Session session = factory.getCurrentSession();
		Session session = factory.openSession();
		
		try {

			// Create a user object
			System.out.println("Create newUser object!!");
			T131_Users newUser = new T131_Users("NTo","Nils Tolleshaug","HRE-2021","nils@tolleshug.net");
			
			// Start a transaction
			session.beginTransaction();
			
			//Save the user Object
			System.out.println("Begin save user object!!");

			session.persist(newUser);
			//session.save(newUser);
			
			// Commit transaction
			Transaction transaction = session.beginTransaction();

			transaction.commit();
			System.out.println("Done save user!!");
			
		} catch (Exception exc) {
			System.out.println("Exception: " + exc.getMessage());
			exc.printStackTrace();
		} finally {
			factory.close();
		}
	}
}

The problem is now in: session.persist(newUser);
Maybe this is related to hibernate 6.0 that use ‘jakarta.persistence’
insted of javax.persistence.

What ‘jakarta lib’ version is now needed for hibernate 6.0 ?

Your help is highly appreciated.
Rgs Nils

dreab8 · July 14, 2022, 7:05am

Hibernate 6 is using Jakarta 3.0

Topic		Replies	Views
I have a problem about Error calling Driver # connect Hibernate ORM	0	6884	March 21, 2019
AnnotationException Hibernate ORM	2	1535	May 14, 2021
Hibernate Reverse Engineering Hibernate ORM	4	2164	August 2, 2023
Can't get Hibernate with JPA to work in Eclipse Hibernate ORM	8	3964	April 13, 2018
Hibernate-configuration-3.0.dtd not found Hibernate ORM	2	1927	July 22, 2022

Library for Eclipse H2 development

Related topics