For anyone else that comes across this post and might find it useful… There is actually nothing wrong with my code. I made the mistake of requesting client_credentials type access code instead of password access code (#facepalms). FYI I am using urlencoded post hence the use of querystring.. So for those that may be looking … Read more
O’right! I found this thread while I was looking for something else. But since I had to work on similar issues, I can give you some directions, and I will do my best to make it clear for you. So there are some data which you want to have it share, across your app (pages/components). … Read more
Request.redirect could be “follow”, “error” or “manual”. If it is “follow”, fetch() API follows the redirect response (HTTP status code = 301,302,303,307,308). If it is “error”, fetch() API treats the redirect response as an error. If it is “manual”, fetch() API doesn’t follow the redirect and returns an opaque-redirect filtered response which wraps the redirect … Read more
Fetch should be used for references and FetchMany for collections. This is particularly important because only FetchMany can be combined with ThenFetchMany to fetch “grandchildren” collections. Example: session.Query<User>() .FetchMany(u => u.Orders) .ThenFetchMany(o => o.OrderItems)
Little benchmark with 200k random records. As expected, the fetchAll method is faster but require more memory. Result : fetchAll : 0.35965991020203s, 100249408b fetch : 0.39197015762329s, 440b The benchmark code used : <?php // First benchmark : speed $dbh = new PDO(‘mysql:dbname=testage;dbhost=localhost’, ‘root’, ”); $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $sql=”SELECT * FROM test_table WHERE 1″; $stmt = $dbh->query($sql); … Read more
Use regular join instead of join fetch (by the way, it’s inner by default): String hql = ” select ec.id as entityChangeId, r.id as revisionId from EntityChange as ec ” + ” join ec.revision as r ” + … As error message tells you, join fetch doesn’t make sense here, because it’s a performance hint … Read more
In this two queries, you are using JOIN to query all employees that have at least one department associated. But, the difference is: in the first query you are returning only the Employes for the Hibernate. In the second query, you are returning the Employes and all Departments associated. So, if you use the second … Read more