<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0">
<base href="https://hibernate.atlassian.net">
<title>Message Title</title>
</head>
<body class="jira" style="color: #333333; font-family: Arial, sans-serif; font-size: 14px; line-height: 1.429">
<table id="background-table" cellpadding="0" cellspacing="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0; mso-table-rspace: 0; background-color: #f5f5f5; border-collapse: collapse; mso-table-lspace: 0; mso-table-rspace: 0" bgcolor="#f5f5f5">
<!-- header here -->
<tbody>
<tr>
<td id="header-pattern-container" style="padding: 0; border-collapse: collapse; padding: 10px 20px">
<table id="header-pattern" cellspacing="0" cellpadding="0" border="0" style="border-collapse: collapse; mso-table-lspace: 0; mso-table-rspace: 0">
<tbody>
<tr>
<td id="header-avatar-image-container" valign="top" style="padding: 0; border-collapse: collapse; vertical-align: top; width: 32px; padding-right: 8px" width="32"> <img id="header-avatar-image" class="image_fix" src="https://avatar-cdn.atlassian.com/2d44223dbde8915e32bea2cc9cf5f439?s=48&d=https%3A%2F%2Fsecure.gravatar.com%2Favatar%2F2d44223dbde8915e32bea2cc9cf5f439%3Fd%3Dmm%26s%3D48%26noRedirect%3Dtrue" height="32" width="32" border="0" style="border-radius: 3px; vertical-align: top"> </td>
<td id="header-text-container" valign="middle" style="padding: 0; border-collapse: collapse; vertical-align: middle; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 1px"> <a class="user-hover" rel="george.labuschagne" style="color:#6c797f;; color: #3b73af; text-decoration: none" id="email_george.labuschagne" href="https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5d035334c97d8b0c633434cf"> George Labuschagne </a> <strong>created</strong> an issue </td>
</tr>
</tbody>
</table> </td>
</tr>
<tr>
<td id="email-content-container" style="padding: 0; border-collapse: collapse; padding: 0 20px">
<table id="email-content-table" cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0; mso-table-rspace: 0; border-spacing: 0; border-collapse: separate">
<tbody>
<tr>
<!-- there needs to be content in the cell for it to render in some clients -->
<td class="email-content-rounded-top mobile-expand" style="padding: 0; border-collapse: collapse; color: #ffffff; padding: 0 15px 0 16px; height: 15px; background-color: #ffffff; border-left: 1px solid #cccccc; border-top: 1px solid #cccccc; border-right: 1px solid #cccccc; border-bottom: 0; border-top-right-radius: 5px; border-top-left-radius: 5px; height: 10px; line-height: 10px; padding: 0 15px 0 16px; mso-line-height-rule: exactly" height="10" bgcolor="#ffffff"> </td>
</tr>
<tr>
<td class="email-content-main mobile-expand " style="padding: 0; border-collapse: collapse; border-left: 1px solid #cccccc; border-right: 1px solid #cccccc; border-top: 0; border-bottom: 0; padding: 0 15px 0 16px; background-color: #ffffff" bgcolor="#ffffff">
<table class="page-title-pattern" cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0; mso-table-rspace: 0">
<tbody>
<tr>
<td class="page-title-pattern-first-line " style="padding: 0; border-collapse: collapse; font-family: Arial, sans-serif; font-size: 14px; padding-top: 10px"> <a href="https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiMTc5ODJlOWE1N2NjNGM2OGExYzcxZTdjMzc3YTUxOWYiLCJwIjoiaiJ9" style="color: #3b73af; text-decoration: none">Hibernate ORM</a> / <a href="https://hibernate.atlassian.net/browse/HHH-13438?atlOrigin=eyJpIjoiMTc5ODJlOWE1N2NjNGM2OGExYzcxZTdjMzc3YTUxOWYiLCJwIjoiaiJ9" style="color: #3b73af; text-decoration: none"><img src="cid:jira-generated-image-avatar-34a3dde8-9916-4fbf-af84-3fe8f61eea62" height="16" width="16" border="0" align="absmiddle" alt="Bug" style="vertical-align: text-bottom"></a> <a href="https://hibernate.atlassian.net/browse/HHH-13438?atlOrigin=eyJpIjoiMTc5ODJlOWE1N2NjNGM2OGExYzcxZTdjMzc3YTUxOWYiLCJwIjoiaiJ9" style="color: #3b73af; text-decoration: none">HHH-13438</a> </td>
</tr>
<tr>
<td style="vertical-align: top;; padding: 0; border-collapse: collapse; padding-right: 5px; font-size: 20px; line-height: 30px; mso-line-height-rule: exactly" class="page-title-pattern-header-container"> <span class="page-title-pattern-header" style="font-family: Arial, sans-serif; padding: 0; font-size: 20px; line-height: 30px; mso-text-raise: 2px; mso-line-height-rule: exactly; vertical-align: middle"> <a href="https://hibernate.atlassian.net/browse/HHH-13438?atlOrigin=eyJpIjoiMTc5ODJlOWE1N2NjNGM2OGExYzcxZTdjMzc3YTUxOWYiLCJwIjoiaiJ9" style="color: #3b73af; text-decoration: none">WildFly 15 and up fails with a NPE when executing the following native PostgreSQL query</a> </span> </td>
</tr>
</tbody>
</table> </td>
</tr>
<tr>
<td class="email-content-main mobile-expand wrapper-special-margin" style="padding: 0; border-collapse: collapse; border-left: 1px solid #cccccc; border-right: 1px solid #cccccc; border-top: 0; border-bottom: 0; padding: 0 15px 0 16px; background-color: #ffffff; padding-top: 10px; padding-bottom: 5px" bgcolor="#ffffff">
<table class="keyvalue-table" style="border-collapse: collapse; mso-table-lspace: 0; mso-table-rspace: 0">
<tbody>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">Issue Type:</th>
<td class="has-icon" style="padding: 0; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> <img src="cid:jira-generated-image-avatar-34a3dde8-9916-4fbf-af84-3fe8f61eea62" height="16" width="16" border="0" align="absmiddle" alt="Bug" style="vertical-align: text-bottom"> Bug </td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">Affects Versions:</th>
<td style="padding: 0; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> 5.3.10 </td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">Assignee:</th>
<td style="padding: 0; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> Unassigned </td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">Components:</th>
<td style="padding: 0; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> hibernate-core </td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">Created:</th>
<td style="padding: 0; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> 14/Jun/2019 01:23 AM </td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">Environment:</th>
<td style="padding: 0; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> Ubuntu 18.04.2 LTS Desktop + openjdk-11 + WildFly 17.0.0.FINAL + PostgreSQL 11.3 </td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">Priority:</th>
<td class="has-icon" style="padding: 0; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> <img src="cid:jira-generated-image-static-critical-c3f9401d-ea11-41a3-a001-446ed27e6b44" height="16" width="16" border="0" align="absmiddle" alt="Critical" style="vertical-align: text-bottom"> Critical </td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">Reporter:</th>
<td style="padding: 0; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> <a class="user-hover" rel="george.labuschagne" style="color:#6c797f;; color: #3b73af; text-decoration: none" id="email_george.labuschagne" href="https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5d035334c97d8b0c633434cf"> George Labuschagne </a> </td>
</tr>
</tbody>
</table> </td>
</tr>
<tr>
<td class="email-content-main mobile-expand issue-description-container" style="padding: 0; border-collapse: collapse; border-left: 1px solid #cccccc; border-right: 1px solid #cccccc; border-top: 0; border-bottom: 0; padding: 0 15px 0 16px; background-color: #ffffff; padding-top: 5px; padding-bottom: 10px" bgcolor="#ffffff">
<table class="text-paragraph-pattern" cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0; mso-table-rspace: 0; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 2px">
<tbody>
<tr>
<td class="text-paragraph-pattern-container mobile-resize-text " style="padding: 0; border-collapse: collapse; padding: 0 0 10px"> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0; margin-top: 0">Good day</p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0">I am porting an existing JSF 2.3 application from WildFly 14 to latest WildFly 17. Using mvn clean package works 100% with zero warnings. When I try to deploy the war using a plethora of different methods, all of them fail when trying to setup the Hibernate persistence unit.</p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0">Code samples below are for WildFly 17</p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0">Here is my pom file:</p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0"><span class="error">[code]</span></p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0"><?xml version="1.0" encoding="UTF-8"?> <!-- EDSNext Copyright (C) 2017-2018, MegChem (Pty) Ltd This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program. If not, see <<a href="http://www.gnu.org/licenses/" class="external-link" rel="nofollow" style="color: #3b73af; text-decoration: none">http://www.gnu.org/licenses/</a>>. --><br> <project xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://maven.apache.org/POM/4.0.0"<br> xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 <a href="http://maven.apache.org/xsd/maven-4.0.0.xsd" class="external-link" rel="nofollow" style="color: #3b73af; text-decoration: none">http://maven.apache.org/xsd/maven-4.0.0.xsd</a>"> <!-- Model Version --><br> <modelVersion>4.0.0</modelVersion> <!-- Application package information --><br> <groupId>com.megchemsa</groupId><br> <artifactId>edsnext</artifactId><br> <version>1.0-SNAPSHOT</version><br> <packaging>war</packaging> <!-- Application final name and URL --><br> <name>$</p> {project.artifactId}</name><br> <description>EDSNext</description><br> <url><a href="http://edsnext.headoffice.megchem.co.za" class="external-link" rel="nofollow" style="color: #3b73af; text-decoration: none">http://edsnext.headoffice.megchem.co.za</a></url> <!-- Properties --><br> <properties><br> <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding><br> <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding><br> <maven.compiler.source>1.8</maven.compiler.source><br> <maven.compiler.target>1.8</maven.compiler.target><br> <failOnMissingWebXml>false</failOnMissingWebXml><br> </properties> <!-- mvn repositories --><br> <repositories><br> <repository><br> <id>JBoss</id><br> <name>public-jboss</name><br> <url><a href="http://repository.jboss.org/nexus/content/groups/public-jboss/" class="external-link" rel="nofollow" style="color: #3b73af; text-decoration: none">http://repository.jboss.org/nexus/content/groups/public-jboss/</a></url><br> </repository><br> <repository><br> <id>java.net-maven2-SNAPSHOT-repository</id><br> <name>Java.net SNAPSHOT-Repository for Maven</name><br> <url><a href="https://maven.java.net/content/repositories/snapshots/" class="external-link" rel="nofollow" style="color: #3b73af; text-decoration: none">https://maven.java.net/content/repositories/snapshots/</a></url><br> <layout>default</layout><br> </repository><br> <repository><br> <id>java.net-maven2-repository</id><br> <name>Java.net Repository for Maven</name><br> <url><a href="https://maven.java.net/content/repositories/releases/" class="external-link" rel="nofollow" style="color: #3b73af; text-decoration: none">https://maven.java.net/content/repositories/releases/</a></url><br> <layout>default</layout><br> </repository><br> <repository><br> <id>oss.sonatype.org</id><br> <url><a href="https://oss.sonatype.org/content/repositories/snapshots/" class="external-link" rel="nofollow" style="color: #3b73af; text-decoration: none">https://oss.sonatype.org/content/repositories/snapshots/</a></url><br> </repository><br> <repository><br> <id>bintray-snapshot</id><br> <name>libs-snapshot</name><br> <url><a href="http://oss.jfrog.org/artifactory/libs-snapshot" class="external-link" rel="nofollow" style="color: #3b73af; text-decoration: none">http://oss.jfrog.org/artifactory/libs-snapshot</a></url><br> </repository><br> <repository><br> <snapshots><br> <enabled>false</enabled><br> </snapshots><br> <id>bintray-deluan-maven</id><br> <name>bintray</name><br> <url><a href="http://dl.bintray.com/deluan/maven" class="external-link" rel="nofollow" style="color: #3b73af; text-decoration: none">http://dl.bintray.com/deluan/maven</a></url><br> </repository><br> </repositories><br> <br> <!-- Dependencies --><br> <dependencies><br> <br> <<span class="error">Unable to render embedded object: File (-- Server specific dependencies for WildFly 14 --> <) not found.</span>-- <a href="https://mvnrepository.com/artifact/org.wildfly.core/wildfly-core-feature-pack" class="external-link" rel="nofollow" style="color: #3b73af; text-decoration: none">https://mvnrepository.com/artifact/org.wildfly.core/wildfly-core-feature-pack</a> --><br> <dependency><br> <groupId>javax</groupId><br> <artifactId>javaee-api</artifactId><br> <version>8.0.1</version><br> <scope>provided</scope><br> </dependency><br> <dependency><br> <groupId>org.hibernate.common</groupId><br> <artifactId>hibernate-commons-annotations</artifactId><br> <version>5.0.5.Final</version><br> <scope>provided</scope><br> </dependency><br> <dependency><br> <groupId>org.hibernate</groupId><br> <artifactId>hibernate-search-orm</artifactId><br> <version>5.10.5.Final</version><br> <scope>provided</scope><br> </dependency><br> <dependency><br> <groupId>org.jboss.spec.javax.faces</groupId><br> <artifactId>jboss-jsf-api_2.3_spec</artifactId><br> <version>2.3.9.SP02</version><br> <scope>provided</scope><br> </dependency><br> <dependency><br> <groupId>org.jboss.spec.javax.ejb</groupId><br> <artifactId>jboss-ejb-api_3.2_spec</artifactId><br> <version>1.0.2.Final</version><br> <scope>provided</scope><br> </dependency><br> <dependency><br> <groupId>com.sun.faces</groupId><br> <artifactId>jsf-impl</artifactId><br> <version>2.3.9.SP02</version><br> <scope>provided</scope><br> </dependency><br> <dependency><br> <groupId>org.jboss.spec.javax.el</groupId><br> <artifactId>jboss-el-api_3.0_spec</artifactId><br> <version>1.0.13.Final</version><br> <scope>provided</scope><br> </dependency><br> <dependency><br> <groupId>org.jboss.spec.javax.servlet</groupId><br> <artifactId>jboss-servlet-api_4.0_spec</artifactId><br> <version>1.0.0.Final</version><br> <scope>provided</scope><br> </dependency><br> <dependency><br> <groupId>org.jboss.spec.javax.annotation</groupId><br> <artifactId>jboss-annotations-api_1.2_spec</artifactId><br> <version>1.0.2.Final</version><br> </dependency><br> <br> <br> <!-- Runtime dependencies. --><br> <dependency><br> <groupId>net.sf.jasperreports</groupId><br> <artifactId>jasperreports</artifactId><br> <version>6.8.1</version><br> </dependency><br> <dependency><br> <groupId>org.apache.httpcomponents</groupId><br> <artifactId>httpclient</artifactId><br> <version>4.5.9</version><br> </dependency><br> <dependency><br> <groupId>org.apache.httpcomponents</groupId><br> <artifactId>httpcore</artifactId><br> <version>4.4.11</version><br> </dependency><br> <br> <!-- Need to replace shiro and move to KeyCloak to be able to run on Java 11 --><br> <dependency><br> <groupId>org.apache.shiro</groupId><br> <artifactId>shiro-core</artifactId><br> <version>1.4.0</version><br> </dependency><br> <dependency><br> <groupId>org.apache.shiro</groupId><br> <artifactId>shiro-web</artifactId><br> <version>1.4.0</version><br> </dependency><br> <dependency><br> <groupId>org.apache.shiro</groupId><br> <artifactId>shiro-ehcache</artifactId><br> <version>1.4.0</version><br> </dependency><br> <dependency><br> <groupId>org.primefaces</groupId><br> <artifactId>primefaces</artifactId><br> <version>7.0.4</version><br> </dependency><br> <dependency><br> <groupId>org.primefaces.extensions</groupId><br> <artifactId>primefaces-extensions</artifactId><br> <version>7.0.1</version><br> </dependency><br> <dependency><br> <groupId>org.omnifaces</groupId><br> <artifactId>omnifaces</artifactId><br> <version>3.3</version><br> </dependency><br> <dependency><br> <groupId>org.postgresql</groupId><br> <artifactId>postgresql</artifactId><br> <version>42.2.5</version><br> </dependency><br> <dependency><br> <groupId>org.apache.logging.log4j</groupId><br> <artifactId>log4j-api</artifactId><br> <version>2.11.2</version><br> </dependency><br> <dependency><br> <groupId>org.apache.logging.log4j</groupId><br> <artifactId>log4j-core</artifactId><br> <version>2.11.2</version><br> </dependency><br> <dependency><br> <groupId>org.apache.logging.log4j</groupId><br> <artifactId>log4j-web</artifactId><br> <version>2.11.2</version><br> </dependency><br> <dependency><br> <groupId>com.intellij</groupId><br> <artifactId>annotations</artifactId><br> <version>12.0</version><br> </dependency><br> <dependency><br> <groupId>org.apache.commons</groupId><br> <artifactId>commons-text</artifactId><br> <version>1.6</version><br> </dependency><br> <dependency><br> <groupId>org.apache.poi</groupId><br> <artifactId>poi</artifactId><br> <version>4.1.0</version><br> </dependency><br> <dependency><br> <groupId>org.apache.poi</groupId><br> <artifactId>poi-ooxml</artifactId><br> <version>4.1.0</version><br> </dependency><br> <dependency><br> <groupId>org.apache.poi</groupId><br> <artifactId>poi-scratchpad</artifactId><br> <version>4.1.0</version><br> </dependency><br> <dependency><br> <groupId>org.apache.commons</groupId><br> <artifactId>commons-lang3</artifactId><br> <version>3.9</version><br> </dependency><br> <dependency><br> <groupId>commons-fileupload</groupId><br> <artifactId>commons-fileupload</artifactId><br> <version>1.4</version><br> </dependency><br> <dependency><br> <groupId>commons-io</groupId><br> <artifactId>commons-io</artifactId><br> <version>2.6</version><br> </dependency><br> <dependency><br> <groupId>org.projectlombok</groupId><br> <artifactId>lombok</artifactId><br> <version>1.18.8</version><br> <scope>provided</scope><br> </dependency><br> <dependency><br> <groupId>org.codehaus.mojo</groupId><br> <artifactId>versions-maven-plugin</artifactId><br> <version>2.7</version><br> </dependency><br> <dependency><br> <groupId>org.apache.maven.plugins</groupId><br> <artifactId>maven-enforcer-plugin</artifactId><br> <version>3.0.0-M2</version><br> </dependency><br> <dependency><br> <groupId>org.apache.maven.plugins</groupId><br> <artifactId>maven-compiler-plugin</artifactId><br> <version>3.8.1</version><br> </dependency><br> <br> <!-<del>Text templating</del>-><br> <dependency><br> <groupId>org.freemarker</groupId><br> <artifactId>freemarker</artifactId><br> <version>2.3.28</version><br> </dependency><br> </dependencies> <!-- Build settings --><br> <build><br> <finalName>${project.artifactId} <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0"></finalName><br> <plugins><br> <plugin><br> <groupId>org.apache.maven.plugins</groupId><br> <artifactId>maven-enforcer-plugin</artifactId><br> <version>3.0.0-M2</version><br> <executions><br> <execution><br> <id>enforce-maven</id><br> <goals><br> <goal>enforce</goal><br> </goals><br> <configuration><br> <rules><br> <requireMavenVersion><br> <version>3.0</version><br> </requireMavenVersion><br> </rules><br> </configuration><br> </execution><br> </executions><br> </plugin><br> <plugin><br> <groupId>org.apache.maven.plugins</groupId><br> <artifactId>maven-compiler-plugin</artifactId><br> <version>3.8.1</version><br> </plugin><br> <plugin><br> <groupId>org.codehaus.mojo</groupId><br> <artifactId>versions-maven-plugin</artifactId><br> <version>2.7</version><br> <configuration><br> <generateBackupPoms>false</generateBackupPoms><br> </configuration><br> </plugin><br> </plugins><br> </build><br> </project><br> <span class="error">[/code]</span></p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0">The error I get in the server log is:</p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0"><span class="error">[code]</span></p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0">08:48:53,006 INFO <span class="error">[org.hibernate.orm.beans]</span> (ServerService Thread Pool – 76) HHH10005004: Stopping BeanContainer : org.hibernate.resource.beans.container.internal.CdiBeanContainerExtendedAccessImpl@7b81609b<br> 08:48:53,010 ERROR <span class="error">[org.jboss.msc.service.fail]</span> (ServerService Thread Pool – 76) MSC000001: Failed to start service jboss.persistenceunit."edsnext.war#PostgresDS": org.jboss.msc.service.StartException in service jboss.persistenceunit."edsnext.war#PostgresDS": javax.persistence.PersistenceException: <span class="error">[PersistenceUnit: PostgresDS]</span> Unable to build Hibernate SessionFactory<br> at org.jboss.as.jpa@17.0.0.Final//org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1$1.run(PersistenceUnitServiceImpl.java:198)<br> at org.jboss.as.jpa@17.0.0.Final//org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1$1.run(PersistenceUnitServiceImpl.java:128)<br> at org.wildfly.security.elytron-private@1.9.1.Final//org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:649)<br> at org.jboss.as.jpa@17.0.0.Final//org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1.run(PersistenceUnitServiceImpl.java:212)<br> at org.jboss.threads@2.3.3.Final//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)<br> at org.jboss.threads@2.3.3.Final//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1982)<br> at org.jboss.threads@2.3.3.Final//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1486)<br> at org.jboss.threads@2.3.3.Final//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1377)<br> at java.base/java.lang.Thread.run(Thread.java:834)<br> at org.jboss.threads@2.3.3.Final//org.jboss.threads.JBossThread.run(JBossThread.java:485)<br> Caused by: javax.persistence.PersistenceException: <span class="error">[PersistenceUnit: PostgresDS]</span> Unable to build Hibernate SessionFactory<br> at org.hibernate@5.3.10.Final//org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.persistenceException(EntityManagerFactoryBuilderImpl.java:1016)<br> at org.hibernate@5.3.10.Final//org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:942)<br> at org.hibernate.jipijapa-hibernate5-3@17.0.0.Final//org.jboss.as.jpa.hibernate5.TwoPhaseBootstrapImpl.build(TwoPhaseBootstrapImpl.java:44)<br> at org.jboss.as.jpa@17.0.0.Final//org.jboss.as.jpa.service.PersistenceUnitServiceImpl$1$1.run(PersistenceUnitServiceImpl.java:170)<br> ... 9 more<br> Caused by: java.lang.NullPointerException<br> at java.base/java.lang.String$CaseInsensitiveComparator.compare(String.java:1224)<br> at java.base/java.lang.String$CaseInsensitiveComparator.compare(String.java:1218)<br> at java.base/java.util.TreeMap.getEntryUsingComparator(TreeMap.java:374)<br> at java.base/java.util.TreeMap.getEntry(TreeMap.java:343)<br> at java.base/java.util.TreeMap.get(TreeMap.java:277)<br> at org.hibernate@5.3.10.Final//org.hibernate.dialect.function.SQLFunctionRegistry.findSQLFunction(SQLFunctionRegistry.java:45)<br> at org.hibernate@5.3.10.Final//org.hibernate.hql.internal.ast.util.SessionFactoryHelper.findSQLFunction(SessionFactoryHelper.java:385)<br> at org.hibernate@5.3.10.Final//org.hibernate.hql.internal.ast.tree.IdentNode.getDataType(IdentNode.java:366)<br> at org.hibernate@5.3.10.Final//org.hibernate.hql.internal.ast.tree.SelectClause.initializeExplicitSelectClause(SelectClause.java:157)<br> at org.hibernate@5.3.10.Final//org.hibernate.hql.internal.ast.HqlSqlWalker.useSelectClause(HqlSqlWalker.java:1018)<br> at org.hibernate@5.3.10.Final//org.hibernate.hql.internal.ast.HqlSqlWalker.processQuery(HqlSqlWalker.java:786)<br> at org.hibernate@5.3.10.Final//org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:677)<br> at org.hibernate@5.3.10.Final//org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:313)<br> at org.hibernate@5.3.10.Final//org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:261)<br> at org.hibernate@5.3.10.Final//org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:271)<br> at org.hibernate@5.3.10.Final//org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:191)<br> at org.hibernate@5.3.10.Final//org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:143)<br> at org.hibernate@5.3.10.Final//org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:119)<br> at org.hibernate@5.3.10.Final//org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:80)<br> at org.hibernate@5.3.10.Final//org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:153)<br> at org.hibernate@5.3.10.Final//org.hibernate.query.spi.NamedQueryRepository.checkNamedQueries(NamedQueryRepository.java:157)<br> at org.hibernate@5.3.10.Final//org.hibernate.internal.SessionFactoryImpl.checkNamedQueries(SessionFactoryImpl.java:574)<br> at org.hibernate@5.3.10.Final//org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:321)<br> at org.hibernate@5.3.10.Final//org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)<br> at org.hibernate@5.3.10.Final//org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)<br> ... 11 more</p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0">08:48:53,023 ERROR <span class="error">[org.jboss.as.controller.management-operation]</span> (Controller Boot Thread) WFLYCTL0013: Operation ("deploy") failed - address: (<span class="error">[("deployment" => "edsnext.war")]</span>) - failure description: {"WFLYCTL0080: Failed services" => {"jboss.persistenceunit.\"edsnext.war#PostgresDS\"" => "javax.persistence.PersistenceException: <span class="error">[PersistenceUnit: PostgresDS]</span> Unable to build Hibernate SessionFactory<br> Caused by: javax.persistence.PersistenceException: <span class="error">[PersistenceUnit: PostgresDS]</span> Unable to build Hibernate SessionFactory<br> Caused by: java.lang.NullPointerException"}}</p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0"><span class="error">[/code]</span></p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0">And my persistence.xml file:</p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0"><span class="error">[code]</span></p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0"><?xml version="1.0" encoding="UTF-8" standalone="yes"?></p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0"><persistence xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"</p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0"> xmlns="http://xmlns.jcp.org/xml/ns/persistence"</p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0"> version="2.1"</p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0"> xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence <a href="http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd" class="external-link" rel="nofollow" style="color: #3b73af; text-decoration: none">http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd</a>"></p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0"> <persistence-unit name="PostgresDS" transaction-type="JTA"></p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0"> <jta-data-source>java:/PostgresDS</jta-data-source></p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0"> <exclude-unlisted-classes>false</exclude-unlisted-classes></p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0"> <properties></p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0"> <property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQL94Dialect"/></p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0"> <property name="hibernate.show_sql" value="false"/></p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0"> <property name="hibernate.connection.url" value="jdbc:postgresql://localhost:5432/edsdb"/></p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0"> <property name="hibernate.connection.driver_class" value="org.postgresql.Driver"/></p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0"> <property name="hibernate.jdbc.batch_size" value="25"/></p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0"> <property name="hibernate.order_inserts" value="true"/></p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0"> <property name="hibernate.order_updates" value="true"/></p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0"> <property name="hibernate.connection.username" value="user"/></p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0"> <property name="hibernate.connection.password" value="password"/></p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0"> <property name="hibernate.temp.use_jdbc_metadata_defaults" value="false"/></p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0"> </properties></p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0"> </persistence-unit></p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0"></persistence></p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0"><span class="error">[/code]</span></p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0">What would be the reason for WildFly 15 -17 to fail like this whereas WildFly 14.0.1.FINAL works 100% Same system Ubuntu 18.04 with openjdk-11</p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0">The culprit seems to be this Native Query (and yes the tablefunc extension is enabled with correct privileges in PostgreSQL <img class="emoticon" src="cid:jira-generated-image-static-wink-73877ff9-f0f2-4b4e-9f6c-e60278147e65" height="16" width="16" align="absmiddle" alt="" border="0"> )</p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0">@NamedNativeQuery(</p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0"> name = "PartialHierarchyDisplay",<br> query = "SELECT t.emp_aid, t.supervisor_emp_aid, t.level, t.branch, t.pos "<br> + "FROM connectby('human_resources.emp_info', 'emp_aid', 'emp_supervisor', 'emp_last_name', :empAid, :treeDepth, '~') "<br> + "t(emp_aid bigint, supervisor_emp_aid bigint, level integer, branch text, pos integer)",<br> resultSetMapping = "PartialHierarchyDisplay")</p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0">@SqlResultSetMapping(</p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0"> name = "PartialHierarchyDisplay",<br> classes =</p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0"> @ConstructorResult(</p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0"> targetClass = PartialHierarchyDisplay.class,<br> columns = </p> { @ColumnResult(name = "emp_aid"), @ColumnResult(name = "supervisor_emp_aid"), @ColumnResult(name = "level"), @ColumnResult(name = "branch"), @ColumnResult(name = "pos") } <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0">))</p> </td>
</tr>
</tbody>
</table> </td>
</tr>
<tr>
<td class="email-content-main mobile-expand " style="padding: 0; border-collapse: collapse; border-left: 1px solid #cccccc; border-right: 1px solid #cccccc; border-top: 0; border-bottom: 0; padding: 0 15px 0 16px; background-color: #ffffff" bgcolor="#ffffff"> <script type="application/ld+json">
{
"@context": "http://schema.org",
"@type": "EmailMessage",
"description": "View Issue",
"potentialAction": {
"@type": "ViewAction",
"target": "https://hibernate.atlassian.net/browse/HHH-13438?inbox=true&",
"name": "View Issue"
},
"publisher": {
"@type": "Organization",
"name": "Atlassian",
"url": "https://www.atlassian.com"
}
}
</script>
<table id="actions-pattern" cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0; mso-table-rspace: 0; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 1px">
<tbody>
<tr>
<td id="actions-pattern-container" valign="middle" style="padding: 0; border-collapse: collapse; padding: 10px 0 10px 24px; vertical-align: middle; padding-left: 0">
<table align="left" style="border-collapse: collapse; mso-table-lspace: 0; mso-table-rspace: 0">
<tbody>
<tr>
<td class="actions-pattern-action-icon-container" style="padding: 0; border-collapse: collapse; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 0; vertical-align: middle"> <a href="https://hibernate.atlassian.net/browse/HHH-13438#add-comment?atlOrigin=eyJpIjoiMTc5ODJlOWE1N2NjNGM2OGExYzcxZTdjMzc3YTUxOWYiLCJwIjoiaiJ9" target="_blank" title="Add Comment" style="color: #3b73af; text-decoration: none"> <img class="actions-pattern-action-icon-image" src="cid:jira-generated-image-static-comment-icon-82b77cd2-245c-4a0a-a022-6aa848c2b031" alt="Add Comment" title="Add Comment" height="16" width="16" border="0" style="vertical-align: middle"> </a> </td>
<td class="actions-pattern-action-text-container" style="padding: 0; border-collapse: collapse; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 4px; padding-left: 5px"> <a href="https://hibernate.atlassian.net/browse/HHH-13438#add-comment?atlOrigin=eyJpIjoiMTc5ODJlOWE1N2NjNGM2OGExYzcxZTdjMzc3YTUxOWYiLCJwIjoiaiJ9" target="_blank" title="Add Comment" style="color: #3b73af; text-decoration: none">Add Comment</a> </td>
</tr>
</tbody>
</table> </td>
</tr>
</tbody>
</table> </td>
</tr>
<!-- there needs to be content in the cell for it to render in some clients -->
<tr>
<td class="email-content-rounded-bottom mobile-expand" style="padding: 0; border-collapse: collapse; color: #ffffff; padding: 0 15px 0 16px; height: 5px; line-height: 5px; background-color: #ffffff; border-top: 0; border-left: 1px solid #cccccc; border-bottom: 1px solid #cccccc; border-right: 1px solid #cccccc; border-bottom-right-radius: 5px; border-bottom-left-radius: 5px; mso-line-height-rule: exactly" height="5" bgcolor="#ffffff"> </td>
</tr>
</tbody>
</table> </td>
</tr>
<tr>
<td id="footer-pattern" style="padding: 0; border-collapse: collapse; padding: 12px 20px">
<table id="footer-pattern-container" cellspacing="0" cellpadding="0" border="0" style="border-collapse: collapse; mso-table-lspace: 0; mso-table-rspace: 0">
<tbody>
<tr>
<td id="footer-pattern-mobile-separated-links" class="mobile-resize-text" width="100%" colspan="2" style="padding: 0; border-collapse: collapse; color: #999999; font-size: 12px; line-height: 18px; font-family: Arial, sans-serif; mso-line-height-rule: exactly; mso-text-raise: 2px"> Get Jira notifications on your phone! Download the Jira Cloud app for <a href="https://play.google.com/store/apps/details?id=com.atlassian.android.jira.core&referrer=utm_source%3DNotificationLink%26utm_medium%3DEmail" style="color: #3b73af; text-decoration: none">Android</a> or <a href="https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailNotificationLink&mt=8" style="color: #3b73af; text-decoration: none">iOS</a>
<hr> </td>
</tr>
<tr>
<td id="footer-pattern-text" class="mobile-resize-text" width="100%" style="padding: 0; border-collapse: collapse; color: #999999; font-size: 12px; line-height: 18px; font-family: Arial, sans-serif; mso-line-height-rule: exactly; mso-text-raise: 2px"> This message was sent by Atlassian Jira <span id="footer-build-information">(v1001.0.0-SNAPSHOT#100104-<span title="ce3e8e11c36d97d6f46f08d27ed9717725e5a764" data-commit-id="ce3e8e11c36d97d6f46f08d27ed9717725e5a764}">sha1:ce3e8e1</span>)</span> </td>
<td id="footer-pattern-logo-desktop-container" valign="top" style="padding: 0; border-collapse: collapse; padding-left: 20px; vertical-align: top">
<table style="border-collapse: collapse; mso-table-lspace: 0; mso-table-rspace: 0">
<tbody>
<tr>
<td id="footer-pattern-logo-desktop-padding" style="padding: 0; border-collapse: collapse; padding-top: 3px; opacity: 0.150"> <img id="footer-pattern-logo-desktop" src="cid:jira-generated-image-static-footer-desktop-logo-20b113f5-8de8-4120-8921-fe3b664efad2" alt="Atlassian logo" title="Atlassian logo" width="192" height="24" class="image_fix"> </td>
</tr>
</tbody>
</table> </td>
</tr>
</tbody>
</table> </td>
</tr>
</tbody>
</table>
<img border="0" width="1" height="1" alt="" src="http://atlassian.et.e.sparkpost.com/q/F1uJ7aqvqLKxiUC32JTMiQ~~/AAAAAQA~/RgRe5IztPlcLYXRsYXNzaWFudXNCCgAAbVkDXS6Z0zdSIGhpYmVybmF0ZS1pc3N1ZXNAbGlzdHMuamJvc3Mub3JnWAQAAAAE">
</body>
</html>