Path: csiph.com!eternal-september.org!feeder.eternal-september.org!mx02.eternal-september.org!.POSTED!not-for-mail From: Cecil Westerhof Newsgroups: comp.lang.java.programmer Subject: How to circumvent getting many queries in JPQL Date: Thu, 25 Feb 2016 02:06:14 +0100 Organization: Decebal Computing Lines: 227 Message-ID: <87twkx61kp.fsf@Equus.decebal.nl> Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="=-=-=" Injection-Info: mx02.eternal-september.org; posting-host="12baf5125b19322b899c79c2e3878015"; logging-data="4718"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18JSm6xjDAF5PMTnl2Lr4ESa1FbmYmFF9Q=" User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/24.3 (gnu/linux) X-Homepage: http://www.decebal.nl/ Cancel-Lock: sha1:ZYl4XqHDjAbfgWa4HTzl10Vjsmw= sha1:+R6KmHxa3TKqE72u4UmmcwcHTlc= Xref: csiph.com comp.lang.java.programmer:33875 --=-=-= Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit I am asked to help improve the performance of a few JPQL queries. (They do not accept a response time of several hours.) The model is a ‘little’ complex. --=-=-= Content-Type: image/png Content-Disposition: attachment; filename=oar.png Content-Transfer-Encoding: base64 iVBORw0KGgoAAAANSUhEUgAAApMAAAFbCAYAAACJRQW5AAAABmJLR0QA/wD/AP+gvaeTAAAgAElE QVR4nO3de3RU9b3+8WfPhSgEuRwrF7kEKCIICkdF+WFEbqUCB8wBAgfRKtZouRygHBKkaIWWIwGr VlCoqFxUMAZSFAxLtKIFe4IeK14iiBCKIMhCqpBAEiYz+/cHJyMhCcENme+emfdrrVmB2WH5GL75 8OS7956xbNu2BQAAAPx42R7TCQAAABC9KJMAAABwjDIJAAAAx3xnPlFSUqLc3FwFg0ETeaJC06ZN lZycbDoGagHrv2as/9jF+q8Z6x+orFKZzM3N1bBhw0xkiRo+n0+BQMB0DNQC1n/NWP+xi/VfM9Y/ UFml09xlZWWSJNu2eVTxyMrKCn+NEHtY/6z/eMb6Z/0DTnDNJAAAAByjTAIAAMAxyiQAAAAco0wC AADAMcokAAAAHKNMAgAAwDHKJAAAAByjTAIAAMAxyiQAAAAco0wCAADAMcokAAAAHKNMAgAAwDHK JAAAAByjTAIAAMAxV5fJP//5z+rTp48sy5Lf79c999yjzz77zHQsoNatWrVKw4cPl2VZ8vl8Sk9P 1//8z/+YjgXUmtzcXN16663hNT9lypTwvM/JydG1114ry7J0xRVXaMaMGSosLDScGEA5n+kAZ5OS kqI+ffqoYcOGuvnmm/Xcc8+ZjhS2c+dOXXHFFaZjIEb9x3/8hwYNGqQ1a9YoOTlZ8+bNMx0JMc62 bW3fvt3Yf3/gwIHq0aOHGjdurOTkZD3++OPhYykpKXryySc1aNAgrVq1SvXr1zeWE0Blrt6ZlKRL LrlEkpSYmGg4SUUdO3bUoEGD9O6775qOghhV/g9m+fcAUBtKSkq0ZMkStW/fXg8//LDRLA0bNpRU ec0/+OCD+pd/+RetXbuWIgm4kOvLpGVZFT66Rf/+/ZWbm6tbbrlFnTt31ooVKxQIBEzHQgxx69pH bDh8+LAyMzPVqlUrpaWlqaCgQLfffrvRTGeuedu2NWvWLG3btk2rVq2Sz+fqk2lA3HJ9mXSrdevW 6Y477pAk5efn66677lJSUpIee+wxHTt2zHA6AKjaF198ofvuu08tWrTQb37zGx0+fFg+n0+rVq3S kCFDTMcLs21b06ZN05YtW7R69WrVqVPHdCQA1aBMOuT3+7V8+XI99NBDkk4NvgMHDigjI0NNmzbV pEmT9NVXXxlOCQCnbNmyRcOHD1enTp20dOlSnTx5UpJ08cUXa/369Ro5cqThhD8IBoO6//779eKL L2rt2rW66KKLTEcCcBaUyfNgWZZmzZqlJ598UpZlybIslZWVqbi4WIsWLVJSUpIGDRqkvLw801EB xKFQKKR169bpuuuuU3Jysl599VWFQiEFAgH5/X41bNhQW7Zs0YABA0xHrWDDhg166aWXdOjQIWVm ZpqOA6AGXIDiUHZ2dvjXTZs21fDhw5WdnS2v16tgMBi+fnLjxo3Kzc3VTTfdpLFjx7ruRiJURPE/ N6evf7hPMBjUnj17tHDhQh08eFAez6l9g7KyMkmnzqzYtq309HTt3r1bu3fvliRt3brVWObT/exn P9OsWbPUt29f/e53v1OLFi2UlpZmOhaAalAmHUpNTa3y+VAoVOH35cN7y5Yt+vLLL3Xo0KFazwbU turWP9yj/AdbSeGP5cp/2M3IyKjwvFtu9qpTp46uv/56rV+/XgMGDNCvfvUrNW/eXIMHDzYdDUAV ouY0d926dU1HqMC27fCjtLRUqamp8ng8sm07/Dler1eWZalVq1Z64oknVFBQUOHP8XDfIysry+Cq ih6m/5541PzYtWuXMjIylJiYWOkuaMuy5PF49Mwzz1T4My+//LKhFVW1m2++WcuXL1coFFJqaqpr dk4BVOTaMvnpp5/q66+/lm2fKmdt2rQxnKhqRUVFGjhwoNasWRPelfT7/ZKkzp07a9myZSooKNCk SZNcV4jhbuVrv/wj8GMkJSVp7ty5OnDggB599FE1a9YsXCJt21YoFFJaWprx15Y8XVVrPjU1Vb/9 7W9VXFyswYMHG31hdQBVc22Z7NOnj0aNGqVvvvlGkjR69GjDiSo7ePCgbrzxRm3atEnBYFA+n08e j0dDhgzR1q1btW3bNt15553yer2moyIKlb9dHG8bh/NRv359TZo0SXv37tWKFSvUqVMnST/80Dtr 1ixNnDix0iU6Jnz//feSpOPHj1d4fubMmbryyiv17bffqnfv3hRKwGVcWyYnTJignTt36vbbb9eq Vat01VVXmY5Uwe7du9WjRw/l5+crFArpoosu0tixY7V9+3atXr1a3bt3Nx0RUSw7O1u//OUvJUl/ /etfNWPGDL3//vuGUyGa+f1+jRkzRp9++qk2b96svn37hq+RXLhwoVJSUoy+8UJubm6FNf/ggw/q 888/lyT95S9/Cb8rzqFDh3TzzTdr6tSprijAACTLPuMc2iuvvKKRI0dyaq0a5V+fhg0b6vvvv9dl l12mqVOnKi0tLfxWYIherP+z4+sTWz7//HM99thj4Xfw6tixo7Zv387fbzVY/0CVsl27M+l2rVu3 1gsvvKD9+/crPT2dIgkg6nTq1EnPPvus9u3bpwcffFBff/216UgAohAvDeTQtm3bTEcAgAuiSZMm mj17tjp37uyqd8IBEB3YmQQAAIBjlEkAAAA4RpkEAACAY5RJAAAAOEaZBAAAgGOUSQAAADhGmQQA AIBjlEkAAAA4RpkEAACAY5RJAAAAOEaZBAAAgGOUSQAAADhGmQQAAIBjlEkAAAA4RpkEAACAY77q DmRnZ0cyR9TIy8szHQERwPqvGus/PrD+q8b6B6pWqUw2a9ZMPp9PqampJvJEhRYtWpiOgFrC+q8Z 6z92sf5rxvoHKrNs27ZNhwDi3Z49e/TTn/5UPXr00FtvvaWLLrpIkvTKK69o5MiROv3b9JNPPlHP nj115ZVX6oMPPjAVGQAAScrmmknABdq0aaOhQ4fqvffe04gRIxQMBqv8vP3792vAgAEqKipSenp6 hFMCAFAZZRJwiQceeECStH79eo0bN67S8SNHjqh379765ptvdPnllyslJSXSEQEAqKTaG3AARNb1 11+v7t276/3339eSJUvUqlUrtW/fXpJ04sQJ/fznP1dBQYEkadq0afL5+PYFAJjHNZOAi+Tk5Gj4 8OGybVuWZWngwIF6/fXXdeutt+qtt95SIBBQYmKiDhw4oPr165uOCwBANmUScJFgMKi2bdtq3759 FW668Xq9CgaD8vv9mjJlijIzMw2mBAAgjBtwADfxer2aNm2aPJ5T35oej0eWZYVvyAmFQpo4caLJ iAAAVECZBFzm7rvvVr169SSdKo/lO5R+v1+jRo3ide4AAK5CmQRcpl69epowYYL8fn+F5wOBgKZO nWooFQAAVeOaScCFDh06pJYtWyoQCEg6dfo7OTlZmzZtMpwMAIAKuGYScKMmTZpo9OjR4d3JYDCo jIwMw6kAAKiMnUnApT799FNdc801kqT27dtrx44dsizLcCoAACpgZxJwqy5duqh3796ybVvp6ekU SQCAK1EmARcbPHiwEhMTNWbMGNNRAACoEmUScLHLL79cRUVFSkhIMB0FAIAqUSYBAADgGGUSAAAA jlEmAQAA4BhlEgAAAI5RJgEAAOAYZRIAAACOUSYBAADgGGUSAAAAjlEmAQAA4BhlEgAAAI5RJgEA AOAYZRIAAACOUSYBAADgGGUSAAAAjlEmAQAA4BhlEgAAAI5RJgEAAOAYZRIAAACOUSYBAADgGGUS AAAAjlEmAQAA4BhlEgAAAI5RJgEAAOAYZRIAAACOUSYBAADgGGUSAAAAjlEmAQAA4BhlEgAAAI5R JgEAAOAYZRIAAACOUSYBAADgmM90AMBNSkpKlJubq2AwaDqKJCkvL0+SlJ2dbTjJD5o2bark5GTT MVAL3Lb+3Yj1D1Rm2bZtmw4BuEVOTo6GDRtmOoar+Xw+BQIB0zFQC1j/NWP9A5Vkc5obOE1ZWZkk ybZtHlU8srKywl8jxB7WP+sfcIIyCQAAAMcokwAAAHCMMgkAAADHKJMAAABwjDIJAAAAxyiTAAAA cIwyCQAAAMcokwAAAHCMMgkAAADHKJMAAABwjDIJAAAAxyiTAAAAcIwyCQAAAMcokwAAAHCMMgm4 wGuvvabk5GRZliWPx6Px48dr69at4eMvvPCC+vbtK8uy5PP59Itf/EK7du0ymBi4sF588UWlpKTI sizVrVtXAwYMUHJysrp166Z///d/17vvvms6IoBq+EwHACANGTJEN998sxo1aqTk5GQ99dRTFY7f cccdGjhwoC699FIlJydr+fLlhpICtWPMmDEaMmSIGjRooL59+2rdunWSpKKiIv3Xf/2XbrnlFuXk 5CglJcVwUgBnYmcScIkGDRpIkho2bFjl8caNG0uSLrnkkohlAiKpfv36kiSv1xt+LjExUQsWLFDz 5s31+9//3lQ0AGdBmQRcwrKsCh9/7HEg2lW3tv1+vzp27KgdO3ZEOBGAc0GZBAC4WjAY1K5du9Su XTvTUQBUgWsmAQCudezYMT3wwAM6cOCAFi5caDoOgCpQJgGXeeutt3TllVeajgEY8+6776pr1646 duyY9uzZo3r16mnx4sUaNGiQ6WgAqkCZBFymX79+Wrt2bZXHuF4S8aBXr17h74FvvvlG2dnZmjBh glavXq1XX31Vfr/fcEIAp+OaSQCAazVt2lQTJ07U888/rw0bNmjJkiWmIwE4A2USAOB6/fv3lyTl 5eUZTgLgTJRJwCVs267w8cceB6Ld2dZ2+Ts+JSUlRSgNgHNFmQRc4ujRoxU+nun777+XdOruViAW FRYWSqq8xnft2qVf/vKX+slPfqLx48ebiAbgLCiTgAu88cYbSktLkyT99a9/1e2336733nsvfPzF F1/U3XffLUnavHmzxo4dy3tzI6ZkZ2frnnvukSS98847uv7669WrVy917dpVQ4cOVXJysj766CM1 adLEcFIAZ+JubsAFBgwYoAEDBlR7fMyYMRozZkwEEwGRNWLECI0YMcJ0DAAOsDMJAAAAxyiTAAAA cIwyCQAAAMcokwAAAHCMMgkAAADHKJMAAABwjDIJAAAAxyiTAAAAcIwyCQAAAMcokwAAAHCMMgkA AADHKJPAaYqLi01HAAAgqlAmAUmFhYXKzMzU+PHjTUcBACCqUCYR18pLZOvWrTVnzhz169fPdCQA AKIKZRJx6cwSmZaWpr1792r06NGmowEAEFV8pgMAkVRYWKinn35amZmZKisr07hx45SRkaFGjRqZ jgYAQFSiTCIuUCIBAKgdlEnENKclMjs7O0IJo0teXp7pCIgA1n/VWP9A1SiTiElOS2SzZs3k8/mU mpoaoaTRp0WLFqYjoJaw/mvG+gcq4wYcxJTqbqyZO3fuOZ3STk5OViAQkG3bEX0UFBTI4/GoZ8+e Ki4uDj+flZUlSRU+9+OPP1ZiYqKuu+66iOe0bVv79u2r7b9GGML6Z/0DTlAmERPOt0Sa1qZNGw0d OlTvvfeeRowYoWAwWOXn7d+/XwMGDFBRUZHS09MjnBKoHax/ILpRJhHVor1Enu6BBx6QJK1fv17j xo2rdPzIkSPq3bu3vvnmG11++eVKSUmJdESg1rD+gejFNZOISrF4d/b111+v7t276/3339eSJUvU qlUrtW/fXpJ04sQJ/fznP1dBQYEkadq0afL5+PZF7GD9A9HLsm3bNh0COFexWCJPl5OTo+HDh8u2 bVmWpYEDB+r111/XrbfeqrfeekuBQECJiYk6cOCA6tevbzoucEGx/oGolE2ZRFSI9RJZLhgMqm3b ttq3b59O/9b0er0KBoPy+/2aMmWKMjMzDaYEagfrH4hK2VwzCVeLpWsiz4XX69W0adPk8Zz61vR4 PLIsK3xDQigU0sSJE01GBGoN6x+ITuxMwpXiZSeyKsePH1fz5s117NixCs/7/X6lpqbqxRdfNJQM qH2sfyDqsDMJd4m3nciq1KtXTxMmTJDf76/wfCAQ0NSpUw2lAiKD9Q9EH3Ym4QrxvBNZlUOHDqll y5YKBAKSTp3+S05O1qZNmwwnA2of6x+IKuxMwix2IqvWpEkTjR49Orw7EwwGlZGRYTgVEBmsfyC6 sDMJI9iJrNmnn36qa665RpLUvn177dixQ5ZlGU4FRAbrH4ga7EwistiJPHddunRR7969Zdu20tPT +YcUcYX1D0QPyiQighLpzODBg5WYmKgxY8aYjgJEHOsfiA68HxVqFaezz8/ll1+uoqIiJSQkmI4C RBzrH4gOlEnUCkokAADxgTKJC4oSCQBAfKFM4oKgRAIAEJ8okzgvlEgAAOIbZRKOUCIBAIBEmcSP RIkEAACno0zinFAiAQBAVSiTOCtKJAAAOBvKJKpEiQQAAOeCMokKKJEAAODHoExCEiUSAAA4Q5mM c5RIAABwPiiTcYoSCQAALgTKZJyhRAIAgAuJMhknKJEAAKA2UCZjHCUSAADUJspkjKJEAgCASKBM xhhKJAAAiCTKZIygRAIAABMok1GOEgkAAEyiTEYpSiQAAHADymSUoUQCAAA3oUxGCUokAABwI8qk y1EiAQCAm1EmXYoSCQAAogFl0mUokQAAIJpQJl2CEgkAAKIRZdIwSiQAAIhmlElDKJEAACAWUCYj jBIJAABiCWUyQiiRAAAgFlUqkyUlJcrNzVUwGDSRx9Vs29aJEyfUqFEjdenSRYWFhSotLdWxY8dU XFyskpISHT16VKWlpSoqKtLx48d18uRJHTlyROvWrdPJkyc1efJkTZo0SQ0aNDD9v4MquG395+Xl SZKys7MNJ/lB06ZNlZycbDoGagHrv2as/9jltvXvRtWtf8u2bfv0J3JycjRs2LCIBYs1Pp9PlmXJ 4/FIkgKBgEKhkGbNmkWJjAKs/5r5fD4FAgHTMVALWP81Y/3HLtZ/zapZ/9meM58pKyuTdGoXjscP j+PHj2vBggXq1q1b+GtVXhjP/PoFAgGVlpaqtLRUlmVpypQpeuihhyiSUYD1f/ZHVlZW+GuE2MP6 Z/3HM9a/8/VfuQ2hSnXr1tWECRM0ffp0SdLbb7+t9PR0denSJbwT6fNVvGrA5/OpV69emj9/vonI AAAAtY4y6VDv3r31yCOPaPPmzRo3bpxs267Q2H0+n1q0aKHVq1fL6/UaTAoAAFB7KJMOHT16VLNn z1ZSUpJeeuklXXvtteHT3pZlqU6dOsrNzeVubQAAENMokw4lJSXp8ccf1+TJk/WPf/xDlmVVOJ6V laWOHTsaSgcAABAZvM6kQ1OnTtXEiRPVoEED5efn64MPPpB0aldyzpw5Gjx4sOGEAAAAtY8y6dDM mTPDv16yZIksy5LX61VKSkr4Jh0AAIBYx2nu81RaWqply5bJtm116NBBS5curXTKGwAAIFZRJs/T mjVrdPToUTVu3FgbNmxQvXr1TEcCAACIGMrkeVq8eLG8Xq9ycnLUsmVL03EAAAAiijJ5HkKhkD7+ +GMtWrRIvXr1Mh0HAAAg4rgB5zx4PB4dOXKk0jvfAAAAxAt2Js8TRRIAAMQzyiQAAAAco0wCAADA MVeWyWAwqGXLlqlPnz5KSkrSVVddpTp16siyLFmWpZtuusl0ROCCe/vttzV48GBZlqWEhAT16tVL /fr1U79+/ZScnKy2bdvKsiw9/PDDpqMCEfH4449r5cqVpmMAEffmm29qxIgR6tatmzp37qyEhIRw B3Lja1m77oK/f/7zn7rtttt06NAhPffcc+rRo4e8Xq9KS0v1hz/8wTX/kO7cuVNXXHGF6RiIIX36 9FG3bt3UuHFj9e3bV7m5uRWO27atxx9/XMeOHTOU8Aesf9Q227a1ePFiXXrppRo9erTpOIhxtm1r +/btpmPo2LFjuvfee7Vt2zYtXbpUN9xwg7xerwKBgJYsWaL09HQdP37cdMxKXLczOXHiRO3du1cf fvihbrrpJnm9XklSQkKCZsyYoSeffNJwwlM6duyoQYMG6d133zUdBTGkYcOGkqQ6depUOmZZlu67 7z795Cc/iXSsSlj/qG2bNm3Snj179Le//U1///vfTcdBjCopKdGSJUvUvn1745tVtm1rxIgR+vjj j/W///u/+n//7/+FO5Df79e4ceP06quvunJn0lVl8i9/+YtWrlyp2bNnKzExscrPuffee9WhQ4cI J6usf//+ys3N1S233KLOnTtrxYoVCgQCpmMhytU0JOrVq6fx48dHKE31WP+obYsWLdLChQslSU89 9ZThNIg1hw8fVmZmplq1aqW0tDQVFBTo9ttvN5opJydHGzdu1COPPKL69etX+Tl9+/bVwIEDI5ys Zq4qk8uWLZPP5zvrKQ2v16s//vGPEUxVtXXr1umOO+6QJOXn5+uuu+5SUlKSHnvsMVechkTs+eqr r4z/5FyO9Y/adPDgQX377be69957ddVVV2nlypX65z//aToWYsAXX3yh++67Ty1atNBvfvMbHT58 WD6fT6tWrdKQIUOMZluxYoXq1aun22677ayf9/vf/z5Cic6dq8rkZ599prZt28rv91c6tmPHDk2b Nk233XabxowZo7Fjx2rv3r0GUp7i9/u1fPlyPfTQQ5JObU8fOHBAGRkZatq0qSZNmqSvvvrKWD7E lmAwqKefftp0jDDWP2rTc889p7vvvjt8aUdJSYmef/5507EQxbZs2aLhw4erU6dOWrp0qU6ePClJ uvjii7V+/XqNHDnScEJp69atat++fY1nqLp27RqhROfOVWVy586dat26dZXHrrzySs2bN0+7du3S q6++qmnTplX7uZFiWZZmzZqlJ598MnyHVVlZmYqLi7Vo0SIlJSVp0KBBysvLM5oT0WfTpk3q2rWr unbtqquvvlqXXnqpMjMzTceqgPWP2hAMBrV69WqNGDFCknTHHXfo4osv1tNPP61gMGg4HaJJKBTS unXrdN111yk5OVmvvvqqQqGQAoGA/H6/GjZsqC1btmjAgAGmo0qSvvvuO1166aWmYzjiqru5mzRp om+++aba45ZlKSkpSfn5+cavm8zOzg7/umnTpho+fLiys7Pl9XoVDAbD149t3LhRubm5uummmzR2 7NhqrwWFO7il+PTu3Vtr164N/962bS1ZskQHDhwwmOoHrP/Y5Ib1n5ubq169euniiy+WdOqmtFGj Rmnp0qXasGGDBg8ebDhhxfUP9wkGg9qzZ48WLlyogwcPyuM5tW9WVlYm6dSZFdu2lZ6ert27d2v3 7t2STu0MmtSyZctwlmjjqjLZoUMHvfPOOwoGg+E7mM5U/vaF5YvDlNTU1CqfD4VCFX5fvni3bNmi L7/8UocOHar1bIg9lmXpF7/4hTZv3mw6iiTWP2rPokWLtHv37gqn8oqKiiRJCxcudEWZrG79wz3K f7CVVGlHu/yH3YyMjArPm75LumPHjnr99ddVXFwc/mEqWrjqNPfIkSNVUlKil19+2XSUGtm2HX6U lpYqNTVVHo9Htm2HP8fr9cqyLLVq1UpPPPGECgoKKvw5Hu57ZGVlGVxVZ5eQkKB+/fqpuLhYe/bs MZqF9R+bD9Prf/fu3SosLNQXX3yhbdu2hR87d+5U27Zt9cYbb+jLL780mlGS8b8nHjU/du3apYyM DCUmJoY3ocpZliWPx6Nnnnmmwp8x3T1GjBgh27a1ceNGozmccFWZvPPOO3XDDTcoIyND3377bZWf Y9t2lc+bUlRUpIEDB2rNmjXhXZnyG4g6d+6sZcuWqaCgQJMmTVLdunVNRkUUOJf1PW/ePO3YsSMC aWrG+seFNHfuXN11112Vnvd4PLr//vsl8TJBODdJSUmaO3euDhw4oEcffVTNmjULl0jbthUKhZSW luaaV8iQpDFjxuhf//VflZ6eXu2rF9i2rT/96U/at29fhNOdnavKpMfjUU5Ojpo2baouXbpo7dq1 OnHihKRTp88+/PBDbd261TV3Mh08eFA33nijNm3apGAwKJ/PJ4/HoyFDhmjr1q3atm2b7rzzzmpP 2QNnKiwslKTwuj/dyZMn9ac//Ulz5851xVuKsv5xIX311Vdavny5/u3f/q3K4ykpKZKkJUuW6Ouv v45kNESx+vXra9KkSdq7d69WrFihTp06Sfrhh95Zs2Zp4sSJlS7RMcHj8eiVV16RZVm67rrr9PLL L4f/TTh69Kjeeecd3XrrrTp+/LhatmxpOG1FriqTktS8eXPl5eXpkUce0aJFi9S2bVtdffXV6tWr lx577DEtWrRIH374oemY2r17t3r06KH8/HyFQiFddNFFGjt2rLZv367Vq1ere/fupiMiyrz55psa O3aspFMv4N+uXbvw+3PfcMMNuuyyy3T//ffrmmuuqfYFbSOF9Y8L6ZNPPtGoUaMUCAQ0Y8aMSrsu //jHP7RgwQJJp37QGjZsmN5//30TURGl/H6/xowZo08//VSbN29W3759w9dILly4UCkpKa5444V2 7dpp27Zt+vWvf62nnnpKrVq1UsuWLXXdddcpKytLjz76qH7961+bjlmZfYasrCy7iqfxf8q/Pg0b NrQl2ZdddpmdmZlpf/fdd6aj4QJg/Z8d6z+2sf7Pjq9PbMnPz7fvuece2+/325Lsjh078vd7FmdZ /6+4bmcyWrRu3VovvPCC9u/fr/T09PB7KgPxgPUPINp16tRJzz77rPbt26cHH3yQyyfOg6teGiia bNu2zXQEwBjWP4BY0aRJE82ePVudO3d2xTvhRCN2JgEAAOAYZRIAAACOUSYBAADgGGUSAAAAjlEm AQAA4BhlEgAAAI5RJgEAAOAYZRIAAACOUSYBAADgGGUSOE1xcbHpCAAAA5j/zlEmAUmFhYXKzMzU +PHjTUcBAEQQ8//8USYR18qHSOvWrTVnzhz169fPdCQAQAQw/y8cyiTi0plDJC0tTXv37tXo0aNN RwMA1CLm/4XnMx0AiKTCwkI9/fTTyszMVFlZmcaNG6eMjAw1atTIdDQAQKqMD7cAAAuPSURBVC1i /tceyiTiAkMEAOIT87/2VVsms7OzI5kjauTl5ZmOgB/B6RBh/VeN9R8fWP9VY/1HF+b/hXW29V+p TDZr1kw+n0+pqam1GiqatWjRwnQE1MDpEGH914z1H7tY/zVj/bsf87/2VLf+Ldu27QhnAWoNpzOA 2PHKK69o5MiR4p8pnAvmvzHZXDOJmMAQAYD4xPw3jzKJqMYQAYD4xPx3D8okohJDBADiE/PffSiT iCoMEQCIT8x/96JMIiowRAAgPjH/3Y8yCVdjiABAfGL+Rw/KJFyJIQIA8Yn5H30ok3AVhggAxCfm f/SiTMIVGCIAEJ+Y/9GPMgmjGCIAEJ+Y/7GDMgkjGCIAEJ+Y/7GHMomIYogAQHxi/scuyiQigiEC APGJ+R/7KJOoVQwRAIhPzP/4QZlErWCIAEB8Yv7HH8okLiiGCADEJ+Z//KJM4oJgiABAfGL+gzKJ 88IQAYD4xPxHOcokHGGIAEB8Yv7jTJRJ/CgMEQCIT8x/VIcyiXPCEAGA+MT8R00okzgrhggAxCfm P84VZRJVYogAQHxi/uPHokyiAoYIAMQn5j+cokxCEkMEAOIV8x/nizIZ5xgiABCfmP+4UCiTcYoh AgDxifmPC40yGWcYIgAQn5j/qC2UyTjBEAGA+MT8R22jTMY4hggAxCfmPyKFMhmjGCIAEJ+Y/4g0 ymSMYYgAiBW2bZuOEFWY/zCFMhkjGCIAYs3nn38ur9er/fv3q0WLFqbjuBbzH6ZRJqMcQwRALAoG g1q2bJmCwaAWLFigzMxM05Fch/kPt7BsziNEJYYIgFiWk5Oj4cOHy7ZtJSYm6sCBA6pfv77pWK7A /IfLZLMzGWUYIgDiwdy5c+XxeBQMBlVSUqLnnntOkydPNh3LKOY/3IqdySjBEAEQL/72t7+pZ8+e FZ5r3ry59u7dK58v/vZAmP9wOXYm3Y4hAiDezJ8/X36/X4FAIPzcwYMHlZOTo9TUVIPJIov5j2jB zqRLMUQAxKOCggK1b99eoVCowvMej0fXXHON/v73vxtKFjnMf0QZdibdhiECIJ498cQT8nq9CoVC 4d1Jy7IUCoX00UcfafPmzUpOTjYds1Yw/xGt2Jl0CYYIgHj33XffqXnz5iopKZHP51MoFFIoFJJl WbJtWz6fT7feeqtee+0101EvKOY/oly2x3SCeFdYWKjMzEy1bt1ac+bMUVpamvbu3au5c+cySADE lUWLFikQCMjj8ahevXr67W9/K0l6+umnJUllZWVav369duzYYTJmjUpKSnT33Xfr7bffPuvnMf8R KzjNbQg/iQLAD06ePKknnnhCwWBQCQkJ2rBhg/bt2ydJuv/++7V//37NmTNHtm3rj3/8oxYtWmQ4 cdVOnjypoUOHauPGjdq6davy8/NlWVaFz2H+I9awMxlh/CQKAJWtXLlShw8flsfj0apVq9SjR48K x3/3u99p7NixkqSlS5fq22+/NRHzrAKBgIYNGxbekdyxY4dycnLCx5n/iFWUyQhhiABA9ebPny/L svTMM88oJSWl0vHyY0OGDFFpaakWL15sIGX1gsGg7rjjDm3YsEFlZWWSTmWeMWOGjh49yvxHTKt0 mrukpES5ubkKBoMm8riabds6ceKEGjVqpC5duqiwsFClpaU6duyYiouLVVJSoqNHj6q0tFRFRUU6 fvy4Tp48qSNHjmjdunU6efKkJk+erEmTJqlBgwam/3cAoAJT83/Hjh36/PPPNWrUKF1yySXKzs6W JG3dulWWZYV/L0kjRozQZ599pj/84Q/q0KFDRHNKUtOmTSvdTR4KhXTnnXdq9erVFb52oVBIX375 pX76058qGAwy/xGzKt3NnZOTo2HDhpnKE/V8Pp8sy5LHc2rTNxAIKBQKadasWQwRAK7G/K+Zz+er 8GLqtm3r/vvv17PPPlvptTGlU6+P2bx5c33yySfsQiJWVb6bu3x73rZtHqc9jh8/rgULFqhbt27h r1V5YTzz6xcIBFRaWqrS0lJZlqUpU6booYceokgCcDXm/9kfWVlZ4a9R+ddp/Pjx1RZJ6dTu5Ndf f13jnd1ANOOayXNUt25dTZgwQdOnT5ckvf3220pPT1eXLl3CO5Fnvmesz+dTr169NH/+fBORAQC1 aPr06Vq8eHG1RbJc+bWTNX0eEK0okw717t1bjzzyiDZv3qxx48bJtu0KP7H6fD61aNFCq1evltfr NZgUAHChTZ8+XfPnz5dt1/y+H6FQSDt37tSf//znCCQDIo8y6dDRo0c1e/ZsJSUl6aWXXtK1114b Pu1tWZbq1Kmj3NxcrpEBgBjz8MMPa968edUWSZ/Pp4SEhAqXQtWpU0d79+6NVEQgonjRcoeSkpIk SZMnT9bkyZPVv3//CsezsrLUsWNHA8kAALVp1qxZ4cubyk9de71eNWvWTO3atVP79u2VlJSkNm3a hD82a9bMcGqg9lAmHZo6daomTpyoBg0aKD8/Xx988IGkU7uSc+bM0eDBgw0nBADUhjvvvFNt2rSp UBYvv/xyLmlC3KJMOjRz5szwr5csWSLLsuT1epWSkhK+SQcAEHuWL19uOgLgKlwzeZ5KS0u1bNky 2batDh06aOnSpZXehxUAACBWUSbP05o1a3T06FE1btxYGzZsUL169UxHAgAAiBjK5HlavHixvF6v cnJy1LJlS9NxAAAAIooyeR5CoZA+/vhjLVq0SL169TIdBwAAIOK4Aec8eDweHTlypNI73wAAAMQL dibPE0USAADEM8okAAAAHKNMAgAAwDFXlcm3335bgwcPlmVZSkhI0C233KJ+/fqpb9++6tmzp1q2 bCnLsvTwww+bjgoAuIA2btyooUOHyrIs+Xw+9ejRQ927d9fVV1+tnj17aubMmdq3b5/pmACq4KoL /vr06aNu3bqpcePG6tevn15//fUKx0OhkKZOnWooHQCgtvzsZz/TjTfeqAYNGqh379568803w8c+ +ugjzZs3T+3atdPcuXM1ZcoU3hwCcBFX7UxKUsOGDSVJfr+/0jGPx6OJEyeqcePGkY4FAKhl9evX l6RKb/7QrVs3rVy5UjNnztTUqVN5O0PAZVxXJmv6abNt27b6z//8zwilAQBEytnmv2VZmjlzpnr2 7Kn09HR99913EUwG4GxcVybPJiMjw3QEAIAhHo9H48eP1+HDh7V+/XrTcQD8n6gpk4cPH9aaNWtM xwAAGHTTTTdJkvLz8w0nAVDOVTfgnG7Tpk3q2rWrJOnkyZMqKChQaWmp4VQAAJMuu+wySeLObsBF XFsme/furbVr14Z/f+zYMfXt29dgIgCAad9//70kqUOHDoaTACgXNae5L7nkEv33f/+36RgAAIM+ ++wzSdI111xjOAmAclFTJiWpf//+piMAAAxasWKFLrnkEt18882mowD4P647zW3btukIAAADapr/ r732mlasWKGnnnpKjRo1ilAqADVx3c5k+fUwRUVFhpMAACKpfO4XFhZWeH7Pnj2aPn26RowYoTlz 5uhXv/qViXgAquGqnck333xTzzzzjCTp3Xff1YwZMzRq1ChdffXVhpMBAGrTG2+8oeeff16S9M47 76hHjx6yLEt169ZVQkKCunTpos8++0zt27c3nBTAmVxVJvv37891kQAQhwYMGKABAwYoKyvLdBQA P5LrTnMDAAAgelAmAQAA4BhlEgAAAI5RJgEAAOAYZRIAAACOUSYBAADgGGUSAAAAjlEmAQAA4Bhl EgAAAI5RJgEAAOAYZRIAAACOUSYBAADgGGUSAAAAjlEmAQAA4BhlEgAAAI5RJgEAAOAYZRIAAACO +ao7kJ2dHckcUSMvL890BACoVcz/qjH/gapVKpPNmjWTz+dTamqqiTxRoUWLFqYjAMAFx/yvGfMf qMyybds2HQIAAABRKZtrJgEAAOAYZRIAAACOUSYBAADgmE8St+0BAADAibz/D5fyJ7q9mXQ3AAAA AElFTkSuQmCC --=-=-= Content-Type: text/plain When writing a query for this there are generated between eleven and fourteen select statements pro record from table A. Even when we use eager fetching. Would it be possible to write a JPQL query that generates one (or a few) queries? Or should we resort to normal SQL? -- Cecil Westerhof Senior Software Engineer LinkedIn: http://www.linkedin.com/in/cecilwesterhof --=-=-=--