0
I’m wearing Genexus 15 U1. By generating the . War and running from wildfly 10 (windows) works perfectly, however, when playing on linux, the moment you 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) com.mysql.jdbc.PreparedStatement.executeInternal(Preparedstatement.java:1861) 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.
By the error seems to me a request error to the server or authentication (I presume), the linux machine has access to the Mysql server?
– Guilherme Nascimento
look what I identified. Imagine the file app.War <br /> when we run deploy on some computers, the generated select is: <br /><br /> select field1, field2 from table <br /><br /> when the same file is deployed on the server, the generated select is: <br /><br /> select * from (select field1, field2 from table) <br/> <br /> , and in this subquery, he does not enter the alias. also we have done tests on another linux machine, and works normal.
– Claudio Pereira
Did you upload the server settings correctly, or did you forget to upload something?
– Guilherme Nascimento