18 | find() delay = it.next(); System.out.printf("child : %d %n", en.getId()); } } System.out.printf("The sum : %d %n", iSum ... : type:Node, sons:0 7 : type:Node, sons:0 8 : type:Node, sons:0 9 : type:Node, sons:0 The sum ... has no sons null has no sons null has no sons The sum : 0 I tried the "codes-2" or "codes-3", they work |
18 | Inconsistent return types from JDO queryI'm running a JDO query which returns the sum of an int field. The return type of the Object ... ) has no effect. sjzlondon Steve Zara The type of a sum expression depends on the type of the field ... . sjzlondon Steve Zara Thank you for this report and for the test. It shows that the sum of a single result |
18 | TypedQuery implementation problems.entity.Account(" + "acct.id, acct.accountCode, acct.name, acct.parentAccountId, " + "sum(case when att.amount > 0 then att.amount else 0 end)," + "sum(case when att.amount < 0 then (att.amount * -1) else 0 end), " + "sum(case when coalesce(att.amount, 0) > 0 then (abs(coalesce(att |
18 | Pre-detach loading: retrieval by navigation not working in if statement_LightingZone() { Float sum = 0f; if (getL_LightingZone() != null && getL_LightingZone().getEls ... ().getValue(); if (area != null) { sum += area; } else { return null;//POLICY } } } return sum |
15 | Performance issues on aggregate querywe are using this aggregate query to collect some data: select p3.doubleValue,c1.classIdentifier,c1.objectName,sum(p4.doubleValue),sum(p4.doubleValue*p5.doubleValue),0,p7.doubleValue,p3.name,count(o) from ObjectNode o INNER JOIN o.properties p1 INNER JOIN o.properties p2 INNER JOIN o.properties p3 |
15 | How to add minutes to a Date with JPA2Hi, I have to sum to a date of minutes, and check the date obtained is greater than the current date. My idea is as follows: Calendar currentTime = Calendar.getInstance(); Date currenteDate ... .prod(samplingPeriod,3); //minutes to be added I must now sum to the dateCapture the delayMinute |
15 | Getting sales quantity per country with a query, an idea anyone? respectively countries, quantity of orders and sum of orders, per country, only including valid orders (ord ... " + "ord.getCountry()," + "COUNT(ord)," + "SUM(ord.getAmountPaid()) " + "FROM OrderData ord " + "WHERE ord |
10 | virtual servers and one file and then I try to open several databases in parallel which in sum exceeds the treshhold and compare |
10 | IN expression in a Criteria Query value combination). Aggregate calculations (count, sum, avg, max, min) that are carried |
10 | Connection is closed (error 526); } System.out.printf("The sum : %d %n", iSum); System.out.println(); } gzdillon Lai Yang Maybe |
