tag:blogger.com,1999:blog-6877629428951398731.post8114796714454093648..comments2024-01-09T09:02:40.935-08:00Comments on Java Persistence Performance: JPQL vs SQL, why not have bothJameshttp://www.blogger.com/profile/07275512393744882781noreply@blogger.comBlogger13125tag:blogger.com,1999:blog-6877629428951398731.post-77887257736115044042015-11-24T19:05:52.226-08:002015-11-24T19:05:52.226-08:00Thanks for the post! Can you use these techniques ...Thanks for the post! Can you use these techniques to build <a href="http://www.modernanalytics.com/enterprise-data-modeling/" rel="nofollow">enterprise level data models</a>? I am not too familiar with these languages but am doing some research for a project for school. Thanks!Anonymoushttps://www.blogger.com/profile/01013321460318408995noreply@blogger.comtag:blogger.com,1999:blog-6877629428951398731.post-26038438184982063122015-06-28T21:01:44.137-07:002015-06-28T21:01:44.137-07:00thanksthanksAnonymoushttps://www.blogger.com/profile/14282863414687033007noreply@blogger.comtag:blogger.com,1999:blog-6877629428951398731.post-80713589316574619482015-03-04T04:37:38.753-08:002015-03-04T04:37:38.753-08:00It is very useful information. I have question for...It is very useful information. I have question for you. does eclipse Link support union with order by cluase. my sample query here is select emp from Emp emp where empId= :empId UNION select emp from Emp emp where deptId=: deptID order by emp.empID. I have tired this on it is working without Order by but when i use Order by i am getting The query contains a malformed ending.Unknownhttps://www.blogger.com/profile/06633945030260640327noreply@blogger.comtag:blogger.com,1999:blog-6877629428951398731.post-29474355204334371562014-01-08T13:26:36.990-08:002014-01-08T13:26:36.990-08:00Very helpful! But since the internet is lack of Cr...Very helpful! But since the internet is lack of Criteria API, it would be nice to give us much more examples (like how to implement NULLS FIRST using CriteriaQuery). Thanks anyway!Anonymoushttps://www.blogger.com/profile/04267940597896406737noreply@blogger.comtag:blogger.com,1999:blog-6877629428951398731.post-40104370971166893232013-08-07T07:55:48.118-07:002013-08-07T07:55:48.118-07:00It's really very nice how many more features E...It's really very nice how many more features EclipseLink 2.4 has, but I must say I am thoroughly disappointed at this moment.<br /><br />What good is an UNION without the possibility of ORDER BY over the combined result set?<br /><br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6877629428951398731.post-76874997292115503202013-08-06T10:29:16.488-07:002013-08-06T10:29:16.488-07:00This depends on how you are accessing the native A...This depends on how you are accessing the native API. If you are just using unwrap() on the EntityManager to access the native Session or UnitOfWork, then you should not have any issues.Jameshttps://www.blogger.com/profile/07275512393744882781noreply@blogger.comtag:blogger.com,1999:blog-6877629428951398731.post-6182867296872943632013-07-19T04:23:57.658-07:002013-07-19T04:23:57.658-07:00Does this mean that I won't get any problems w...Does this mean that I won't get any problems when accessing the same table using JPA and using the native API within the same transaction. <br />And could there be any problems with referential integrity constraints when using both ORM technologies together?<br /><br />Thanks again!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6877629428951398731.post-77334787783776956392013-07-18T07:14:33.431-07:002013-07-18T07:14:33.431-07:00Yes, you can use both. In general we recommend us...Yes, you can use both. In general we recommend using JPA, and using the native API only when required.Jameshttps://www.blogger.com/profile/07275512393744882781noreply@blogger.comtag:blogger.com,1999:blog-6877629428951398731.post-63157283590815956872013-07-16T08:14:47.858-07:002013-07-16T08:14:47.858-07:00Question: is it possible to use JPA with EclipseLi...Question: is it possible to use JPA with EclipseLink and native EclipseLink at the same time. What kind of database specific issues do I have to consider?<br /><br />ThanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6877629428951398731.post-52868663211191204472013-07-02T05:26:45.372-07:002013-07-02T05:26:45.372-07:00Nice post very helpful
dbakingsNice post very helpful<br /><br /><a href="http://dbakings.com/sqldatabase/SQLPredefinedFunctions.aspx" rel="nofollow">dbakings</a>Anonymoushttps://www.blogger.com/profile/14178155909391788234noreply@blogger.comtag:blogger.com,1999:blog-6877629428951398731.post-18845590386241735392013-03-20T05:26:54.334-07:002013-03-20T05:26:54.334-07:00SELECT * FROM Places WHERE
(Lat >= 1.2393 A...SELECT * FROM Places WHERE<br /> (Lat >= 1.2393 AND Lat <= 1.5532) AND (Lon >= -1.8184 AND Lon <= 0.4221)<br />HAVING<br /> acos(sin(1.3963) * sin(Lat) + cos(1.3963) * cos(Lat) * cos(Lon - (-0.6981))) <= 0.1570;<br /><br />How do this ^this is JPQL with object db :/... I wonders..Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6877629428951398731.post-14758657433044802102012-11-08T07:09:54.610-08:002012-11-08T07:09:54.610-08:00Hello,
do you know if EXTRACT is allowed in WHERE ...Hello,<br />do you know if EXTRACT is allowed in WHERE clausule?<br />ThanksJulián Martínezhttps://www.blogger.com/profile/08521643677001309992noreply@blogger.comtag:blogger.com,1999:blog-6877629428951398731.post-57816386400056083832012-05-17T08:42:12.959-07:002012-05-17T08:42:12.959-07:00Good article but you must take a look to torpedoqu...Good article but you must take a look to torpedoquery.orgXavier Jodoinhttps://www.blogger.com/profile/10965948119654174635noreply@blogger.com