How to properly deploy an EAR project in wildfly 9.0.2?

Question

Hibernate

I'm trying to deploy an EAR type project to a local application server, but I get such an error
to the sources, I don't have access as such, I only configured Datasource in Wildfly and that's it

Cannot upload deployment: {"WFLYCTL0080: Failed services" => {"jboss.persistenceunit.\"warehouse.ear/warehouse-core.jar#warehouse\"" => "org.jboss.msc.service.StartException in service jboss.persistenceunit.\"warehouse.ear/warehouse-core.jar#warehouse\": org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when 'hibernate.dialect' not set Caused by: org.hibernate.HibernateException: Access to DialectResolutionInfo cannot be null when 'hibernate.dialect' not set"},"WFLYCTL0180: Services with missing/unavailable dependencies" => ["jboss.undertow.deployment.default-server.default-host./warehouse.UndertowDeploymentInfoService is missing [jboss.security.security-domain.JbSecurityDomain]"]}

Answer 1

It appears that the application being deployed requires a security domain named " JbSecurityDomain ". Usually, it is used to authenticate application users, in which case it should be referenced from YOUR.EAR/SOME.WAR/WEB-INF/jboss-web.xml . The domain description must be added to <security-domains>the server configuration section.
If there is no information on how to configure security for your particular application, then this can be a problem. But, since there is a Datasource, it can be assumed with a high degree of probability that information about users is stored in the database. If so, then you can try adding something like this:

<security-domains>
...
                <security-domain name="JbSecurityDomain">
                    <authentication>
                        <login-module code="org.jboss.security.auth.spi.DatabaseServerLoginModule" flag="required">
                            <module-option name="dsJndiName" value="имя-вашего-datasource"/>
                            <module-option name="principalsQuery" value="select password from users where login = ?"/>
                            <module-option name="rolesQuery" value="select t3.code, 'Roles' from users t1 inner join user_roles t2 on t2.user_id = t1.id and t1.login = ? inner join roles t3 on t2.role_id = t3.id"/>
                        </login-module>
                    </authentication>
                </security-domain>
            </security-domains>

In principalsQuery and rolesQuery, insert SQL queries for data selection in accordance with the structure of your database. In rolesQuery, the first field must be the name of the role from the table, the second field is the 'Roles' constant.