why the hibernate-tools-maven-plugin 5.6.2.Final cannot read the reveng.xml

[peter tong]

I want my hibernate-tools-maven-plugin 5.6.2.Final, goal hbm2java to generate only one java class for table "UAC_USER_SSN" , but the plugin seems ignore the reveng.xml and scan all table in all schema from my oracle database, why?

My reveng.xml stored in src/main/resources with content as follow:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-reverse-engineering 
     SYSTEM "https://hibernate.org/dtd/hibernate-reverse-engineering-3.0.dtd" >

<hibernate-reverse-engineering>
  <!-- This assumes your database connection is pointing to the proper catalog -->
  <!-- To get all tables in the named schema, use the following 
       <schema-selection match-schema="PM" />
  -->
  <!--  to get only the named tables -->
  <!--  <schema-selection match-schema="dsli01" match-table="UAC_USER_SSN"/>-->
  <table-filter match-schema="dsli01" match-name="UAC_USER_SSN" /> 
   
</hibernate-reverse-engineering>

My hiberate.properties also placed in src/main/resources and with content as follow:

hibernate.dialect=org.hibernate.dialect.Oracle12cDialect
#hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver
hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver
hibernate.connection.url=jdbc:oracle:thin:@xx.xx.xx.xx:25100:dsli01.xxx.com
hibernate.connection.username=dsli01
hibernate.connection.password=xxxxxx

My pom.xml is as follow:

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>Test</groupId>
  <artifactId>Hibernate_Reveng_Maven</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <name>Hibernate Reveng Gen Java</name>
  
  <properties>
	  <project.basedir>C:/Kei/SLIS_git_eclipse_2023_09_20231115_2/Hibernate_Reveng (Not work) </project.basedir>
    <h2.version>1.4.200</h2.version>   
    
  </properties>
  
  <build>
	  <plugins>
	   	<plugin>	       
		    <groupId>org.hibernate</groupId>
		    <artifactId>hibernate-tools-maven-plugin</artifactId>
		    <version>5.6.2.Final</version>	    
		    <executions>
		          <execution>
		            <id>entity-generation</id>
		            <phase>none</phase>
		            <goals>
		              <goal>hbm2java</goal>
		            </goals>		            
		          </execution>		          
        </executions> 
        <configuration>
              <ejb3>true</ejb3>
              <revengFile>src/main/resources/reveng.xml</revengFile>
              <outputDirectory>src/main/java</outputDirectory>
        </configuration>  
        <dependencies>			
			<dependency>
			    <groupId>com.oracle.database.jdbc</groupId>
			    <artifactId>ojdbc8</artifactId>
			    <version>12.2.0.1</version>
			</dependency>
		</dependencies>     
      </plugin>      
	  </plugins>
	</build>
	
	<dependencies>	
		<dependency>	
		    <groupId>org.hibernate</groupId>
		    <artifactId>hibernate-tools-maven-plugin</artifactId>
		    <version>5.6.2.Final</version>
		</dependency>
			<!-- https://mvnrepository.com/artifact/com.oracle/ojdbc14 -->
		 <dependency>
		    <groupId>com.oracle.database.jdbc</groupId>
		    <artifactId>ojdbc8</artifactId>
		    <version>12.2.0.1</version>
		</dependency>
	</dependencies>
</project>

then I run hibernate-tools:hbm2java in eclipse run configuration, but the job scans all table in the database:

