wildfly 10 (linux) Error: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Every derived table must have its own alias

0

I'm using Genexus 15 U1. Generating the .war and running wildfly 10 (windows) works perfectly, however, when playing in linux, at the moment it will open the application, we have the following error:

  

2016-11-07 12: 17: 09,626 ERROR [io.undertow.request] (default task-14) UT005023: Exception handling request to /nfrr/servlet/com.sefaznfroraima.action: javax.servlet.ServletException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Every derived table must have its own alias           at sun.reflect.NativeConstructorAccessorImpl.newInstance0 (Native Method)           at sun.reflect.NativeConstructorAccessorImpl.newInstance (NativeConstructorAccessorImpl.java:62)           at sun.reflect.DelegatingConstructorAccessorImpl.newInstance (DelegatingConstructorAccessorImpl.java:45)           at java.lang.reflect.Constructor.newInstance (Constructor.java:423)           at com.mysql.jdbc.Util.handleNewInstance (Util.java:404)           at com.mysql.jdbc.Util.getInstance (Util.java:387)           at com.mysql.jdbc.SQLError.createSQLException (SQLError.java:942)           at com.mysql.jdbc.MysqlIO.checkErrorPacket (MysqlIO.java:3966)           at com.mysql.jdbc.MysqlIO.checkErrorPacket (MysqlIO.java:3902)           at com.mysql.jdbc.MysqlIO.sendCommand (MysqlIO.java:2526)           at com.mysql.jdbc.MysqlIO.sqlQueryDirect (MysqlIO.java:2673)           at com.mysql.jdbc.ConnectionImpl.execSQL (ConnectionImpl.java:2549)           at com.mysql.jdbc.PreparedStatement.executeInternal (PreparedStatement.java:1861)           at com.mysql.jdbc.PreparedStatement.executeQuery (PreparedStatement.java:1962)           at com.genexus.db.driver.GXDBMSmysql.executeQuery (Unknown Source)           at com.genexus.db.driver.GXPreparedStatement.executeQuery (Unknown Source)           at com.genexus.db.ForEachCursor.postExecute (Unknown Source)           at com.genexus.db.DataStoreProvider.execute (Unknown Source)           at com.genexus.db.DataStoreProvider.execute (Unknown Source)           at artech.security.api.gamloadrepositorycache.privateExecute (gamloadrepositorycache.java:65)           at artech.security.api.gamloadrepositorycache.execute_int (gamloadrepositorycache.java:58)           at artech.security.api.gamloadrepositorycache.execute (gamloadrepositorycache.java:45)           at artech.security.api.gamgetrepositoryconnection.privateExecute (gamgetrepositoryconnection.java:85)           at artech.security.api.gamgetrepositoryconnection.execute_int (gamgetrepositoryconnection.java:58)           at artech.security.api.gamgetrepositoryconnection.execute (gamgetrepositoryconnection.java:45)           at artech.security.api.getcurrentusername.privateExecute (getcurrentusername.java:58)           at artech.security.api.getcurrentusername.execute_int (getcurrentusername.java:49)           at artech.security.api.getcurrentusername.execute (getcurrentusername.java:40)           at artech.security.GAMUser.GetName (GAMUser.java:479)           at com.sefaznfroraima.SdtGAMUser.getname (SdtGAMUser.java:98)           at com.sefaznfroraima.action_impl.e11562 (action_impl.java:727)

Wildfly Server 10 Genexus 15 U1 MySQL 5.5.52

Remembering, the same .war works on wildfly 10 windows.

    
asked by anonymous 07.11.2016 / 17:16

0 answers