API tools faq
paste
Guest User

Untitled

a guest
Mar 13th, 2017
112
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 55.54 KB | None | 0 0
raw download clone embed print report
  1. package zesp03.rest.resource;
  2.  
  3. import zesp03.common.Database;
  4. import zesp03.data.BuildingData;
  5. import zesp03.entity.Building;
  6. import zesp03.entity.Link_unit_building;
  7.  
  8. import javax.persistence.EntityManager;
  9. import javax.persistence.EntityTransaction;
  10. import javax.ws.rs.*;
  11. import java.util.List;
  12.  
  13. /**
  14.  * Created by Berent on 2017-03-13.
  15.  */
  16.  
  17. @Path("building")
  18. public class BuildingResource {
  19.  
  20.         @GET
  21.         @Produces("application/json")
  22.         public BuildingData getBuilding(
  23.                 @QueryParam("id") long id)
  24.                  {
  25.             BuildingData result = null;
  26.  
  27.             EntityManager em = null;
  28.             EntityTransaction tran = null;
  29.             try {
  30.                 em = Database.createEntityManager();
  31.                 tran = em.getTransaction();
  32.                 tran.begin();
  33.  
  34.                 List<Object[]> list = em.createQuery("SELECT b, u, lub FROM Link_unit_building lub" +
  35.                         "INNER JOIN b.building b " +
  36.                         "INNER JOIN lub.linkunitbuilding lub " +
  37.                         "INNER JOIN lub.unit u " +
  38.                         "WHERE b.id = :id", Object[].class)
  39.                         .getResultList();
  40.                 if (!list.isEmpty()) {
  41.                     Object[] arr = list.get(0);
  42.                     Building b = (Building) arr[1];
  43.                     Link_unit_building lub= (Link_unit_building) arr[2];
  44.                     result = new BuildingData(b,lub );
  45.                 }
  46.  
  47.  
  48.  
  49.                 tran.commit();
  50.             } catch (RuntimeException exc) {
  51.                 if (tran != null && tran.isActive()) tran.rollback();
  52.                 throw exc;
  53.             } finally {
  54.                 if (em != null) em.close();
  55.             }
  56.  
  57.             if (result == null)
  58.                 throw new NotFoundException();
  59.             return result;
  60.         }
  61. }
  62.  
  63. ---------------------------------------------------------------------------------------------------------------------------------------
  64. package zesp03.data;
  65.  
  66. import zesp03.data.row.BuildingRow;
  67. import zesp03.data.row.UnitRow;
  68. import zesp03.entity.Building;
  69. import zesp03.entity.Link_unit_building;
  70.  
  71. /**
  72.  * Created by Berent on 2017-03-13.
  73.  */
  74. public class BuildingData {
  75.     private Long id;
  76.     private String code;
  77.     private String name;
  78.     private Number latitude;
  79.     private Number longitude;
  80.     private Long unitId;
  81.     private String unitCode;
  82.     private String unitDescription;
  83.  
  84.     public BuildingData(){
  85.  
  86.     }
  87. public BuildingData(BuildingRow building, UnitRow unit) {
  88.         this.id = building.getId();
  89.         this.code = building.getCode();
  90.         this.name = building.getName();
  91.         this.longitude = building.getLongitude();
  92.         this.latitude = building.getLatitude();
  93.         this.unitId = unit.getId();
  94.         this.unitCode = unit.getCode();
  95.         this.unitDescription = unit.getDescription();
  96.  
  97. }
  98.     public BuildingData(Building building, Link_unit_building linkunitbuilding) {
  99.         this.id = building.getId();
  100.         this.code = building.getCode();
  101.         this.name = building.getName();
  102.         this.longitude = building.getLongitude();
  103.         this.latitude = building.getLatitude();
  104.         this.unitId = linkunitbuilding.getUnit().getId();
  105.         this.unitCode = linkunitbuilding.getUnit().getCode();
  106.         this.unitDescription = linkunitbuilding.getUnit().getDescription();
  107.  
  108.     }
  109.  
  110.     public long getId() {
  111.         return id;
  112.     }
  113.  
  114.     public void setId(long id) {
  115.         this.id = id;
  116.     }
  117.  
  118.     public String getName() {
  119.         return name;
  120.     }
  121.  
  122.     public void setName(String name) {
  123.         this.name = name;
  124.     }
  125.  
  126.     public String getCode() {
  127.         return code;
  128.     }
  129.  
  130.     public void setCode(String code) {
  131.         this.code = code;
  132.     }
  133.  
  134.     public Number getLatitude() {
  135.         return latitude;
  136.     }
  137.  
  138.     public void setLatitude(Number latitude) {
  139.         this.latitude = latitude;
  140.     }
  141.  
  142.     public Number getLongitude() {
  143.         return longitude;
  144.     }
  145.  
  146.     public void setLongitude(Number longitude) { this.longitude = longitude;
  147.     }
  148.  
  149.     public long getUnitId() {
  150.         return unitId;
  151.     }
  152.  
  153.     public void setUnitId(long unitId) {
  154.         this.unitId = unitId;
  155.     }
  156.  
  157.     public String getUnitCode() {
  158.         return unitCode;
  159.     }
  160.  
  161.     public void setUnitCode(String unitCode) {
  162.         this.unitCode = unitCode;
  163.     }
  164.  
  165.     public String getUnitDescription() {
  166.         return unitDescription;
  167.     }
  168.  
  169.     public void setUnitDescription(String unitDescription) {
  170.         this.unitDescription = unitDescription;
  171.     }
  172.  
  173. }
  174.  
  175. tu na podobe bylo: ale u mnie nie działa a tu na dole działa
  176. _____________________________________________________________________________________________________________________________________
  177. package zesp03.data;
  178.  
  179. import zesp03.data.row.DeviceRow;
  180. import zesp03.data.row.DeviceSurveyRow;
  181. import zesp03.entity.Device;
  182. import zesp03.entity.DeviceSurvey;
  183.  
  184. public class DeviceData {
  185.     private long id;
  186.     private String name;
  187.     private boolean known;
  188.     private String description;
  189.     private long controllerId;
  190.     private int lastSurveyTimestamp;
  191.     private boolean enabled;
  192.     private int clientsSum;
  193.  
  194.     public DeviceData() {
  195.     }
  196.  
  197.     public DeviceData(DeviceRow device, DeviceSurveyRow survey) {
  198.         this.id = device.getId();
  199.         this.name = device.getName();
  200.         this.known = device.isKnown();
  201.         this.description = device.getDescription();
  202.         this.controllerId = device.getControllerId();
  203.         this.lastSurveyTimestamp = survey.getTimestamp();
  204.         this.enabled = survey.isEnabled();
  205.         this.clientsSum = survey.getClientsSum();
  206.     }
  207.  
  208.     /**
  209.      * Device and DeviceSurvey entities should be in managed state.
  210.      */
  211.     public DeviceData(Device device, DeviceSurvey survey) {
  212.         this.id = device.getId();
  213.         this.name = device.getName();
  214.         this.known = device.isKnown();
  215.         this.description = device.getDescription();
  216.         this.controllerId = device.getController().getId();
  217.         this.lastSurveyTimestamp = survey.getTimestamp();
  218.         this.enabled = survey.isEnabled();
  219.         this.clientsSum = survey.getClientsSum();
  220.     }
  221.  
  222.     public long getId() {
  223.         return id;
  224.     }
  225.  
  226.     public void setId(long id) {
  227.         this.id = id;
  228.     }
  229.  
  230.     public String getName() {
  231.         return name;
  232.     }
  233.  
  234.     public void setName(String name) {
  235.         this.name = name;
  236.     }
  237.  
  238.     public boolean isKnown() {
  239.         return known;
  240.     }
  241.  
  242.     public void setKnown(boolean known) {
  243.         this.known = known;
  244.     }
  245.  
  246.     public String getDescription() {
  247.         return description;
  248.     }
  249.  
  250.     public void setDescription(String description) {
  251.         this.description = description;
  252.     }
  253.  
  254.     public long getControllerId() {
  255.         return controllerId;
  256.     }
  257.  
  258.     public void setControllerId(long controllerId) {
  259.         this.controllerId = controllerId;
  260.     }
  261.  
  262.     public int getLastSurveyTimestamp() {
  263.         return lastSurveyTimestamp;
  264.     }
  265.  
  266.     public void setLastSurveyTimestamp(int lastSurveyTimestamp) {
  267.         this.lastSurveyTimestamp = lastSurveyTimestamp;
  268.     }
  269.  
  270.     public boolean isEnabled() {
  271.         return enabled;
  272.     }
  273.  
  274.     public void setEnabled(boolean enabled) {
  275.         this.enabled = enabled;
  276.     }
  277.  
  278.     public int getClientsSum() {
  279.         return clientsSum;
  280.     }
  281.  
  282.     public void setClientsSum(int clientsSum) {
  283.         this.clientsSum = clientsSum;
  284.     }
  285. }
  286. ----------------------------------------------------------------------------------------------------------------------------------
  287. package zesp03.rest.resource;
  288.  
  289. import zesp03.common.Database;
  290. import zesp03.data.DeviceData;
  291. import zesp03.entity.Device;
  292. import zesp03.entity.DeviceSurvey;
  293.  
  294. import javax.persistence.EntityManager;
  295. import javax.persistence.EntityTransaction;
  296. import javax.ws.rs.*;
  297. import java.util.List;
  298.  
  299. @Path("device")
  300. public class DeviceResource {
  301.     @GET
  302.     @Produces("application/json")
  303.     public DeviceData getDevice(
  304.             @QueryParam("id") long id) {
  305.         DeviceData result = null;
  306.  
  307.         EntityManager em = null;
  308.         EntityTransaction tran = null;
  309.         try {
  310.             em = Database.createEntityManager();
  311.             tran = em.getTransaction();
  312.             tran.begin();
  313.  
  314.             //TODO sprawdź wydajność SQL
  315.             //TODO może left join
  316.             List<Object[]> list = em.createQuery("SELECT c, d, ds, cs FROM CurrentSurvey cs " +
  317.                     "INNER JOIN cs.survey ds " +
  318.                     "INNER JOIN ds.device d " +
  319.                     "INNER JOIN d.controller c " +
  320.                     "WHERE d.id = :id", Object[].class)
  321.                     .setParameter("id", id)
  322.                     .getResultList();
  323.             if (!list.isEmpty()) {
  324.                 Object[] arr = list.get(0);
  325.                 Device d = (Device) arr[1];
  326.                 DeviceSurvey ds = (DeviceSurvey) arr[2];
  327.                 result = new DeviceData(d, ds);
  328.             }
  329.  
  330.             tran.commit();
  331.         } catch (RuntimeException exc) {
  332.             if (tran != null && tran.isActive()) tran.rollback();
  333.             throw exc;
  334.         } finally {
  335.             if (em != null) em.close();
  336.         }
  337.  
  338.         if (result == null)
  339.             throw new NotFoundException();
  340.         return result;
  341.     }
  342. }
  343. ---------------------------------------------------------------------------------------------------------------------------------------
  344. błędy u mnie:
  345. -------------------------------------------------------------------------------------------------------------------------------------
  346. "C:\Program Files (x86)\Apache Software Foundation\Tomcat 8.5\bin\catalina.bat" run
  347. [2017-03-13 07:32:18,000] Artifact server-webapp:war exploded: Server is not connected. Deploy is not available.
  348. Using CATALINA_BASE:   "C:\Users\Media\.IntelliJIdea2016.3\system\tomcat\Unnamed_NetworkMonitor_2"
  349. Using CATALINA_HOME:   "C:\Program Files (x86)\Apache Software Foundation\Tomcat 8.5"
  350. Using CATALINA_TMPDIR: "C:\Program Files (x86)\Apache Software Foundation\Tomcat 8.5\temp"
  351. Using JRE_HOME:        "C:\PROGRA~1\Java\JDK18~1.0_7"
  352. Using CLASSPATH:       "C:\Program Files (x86)\Apache Software Foundation\Tomcat 8.5\bin\bootstrap.jar;C:\Program Files (x86)\Apache Software Foundation\Tomcat 8.5\bin\tomcat-juli.jar"
  353. 13-Mar-2017 19:32:19.374 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version:        Apache Tomcat/8.5.8
  354. 13-Mar-2017 19:32:19.374 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built:          Nov 3 2016 21:14:13 UTC
  355. 13-Mar-2017 19:32:19.374 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number:         8.5.8.0
  356. 13-Mar-2017 19:32:19.374 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name:               Windows 10
  357. 13-Mar-2017 19:32:19.374 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version:            10.0
  358. 13-Mar-2017 19:32:19.374 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture:          amd64
  359. 13-Mar-2017 19:32:19.374 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home:             C:\PROGRA~1\Java\JDK18~1.0_7\jre
  360. 13-Mar-2017 19:32:19.374 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version:           1.8.0_73-b02
  361. 13-Mar-2017 19:32:19.374 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor:            Oracle Corporation
  362. 13-Mar-2017 19:32:19.374 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE:         C:\Users\Media\.IntelliJIdea2016.3\system\tomcat\Unnamed_NetworkMonitor_2
  363. 13-Mar-2017 19:32:19.374 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME:         C:\Program Files (x86)\Apache Software Foundation\Tomcat 8.5
  364. 13-Mar-2017 19:32:19.390 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote=
  365. 13-Mar-2017 19:32:19.390 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote.port=1099
  366. 13-Mar-2017 19:32:19.390 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote.ssl=false
  367. 13-Mar-2017 19:32:19.390 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcom.sun.management.jmxremote.authenticate=false
  368. 13-Mar-2017 19:32:19.390 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.rmi.server.hostname=127.0.0.1
  369. 13-Mar-2017 19:32:19.390 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
  370. 13-Mar-2017 19:32:19.390 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources
  371. 13-Mar-2017 19:32:19.390 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=C:\Users\Media\.IntelliJIdea2016.3\system\tomcat\Unnamed_NetworkMonitor_2\conf\logging.properties
  372. 13-Mar-2017 19:32:19.390 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
  373. 13-Mar-2017 19:32:19.390 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=C:\Users\Media\.IntelliJIdea2016.3\system\tomcat\Unnamed_NetworkMonitor_2
  374. 13-Mar-2017 19:32:19.390 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=C:\Program Files (x86)\Apache Software Foundation\Tomcat 8.5
  375. 13-Mar-2017 19:32:19.390 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=C:\Program Files (x86)\Apache Software Foundation\Tomcat 8.5\temp
  376. 13-Mar-2017 19:32:19.390 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\PROGRA~1\Java\JDK18~1.0_7\bin;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\ProgramData\Oracle\Java\javapath;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Windows Live\Shared;C:\Program Files (x86)\ATI Technologies\ATI.ACE\Core-Static;C:\Program Files (x86)\AMD\ATI.ACE\Core-Static;C:\Program Files (x86)\Skype\Phone\;C:\Qt\4.8.5\bin;C:\Program Files\Java\jdk1.7.0_79\bin;C:\Users\Media\Downloads\android-ndk-r10e;C:\Program Files\Predictive Solutions\PS IMAGO\4\IBM\SPSS\Statistics\24\JRE\bin;C:\Program Files\Predictive Solutions\PS IMAGO\4\Process;C:\Program Files (x86)\Satsuki Decoder Pack\Filtres;C:\Users\Media\AppData\Local\Microsoft\WindowsApps;;.
  377. 13-Mar-2017 19:32:19.890 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8081"]
  378. 13-Mar-2017 19:32:19.952 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
  379. 13-Mar-2017 19:32:19.952 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["ajp-nio-8009"]
  380. 13-Mar-2017 19:32:19.952 INFO [main] org.apache.tomcat.util.net.NioSelectorPool.getSharedSelector Using a shared selector for servlet write/read
  381. 13-Mar-2017 19:32:19.968 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 1227 ms
  382. 13-Mar-2017 19:32:20.046 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service Catalina
  383. 13-Mar-2017 19:32:20.046 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.5.8
  384. 13-Mar-2017 19:32:20.077 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler [http-nio-8081]
  385. 13-Mar-2017 19:32:20.097 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler [ajp-nio-8009]
  386. 13-Mar-2017 19:32:20.099 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 131 ms
  387. Connected to server
  388. [2017-03-13 07:32:20,537] Artifact server-webapp:war exploded: Artifact is being deployed, please wait...
  389. 13-Mar-2017 19:32:23.496 INFO [RMI TCP Connection(3)-127.0.0.1] org.apache.jasper.servlet.TldScanner.scanJars 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.
  390. 2017-03-13 19:32:24 INFO  org.flywaydb.core.internal.util.VersionPrinter info 44; Flyway 4.1.1 by Boxfuse
  391. 2017-03-13 19:32:24 INFO  org.flywaydb.core.internal.dbsupport.DbSupportFactory info 44; Database: jdbc:mysql://localhost:3306/pz?useSSL=false&rewriteBatchedStatements=true (MySQL 5.7)
  392. 2017-03-13 19:32:24 INFO  org.flywaydb.core.internal.command.DbValidate info 44; Successfully validated 3 migrations (execution time 00:00.102s)
  393. 2017-03-13 19:32:24 INFO  org.flywaydb.core.internal.command.DbMigrate info 44; Current version of schema `pz`: 2017.03.05.1
  394. 2017-03-13 19:32:24 INFO  org.flywaydb.core.internal.command.DbMigrate info 44; Schema `pz` is up to date. No migration necessary.
  395. 2017-03-13 19:32:25 INFO  org.hibernate.jpa.internal.util.LogHelper logPersistenceUnitInformation 31; HHH000204: Processing PersistenceUnitInfo [
  396.     name: CRM
  397.     ...]
  398. 2017-03-13 19:32:25 INFO  org.hibernate.Version logVersion 45; HHH000412: Hibernate Core {5.2.6.Final}
  399. 2017-03-13 19:32:25 INFO  org.hibernate.cfg.Environment <clinit> 213; HHH000206: hibernate.properties not found
  400. 2017-03-13 19:32:25 INFO  org.hibernate.annotations.common.Version <clinit> 66; HCANN000001: Hibernate Commons Annotations {5.0.1.Final}
  401. 2017-03-13 19:32:26 INFO  org.hibernate.engine.jdbc.connections.internal.ConnectionProviderInitiator initiateService 122; HHH000130: Instantiating explicit connection provider: org.hibernate.hikaricp.internal.HikariCPConnectionProvider
  402. 2017-03-13 19:32:26 INFO  com.zaxxer.hikari.HikariDataSource <init> 70; HikariPool-1 - Started.
  403. 2017-03-13 19:32:26 INFO  org.hibernate.dialect.Dialect <init> 157; HHH000400: Using dialect: org.hibernate.dialect.MySQL57InnoDBDialect
  404. 2017-03-13 19:32:28 INFO  org.hibernate.orm.connections.access getIsolatedConnection 47; HHH10001501: Connection obtained from JdbcConnectionAccess [org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$ConnectionProviderJdbcConnectionAccess@52c9a8c1] for (non-JTA) DDL execution was not in auto-commit mode; the Connection 'local transaction' will be committed and the Connection will be set into auto-commit mode.
  405. 2017-03-13 19:32:29 INFO  org.hibernate.hql.internal.QueryTranslatorFactoryInitiator initiateService 47; HHH000397: Using ASTQueryTranslatorFactory
  406. 13-Mar-2017 19:32:30.081 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory C:\Program Files (x86)\Apache Software Foundation\Tomcat 8.5\webapps\manager
  407. 13-Mar-2017 19:32:30.284 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory C:\Program Files (x86)\Apache Software Foundation\Tomcat 8.5\webapps\manager has finished in 203 ms
  408. [2017-03-13 07:32:31,982] Artifact server-webapp:war exploded: Artifact is deployed successfully
  409. [2017-03-13 07:32:31,982] Artifact server-webapp:war exploded: Deploy took 11 445 milliseconds
  410. 2017-03-13 19:32:40 ERROR org.hibernate.hql.internal.ast.ErrorCounter reportError 60;  Invalid path: 'b.building'
  411. 2017-03-13 19:32:40 ERROR org.hibernate.hql.internal.ast.ErrorCounter reportError 55;  Invalid path: 'b.building'
  412.  Invalid path: 'b.building'
  413.     at org.hibernate.hql.internal.ast.util.LiteralProcessor.lookupConstant(LiteralProcessor.java:111)
  414.     at org.hibernate.hql.internal.ast.tree.DotNode.resolve(DotNode.java:214)
  415.     at org.hibernate.hql.internal.ast.tree.FromReferenceNode.resolve(FromReferenceNode.java:109)
  416.     at org.hibernate.hql.internal.ast.HqlSqlWalker.createFromJoinElement(HqlSqlWalker.java:398)
  417.     at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.joinElement(HqlSqlBaseWalker.java:3915)
  418.     at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3701)
  419.     at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:3579)
  420.     at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:718)
  421.     at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:574)
  422.     at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:311)
  423.     at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:259)
  424.     at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:261)
  425.     at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:189)
  426.     at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:141)
  427.     at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:115)
  428.     at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
  429.     at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:153)
  430.     at org.hibernate.internal.AbstractSharedSessionContract.getQueryPlan(AbstractSharedSessionContract.java:545)
  431.     at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:654)
  432.     at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:678)
  433.     at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:23)
  434.     at zesp03.rest.resource.BuildingResource.getBuilding(BuildingResource.java:34)
  435.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  436.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  437.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  438.     at java.lang.reflect.Method.invoke(Method.java:497)
  439.     at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
  440.     at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
  441.     at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
  442.     at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:205)
  443.     at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
  444.     at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
  445.     at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
  446.     at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
  447.     at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326)
  448.     at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
  449.     at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
  450.     at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
  451.     at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
  452.     at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
  453.     at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)
  454.     at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305)
  455.     at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154)
  456.     at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473)
  457.     at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427)
  458.     at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388)
  459.     at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341)
  460.     at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228)
  461.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
  462.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
  463.     at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  464.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
  465.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
  466.     at zesp03.filter.DynamicHtmlFilter.doFilter(DynamicHtmlFilter.java:20)
  467.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
  468.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
  469.     at zesp03.filter.AuthenticationFilter.doFilter(AuthenticationFilter.java:96)
  470.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
  471.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
  472.     at zesp03.filter.StaticResourceFilter.doFilter(StaticResourceFilter.java:30)
  473.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
  474.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
  475.     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
  476.     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:108)
  477.     at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
  478.     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
  479.     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
  480.     at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)
  481.     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
  482.     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349)
  483.     at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:783)
  484.     at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  485.     at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:789)
  486.     at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)
  487.     at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  488.     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  489.     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  490.     at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  491.     at java.lang.Thread.run(Thread.java:745)
  492. 2017-03-13 19:32:40 ERROR org.hibernate.hql.internal.ast.ErrorCounter reportError 60;  Invalid path: 'lub.unit'
  493. 2017-03-13 19:32:40 ERROR org.hibernate.hql.internal.ast.ErrorCounter reportError 55;  Invalid path: 'lub.unit'
  494.  Invalid path: 'lub.unit'
  495.     at org.hibernate.hql.internal.ast.util.LiteralProcessor.lookupConstant(LiteralProcessor.java:111)
  496.     at org.hibernate.hql.internal.ast.tree.DotNode.resolve(DotNode.java:214)
  497.     at org.hibernate.hql.internal.ast.tree.FromReferenceNode.resolve(FromReferenceNode.java:109)
  498.     at org.hibernate.hql.internal.ast.HqlSqlWalker.createFromJoinElement(HqlSqlWalker.java:398)
  499.     at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.joinElement(HqlSqlBaseWalker.java:3915)
  500.     at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3701)
  501.     at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:3579)
  502.     at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:718)
  503.     at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:574)
  504.     at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:311)
  505.     at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:259)
  506.     at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:261)
  507.     at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:189)
  508.     at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:141)
  509.     at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:115)
  510.     at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
  511.     at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:153)
  512.     at org.hibernate.internal.AbstractSharedSessionContract.getQueryPlan(AbstractSharedSessionContract.java:545)
  513.     at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:654)
  514.     at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:678)
  515.     at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:23)
  516.     at zesp03.rest.resource.BuildingResource.getBuilding(BuildingResource.java:34)
  517.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  518.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  519.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  520.     at java.lang.reflect.Method.invoke(Method.java:497)
  521.     at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
  522.     at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
  523.     at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
  524.     at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:205)
  525.     at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
  526.     at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
  527.     at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
  528.     at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
  529.     at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326)
  530.     at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
  531.     at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
  532.     at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
  533.     at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
  534.     at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
  535.     at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)
  536.     at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305)
  537.     at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154)
  538.     at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473)
  539.     at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427)
  540.     at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388)
  541.     at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341)
  542.     at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228)
  543.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
  544.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
  545.     at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  546.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
  547.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
  548.     at zesp03.filter.DynamicHtmlFilter.doFilter(DynamicHtmlFilter.java:20)
  549.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
  550.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
  551.     at zesp03.filter.AuthenticationFilter.doFilter(AuthenticationFilter.java:96)
  552.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
  553.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
  554.     at zesp03.filter.StaticResourceFilter.doFilter(StaticResourceFilter.java:30)
  555.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
  556.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
  557.     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
  558.     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:108)
  559.     at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
  560.     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
  561.     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
  562.     at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)
  563.     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
  564.     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349)
  565.     at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:783)
  566.     at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  567.     at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:789)
  568.     at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)
  569.     at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  570.     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  571.     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  572.     at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  573.     at java.lang.Thread.run(Thread.java:745)
  574. 2017-03-13 19:32:40 ERROR org.hibernate.hql.internal.ast.ErrorCounter reportError 60;  Invalid path: 'b.id'
  575. 2017-03-13 19:32:40 ERROR org.hibernate.hql.internal.ast.ErrorCounter reportError 55;  Invalid path: 'b.id'
  576.  Invalid path: 'b.id'
  577.     at org.hibernate.hql.internal.ast.util.LiteralProcessor.lookupConstant(LiteralProcessor.java:111)
  578.     at org.hibernate.hql.internal.ast.tree.DotNode.resolve(DotNode.java:214)
  579.     at org.hibernate.hql.internal.ast.tree.FromReferenceNode.resolve(FromReferenceNode.java:109)
  580.     at org.hibernate.hql.internal.ast.tree.FromReferenceNode.resolve(FromReferenceNode.java:104)
  581.     at org.hibernate.hql.internal.ast.HqlSqlWalker.resolve(HqlSqlWalker.java:1013)
  582.     at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.expr(HqlSqlBaseWalker.java:1286)
  583.     at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.exprOrSubquery(HqlSqlBaseWalker.java:4699)
  584.     at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWalker.java:4169)
  585.     at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:2134)
  586.     at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker.java:813)
  587.     at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:607)
  588.     at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:311)
  589.     at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:259)
  590.     at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:261)
  591.     at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:189)
  592.     at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:141)
  593.     at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:115)
  594.     at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
  595.     at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:153)
  596.     at org.hibernate.internal.AbstractSharedSessionContract.getQueryPlan(AbstractSharedSessionContract.java:545)
  597.     at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:654)
  598.     at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:678)
  599.     at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:23)
  600.     at zesp03.rest.resource.BuildingResource.getBuilding(BuildingResource.java:34)
  601.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  602.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  603.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  604.     at java.lang.reflect.Method.invoke(Method.java:497)
  605.     at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
  606.     at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
  607.     at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
  608.     at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:205)
  609.     at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
  610.     at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
  611.     at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
  612.     at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
  613.     at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326)
  614.     at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
  615.     at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
  616.     at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
  617.     at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
  618.     at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
  619.     at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)
  620.     at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305)
  621.     at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154)
  622.     at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473)
  623.     at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427)
  624.     at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388)
  625.     at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341)
  626.     at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228)
  627.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
  628.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
  629.     at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  630.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
  631.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
  632.     at zesp03.filter.DynamicHtmlFilter.doFilter(DynamicHtmlFilter.java:20)
  633.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
  634.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
  635.     at zesp03.filter.AuthenticationFilter.doFilter(AuthenticationFilter.java:96)
  636.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
  637.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
  638.     at zesp03.filter.StaticResourceFilter.doFilter(StaticResourceFilter.java:30)
  639.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
  640.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
  641.     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
  642.     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:108)
  643.     at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
  644.     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
  645.     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
  646.     at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)
  647.     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
  648.     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349)
  649.     at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:783)
  650.     at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  651.     at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:789)
  652.     at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)
  653.     at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  654.     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  655.     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  656.     at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  657.     at java.lang.Thread.run(Thread.java:745)
  658. 2017-03-13 19:32:40 ERROR org.hibernate.hql.internal.ast.ErrorCounter reportError 60; <AST>:0:0: unexpected end of subtree
  659. 2017-03-13 19:32:40 ERROR org.hibernate.hql.internal.ast.ErrorCounter reportError 55; <AST>:0:0: unexpected end of subtree
  660. <AST>:0:0: unexpected end of subtree
  661.     at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.exprOrSubquery(HqlSqlBaseWalker.java:4781)
  662.     at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWalker.java:4172)
  663.     at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:2134)
  664.     at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker.java:813)
  665.     at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:607)
  666.     at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:311)
  667.     at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:259)
  668.     at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:261)
  669.     at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:189)
  670.     at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:141)
  671.     at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:115)
  672.     at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
  673.     at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:153)
  674.     at org.hibernate.internal.AbstractSharedSessionContract.getQueryPlan(AbstractSharedSessionContract.java:545)
  675.     at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:654)
  676.     at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:678)
  677.     at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:23)
  678.     at zesp03.rest.resource.BuildingResource.getBuilding(BuildingResource.java:34)
  679.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  680.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  681.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  682.     at java.lang.reflect.Method.invoke(Method.java:497)
  683.     at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
  684.     at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
  685.     at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
  686.     at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:205)
  687.     at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
  688.     at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
  689.     at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
  690.     at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
  691.     at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326)
  692.     at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
  693.     at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
  694.     at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
  695.     at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
  696.     at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
  697.     at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)
  698.     at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305)
  699.     at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154)
  700.     at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473)
  701.     at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427)
  702.     at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388)
  703.     at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341)
  704.     at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228)
  705.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
  706.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
  707.     at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  708.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
  709.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
  710.     at zesp03.filter.DynamicHtmlFilter.doFilter(DynamicHtmlFilter.java:20)
  711.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
  712.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
  713.     at zesp03.filter.AuthenticationFilter.doFilter(AuthenticationFilter.java:96)
  714.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
  715.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
  716.     at zesp03.filter.StaticResourceFilter.doFilter(StaticResourceFilter.java:30)
  717.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
  718.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
  719.     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
  720.     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:108)
  721.     at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
  722.     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
  723.     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
  724.     at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)
  725.     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
  726.     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349)
  727.     at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:783)
  728.     at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  729.     at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:789)
  730.     at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)
  731.     at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  732.     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  733.     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  734.     at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  735.     at java.lang.Thread.run(Thread.java:745)
  736. 2017-03-13 19:32:40 ERROR org.hibernate.hql.internal.ast.ErrorCounter reportError 60;  left-hand operand of a binary operator was null
  737. 2017-03-13 19:32:40 ERROR org.hibernate.hql.internal.ast.ErrorCounter reportError 55;  left-hand operand of a binary operator was null
  738.  left-hand operand of a binary operator was null
  739.     at org.hibernate.hql.internal.ast.tree.BinaryLogicOperatorNode.initialize(BinaryLogicOperatorNode.java:40)
  740.     at org.hibernate.hql.internal.ast.HqlSqlWalker.prepareLogicOperator(HqlSqlWalker.java:1369)
  741.     at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.comparisonExpr(HqlSqlBaseWalker.java:4643)
  742.     at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.logicalExpr(HqlSqlBaseWalker.java:2134)
  743.     at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.whereClause(HqlSqlBaseWalker.java:813)
  744.     at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:607)
  745.     at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:311)
  746.     at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:259)
  747.     at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:261)
  748.     at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:189)
  749.     at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:141)
  750.     at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:115)
  751.     at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
  752.     at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:153)
  753.     at org.hibernate.internal.AbstractSharedSessionContract.getQueryPlan(AbstractSharedSessionContract.java:545)
  754.     at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:654)
  755.     at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:678)
  756.     at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:23)
  757.     at zesp03.rest.resource.BuildingResource.getBuilding(BuildingResource.java:34)
  758.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  759.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  760.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  761.     at java.lang.reflect.Method.invoke(Method.java:497)
  762.     at org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
  763.     at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
  764.     at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
  765.     at org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$TypeOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:205)
  766.     at org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
  767.     at org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
  768.     at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
  769.     at org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
  770.     at org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326)
  771.     at org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
  772.     at org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
  773.     at org.glassfish.jersey.internal.Errors.process(Errors.java:315)
  774.     at org.glassfish.jersey.internal.Errors.process(Errors.java:297)
  775.     at org.glassfish.jersey.internal.Errors.process(Errors.java:267)
  776.     at org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)
  777.     at org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305)
  778.     at org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154)
  779.     at org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473)
  780.     at org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427)
  781.     at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388)
  782.     at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341)
  783.     at org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228)
  784.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
  785.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
  786.     at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  787.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
  788.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
  789.     at zesp03.filter.DynamicHtmlFilter.doFilter(DynamicHtmlFilter.java:20)
  790.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
  791.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
  792.     at zesp03.filter.AuthenticationFilter.doFilter(AuthenticationFilter.java:96)
  793.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
  794.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
  795.     at zesp03.filter.StaticResourceFilter.doFilter(StaticResourceFilter.java:30)
  796.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
  797.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
  798.     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
  799.     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:108)
  800.     at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
  801.     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
  802.     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
  803.     at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)
  804.     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
  805.     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349)
  806.     at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:783)
  807.     at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  808.     at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:789)
  809.     at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)
  810.     at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  811.     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  812.     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  813.     at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  814.     at java.lang.Thread.run(Thread.java:745)
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!