[INFO] Scanning for projects...
[INFO] 
[INFO] --------------------< Test:Hibernate_Reveng_Maven >---------------------
[INFO] Building Hibernate Reveng Gen Java 0.0.1-SNAPSHOT
[INFO]   from pom.xml
[INFO] --------------------------------[ jar ]---------------------------------
[INFO] 
[INFO] --- hibernate-tools:5.6.2.Final:hbm2java (default-cli) @ Hibernate_Reveng_Maven ---
[INFO] Starting Hbm2JavaMojo...
Mar 03, 2024 6:18:06 PM org.hibernate.cfg.reveng.OverrideRepository addFile
INFO: Override file: C:\Kei\SLIS_git_eclipse_2023_09_20231115_2\Hibernate_Reveng (Not work)\src\main\resources\reveng.xml
Mar 03, 2024 6:18:08 PM org.hibernate.Version logVersion
INFO: HHH000412: Hibernate ORM core version 5.6.1.Final
[INFO] Starting POJO export to directory: C:\Kei\SLIS_git_eclipse_2023_09_20231115_2\Hibernate_Reveng (Not work)\src\main\java...
Mar 03, 2024 6:18:08 PM org.hibernate.tool.Version <clinit>
INFO: Hibernate Tools 5.6.2.Final
Mar 03, 2024 6:18:08 PM org.hibernate.annotations.common.reflection.java.JavaReflectionManager <clinit>
INFO: HCANN000001: Hibernate Commons Annotations {5.1.2.Final}
Mar 03, 2024 6:18:08 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl configure
WARN: HHH10001002: Using Hibernate built-in connection pool (not for production use!)
Mar 03, 2024 6:18:08 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH10001005: using driver [oracle.jdbc.driver.OracleDriver] at URL [jdbc:oracle:thin:@10.9.200.58:25100:dsli01.unifysoft.com]
Mar 03, 2024 6:18:08 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH10001001: Connection properties: {password=****, user=dsli01}
Mar 03, 2024 6:18:08 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl buildCreator
INFO: HHH10001003: Autocommit mode: false
Mar 03, 2024 6:18:08 PM org.hibernate.engine.jdbc.connections.internal.DriverManagerConnectionProviderImpl$PooledConnections <init>
INFO: HHH000115: Hibernate connection pool size: 20 (min=1)
Mar 03, 2024 6:18:10 PM org.hibernate.dialect.Dialect <init>
INFO: HHH000400: Using dialect: org.hibernate.dialect.Oracle12cDialect
Mar 03, 2024 6:18:10 PM org.hibernate.resource.beans.spi.ManagedBeanRegistryInitiator resolveBeanContainer
INFO: HHH10005002: No explicit CDI BeanManager reference was passed to Hibernate, but CDI is available on the Hibernate ClassLoader.
Mar 03, 2024 6:18:11 PM org.hibernate.cfg.reveng.dialect.OracleMetaDataDialect$1 convertRow
INFO: {TABLE_CAT=null, TABLE_NAME=IND$, TABLE_SCHEM=SYS, TABLE_TYPE=TABLE, REMARKS=null}
Mar 03, 2024 6:18:11 PM org.hibernate.cfg.reveng.dialect.OracleMetaDataDialect$1 convertRow
INFO: {TABLE_CAT=null, TABLE_NAME=CLU$, TABLE_SCHEM=SYS, TABLE_TYPE=TABLE, REMARKS=null}
Mar 03, 2024 6:18:11 PM org.hibernate.cfg.reveng.dialect.OracleMetaDataDialect$1 convertRow
INFO: {TABLE_CAT=null, TABLE_NAME=ICOL$, TABLE_SCHEM=SYS, TABLE_TYPE=TABLE, REMARKS=null}
Mar 03, 2024 6:18:11 PM org.hibernate.cfg.reveng.dialect.OracleMetaDataDialect$1 convertRow
INFO: {TABLE_CAT=null, TABLE_NAME=COL$, TABLE_SCHEM=SYS, TABLE_TYPE=TABLE, REMARKS=null}
Mar 03, 2024 6:18:11 PM org.hibernate.cfg.reveng.dialect.OracleMetaDataDialect$1 convertRow
INFO: {TABLE_CAT=null, TABLE_NAME=TAB$, TABLE_SCHEM=SYS, TABLE_TYPE=TABLE, REMARKS=null}
Mar 03, 2024 6:18:11 PM org.hibernate.cfg.reveng.dialect.OracleMetaDataDialect$1 convertRow
INFO: {TABLE_CAT=null, TABLE_NAME=LOB$, TABLE_SCHEM=SYS, TABLE_TYPE=TABLE, REMARKS=null}
Mar 03, 2024 6:18:11 PM org.hibernate.cfg.reveng.dialect.OracleMetaDataDialect$1 convertRow
INFO: {TABLE_CAT=null, TABLE_NAME=COLTYPE$, TABLE_SCHEM=SYS, TABLE_TYPE=TABLE, REMARKS=null}
Mar 03, 2024 6:18:11 PM org.hibernate.cfg.reveng.dialect.OracleMetaDataDialect$1 convertRow
INFO: {TABLE_CAT=null, TABLE_NAME=SUBCOLTYPE$, TABLE_SCHEM=SYS, TABLE_TYPE=TABLE, REMARKS=null}
Mar 03, 2024 6:18:11 PM org.hibernate.cfg.reveng.dialect.OracleMetaDataDialect$1 convertRow
INFO: {TABLE_CAT=null, TABLE_NAME=NTAB$, TABLE_SCHEM=SYS, TABLE_TYPE=TABLE, REMARKS=null}
Mar 03, 2024 6:18:11 PM org.hibernate.cfg.reveng.dialect.OracleMetaDataDialect$1 convertRow
INFO: {TABLE_CAT=null, TABLE_NAME=REFCON$, TABLE_SCHEM=SYS, TABLE_TYPE=TABLE, REMARKS=null}
Mar 03, 2024 6:18:12 PM org.hibernate.cfg.reveng.dialect.OracleMetaDataDialect$1 convertRow
INFO: {TABLE_CAT=null, TABLE_NAME=OPQTYPE$, TABLE_SCHEM=SYS, TABLE_TYPE=TABLE, REMARKS=null}
Mar 03, 2024 6:18:12 PM org.hibernate.cfg.reveng.dialect.OracleMetaDataDialect$1 convertRow
.............

[Javier Condor]

Hello,

Maybe you have already solved your issue. I was also frustrated trying to make version 5.6.15.Final work. Here’s the key information that helped me:

https://github.com/stadler/hibernate-tools-maven-plugin-sample/blob/master/pom.xml

It is quite old, but I used it as a model, and it worked! Here is part of my pom.xml:

<plugin>    <groupId>org.hibernate</groupId>    <artifactId>hibernate-tools-maven-plugin</artifactId>    <version>5.6.15.Final</version>    <dependencies>        <dependency>            <groupId>com.oracle.database.jdbc</groupId>            <artifactId>ojdbc8</artifactId>            <version>18.3.0.0</version>        </dependency>    </dependencies>    <executions>        <execution>            <id>hbm2java</id>            <goals>                <goal>hbm2java</goal>            </goals>        </execution>    </executions>    <configuration>        <revengFile>src/main/resources/reveng.xml</revengFile>        <outputDirectory>${project.build.directory}/generated-sources/</outputDirectory>    </configuration> </plugin>

It’s similar to what you have, but you might be facing issues because your dependencies are defined later in the pom.xml.

In my case, my problem was that ChatGPT suggested putting the configuration inside the execution block, moreover before it was suggesting tags and configuration of 2.x plugin's version.

I hope this helps!

Regards.