Menu ▾ ▴

ERROR: [SQL5051] El calificador XXXXXX no coincide con el nombre

Ayuda (Español)
Jesús F. Hernández
2021-05-15
2021-05-25

  • Jesús F. Hernández

    Jesús F. Hernández - 2021-05-15

    Buenos días,
    Estoy intentando desarrollar una aplicación sobre DB2 en un AS400 (IBM i 7.3) en XavaPro 6.4.2 (aunque lo he intentado en la versión 6.5.1) y el resultado es el mismo. Me genera todas las tablas OX en el esquema BWRESIDEN, creado desde SQL, pero al final proceso indica el error "ERROR: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN" y elimina del esquema las OX previamente creadas, con lo cual la aplicación nunca funciona y no sé que puede ocurrir. Aquí adjunto los logs y .xml implicado.

    Iniciando aplicación...
    may. 15, 2021 10:09:27 A. M. org.apache.coyote.AbstractProtocol init
    INFORMACIÓN: Initializing ProtocolHandler ["http-nio-8080"]
    may. 15, 2021 10:09:27 A. M. org.apache.catalina.core.StandardService startInternal
    INFORMACIÓN: Starting service [Tomcat]
    may. 15, 2021 10:09:27 A. M. org.apache.catalina.core.StandardEngine startInternal
    INFORMACIÓN: Starting Servlet engine: [Apache Tomcat/9.0.22]
    may. 15, 2021 10:09:28 A. M. org.apache.catalina.startup.ContextConfig getDefaultWebXmlFragment
    INFORMACIÓN: No global web.xml found
    may. 15, 2021 10:09:36 A. M. org.apache.jasper.servlet.TldScanner scanJars
    INFORMACIÓN: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
    may. 15, 2021 10:09:37 A. M. org.apache.catalina.util.SessionIdGeneratorBase createSecureRandom
    ADVERTENCIA: Creation of SecureRandom instance for session ID generation using [SHA1PRNG] took [316] milliseconds.
    may. 15, 2021 10:09:37 A. M. org.hibernate.jpa.internal.util.LogHelper logPersistenceUnitInformation
    INFO: HHH000204: Processing PersistenceUnitInfo
    name: default
    ...
    may. 15, 2021 10:09:37 A. M. org.hibernate.Version logVersion
    INFO: HHH000412: Hibernate Core {5.3.9.Final}
    may. 15, 2021 10:09:37 A. M. org.hibernate.cfg.Environment <clinit>
    INFO: HHH000206: hibernate.properties not found
    may. 15, 2021 10:09:38 A. M. org.hibernate.annotations.common.reflection.java.JavaReflectionManager <clinit>
    INFO: HCANN000001: Hibernate Commons Annotations {5.0.4.Final}
    WARNING: An illegal reflective access operation has occurred
    WARNING: Illegal reflective access by com.sun.xml.bind.v2.runtime.reflect.opt.Injector (file:/C:/openxavaTorres-6.4.2/workspace/ClientesPba1/web/WEB-INF/lib/jaxb-impl.jar) to method java.lang.ClassLoader.defineClass(java.lang.String,byte[],int,int)
    WARNING: Please consider reporting this to the maintainers of com.sun.xml.bind.v2.runtime.reflect.opt.Injector
    WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
    WARNING: All illegal access operations will be denied in a future release
    may. 15, 2021 10:09:43 A. M. org.hibernate.dialect.Dialect <init>
    INFO: HHH000400: Using dialect: org.hibernate.dialect.DB2400Dialect
    may. 15, 2021 10:09:45 A. M. org.hibernate.envers.boot.internal.EnversServiceImpl configure
    INFO: Envers integration enabled? : true
    may. 15, 2021 10:09:46 A. M. org.hibernate.id.UUIDHexGenerator <init>
    WARN: HHH000409: Using org.hibernate.id.UUIDHexGenerator which does not generate IETF RFC 4122 compliant UUID values; consider using org.hibernate.id.UUIDGenerator instead
    may. 15, 2021 10:09:47 A. M. org.hibernate.validator.internal.util.Version <clinit>
    INFO: HV000001: Hibernate Validator 6.0.15.Final
    may. 15, 2021 10:09:50 A. M. org.hibernate.jpa.internal.util.LogHelper logPersistenceUnitInformation
    INFO: HHH000204: Processing PersistenceUnitInfo
    name: default
    ...
    may. 15, 2021 10:09:50 A. M. org.hibernate.dialect.Dialect <init>
    INFO: HHH000400: Using dialect: org.hibernate.dialect.DB2400Dialect
    may. 15, 2021 10:09:52 A. M. org.hibernate.envers.boot.internal.EnversServiceImpl configure
    INFO: Envers integration enabled? : true
    may. 15, 2021 10:09:53 A. M. org.hibernate.hql.internal.QueryTranslatorFactoryInitiator initiateService
    INFO: HHH000397: Using ASTQueryTranslatorFactory
    may. 15, 2021 10:09:53 A. M. org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
    WARN: SQL Error: -204, SQLState: 42704
    may. 15, 2021 10:09:53 A. M. org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
    ERROR: [SQL0204] OXMODULES en BWRESIDEN de tipo *FILE no encontrado.
    may. 15, 2021 10:09:53 A. M. com.openxava.naviox.impl.DB init
    INFORMACIÓN: Primera ejecución de XavaPro
    may. 15, 2021 10:09:54 A. M. com.openxava.naviox.impl.DB createDB
    INFORMACIÓN: Creando tablas de XavaPro...
    may. 15, 2021 10:09:54 A. M. org.hibernate.dialect.Dialect <init>
    INFO: HHH000400: Using dialect: org.hibernate.dialect.DB2400Dialect
    may. 15, 2021 10:09:56 A. M. org.hibernate.envers.boot.internal.EnversServiceImpl configure
    INFO: Envers integration enabled? : true
    may. 15, 2021 10:09:56 A. M. org.hibernate.tool.hbm2ddl.SchemaExport execute
    INFO: HHH000227: Running hbm2ddl schema export
    may. 15, 2021 10:09:56 A. M. org.hibernate.tool.schema.internal.SchemaCreatorImpl applyImportSources
    INFO: HHH000476: Executing import script 'org.hibernate.tool.schema.internal.exec.ScriptSourceInputNonExistentImpl@74433068'
    may. 15, 2021 10:09:56 A. M. org.openxava.tools.SchemaTool execute
    INFORMACIÓN: Ejecutando: create table BWRESIDEN.OXCONFIGURATION (id integer not null, forceChangePasswordDays integer not null, forceLetterAndNumbersInPasswd varchar(1) default 'N' not null, guestCanCreateAccount varchar(1) default 'Y' not null, guestCanCreateAccountInOrgs varchar(1) default 'Y' not null, inactiveDaysBeforeDisUser integer, lockSessionMinutes integer not null, loginAttemptsBeforeLocking integer not null, passwordMinLength integer not null, privacyPolicyOnSignUp varchar(1) default 'N' not null, recentPasswordsNotAllowed varchar(1) default 'N' not null, sharedUsersBetweenOrgs varchar(1) default 'N' not null, useEmailAsUserName varchar(1) default 'N' not null, primary key (id))
    may. 15, 2021 10:09:57 A. M. org.openxava.tools.SchemaTool execute
    INFORMACIÓN: Ejecutando: create table BWRESIDEN.OXFOLDERS (id varchar(32) not null, icon varchar(40), name varchar(25), orderInFolder integer, parent_id varchar(32), primary key (id))
    may. 15, 2021 10:09:57 A. M. org.openxava.tools.SchemaTool execute
    INFORMACIÓN: Ejecutando: create table BWRESIDEN.OXHISTORY (id varchar(32) not null, action varchar(255), changes varchar(255), dateTime timestamp, entity varchar(100), ip varchar(15), entityKey varchar(100), userName varchar(30), primary key (id))
    may. 15, 2021 10:09:58 A. M. org.openxava.tools.SchemaTool execute
    INFORMACIÓN: Ejecutando: create table BWRESIDEN.OXMODULES (name varchar(80) not null, application varchar(50) not null, desktop varchar(1) default 'Y' not null, hidden varchar(1) default 'N' not null, mobile varchar(1) default 'Y' not null, orderInFolder integer, unrestricted varchar(1) default 'N' not null, folder_id varchar(32), primary key (name, application))
    may. 15, 2021 10:09:58 A. M. org.openxava.tools.SchemaTool execute
    INFORMACIÓN: Ejecutando: create table BWRESIDEN.OXORGANIZATIONS (id varchar(50) not null, active varchar(1) default 'Y' not null, name varchar(50), theme varchar(30), primary key (id))
    may. 15, 2021 10:09:59 A. M. org.openxava.tools.SchemaTool execute
    INFORMACIÓN: Ejecutando: create table BWRESIDEN.OXROLES (name varchar(30) not null, description varchar(80), primary key (name))
    may. 15, 2021 10:09:59 A. M. org.openxava.tools.SchemaTool execute
    INFORMACIÓN: Ejecutando: create table BWRESIDEN.OXROLES_OXMODULES (excludedActions varchar(1000), excludedMembers varchar(1000), readOnlyMembers varchar(1000), roles_name varchar(30) not null, modules_name varchar(80) not null, modules_application varchar(50) not null, primary key (roles_name, modules_name, modules_application))
    may. 15, 2021 10:10:00 A. M. org.openxava.tools.SchemaTool execute
    INFORMACIÓN: Ejecutando: create table BWRESIDEN.OXSESSIONSRECORD (id varchar(32) not null, singInTime timestamp, user_name varchar(30), primary key (id))
    may. 15, 2021 10:10:00 A. M. org.openxava.tools.SchemaTool execute
    INFORMACIÓN: Ejecutando: create table BWRESIDEN.OXUSERS (name varchar(30) not null, active varchar(1) default 'Y' not null, allowedIP varchar(15), authenticateWithLDAP varchar(1) default 'N' not null, birthDate timestamp, creationDate timestamp, email varchar(60), failedLoginAttempts integer not null, familyName varchar(30), forceChangePassword varchar(1) default 'N' not null, givenName varchar(30), jobTitle varchar(30), lastLoginDate timestamp, lastPasswordChangeDate timestamp, middleName varchar(30), nickName varchar(30), password varchar(41), passwordRecoveringCode varchar(32), passwordRecoveringDate timestamp, privacyPolicyAcceptanceDate timestamp, recentPassword1 varchar(41), recentPassword2 varchar(41), recentPassword3 varchar(41), recentPassword4 varchar(41), primary key (name))
    may. 15, 2021 10:10:01 A. M. org.openxava.tools.SchemaTool execute
    INFORMACIÓN: Ejecutando: create table BWRESIDEN.OXUSERS_OXORGANIZATIONS (OXUSERS_NAME varchar(30) not null, ORGANIZATIONS_ID varchar(50) not null)
    may. 15, 2021 10:10:01 A. M. org.openxava.tools.SchemaTool execute
    INFORMACIÓN: Ejecutando: create table BWRESIDEN.OXUSERS_OXROLES (OXUSERS_NAME varchar(30) not null, ROLES_NAME varchar(30) not null)
    may. 15, 2021 10:10:02 A. M. org.openxava.tools.SchemaTool execute
    INFORMACIÓN: Ejecutando: create index BWRESIDEN.IDXlgjiwadcond97x6o36c8ifjfa on BWRESIDEN.OXFOLDERS (name)
    may. 15, 2021 10:10:02 A. M. org.openxava.tools.SchemaTool execute
    INFORMACIÓN: Ejecutando: create index BWRESIDEN.IDX1kr6bnx5w22vlyob1y4p8qqft on BWRESIDEN.OXUSERS (email)
    may. 15, 2021 10:10:02 A. M. org.openxava.tools.SchemaTool execute
    INFORMACIÓN: Ejecutando: create index BWRESIDEN.IDX4scpsyerabcdjqu5hj2yq3el7 on BWRESIDEN.OXUSERS (passwordRecoveringCode)
    may. 15, 2021 10:10:03 A. M. org.openxava.tools.SchemaTool execute
    INFORMACIÓN: Ejecutando: alter table BWRESIDEN.OXFOLDERS add constraint FKlp3v9vj6d112rk1wsunkwl2rf foreign key (parent_id) references BWRESIDEN.OXFOLDERS
    may. 15, 2021 10:10:03 A. M. org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
    WARN: SQL Error: -5051, SQLState: 42875
    may. 15, 2021 10:10:03 A. M. org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
    ERROR: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN.
    may. 15, 2021 10:10:03 A. M. org.openxava.tools.SchemaTool execute
    GRAVE: org.hibernate.exception.SQLGrammarException: could not prepare statement
    javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
    at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)
    at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181)
    at org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1599)
    at org.openxava.tools.SchemaTool.execute(Unknown Source)
    at org.openxava.tools.SchemaTool.generateSchema(Unknown Source)
    at com.openxava.naviox.impl.DB.createDB(DB.java:196)
    at com.openxava.naviox.impl.DB.init(DB.java:41)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement
    at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)
    at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
    at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:182)
    at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareStatement(StatementPreparerImpl.java:78)
    at org.hibernate.engine.query.spi.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:97)
    at org.hibernate.internal.SessionImpl.executeNativeUpdate(SessionImpl.java:1592)
    at org.hibernate.query.internal.NativeQueryImpl.doExecuteUpdate(NativeQueryImpl.java:292)
    at org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1589)
    ... 36 more
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1790)
    at com.ibm.as400.access.AS400JDBCPreparedStatementImpl.<init>(AS400JDBCPreparedStatementImpl.java:357)
    at com.ibm.as400.access.AS400JDBCConnectionImpl.prepareStatement(AS400JDBCConnectionImpl.java:2312)
    at com.ibm.as400.access.AS400JDBCConnectionImpl.prepareStatement(AS400JDBCConnectionImpl.java:2083)
    at com.ibm.as400.access.AS400JDBCConnectionImpl.prepareStatement(AS400JDBCConnectionImpl.java:2078)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:292)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:292)
    at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$1.doPrepare(StatementPreparerImpl.java:87)
    at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:172)
    ... 41 more</init></init></init></init></clinit></init></init></clinit></clinit>

    may. 15, 2021 10:10:04 A. M. org.apache.catalina.core.StandardContext filterStart
    GRAVE: Exception starting filter [naviox]
    java.lang.RuntimeException: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
    at org.openxava.tools.SchemaTool.execute(Unknown Source)
    at org.openxava.tools.SchemaTool.generateSchema(Unknown Source)
    at com.openxava.naviox.impl.DB.createDB(DB.java:196)
    at com.openxava.naviox.impl.DB.init(DB.java:41)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not prepare statement
    at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)
    at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181)
    at org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1599)
    ... 36 more
    Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement
    at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)
    at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
    at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:182)
    at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareStatement(StatementPreparerImpl.java:78)
    at org.hibernate.engine.query.spi.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:97)
    at org.hibernate.internal.SessionImpl.executeNativeUpdate(SessionImpl.java:1592)
    at org.hibernate.query.internal.NativeQueryImpl.doExecuteUpdate(NativeQueryImpl.java:292)
    at org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1589)
    ... 36 more
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1790)
    at com.ibm.as400.access.AS400JDBCPreparedStatementImpl.<init>(AS400JDBCPreparedStatementImpl.java:357)
    at com.ibm.as400.access.AS400JDBCConnectionImpl.prepareStatement(AS400JDBCConnectionImpl.java:2312)
    at com.ibm.as400.access.AS400JDBCConnectionImpl.prepareStatement(AS400JDBCConnectionImpl.java:2083)
    at com.ibm.as400.access.AS400JDBCConnectionImpl.prepareStatement(AS400JDBCConnectionImpl.java:2078)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:292)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingConnection.prepareStatement(DelegatingConnection.java:292)
    at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$1.doPrepare(StatementPreparerImpl.java:87)
    at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:172)
    ... 41 more</init></init>

    may. 15, 2021 10:10:04 A. M. org.apache.catalina.core.StandardContext startInternal
    GRAVE: One or more Filters failed to start. Full details will be found in the appropriate container log file
    may. 15, 2021 10:10:04 A. M. org.apache.catalina.core.StandardContext startInternal
    GRAVE: Context [/ClientesPba1] startup failed due to previous errors
    may. 15, 2021 10:10:04 A. M. org.apache.catalina.loader.WebappClassLoaderBase clearReferencesJdbc
    ADVERTENCIA: The web application [ClientesPba1] registered the JDBC driver [com.ibm.as400.access.AS400JDBCDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
    may. 15, 2021 10:10:04 A. M. org.apache.coyote.AbstractProtocol start
    INFORMACIÓN: Starting ProtocolHandler ["http-nio-8080"]
    Aplicación iniciada. Ve a http://localhost:8080/ClientesPba1

    El fichero persistence.xml es el siguiente:
    <?xml version="1.0" encoding="UTF-8"?>

    <persistence xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemalocation="http://java.sun.com/xml/ns/persistence &lt;a href=" http:="" java.sun.com="" xml="" ns="" persistence="" persistence_1_0.xsd"="">http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd" version="1.0"></persistence>

    <persistence-unit name="default">
    <provider>org.hibernate.jpa.HibernatePersistenceProvider</provider>
    <non-jta-data-source>java://comp/env/jdbc/ClientesPba1DS</non-jta-data-source>
    <class>org.openxava.session.GalleryImage</class>
    <properties>
        <property name="hibernate.dialect" value="org.hibernate.dialect.DB2400Dialect"/>
        <property name="hibernate.default_schema" value="BWRESIDEN"/> 
    </properties>
</persistence-unit>

<persistence-unit name="junit">
    <provider>org.hibernate.jpa.HibernatePersistenceProvider</provider>
    <properties>
        <property name="hibernate.connection.driver_class" value="com.ibm.as400.access.AS400JDBCDriver"/>
         <property name="hibernate.dialect" value="org.hibernate.dialect.DB2400Dialect"/>
         <property name="hibernate.connection.url" value="jdbc:as400://10.100.100.1;naming=system;errors=full"/>
         <property name="hibernate.connection.username" value="wsuser"/>
         <property name="hibernate.connection.password" value="XELX2211Z"/> 
    </properties>
</persistence-unit>


    Gracias.
     

  • Javier Paniza

    Javier Paniza - 2021-05-17

    Hola Jesús:

    Según la traza lo que falla es esto:

    alter table BWRESIDEN.OXFOLDERS 
    add constraint FKlp3v9vj6d112rk1wsunkwl2rf 
    foreign key (parent_id) references BWRESIDEN.OXFOLDERS

    Prueba ejecutar directamente contra la base de datos la siguiente sentencia SQL:

    create table BWRESIDEN.OXFOLDERS (
    id varchar(32) not null, 
    icon varchar(40), 
    name varchar(25), 
    orderInFolder integer, 
    parent_id varchar(32), 
    primary key (id))

    Te debería de funcionar, sin problemas. Después ejecuta la siguiente:

    alter table BWRESIDEN.OXFOLDERS 
    add constraint FKlp3v9vj6d112rk1wsunkwl2rf 
    foreign key (parent_id) references BWRESIDEN.OXFOLDERS

    Debería falla y dar un error parecido al que da XavaPro al arrancar. ¿Es así?
    Si funciona bien, dímelo, si falla pruebalo de esta forma:

    alter table BWRESIDEN.OXFOLDERS add constraint BWRESIDEN.FKlp3v9vj6d112rk1wsunkwl2rf foreign key (parent_id) references BWRESIDEN.OXFOLDERS

    Fíjate que hemos prefijado la clave foranea. ¿Te funciona así?

    Ayuda a otros en este foro como yo te ayudo a ti.

     

    Last edit: Javier Paniza 2021-05-17

  • Jesús F. Hernández

    Jesús F. Hernández - 2021-05-19

    Hola Javier,
    Perdona que no te haya podido responder antes. He probado lo que comentas y efectivamente parece que es así, pero ahora el problema al ejecutar la aplicación OX es que la tabla OXFOLDERS ya existe.
    Lo que no entiendo es qué estoy haciendo mal para que no se me creen automáticamente todas las tablas OX*. Como te comenté yo creo tanto el esquema como la tabla en el AS400 con mandatos SQL (CREATE SCHEMA y CREATE TABLE).
    Te adjunto la traza de la nueva ejecución.

    Iniciando aplicación...
    may. 19, 2021 12:30:21 P. M. org.apache.coyote.AbstractProtocol init
    INFO: Initializing ProtocolHandler ["http-nio-8080"]
    may. 19, 2021 12:30:21 P. M. org.apache.catalina.core.StandardService startInternal
    INFO: Starting service [Tomcat]
    may. 19, 2021 12:30:21 P. M. org.apache.catalina.core.StandardEngine startInternal
    INFO: Starting Servlet engine: [Apache Tomcat/9.0.22]
    may. 19, 2021 12:30:22 P. M. org.apache.catalina.startup.ContextConfig getDefaultWebXmlFragment
    INFO: No global web.xml found
    may. 19, 2021 12:30:25 P. M. org.apache.jasper.servlet.TldScanner scanJars
    INFO: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
    may. 19, 2021 12:30:26 P. M. org.hibernate.jpa.internal.util.LogHelper logPersistenceUnitInformation
    INFO: HHH000204: Processing PersistenceUnitInfo
    name: default
    ...
    may. 19, 2021 12:30:26 P. M. org.hibernate.Version logVersion
    INFO: HHH000412: Hibernate Core {5.3.9.Final}
    may. 19, 2021 12:30:26 P. M. org.hibernate.cfg.Environment <clinit>
    INFO: HHH000206: hibernate.properties not found
    may. 19, 2021 12:30:26 P. M. org.hibernate.annotations.common.reflection.java.JavaReflectionManager <clinit>
    INFO: HCANN000001: Hibernate Commons Annotations {5.0.4.Final}
    WARNING: An illegal reflective access operation has occurred
    WARNING: Illegal reflective access by com.sun.xml.bind.v2.runtime.reflect.opt.Injector (file:/C:/openxava-6.5.1/workspace/ClientesPba1/web/WEB-INF/lib/jaxb-impl.jar) to method java.lang.ClassLoader.defineClass(java.lang.String,byte[],int,int)
    WARNING: Please consider reporting this to the maintainers of com.sun.xml.bind.v2.runtime.reflect.opt.Injector
    WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
    WARNING: All illegal access operations will be denied in a future release
    may. 19, 2021 12:30:27 P. M. org.hibernate.dialect.Dialect <init>
    INFO: HHH000400: Using dialect: org.hibernate.dialect.DB2400Dialect
    may. 19, 2021 12:30:28 P. M. org.hibernate.envers.boot.internal.EnversServiceImpl configure
    INFO: Envers integration enabled? : true
    may. 19, 2021 12:30:28 P. M. org.hibernate.id.UUIDHexGenerator <init>
    WARN: HHH000409: Using org.hibernate.id.UUIDHexGenerator which does not generate IETF RFC 4122 compliant UUID values; consider using org.hibernate.id.UUIDGenerator instead
    may. 19, 2021 12:30:28 P. M. org.hibernate.validator.internal.util.Version <clinit>
    INFO: HV000001: Hibernate Validator 6.0.15.Final
    may. 19, 2021 12:30:29 P. M. org.hibernate.jpa.internal.util.LogHelper logPersistenceUnitInformation
    INFO: HHH000204: Processing PersistenceUnitInfo
    name: default
    ...
    may. 19, 2021 12:30:29 P. M. org.hibernate.dialect.Dialect <init>
    INFO: HHH000400: Using dialect: org.hibernate.dialect.DB2400Dialect
    may. 19, 2021 12:30:30 P. M. org.hibernate.envers.boot.internal.EnversServiceImpl configure
    INFO: Envers integration enabled? : true
    may. 19, 2021 12:30:30 P. M. org.hibernate.hql.internal.QueryTranslatorFactoryInitiator initiateService
    INFO: HHH000397: Using ASTQueryTranslatorFactory
    may. 19, 2021 12:30:30 P. M. org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
    WARN: SQL Error: -204, SQLState: 42704
    may. 19, 2021 12:30:30 P. M. org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
    ERROR: [SQL0204] OXMODULES en BWRESIDEN de tipo FILE no encontrado.
    may. 19, 2021 12:30:30 P. M. com.openxava.naviox.impl.DB init
    INFO: Primera ejecución de XavaPro
    may. 19, 2021 12:30:30 P. M. com.openxava.naviox.impl.DB createDB
    INFO: Creando tablas de XavaPro...
    may. 19, 2021 12:30:30 P. M. org.hibernate.dialect.Dialect <init>
    INFO: HHH000400: Using dialect: org.hibernate.dialect.DB2400Dialect
    may. 19, 2021 12:30:30 P. M. org.hibernate.envers.boot.internal.EnversServiceImpl configure
    INFO: Envers integration enabled? : true
    may. 19, 2021 12:30:30 P. M. org.hibernate.tool.hbm2ddl.SchemaExport execute
    INFO: HHH000227: Running hbm2ddl schema export
    may. 19, 2021 12:30:30 P. M. org.hibernate.tool.schema.internal.SchemaCreatorImpl applyImportSources
    INFO: HHH000476: Executing import script 'org.hibernate.tool.schema.internal.exec.ScriptSourceInputNonExistentImpl@1b3a95c1'
    may. 19, 2021 12:30:30 P. M. org.openxava.tools.SchemaTool execute
    INFO: Ejecutando: create table BWRESIDEN.OXCONFIGURATION (id integer not null, forceChangePasswordDays integer not null, forceLetterAndNumbersInPasswd varchar(1) default 'N' not null, guestCanCreateAccount varchar(1) default 'Y' not null, guestCanCreateAccountInOrgs varchar(1) default 'Y' not null, inactiveDaysBeforeDisUser integer, lockSessionMinutes integer not null, loginAttemptsBeforeLocking integer not null, passwordMinLength integer not null, privacyPolicyOnSignUp varchar(1) default 'N' not null, recentPasswordsNotAllowed varchar(1) default 'N' not null, sharedUsersBetweenOrgs varchar(1) default 'N' not null, useEmailAsUserName varchar(1) default 'N' not null, primary key (id))
    may. 19, 2021 12:30:30 P. M. org.openxava.tools.SchemaTool execute
    INFO: Ejecutando: create table BWRESIDEN.OXFOLDERS (id varchar(32) not null, icon varchar(40), name varchar(25), orderInFolder integer, parent_id varchar(32), primary key (id))
    may. 19, 2021 12:30:30 P. M. org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
    WARN: SQL Error: -601, SQLState: 42710
    may. 19, 2021 12:30:30 P. M. org.hibernate.engine.jdbc.spi.SqlExceptionHelper logExceptions
    ERROR: [SQL0601] OXFOLDERS en BWRESIDEN de tipo </init>    FILE ya existe.
    may. 19, 2021 12:30:30 P. M. org.openxava.tools.SchemaTool execute
    SEVERE: org.hibernate.exception.SQLGrammarException: could not execute statement
    javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement
    at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)
    at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181)
    at org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1599)
    at org.openxava.tools.SchemaTool.execute(Unknown Source)
    at org.openxava.tools.SchemaTool.generateSchema(Unknown Source)
    at com.openxava.naviox.impl.DB.createDB(DB.java:196)
    at com.openxava.naviox.impl.DB.init(DB.java:41)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: org.hibernate.exception.SQLGrammarException: could not execute statement
    at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)
    at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
    at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:178)
    at org.hibernate.engine.query.spi.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:107)
    at org.hibernate.internal.SessionImpl.executeNativeUpdate(SessionImpl.java:1592)
    at org.hibernate.query.internal.NativeQueryImpl.doExecuteUpdate(NativeQueryImpl.java:292)
    at org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1589)
    ... 36 more
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL0601] OXFOLDERS en BWRESIDEN de tipo *FILE ya existe.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java:1075)
    at com.ibm.as400.access.AS400JDBCPreparedStatementImpl.executeUpdate(AS400JDBCPreparedStatementImpl.java:1861)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)
    at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:175)
    ... 40 more</init></init></clinit></init></init></clinit></clinit>

    may. 19, 2021 12:30:30 P. M. org.apache.catalina.core.StandardContext filterStart
    SEVERE: Exception starting filter [naviox]
    java.lang.RuntimeException: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement
    at org.openxava.tools.SchemaTool.execute(Unknown Source)
    at org.openxava.tools.SchemaTool.generateSchema(Unknown Source)
    at com.openxava.naviox.impl.DB.createDB(DB.java:196)
    at com.openxava.naviox.impl.DB.init(DB.java:41)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement
    at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)
    at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181)
    at org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1599)
    ... 36 more
    Caused by: org.hibernate.exception.SQLGrammarException: could not execute statement
    at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)
    at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
    at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:178)
    at org.hibernate.engine.query.spi.NativeSQLQueryPlan.performExecuteUpdate(NativeSQLQueryPlan.java:107)
    at org.hibernate.internal.SessionImpl.executeNativeUpdate(SessionImpl.java:1592)
    at org.hibernate.query.internal.NativeQueryImpl.doExecuteUpdate(NativeQueryImpl.java:292)
    at org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1589)
    ... 36 more
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL0601] OXFOLDERS en BWRESIDEN de tipo *FILE ya existe.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java:1075)
    at com.ibm.as400.access.AS400JDBCPreparedStatementImpl.executeUpdate(AS400JDBCPreparedStatementImpl.java:1861)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)
    at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:175)
    ... 40 more</init>

    may. 19, 2021 12:30:30 P. M. org.apache.catalina.core.StandardContext startInternal
    SEVERE: One or more Filters failed to start. Full details will be found in the appropriate container log file
    may. 19, 2021 12:30:30 P. M. org.apache.catalina.core.StandardContext startInternal
    SEVERE: Context [/ClientesPba1] startup failed due to previous errors
    may. 19, 2021 12:30:30 P. M. org.apache.catalina.loader.WebappClassLoaderBase clearReferencesJdbc
    WARNING: The web application [ClientesPba1] registered the JDBC driver [com.ibm.as400.access.AS400JDBCDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
    may. 19, 2021 12:30:30 P. M. org.apache.coyote.AbstractProtocol start
    INFO: Starting ProtocolHandler ["http-nio-8080"]

    Gracias y un saludo.

     

  • Javier Paniza

    Javier Paniza - 2021-05-19

    Hola Jesús:

    Para saber por donde tirar necesito las respuesta concretas a cada una de la dos preguntas. Te las vuelvo a poner.

    Prueba A:
    Sobre un OXFOLDERS recien creado:

    alter table BWRESIDEN.OXFOLDERS 
    add constraint FKlp3v9vj6d112rk1wsunkwl2rf 
    foreign key (parent_id) references BWRESIDEN.OXFOLDERS

    ¿Funciona o falla?

    Si funciona dímelo, si falla dime el error.

    Prueba B:
    Si la prueba A falla prueba esto:

    alter table BWRESIDEN.OXFOLDERS add constraint     BWRESIDEN.FKlp3v9vj6d112rk1wsunkwl2rf foreign key (parent_id) references     BWRESIDEN.OXFOLDERS

    Esto, ¿funciona o falla?

    Ayuda a otros en este foro como yo te ayudo a ti.

     

  • Jesús F. Hernández

    Jesús F. Hernández - 2021-05-19

    Hola Javier,
    La que ha funcionado ha sido la prueba B con la clave foranea prefijada.
    Te adjunto todos los pasos realizados tal como me indicabas:

    create table BWRESIDEN.OXFOLDERS (id varchar(32) not null, icon varchar(40), name varchar(25), orderInFolder integer, parent_id varchar(32), primary key (id))
    La sentencia se ha ejecutado satisfactoriamente (306 ms)

    alter table BWRESIDEN.OXFOLDERS add constraint FKlp3v9vj6d112rk1wsunkwl2rf foreign key (parent_id) references BWRESIDEN.OXFOLDERS
    Estado de SQL: 42875
    Código de proveedor: -5051
    Mensaje: [SQL5051] El calificador SPDHELP no coincide con el nombre BWRESIDEN. Causa . . . . . : Se ha producido una de las causas siguientes: -- Un objeto creado en una sentencia CREATE SCHEMA está calificado por un nombre diferente al nombre de esquema. Todos los objetos creados en una sentencia CREATE SCHEMA deben estar calificados por el nombre de esquema BWRESIDEN o no deben estar calificados. Los objetos no calificados lo están de forma implícita por el nombre de esquema. -- Un nombre de restricción se calificó con un nombre que no coincide con el calificador de la tabla. Una restricción para una tabla debe calificarse con el mismo esquema que califica la tabla. Si no se califica explícitamente, un nombre de restricción se califica implícitamente con el esquema por omisión, si se ha especificado alguna. De otro modo, el nombre de restricción se califica implícitamente con el ID de autorización para los nombres SQL y con el calificador del nombre de la tabla para los nombres del sistema. -- Una máscara o permiso se ha calificado con un nombre que no coincide con el calificador de la tabla. -- La tabla que se está definiendo como tabla de historial se ha calificado con un nombre que no coincide con el calificador de la tabla temporal de periodo de sistema. Recuperación . .: Realice una de las siguientes acciones y vuelva a intentar la petición : -- Califique explícitamente el objeto en el esquema con BWRESIDEN o elimine el calificador SPDHELP del nombre de objeto. -- Utilice el mismo calificador para el nombres de objeto y el nombre de tabla.
    El proceso ha finalizado porque la sentencia resaltada no se ha completado satisfactoriamente

    alter table BWRESIDEN.OXFOLDERS add constraint BWRESIDEN.FKlp3v9vj6d112rk1wsunkwl2rf foreign key (parent_id) references BWRESIDEN.OXFOLDERS
    La sentencia se ha ejecutado satisfactoriamente (240 ms)

    Gracias.

     

  • Javier Paniza

    Javier Paniza - 2021-05-20

    Hola Jesús:

    Gracias, era lo que sospechaba, no prefija el nombre de la clave foranea. Parece que es el dialecto para el AS/400 de Hibernate el que está fallando aquí, pero creo que podré encontrar una forma de arreglarlo desde OpenXava. Me lo he apuntado.

    Lo curioso, es que XavaPro sí que crea las tablas bien en el AS/400 en otros casos. Por lo que tiene que haber algo diferente en tu proyecto. Prueba activar la generación automática de schema, para ver si eso. Añade javax.persistence.schema-generation.database.action a tu unidad de persistencia con valor update, así:

    <persistence-unit name="default">
    <provider>org.hibernate.jpa.HibernatePersistenceProvider</provider>
    <non-jta-data-source>java://comp/env/jdbc/ClientesPba1DS</non-jta-data-source>
    <class>org.openxava.session.GalleryImage</class>
    <properties>
        <property name="hibernate.dialect" value="org.hibernate.dialect.DB2400Dialect"/>
        <property name="hibernate.default_schema" value="BWRESIDEN"/> 
        <property name="javax.persistence.schema-generation.database.action" value="update"/>
    </properties>
</persistence-unit>

    Pruébalo así y dime si te funciona.

    Ayuda a otros en este foro como yo te ayudo a ti.

     

  • Jesús F. Hernández

    Jesús F. Hernández - 2021-05-20

    Hola Javier,
    Como siempre has acertado!
    Al añadir esta línea en persistence.xml me ha creado las 11 tablas OX y el proyecto funciona:
    <property name="javax.persistence.schema-generation.database.action" value="update"></property>

    De todas maneras, aunque la aplicación parece funcionar correctamente, mirando la traza que crea previa a la ejecución, siguen apareciendo errores como el que indicaba anteriormente de
    "[SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN".
    Obviamente yo los ignoro, pero no sé si eso puede tener algún tipo repercusión futura en la ejecución.

    Te lo adjunto de todas maneras por si crees que hay algo que deba tener en cuenta y, lo dicho, muchas gracias por todo Javier.

    TRAZA:
    Iniciando aplicación...
    may. 20, 2021 7:17:21 P. M. org.apache.coyote.AbstractProtocol init
    INFO: Initializing ProtocolHandler ["http-nio-8080"]
    may. 20, 2021 7:17:21 P. M. org.apache.catalina.core.StandardService startInternal
    INFO: Starting service [Tomcat]
    may. 20, 2021 7:17:21 P. M. org.apache.catalina.core.StandardEngine startInternal
    INFO: Starting Servlet engine: [Apache Tomcat/9.0.22]
    may. 20, 2021 7:17:22 P. M. org.apache.catalina.startup.ContextConfig getDefaultWebXmlFragment
    INFO: No global web.xml found
    may. 20, 2021 7:17:31 P. M. org.apache.jasper.servlet.TldScanner scanJars
    INFO: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
    may. 20, 2021 7:17:31 P. M. org.apache.catalina.util.SessionIdGeneratorBase createSecureRandom
    WARNING: Creation of SecureRandom instance for session ID generation using [SHA1PRNG] took [362] milliseconds.
    may. 20, 2021 7:17:32 P. M. org.hibernate.jpa.internal.util.LogHelper logPersistenceUnitInformation
    INFO: HHH000204: Processing PersistenceUnitInfo
    name: default
    ...
    may. 20, 2021 7:17:32 P. M. org.hibernate.Version logVersion
    INFO: HHH000412: Hibernate Core {5.3.9.Final}
    may. 20, 2021 7:17:32 P. M. org.hibernate.cfg.Environment <clinit>
    INFO: HHH000206: hibernate.properties not found
    may. 20, 2021 7:17:33 P. M. org.hibernate.annotations.common.reflection.java.JavaReflectionManager <clinit>
    INFO: HCANN000001: Hibernate Commons Annotations {5.0.4.Final}
    WARNING: An illegal reflective access operation has occurred
    WARNING: Illegal reflective access by com.sun.xml.bind.v2.runtime.reflect.opt.Injector (file:/C:/openxava-6.5.1/workspace/ClientesPba1/web/WEB-INF/lib/jaxb-impl.jar) to method java.lang.ClassLoader.defineClass(java.lang.String,byte[],int,int)
    WARNING: Please consider reporting this to the maintainers of com.sun.xml.bind.v2.runtime.reflect.opt.Injector
    WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
    WARNING: All illegal access operations will be denied in a future release
    may. 20, 2021 7:17:37 P. M. org.hibernate.dialect.Dialect <init>
    INFO: HHH000400: Using dialect: org.hibernate.dialect.DB2400Dialect
    may. 20, 2021 7:17:40 P. M. org.hibernate.envers.boot.internal.EnversServiceImpl configure
    INFO: Envers integration enabled? : true
    may. 20, 2021 7:17:41 P. M. org.hibernate.id.UUIDHexGenerator <init>
    WARN: HHH000409: Using org.hibernate.id.UUIDHexGenerator which does not generate IETF RFC 4122 compliant UUID values; consider using org.hibernate.id.UUIDGenerator instead
    may. 20, 2021 7:17:42 P. M. org.hibernate.validator.internal.util.Version <clinit>
    INFO: HV000001: Hibernate Validator 6.0.15.Final
    may. 20, 2021 7:17:46 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "create table BWRESIDEN.IMAGES (ID varchar(255) not null, GALLERY varchar(255), IMAGE varchar(16777216) for bit data, primary key (ID))" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "create table BWRESIDEN.IMAGES (ID varchar(255) not null, GALLERY varchar(255), IMAGE varchar(16777216) for bit data, primary key (ID))" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.createTable(AbstractSchemaMigrator.java:277)
    at org.hibernate.tool.schema.internal.GroupedSchemaMigratorImpl.performTablesMigration(GroupedSchemaMigratorImpl.java:71)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:207)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.getHibernateDefaultSchemaPropertyName(Unknown Source)
    at org.openxava.jpa.XPersistence.getDefaultPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL0604] Atributos no válidos.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 54 more</init></clinit></init></clinit></init></init></clinit></clinit>

    may. 20, 2021 7:17:49 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "alter table BWRESIDEN.OXFOLDERS add constraint FKlp3v9vj6d112rk1wsunkwl2rf foreign key (parent_id) references BWRESIDEN.OXFOLDERS" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table BWRESIDEN.OXFOLDERS add constraint FKlp3v9vj6d112rk1wsunkwl2rf foreign key (parent_id) references BWRESIDEN.OXFOLDERS" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.getHibernateDefaultSchemaPropertyName(Unknown Source)
    at org.openxava.jpa.XPersistence.getDefaultPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 53 more</init></clinit></init>

    may. 20, 2021 7:17:49 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "alter table BWRESIDEN.OXMODULES add constraint FK5bx1gx2d8yiwpbk82e2nnc0sh foreign key (folder_id) references BWRESIDEN.OXFOLDERS" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table BWRESIDEN.OXMODULES add constraint FK5bx1gx2d8yiwpbk82e2nnc0sh foreign key (folder_id) references BWRESIDEN.OXFOLDERS" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.getHibernateDefaultSchemaPropertyName(Unknown Source)
    at org.openxava.jpa.XPersistence.getDefaultPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 53 more</init></clinit></init>

    may. 20, 2021 7:17:50 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "alter table BWRESIDEN.OXROLES_OXMODULES add constraint FKs58jxdqal45a7qvm0d4xt7id3 foreign key (roles_name) references BWRESIDEN.OXROLES" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table BWRESIDEN.OXROLES_OXMODULES add constraint FKs58jxdqal45a7qvm0d4xt7id3 foreign key (roles_name) references BWRESIDEN.OXROLES" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.getHibernateDefaultSchemaPropertyName(Unknown Source)
    at org.openxava.jpa.XPersistence.getDefaultPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 53 more</init></clinit></init>

    may. 20, 2021 7:17:50 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "alter table BWRESIDEN.OXROLES_OXMODULES add constraint FKtgaxpdnqnre5fqnre6vptqqpk foreign key (modules_name, modules_application) references BWRESIDEN.OXMODULES" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table BWRESIDEN.OXROLES_OXMODULES add constraint FKtgaxpdnqnre5fqnre6vptqqpk foreign key (modules_name, modules_application) references BWRESIDEN.OXMODULES" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.getHibernateDefaultSchemaPropertyName(Unknown Source)
    at org.openxava.jpa.XPersistence.getDefaultPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 53 more</init></clinit></init>

    may. 20, 2021 7:17:50 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "alter table BWRESIDEN.OXSESSIONSRECORD add constraint FKdwtw9vgwivinpffh0p00wsphr foreign key (user_name) references BWRESIDEN.OXUSERS" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table BWRESIDEN.OXSESSIONSRECORD add constraint FKdwtw9vgwivinpffh0p00wsphr foreign key (user_name) references BWRESIDEN.OXUSERS" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.getHibernateDefaultSchemaPropertyName(Unknown Source)
    at org.openxava.jpa.XPersistence.getDefaultPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 53 more</init></clinit></init>

    may. 20, 2021 7:17:50 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "alter table BWRESIDEN.OXUSERS_OXORGANIZATIONS add constraint FKeunblsb6qmnc6fcw8fdhbyqn2 foreign key (ORGANIZATIONS_ID) references BWRESIDEN.OXORGANIZATIONS" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table BWRESIDEN.OXUSERS_OXORGANIZATIONS add constraint FKeunblsb6qmnc6fcw8fdhbyqn2 foreign key (ORGANIZATIONS_ID) references BWRESIDEN.OXORGANIZATIONS" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.getHibernateDefaultSchemaPropertyName(Unknown Source)
    at org.openxava.jpa.XPersistence.getDefaultPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 53 more</init></clinit></init>

    may. 20, 2021 7:17:50 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "alter table BWRESIDEN.OXUSERS_OXORGANIZATIONS add constraint FK69m3xi014uyty428sxvb4gn5r foreign key (OXUSERS_NAME) references BWRESIDEN.OXUSERS" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table BWRESIDEN.OXUSERS_OXORGANIZATIONS add constraint FK69m3xi014uyty428sxvb4gn5r foreign key (OXUSERS_NAME) references BWRESIDEN.OXUSERS" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.getHibernateDefaultSchemaPropertyName(Unknown Source)
    at org.openxava.jpa.XPersistence.getDefaultPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 53 more</init></clinit></init>

    may. 20, 2021 7:17:50 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "alter table BWRESIDEN.OXUSERS_OXROLES add constraint FK4mq23r96bfd132cp2qbr6yr8y foreign key (ROLES_NAME) references BWRESIDEN.OXROLES" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table BWRESIDEN.OXUSERS_OXROLES add constraint FK4mq23r96bfd132cp2qbr6yr8y foreign key (ROLES_NAME) references BWRESIDEN.OXROLES" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.getHibernateDefaultSchemaPropertyName(Unknown Source)
    at org.openxava.jpa.XPersistence.getDefaultPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 53 more</init></clinit></init>

    may. 20, 2021 7:17:50 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "alter table BWRESIDEN.OXUSERS_OXROLES add constraint FKf6v8slnpkrswb38wcg5lihs4d foreign key (OXUSERS_NAME) references BWRESIDEN.OXUSERS" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table BWRESIDEN.OXUSERS_OXROLES add constraint FKf6v8slnpkrswb38wcg5lihs4d foreign key (OXUSERS_NAME) references BWRESIDEN.OXUSERS" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.getHibernateDefaultSchemaPropertyName(Unknown Source)
    at org.openxava.jpa.XPersistence.getDefaultPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 53 more</init></clinit></init>

    may. 20, 2021 7:17:51 P. M. org.hibernate.jpa.internal.util.LogHelper logPersistenceUnitInformation
    INFO: HHH000204: Processing PersistenceUnitInfo
    name: default
    ...
    may. 20, 2021 7:17:51 P. M. org.hibernate.dialect.Dialect <init>
    INFO: HHH000400: Using dialect: org.hibernate.dialect.DB2400Dialect
    may. 20, 2021 7:17:53 P. M. org.hibernate.envers.boot.internal.EnversServiceImpl configure
    INFO: Envers integration enabled? : true
    may. 20, 2021 7:17:55 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "create table BWRESIDEN.IMAGES (ID varchar(255) not null, GALLERY varchar(255), IMAGE varchar(16777216) for bit data, primary key (ID))" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "create table BWRESIDEN.IMAGES (ID varchar(255) not null, GALLERY varchar(255), IMAGE varchar(16777216) for bit data, primary key (ID))" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.createTable(AbstractSchemaMigrator.java:277)
    at org.hibernate.tool.schema.internal.GroupedSchemaMigratorImpl.performTablesMigration(GroupedSchemaMigratorImpl.java:71)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:207)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL0604] Atributos no válidos.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 50 more</init></clinit></init></init>

    may. 20, 2021 7:17:58 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "alter table BWRESIDEN.OXFOLDERS add constraint FKlp3v9vj6d112rk1wsunkwl2rf foreign key (parent_id) references BWRESIDEN.OXFOLDERS" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table BWRESIDEN.OXFOLDERS add constraint FKlp3v9vj6d112rk1wsunkwl2rf foreign key (parent_id) references BWRESIDEN.OXFOLDERS" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 49 more</init></clinit></init>

    may. 20, 2021 7:17:59 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "alter table BWRESIDEN.OXMODULES add constraint FK5bx1gx2d8yiwpbk82e2nnc0sh foreign key (folder_id) references BWRESIDEN.OXFOLDERS" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table BWRESIDEN.OXMODULES add constraint FK5bx1gx2d8yiwpbk82e2nnc0sh foreign key (folder_id) references BWRESIDEN.OXFOLDERS" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 49 more</init></clinit></init>

    may. 20, 2021 7:17:59 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "alter table BWRESIDEN.OXROLES_OXMODULES add constraint FKs58jxdqal45a7qvm0d4xt7id3 foreign key (roles_name) references BWRESIDEN.OXROLES" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table BWRESIDEN.OXROLES_OXMODULES add constraint FKs58jxdqal45a7qvm0d4xt7id3 foreign key (roles_name) references BWRESIDEN.OXROLES" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 49 more</init></clinit></init>

    may. 20, 2021 7:17:59 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "alter table BWRESIDEN.OXROLES_OXMODULES add constraint FKtgaxpdnqnre5fqnre6vptqqpk foreign key (modules_name, modules_application) references BWRESIDEN.OXMODULES" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table BWRESIDEN.OXROLES_OXMODULES add constraint FKtgaxpdnqnre5fqnre6vptqqpk foreign key (modules_name, modules_application) references BWRESIDEN.OXMODULES" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 49 more</init></clinit></init>

    may. 20, 2021 7:18:00 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "alter table BWRESIDEN.OXSESSIONSRECORD add constraint FKdwtw9vgwivinpffh0p00wsphr foreign key (user_name) references BWRESIDEN.OXUSERS" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table BWRESIDEN.OXSESSIONSRECORD add constraint FKdwtw9vgwivinpffh0p00wsphr foreign key (user_name) references BWRESIDEN.OXUSERS" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 49 more</init></clinit></init>

    may. 20, 2021 7:18:01 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "alter table BWRESIDEN.OXUSERS_OXORGANIZATIONS add constraint FKeunblsb6qmnc6fcw8fdhbyqn2 foreign key (ORGANIZATIONS_ID) references BWRESIDEN.OXORGANIZATIONS" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table BWRESIDEN.OXUSERS_OXORGANIZATIONS add constraint FKeunblsb6qmnc6fcw8fdhbyqn2 foreign key (ORGANIZATIONS_ID) references BWRESIDEN.OXORGANIZATIONS" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 49 more</init></clinit></init>

    may. 20, 2021 7:18:01 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "alter table BWRESIDEN.OXUSERS_OXORGANIZATIONS add constraint FK69m3xi014uyty428sxvb4gn5r foreign key (OXUSERS_NAME) references BWRESIDEN.OXUSERS" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table BWRESIDEN.OXUSERS_OXORGANIZATIONS add constraint FK69m3xi014uyty428sxvb4gn5r foreign key (OXUSERS_NAME) references BWRESIDEN.OXUSERS" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 49 more</init></clinit></init>

    may. 20, 2021 7:18:02 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "alter table BWRESIDEN.OXUSERS_OXROLES add constraint FK4mq23r96bfd132cp2qbr6yr8y foreign key (ROLES_NAME) references BWRESIDEN.OXROLES" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table BWRESIDEN.OXUSERS_OXROLES add constraint FK4mq23r96bfd132cp2qbr6yr8y foreign key (ROLES_NAME) references BWRESIDEN.OXROLES" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 49 more</init></clinit></init>

    may. 20, 2021 7:18:02 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "alter table BWRESIDEN.OXUSERS_OXROLES add constraint FKf6v8slnpkrswb38wcg5lihs4d foreign key (OXUSERS_NAME) references BWRESIDEN.OXUSERS" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table BWRESIDEN.OXUSERS_OXROLES add constraint FKf6v8slnpkrswb38wcg5lihs4d foreign key (OXUSERS_NAME) references BWRESIDEN.OXUSERS" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 49 more</init></clinit></init>

    may. 20, 2021 7:18:03 P. M. org.hibernate.hql.internal.QueryTranslatorFactoryInitiator initiateService
    INFO: HHH000397: Using ASTQueryTranslatorFactory
    may. 20, 2021 7:18:16 P. M. com.openxava.naviox.impl.DB createUserRolesConfiguration
    INFO: Creando configuración de usuarios y roles por defecto...
    may. 20, 2021 7:18:33 P. M. com.openxava.naviox.impl.DB createSelfSignUpRole
    INFO: Creando el rol self sign up
    may. 20, 2021 7:18:35 P. M. com.openxava.naviox.impl.DB createROOTFolder
    INFO: Creando carpeta ROOT
    may. 20, 2021 7:18:37 P. M. org.directwebremoting.impl.StartupUtil info
    INFO: DWR Version 2.0.10 starting.
    may. 20, 2021 7:18:37 P. M. org.directwebremoting.impl.StartupUtil info
    INFO: - Servlet Engine: Apache Tomcat/9.0.22
    may. 20, 2021 7:18:37 P. M. org.directwebremoting.impl.StartupUtil info
    INFO: - Java Version: 11.0.2
    may. 20, 2021 7:18:37 P. M. org.directwebremoting.impl.StartupUtil info
    INFO: - Java Vendor: Oracle Corporation
    may. 20, 2021 7:18:37 P. M. org.directwebremoting.dwrp.DefaultConverterManager info
    INFO: Probably not an issue: org.jdom.Document is not available so the jdom converter will not load. This is only a problem if you wanted to use it.
    may. 20, 2021 7:18:37 P. M. org.directwebremoting.dwrp.DefaultConverterManager info
    INFO: Probably not an issue: org.jdom.Element is not available so the jdom converter will not load. This is only a problem if you wanted to use it.
    may. 20, 2021 7:18:37 P. M. org.apache.coyote.AbstractProtocol start
    INFO: Starting ProtocolHandler ["http-nio-8080"]
    Aplicación iniciada. Ve a http://localhost:8080/ClientesPba1

     

  • Javier Paniza

    Javier Paniza - 2021-05-21

    Hola Jesús:

    Al añadir esta línea en persistence.xml me ha creado las 11 tablas OX y el proyecto funciona

    Genial, por lo menos ya tienes una solución y puedes seguir avanzando. He visto por la traza que pones que da exactamente la misma excepción, lo cual para mi tiene sentido, ya que si el error está en el dialecto de AS/400 tiene que fallar se haga por un sitio o por el otro. Las tablas las crea cuando usas generación automática de esquema, porque parece que confirma la transacción después de cada creación, por lo que lo que no falla lo ha creado.

    Lo que ha dejado de crear es una clave foranea, que en nuestro caso no es muy importante y todo te va a seguir funcionando. Sin embargo, la puedes crear tu directamente para más tranquilidad, ejecuta esto con la db:

    alter table BWRESIDEN.OXFOLDERS add constraint     BWRESIDEN.FKlp3v9vj6d112rk1wsunkwl2rf foreign key (parent_id) references     BWRESIDEN.OXFOLDERS

    Ayuda a otros en este foro como yo te ayudo a ti.

     

  • Jesús F. Hernández

    Jesús F. Hernández - 2021-05-23

    Hola Javier,
    He ejecutado sin problemas la sentencia SQL que me has indicado pero siguen apareciendo los errores que te comentaba en la traza anterior, aunque la aplicación funciona. El problema es seguir una traza tan extensa si surgen otros problemas de ejecución. ¿Debo hacer lo mismo en cada uno de los errores que aparecen? Es decir, ¿Ejecutar las sentencias erróneas de manera manual "calificando" la clave foránea?

    Te adjunto la última traza de ejecución, después de haber ejecutado la sentencia SQL de creación de la clave foránea.
    Muchas gracias por tu interés.

    Iniciando aplicación...
    may. 23, 2021 7:54:43 P. M. org.apache.coyote.AbstractProtocol init
    INFO: Initializing ProtocolHandler ["http-nio-8080"]
    may. 23, 2021 7:54:43 P. M. org.apache.catalina.core.StandardService startInternal
    INFO: Starting service [Tomcat]
    may. 23, 2021 7:54:43 P. M. org.apache.catalina.core.StandardEngine startInternal
    INFO: Starting Servlet engine: [Apache Tomcat/9.0.22]
    may. 23, 2021 7:54:44 P. M. org.apache.catalina.startup.ContextConfig getDefaultWebXmlFragment
    INFO: No global web.xml found
    may. 23, 2021 7:54:53 P. M. org.apache.jasper.servlet.TldScanner scanJars
    INFO: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
    may. 23, 2021 7:54:53 P. M. org.apache.catalina.util.SessionIdGeneratorBase createSecureRandom
    WARNING: Creation of SecureRandom instance for session ID generation using [SHA1PRNG] took [310] milliseconds.
    may. 23, 2021 7:54:54 P. M. org.hibernate.jpa.internal.util.LogHelper logPersistenceUnitInformation
    INFO: HHH000204: Processing PersistenceUnitInfo
    name: default
    ...
    may. 23, 2021 7:54:54 P. M. org.hibernate.Version logVersion
    INFO: HHH000412: Hibernate Core {5.3.9.Final}
    may. 23, 2021 7:54:54 P. M. org.hibernate.cfg.Environment <clinit>
    INFO: HHH000206: hibernate.properties not found
    may. 23, 2021 7:54:55 P. M. org.hibernate.annotations.common.reflection.java.JavaReflectionManager <clinit>
    INFO: HCANN000001: Hibernate Commons Annotations {5.0.4.Final}
    WARNING: An illegal reflective access operation has occurred
    WARNING: Illegal reflective access by com.sun.xml.bind.v2.runtime.reflect.opt.Injector (file:/C:/openxava-6.5.1/workspace/ClientesPba1/web/WEB-INF/lib/jaxb-impl.jar) to method java.lang.ClassLoader.defineClass(java.lang.String,byte[],int,int)
    WARNING: Please consider reporting this to the maintainers of com.sun.xml.bind.v2.runtime.reflect.opt.Injector
    WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
    WARNING: All illegal access operations will be denied in a future release
    may. 23, 2021 7:54:59 P. M. org.hibernate.dialect.Dialect <init>
    INFO: HHH000400: Using dialect: org.hibernate.dialect.DB2400Dialect
    may. 23, 2021 7:55:02 P. M. org.hibernate.envers.boot.internal.EnversServiceImpl configure
    INFO: Envers integration enabled? : true
    may. 23, 2021 7:55:03 P. M. org.hibernate.id.UUIDHexGenerator <init>
    WARN: HHH000409: Using org.hibernate.id.UUIDHexGenerator which does not generate IETF RFC 4122 compliant UUID values; consider using org.hibernate.id.UUIDGenerator instead
    may. 23, 2021 7:55:04 P. M. org.hibernate.validator.internal.util.Version <clinit>
    INFO: HV000001: Hibernate Validator 6.0.15.Final
    may. 23, 2021 7:55:09 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "create table BWRESIDEN.IMAGES (ID varchar(255) not null, GALLERY varchar(255), IMAGE varchar(16777216) for bit data, primary key (ID))" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "create table BWRESIDEN.IMAGES (ID varchar(255) not null, GALLERY varchar(255), IMAGE varchar(16777216) for bit data, primary key (ID))" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.createTable(AbstractSchemaMigrator.java:277)
    at org.hibernate.tool.schema.internal.GroupedSchemaMigratorImpl.performTablesMigration(GroupedSchemaMigratorImpl.java:71)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:207)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.getHibernateDefaultSchemaPropertyName(Unknown Source)
    at org.openxava.jpa.XPersistence.getDefaultPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL0604] Atributos no válidos.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 54 more</init></clinit></init></clinit></init></init></clinit></clinit>

    may. 23, 2021 7:55:15 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "alter table BWRESIDEN.OXMODULES add constraint FK5bx1gx2d8yiwpbk82e2nnc0sh foreign key (folder_id) references BWRESIDEN.OXFOLDERS" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table BWRESIDEN.OXMODULES add constraint FK5bx1gx2d8yiwpbk82e2nnc0sh foreign key (folder_id) references BWRESIDEN.OXFOLDERS" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.getHibernateDefaultSchemaPropertyName(Unknown Source)
    at org.openxava.jpa.XPersistence.getDefaultPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 53 more</init></clinit></init>

    may. 23, 2021 7:55:16 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "alter table BWRESIDEN.OXROLES_OXMODULES add constraint FKs58jxdqal45a7qvm0d4xt7id3 foreign key (roles_name) references BWRESIDEN.OXROLES" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table BWRESIDEN.OXROLES_OXMODULES add constraint FKs58jxdqal45a7qvm0d4xt7id3 foreign key (roles_name) references BWRESIDEN.OXROLES" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.getHibernateDefaultSchemaPropertyName(Unknown Source)
    at org.openxava.jpa.XPersistence.getDefaultPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 53 more</init></clinit></init>

    may. 23, 2021 7:55:16 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "alter table BWRESIDEN.OXROLES_OXMODULES add constraint FKtgaxpdnqnre5fqnre6vptqqpk foreign key (modules_name, modules_application) references BWRESIDEN.OXMODULES" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table BWRESIDEN.OXROLES_OXMODULES add constraint FKtgaxpdnqnre5fqnre6vptqqpk foreign key (modules_name, modules_application) references BWRESIDEN.OXMODULES" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.getHibernateDefaultSchemaPropertyName(Unknown Source)
    at org.openxava.jpa.XPersistence.getDefaultPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 53 more</init></clinit></init>

    may. 23, 2021 7:55:17 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "alter table BWRESIDEN.OXSESSIONSRECORD add constraint FKdwtw9vgwivinpffh0p00wsphr foreign key (user_name) references BWRESIDEN.OXUSERS" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table BWRESIDEN.OXSESSIONSRECORD add constraint FKdwtw9vgwivinpffh0p00wsphr foreign key (user_name) references BWRESIDEN.OXUSERS" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.getHibernateDefaultSchemaPropertyName(Unknown Source)
    at org.openxava.jpa.XPersistence.getDefaultPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 53 more</init></clinit></init>

    may. 23, 2021 7:55:18 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "alter table BWRESIDEN.OXUSERS_OXORGANIZATIONS add constraint FKeunblsb6qmnc6fcw8fdhbyqn2 foreign key (ORGANIZATIONS_ID) references BWRESIDEN.OXORGANIZATIONS" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table BWRESIDEN.OXUSERS_OXORGANIZATIONS add constraint FKeunblsb6qmnc6fcw8fdhbyqn2 foreign key (ORGANIZATIONS_ID) references BWRESIDEN.OXORGANIZATIONS" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.getHibernateDefaultSchemaPropertyName(Unknown Source)
    at org.openxava.jpa.XPersistence.getDefaultPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 53 more</init></clinit></init>

    may. 23, 2021 7:55:18 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "alter table BWRESIDEN.OXUSERS_OXORGANIZATIONS add constraint FK69m3xi014uyty428sxvb4gn5r foreign key (OXUSERS_NAME) references BWRESIDEN.OXUSERS" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table BWRESIDEN.OXUSERS_OXORGANIZATIONS add constraint FK69m3xi014uyty428sxvb4gn5r foreign key (OXUSERS_NAME) references BWRESIDEN.OXUSERS" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.getHibernateDefaultSchemaPropertyName(Unknown Source)
    at org.openxava.jpa.XPersistence.getDefaultPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 53 more</init></clinit></init>

    may. 23, 2021 7:55:19 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "alter table BWRESIDEN.OXUSERS_OXROLES add constraint FK4mq23r96bfd132cp2qbr6yr8y foreign key (ROLES_NAME) references BWRESIDEN.OXROLES" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table BWRESIDEN.OXUSERS_OXROLES add constraint FK4mq23r96bfd132cp2qbr6yr8y foreign key (ROLES_NAME) references BWRESIDEN.OXROLES" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.getHibernateDefaultSchemaPropertyName(Unknown Source)
    at org.openxava.jpa.XPersistence.getDefaultPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 53 more</init></clinit></init>

    may. 23, 2021 7:55:20 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "alter table BWRESIDEN.OXUSERS_OXROLES add constraint FKf6v8slnpkrswb38wcg5lihs4d foreign key (OXUSERS_NAME) references BWRESIDEN.OXUSERS" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table BWRESIDEN.OXUSERS_OXROLES add constraint FKf6v8slnpkrswb38wcg5lihs4d foreign key (OXUSERS_NAME) references BWRESIDEN.OXUSERS" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.getHibernateDefaultSchemaPropertyName(Unknown Source)
    at org.openxava.jpa.XPersistence.getDefaultPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getPersistenceUnitProperties(Unknown Source)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 53 more</init></clinit></init>

    may. 23, 2021 7:55:20 P. M. org.hibernate.jpa.internal.util.LogHelper logPersistenceUnitInformation
    INFO: HHH000204: Processing PersistenceUnitInfo
    name: default
    ...
    may. 23, 2021 7:55:20 P. M. org.hibernate.dialect.Dialect <init>
    INFO: HHH000400: Using dialect: org.hibernate.dialect.DB2400Dialect
    may. 23, 2021 7:55:23 P. M. org.hibernate.envers.boot.internal.EnversServiceImpl configure
    INFO: Envers integration enabled? : true
    may. 23, 2021 7:55:25 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "create table BWRESIDEN.IMAGES (ID varchar(255) not null, GALLERY varchar(255), IMAGE varchar(16777216) for bit data, primary key (ID))" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "create table BWRESIDEN.IMAGES (ID varchar(255) not null, GALLERY varchar(255), IMAGE varchar(16777216) for bit data, primary key (ID))" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.createTable(AbstractSchemaMigrator.java:277)
    at org.hibernate.tool.schema.internal.GroupedSchemaMigratorImpl.performTablesMigration(GroupedSchemaMigratorImpl.java:71)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:207)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL0604] Atributos no válidos.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 50 more</init></clinit></init></init>

    may. 23, 2021 7:55:31 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "alter table BWRESIDEN.OXMODULES add constraint FK5bx1gx2d8yiwpbk82e2nnc0sh foreign key (folder_id) references BWRESIDEN.OXFOLDERS" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table BWRESIDEN.OXMODULES add constraint FK5bx1gx2d8yiwpbk82e2nnc0sh foreign key (folder_id) references BWRESIDEN.OXFOLDERS" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 49 more</init></clinit></init>

    may. 23, 2021 7:55:32 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "alter table BWRESIDEN.OXROLES_OXMODULES add constraint FKs58jxdqal45a7qvm0d4xt7id3 foreign key (roles_name) references BWRESIDEN.OXROLES" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table BWRESIDEN.OXROLES_OXMODULES add constraint FKs58jxdqal45a7qvm0d4xt7id3 foreign key (roles_name) references BWRESIDEN.OXROLES" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 49 more</init></clinit></init>

    may. 23, 2021 7:55:32 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "alter table BWRESIDEN.OXROLES_OXMODULES add constraint FKtgaxpdnqnre5fqnre6vptqqpk foreign key (modules_name, modules_application) references BWRESIDEN.OXMODULES" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table BWRESIDEN.OXROLES_OXMODULES add constraint FKtgaxpdnqnre5fqnre6vptqqpk foreign key (modules_name, modules_application) references BWRESIDEN.OXMODULES" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 49 more</init></clinit></init>

    may. 23, 2021 7:55:33 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "alter table BWRESIDEN.OXSESSIONSRECORD add constraint FKdwtw9vgwivinpffh0p00wsphr foreign key (user_name) references BWRESIDEN.OXUSERS" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table BWRESIDEN.OXSESSIONSRECORD add constraint FKdwtw9vgwivinpffh0p00wsphr foreign key (user_name) references BWRESIDEN.OXUSERS" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 49 more</init></clinit></init>

    may. 23, 2021 7:55:34 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "alter table BWRESIDEN.OXUSERS_OXORGANIZATIONS add constraint FKeunblsb6qmnc6fcw8fdhbyqn2 foreign key (ORGANIZATIONS_ID) references BWRESIDEN.OXORGANIZATIONS" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table BWRESIDEN.OXUSERS_OXORGANIZATIONS add constraint FKeunblsb6qmnc6fcw8fdhbyqn2 foreign key (ORGANIZATIONS_ID) references BWRESIDEN.OXORGANIZATIONS" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 49 more</init></clinit></init>

    may. 23, 2021 7:55:35 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "alter table BWRESIDEN.OXUSERS_OXORGANIZATIONS add constraint FK69m3xi014uyty428sxvb4gn5r foreign key (OXUSERS_NAME) references BWRESIDEN.OXUSERS" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table BWRESIDEN.OXUSERS_OXORGANIZATIONS add constraint FK69m3xi014uyty428sxvb4gn5r foreign key (OXUSERS_NAME) references BWRESIDEN.OXUSERS" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 49 more</init></clinit></init>

    may. 23, 2021 7:55:36 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "alter table BWRESIDEN.OXUSERS_OXROLES add constraint FK4mq23r96bfd132cp2qbr6yr8y foreign key (ROLES_NAME) references BWRESIDEN.OXROLES" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table BWRESIDEN.OXUSERS_OXROLES add constraint FK4mq23r96bfd132cp2qbr6yr8y foreign key (ROLES_NAME) references BWRESIDEN.OXROLES" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 49 more</init></clinit></init>

    may. 23, 2021 7:55:36 P. M. org.hibernate.tool.schema.internal.ExceptionHandlerLoggedImpl handleException
    WARN: GenerationTarget encountered exception accepting command : Error executing DDL "alter table BWRESIDEN.OXUSERS_OXROLES add constraint FKf6v8slnpkrswb38wcg5lihs4d foreign key (OXUSERS_NAME) references BWRESIDEN.OXUSERS" via JDBC Statement
    org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table BWRESIDEN.OXUSERS_OXROLES add constraint FKf6v8slnpkrswb38wcg5lihs4d foreign key (OXUSERS_NAME) references BWRESIDEN.OXUSERS" via JDBC Statement
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249)
    at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:183)
    at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:72)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:310)
    at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:467)
    at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:939)
    at org.hibernate.jpa.HibernatePersistenceProvider.createEntityManagerFactory(HibernatePersistenceProvider.java:56)
    at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:79)
    at org.openxava.jpa.XPersistence.getEntityManagerFactory(Unknown Source)
    at org.openxava.jpa.XPersistence.createManager(Unknown Source)
    at org.openxava.jpa.XPersistence.openManager(Unknown Source)
    at org.openxava.jpa.XPersistence.getManager(Unknown Source)
    at com.openxava.naviox.impl.DB.<clinit>(DB.java:30)
    at com.openxava.naviox.Modules.init(Modules.java:40)
    at com.openxava.naviox.web.NaviOXFilter.init(NaviOXFilter.java:36)
    at org.apache.catalina.core.ApplicationFilterConfig.initFilter(ApplicationFilterConfig.java:270)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:251)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:102)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:4530)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5169)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:841)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1384)
    at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1374)
    at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
    at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
    at java.base/java.util.concurrent.AbstractExecutorService.submit(Unknown Source)
    at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:909)
    at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:262)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardService.startInternal(StandardService.java:421)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:932)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
    at org.apache.catalina.startup.Tomcat.start(Tomcat.java:456)
    at org.openxava.util.AppServer.startTomcat(Unknown Source)
    at org.openxava.util.AppServer.run(Unknown Source)
    at _run._Run_ClientesPba1.main(_Run_ClientesPba1.java:15)
    Caused by: com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL5051] El calificador WSUSER no coincide con el nombre BWRESIDEN.
    at com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:948)
    at com.ibm.as400.access.JDError.throwSQLException(JDError.java:745)
    at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1586)
    at com.ibm.as400.access.AS400JDBCStatement.execute(AS400JDBCStatement.java:2096)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:175)
    at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
    ... 49 more</init></clinit></init>

    may. 23, 2021 7:55:36 P. M. org.hibernate.hql.internal.QueryTranslatorFactoryInitiator initiateService
    INFO: HHH000397: Using ASTQueryTranslatorFactory
    may. 23, 2021 7:55:42 P. M. org.directwebremoting.impl.StartupUtil info
    INFO: DWR Version 2.0.10 starting.
    may. 23, 2021 7:55:42 P. M. org.directwebremoting.impl.StartupUtil info
    INFO: - Servlet Engine: Apache Tomcat/9.0.22
    may. 23, 2021 7:55:42 P. M. org.directwebremoting.impl.StartupUtil info
    INFO: - Java Version: 11.0.2
    may. 23, 2021 7:55:42 P. M. org.directwebremoting.impl.StartupUtil info
    INFO: - Java Vendor: Oracle Corporation
    may. 23, 2021 7:55:42 P. M. org.directwebremoting.dwrp.DefaultConverterManager info
    INFO: Probably not an issue: org.jdom.Document is not available so the jdom converter will not load. This is only a problem if you wanted to use it.
    may. 23, 2021 7:55:42 P. M. org.directwebremoting.dwrp.DefaultConverterManager info
    INFO: Probably not an issue: org.jdom.Element is not available so the jdom converter will not load. This is only a problem if you wanted to use it.
    may. 23, 2021 7:55:42 P. M. org.apache.coyote.AbstractProtocol start
    INFO: Starting ProtocolHandler ["http-nio-8080"]
    Aplicación iniciada. Ve a http://localhost:8080/ClientesPba1

     

  • Javier Paniza

    Javier Paniza - 2021-05-24

    Hola Jesús:

    El problema es seguir una traza tan extensa si surgen otros problemas de ejecución.

    Esto sólo debería ocurrir la primera vez que ejecutas XavaPro, una vez las tablas estén creadas no volveras a tener estas trazas.

    ¿Debo hacer lo mismo en cada uno de los errores que aparecen? Es decir, ¿Ejecutar las sentencias erróneas de manera manual "calificando" la clave foránea?

    Como quieras. Yo no lo haría. Lo normal es que si hay una referencia en Java en la base de datos haya una clave foranea. Lo curioso, es que los programadores de RPG no usan claves foraneas (entre otras cosa porque ellos no trabajan con nulos), y nosotros (los programadores Java) hemos mapeados las tablas de los programadores RPG con JPA toda la vida, sin que estén las clave foranea, y nadie ha muerto.

    Para la siguiente versión de OpenXava he modificado el código para que cree bien las claves foraneas de en el AS/400. Lo hago refinando la setencia que me devuelve Hibertante Tools antes de ejecutarlo. Lo malo es que esto solo va a funcionar cuando no se use evolución de schema automática, que es como tu lo intentaste al principio.

    Ayuda a otros en este foro como yo te ayudo a ti.

     

  • Jesús F. Hernández

    Jesús F. Hernández - 2021-05-24

    Perfecto Javier,
    En principio, lo dejaré tal cual está y seguiré mejorando mi proyecto en OpenXava e integrándolo con "mi mundo de origen" 400. ;-)

    Por cerrar este hilo, ¿Qué significa "cuando no se use evolución de schema automática"? ¿CRTLIB?

    Muchas gracias por todo.

     

  • Javier Paniza

    Javier Paniza - 2021-05-25

    Hola Jesús:

    ¿Qué significa "cuando no se use evolución de schema automática"?

    La evolución automática de esquema está activa si tu persitence.xml tiene esta línea:

    <property name="javax.persistence.schema-generation.database.action" value="update"/>

    Significa que ha medida que añadas o cambies tus entidades, se crearan o modificaran las tablas en la base de datos. Es decir, si creas una nueva entidad Java Recibo, se creará automáticamente una tabla RECIBO en tu base de datos. Si después le añades algún campo más a tu entidad en Java, automáticamente se hará un ALTER TABLE (cuando ejecutes la aplicación) y se añadirá esa columna.

    Por cierto, el bug de este hilo con el AS/400 ya lo he resuelto:
    https://openxava.org/XavaProjects/o/OpenXava/m/Issue?detail=ff8080817966cab2017989b2c95d004c
    Y estará disponible en la 6.5.2.

    Ayuda a otros en este foro como yo te ayudo a ti.

     

  • Jesús F. Hernández

    Jesús F. Hernández - 2021-05-25

    Hola Javier,
    Gracias por la aclaración y me alegro haber podido contribuir, aunque sea de forma indirecta, a mejorar OpenXava.
    Un saludo y gracias por tu dedicación.

     

Log in to post a comment.