SQL to HQL

Comments

Inspirational

Posted By: toy hauler On: 10/22/10 12:31 PM

Houses are quite expensive and not everyone is able to buy it. Nevertheless, <a href="http://bestfinance-blog.com">loan</a> was created to aid different people in such cases.

Posted By: DAVISLatonya On: 11/07/10 10:21 PM

I claim that professional Master's writers are hired at the custom paper writing services. Therefore, essays finished by these academic writers can be the best!

Posted By: custom writing On: 11/12/10 1:49 PM

Very nice and helpful information has been given in this article. I must say that this is a great post. I loved reading it slide six.

Posted By: cheap hosting On: 11/22/10 8:38 AM

Share your Slide-Six presentations both live and virtually right from your desktop. ... nice article Thanks

Posted By: 11 kv lightning arresters On: 12/26/10 4:36 AM

Presentation is just awesome. I got good information about Hibernate. Presentation has covered so many different topics and I even got to know about different types of demos. I have never come across such conceptual presentation at any time in my life and will have to appreciate the great efforts of John to make it happen. I will like to get some tips on my presentation which is a project work for me from my university.

Posted By: Multivariate Testing On: 01/25/11 1:15 AM

John Whish, an interesting comparison with SQL

Posted By: Tadacip On: 01/25/11 11:50 AM

The elegant jaguar is undoubtedly an legendary animal to Cartier.

Posted By: Thomas Sabo Charms On: 01/27/11 3:50 AM

Can't beat a good scotch on the rocks.. or 5!

Posted By: Virtual Receptionist On: 01/31/11 9:08 AM

Lots of guys just talks about high quality! I claim that to buy essay is secured.

Posted By: buy essays On: 02/03/11 8:40 AM

shbt.net

Posted By: Shbt On: 02/07/11 5:41 AM

thanks

Posted By: Sohbet On: 02/07/11 5:42 AM

good works

Posted By: Chat On: 02/07/11 5:42 AM

forum

Posted By: Forum On: 02/07/11 5:43 AM

The post is written in very a good manner and it entails many useful information for me. I am happy to find your distinguished way of writing the post. Now you make it easy for me to understand and implement the concept. Thank you for the post.

Posted By: Office 2010 key On: 02/16/11 2:11 AM

Its good article. I found it on google.

I like your post. I found it when I was looking through digg. I'll go bookmark your site now.

Posted By: Thomas Sabo On: 02/22/11 8:50 AM

I've never tried HQL. What are the benefits of HQL over SQL? Is HQL stable across many different platforms?

Posted By: business voip On: 02/23/11 12:28 PM

It's not so simply to bring a pretty good essays written, preferably if you are booked. I advise you to define buy an essay and to be void from doubt that your work will be done by writing services

Posted By: buy custom essay papers On: 02/28/11 12:48 PM

จองโรงแรมราคาถูกได้เลย

Posted By: จองโรงแรม On: 03/01/11 12:12 AM

study ielts in bangkok

Posted By: ielts On: 03/01/11 12:14 AM

เรียนภาษาอังกฤษ

Posted By: เรียนภาษาอังกฤษ On: 03/01/11 12:16 AM

güzel bir konu paylaşmısınız teşekkürler.

Posted By: köpük kesici On: 03/02/11 3:21 PM

Thanks a lot for amazing presentation!

Posted By: essay service On: 03/04/11 3:54 AM

good ppt well explained

Posted By: intranet 2.0 On: 03/04/11 4:50 AM

Your blog has some of the most fascinating information! I've read several pages here and I just had to comment and let you know that I thought you've been doing a great job here. Keep it up!

Posted By: axiolabs On: 03/04/11 2:34 PM

Thanks for sharing dear buddies.

Posted By: Watch Winder On: 03/06/11 2:12 AM

Yep Great post.

Posted By: Dual Watch Winder On: 03/06/11 2:21 AM

This is very informative post so, you should keep it up and say all is well.

Posted By: Single Watch Winder On: 03/06/11 2:21 AM

Very good info here, This is what i’m looking for. thanks, i've bookmark your website.

Posted By: maigrir des cuisses On: 03/06/11 5:11 AM

I’m happy to have found your very excellent article! I agree with some of your readers and will eagerly look forward to your coming updates. Just saying thanks will not just be adequate

Posted By: Dirt Bike Games On: 03/07/11 5:16 AM

The tutorial is very simple and explained to a great level. It doesn’t take any effort from our side to grasp it! I guess now I understand what the threshold function was for and how it could be used to make striking line art conversion effects!

Posted By: window box On: 03/07/11 6:31 AM

I want to take this moment to say that I really love this blog. It has been a good resource of information for me. Thank you so much

Posted By: Windows Registry Cleaners On: 03/07/11 1:40 PM

Very nice and helpful information has been given in this article. I must say that this is a great post. I loved reading it slide six.

Posted By: Louis Vuitton Handbags On: 03/10/11 9:48 PM

Your code and slides have helped me get a better grasp on this new feature. Thanks for sharing.

Posted By: Electrical Reviews On: 03/11/11 2:45 AM

Very good points you wrote here..Great stuff...I think you've made some truly interesting points.Keep up the good work.

Posted By: sheds On: 03/11/11 7:44 AM

Great slide. Is it really hard to switch from SQL to HQL? Thanks!

Posted By: government grants for single moms On: 03/15/11 2:24 AM

The ability to create a team (gang) is designed for those players who want to participate in adventures together

Posted By: buy isk On: 03/15/11 5:52 AM

Thank you for the sensible critique. Me and my neighbor were just preparing to do some research about this. We got a grab a book from our local library but I think I learned more from this post. I am very glad to see such great information being shared freely out there.

Posted By: write my essay On: 03/16/11 2:39 PM

Thanks for this informational publocation. I think helpful to everyone who is interested in the possibility of learning from this. .

Posted By: lasix On: 03/17/11 6:23 AM

You may keep a few extras for yourself, in case the original pair breaks. Also, you may give extras to friends, or you may possibly sell them at a garage sale. If you want, you can even give the extras out as party favors.

Posted By: Ray Ban UK On: 03/19/11 4:27 AM

It’s usually around this time of year that everyone starts looking forward to the summer and even though it’s still a while away, sunglasses are certainly something you can buy right now. The best thing is that because of various market issues, the designer sunglasses market seems to have become something that everyone can get into. Designer sunglasses aren’t over priced and are certainly worth the purchase.

Posted By: Ray Ban On: 03/19/11 4:33 AM

Sunglasses are certainly a fashion statement but they are also practical and I guess that’s what makes them so popular. When the sun is shining it just feels natural to have a pair of shades on and it’s obvious that everyone else feels the same. You should have no problems finding what you need on the web.

Posted By: Ray Ban 3025 On: 03/19/11 4:33 AM

Select Ray Ban UK with gray, brown and green color lenses lens color of choice has to be while using surrounding environment without distortion, sharp edges of objects, can recognize the principle of lights of different colors. Lens color to gray, brown, a benefit to good, due to the fact color lenses for infrared, ultraviolet absorption better.

Posted By: Ray Ban 2140 On: 03/19/11 4:35 AM

HAHA

Posted By: Ray Ban 2113 On: 03/19/11 4:38 AM

Great information, thanks for sharing

Posted By: eyebrow threading On: 03/19/11 7:55 AM

Thanks for admin.nice sharing.very nice..

Posted By: Cnc Freze On: 03/19/11 7:02 PM

I just luckily stumbled upon this blog and have been reading along. Thanks for this brilliant share.

Posted By: wound bandages On: 03/21/11 7:53 PM

I was wondering the same thing. and observed your website by bing, many userful stuff here, now i’m a bit clear. I’ve bookmark your web page and also add rss. preserve us updated. | <a href="http://maquillage-pas-cher.biz/conseil-maquilllage/">conseil maquillage</a>

Posted By: conseil maquillage On: 03/23/11 10:01 AM

Thank you for the sensible critique. Me and my neighbor were just preparing to do some research about this. We got a grab a book from our local library but I think I learned more from this post. I am very glad to see such great information being shared freely out there.

Posted By: clothing manufacturer On: 03/23/11 10:54 AM

Thanks for taking this opportunity to discuss this, I feel fervently about this and I like learning about this subject. If possible, as you gain information, please update this blog with more information. I have found it really useful.

Posted By: Ball Gowns On: 03/26/11 3:09 AM

Very good info here, This is what i’m interested in. thanks, i have bookmark your internet site. | <a href="http://maigrir-des-cuisses.fr/maigrir-des-cuisses/">maigrir des cuisses</a>

Posted By: maigrir des cuisses On: 03/27/11 1:34 PM

I was wondering the same thing. and observed your website by bing, many userful stuff here, now i’m a bit clear. I’ve bookmark your web page and also add rss. preserve us updated.

Posted By: cheap LED watch On: 03/28/11 3:21 AM

I really like how your slideshow was presented. It's very educational but also very entertaining. Thanks a lot for posting this up.

Posted By: nivea cellulite cream On: 03/28/11 3:49 AM

If make a choice to accomplish the online term paper, you should understand that this involves a lot of work! Some men fail their customized research paper, just because they are not experienced! That’s bitter, but the do my essay service will assist such kind of people any time they need it.

Posted By: non-plagiarized essay On: 03/28/11 4:59 AM

Thanks for taking this opportunity to discuss this, I feel fervently about this and I like learning about this subject. If possible, as you gain information, please update this blog with more information. I have found it really useful.

Posted By: Dog behavior Training On: 03/29/11 1:02 AM

The tutorial is very simple and explained to a great level. It doesn’t take any effort from our side to grasp it! I guess now I understand what the threshold function was for and how it could be used to make striking line art conversion effects!

Posted By: Playa Del Carmen All Inclusive On: 03/29/11 5:34 AM

I want to take this moment to say that I really love this blog. It has been a good resource of information for me. Thank you so much

Posted By: hidden object games On: 03/29/11 3:18 PM

very good presentation. Slide six always provide new things.

Posted By: Shark Videos On: 03/30/11 5:30 AM

Great slides. Interesting content.

Posted By: Credit Card Factoring On: 03/30/11 4:04 PM

Thanks for this informational publication. I think helpful to everyone who is interested in the possibility of learning from this.

Posted By: viagra On: 04/02/11 12:57 PM

Thanks for the interesting article. Great slides.

Posted By: Merchant Services Loans On: 04/02/11 5:55 PM

Thanks for this informational publication. I think helpful to everyone who is interested in the possibility of learning from this.

Posted By: km-lace-wigs On: 04/04/11 3:25 AM

33 DRUGS International Pharmacy. Order Prescription ED Drugs Online Start Save Money. <a href="http://www.33drugs.net">ED Drugs Disount Pharmacy</a> 33Drugs.com benefits include: Lowest price guaranteed, 33DRUGS approved pharmacy.

Posted By: ed drugs On: 04/04/11 7:49 AM

33 DRUGS International Pharmacy. Order Prescription ED Drugs Online Start Save Money. <a href="http://www.33drugs.net">ED Drugs Disount Pharmacy</a> 33Drugs.com benefits include: Lowest price guaranteed, 33DRUGS approved pharmacy. Savings of up to 90% on common prescriptions ED drugs. Free shipping options for orders. Fully licensed approved pharmacy. Quality control system. Toll-free customer support and order line. 1-866-33-DRUGS The most complete list of popular ED drugs. Buy ED Drugs on 33Drugs.com - effective treatment for erectile dysfunction (impotence). <a href="http://www.33drugs.net/">ED Drugs Disount Pharmacy</a>

Posted By: ed drugs On: 04/04/11 8:30 AM

It is indeed an art to stop visitors with their attractive writing skills. The author really knows his job well. Thanks for sharing.

Posted By: moleskin On: 04/04/11 6:14 PM

Can't beat a good scotch on the rocks.. or 5!

Posted By: write my essay for me On: 04/05/11 11:09 AM

It is indeed an art to stop visitors with their attractive writing skills. The author really knows his job well. Thanks for sharing.

Posted By: liposuction risks On: 04/06/11 3:59 AM

Really great video, I enjoyed it.

Posted By: investing On: 04/08/11 9:40 AM

It’s really great article. I would like to appreciate your work and would like to tell to my friends.

Posted By: amazon affiliate script On: 04/08/11 11:59 AM

Thanks for sharing.

Posted By: amazon affiliate On: 04/08/11 12:05 PM

It’s really great article. I would like to appreciate your work and would like to tell to my friends.

Posted By: amazon associate On: 04/08/11 12:10 PM

I would like to congratulate the author for his brilliant efforts in putting this article together and sharing with us. Thanks for sharing.

Posted By: incontinence products On: 04/09/11 11:32 AM

would like to congratulate the author for his brilliant efforts in putting this article together and sharing with us. Thanks for sharing.

Posted By: Pellet Mill On: 04/10/11 10:32 AM

This was well done...very tasteful and engaging.

Posted By: earn money online surveys On: 04/11/11 10:52 AM

Your work is very good and I appreciate you and hopping for some more informative posts. Thank you for sharing great information to us.

Posted By: flowers delivery Canada On: 04/13/11 7:29 AM

Your blog is really excellent

Posted By: send flower to Australia On: 04/13/11 7:29 AM

Thanks, I really liked your speech.

Posted By: custom writing On: 04/13/11 8:19 AM


Pleasant work and much success in your business efforts!Substantially, the article is in reality the sweetest on this precious topic.

Posted By: Portable Displays On: 04/14/11 6:19 AM

Just cool

Posted By: maquillage pas cher On: 04/14/11 7:57 AM

Excellent taken Pictures.

Posted By: Plumber hertford On: 04/15/11 4:13 AM

Adding whey protein powder to your diet plan is an ideal way to give your body the whey protein it needs without the fat. Loaded with 25 grams of whey protein and very low in fat, whey protein powder will definitely help you develop lean and sexy muscle mass.

Posted By: wheyproteinspowder On: 04/15/11 5:17 PM

Thanks for making such a cool project. I've been checking the site for the Windows version, but I never left a comment about it. I know you are working hard and doing it for free so you shouldn't feel rushed or anything.

Posted By: newsletter templates On: 04/18/11 3:35 AM

Adding whey protein powder to your diet plan is an ideal way to give your body the whey protein it needs without the fat. Loaded with 25 grams of whey protein and very low in fat, whey protein powder will definitely help you develop lean and sexy muscle mass.

Posted By: Long Wigs On: 04/18/11 5:26 AM

its good to see this information in your post

Posted By: Buy Thesis On: 04/18/11 7:34 AM

Really liked reading this. Keep it up!

Posted By: what does asbestos look like On: 04/19/11 2:11 PM

I recently came across your blog and have been reading along and the article you have written is very interesting.

Posted By: home improvement On: 04/19/11 10:16 PM

I really like how your slideshow was presented. It's very educational but also very entertaining. Thanks a lot for posting this up.

Posted By: African Mango On: 04/20/11 5:10 AM

Houses are quite expensive and not everyone is able

Posted By: Thesis Writing On: 04/20/11 6:45 AM

Pleasant work and much success in your business efforts!Substantially, the article is in reality the sweetest on this precious topic.

Posted By: Assignments On: 04/20/11 6:46 AM

It’s really great article. I would like to appreciate your work and would like to tell to my friends

Posted By: Courseworks On: 04/20/11 6:46 AM

I like your post. I found it when I was looking through digg. I'll go bookmark your site now.

Posted By: cadeau original On: 04/20/11 10:46 AM

Really great post, Thank you for sharing This knowledge.Thank you very much for sharing this knowledge.this graph really conveyed the part which i was looking for.

Posted By: kids books On: 04/21/11 12:07 AM

I would like to appreciate your work and would like to tell to my friends.

Posted By: Novoline On: 04/21/11 12:20 AM

Asha Infotech offers a bouquet of web based services to its clients including web designing and development, local SEO services india and internet marketing as well as print and graphic design services. We specialize in local SEO services and offer these services to local businesses at highly affordable costs. Our local SEO Services are highly professional and will help you get quick results.

Posted By: seo services india On: 04/22/11 6:54 AM

Thanks for taking this opportunity to discuss this..
It has been a good resource of information for me

Posted By: منتديات On: 04/22/11 7:53 PM

Loaded with 25 grams of whey protein and very low in fat, whey protein powder will definitely help you develop lean and sexy muscle mass.

Posted By: flour mills On: 04/22/11 10:48 PM

I want to take this moment to say that I really love this blog. It has been a good resource of information for me. Thank you so much

Posted By: Hip Hop Blog On: 04/23/11 9:06 AM

Interesting slides. Nicely presented. Really great site.

Posted By: Merchant Loans On: 04/23/11 8:34 PM

It was a very good read indeed. Very informative and interesting at the same time. Thanks to the author for this wonderful share. Just bookmarked this URL.

Posted By: medical supplies On: 04/24/11 11:32 AM

thank you nice information.

Posted By: bosch servisi On: 04/25/11 9:44 AM

It was a wonderful chance to visit this kind of site and I am happy to know.

Posted By: intranet software On: 04/26/11 6:36 AM

This is a very fine object, I think there will be unlimited people like it, of course, I was one of the them.

Posted By: love messages On: 04/27/11 1:12 AM

A real artistic start of the show. I love how you combine creative images with a pure technical topic. Like your blog a lot! ;)

Posted By: liebeskummer hilfe On: 04/28/11 5:19 AM

Well that's cool one! Your work is very good and I appreciate you and hopping for some more informative posts. Thank you for sharing great information to us.keep it up

Posted By: essay writing On: 04/29/11 9:16 AM

Great work dude, u gave nice post to us. Thanks for spending the time to discuss this, I feel strongly about it and love learn I was very pleased to find this site. I wanted to thank you for this great read!! This is a very informative post, it helps me more.ing more on this topic.

Posted By: help with dissertation On: 04/29/11 9:18 AM

Nice one!Thank you for the sensible critique. Me and my neighbor were just preparing to do some research about this. We got a grab a book from our local library but I think I learned more from this post. all discussion is very informative.

Posted By: help with dissertation On: 04/29/11 9:20 AM

Thank you for sharing to us.there are many person searching about that now they will find enough resources by your post.I would like to join your blog anyway so please continue sharing with us

Posted By: Careprost On: 04/30/11 2:01 AM

недвижимости в Греции дома квартира купить квартиру продажа квартир агентство недвижимости продажа Греции


Posted By: недвижимости в Греции On: 05/01/11 8:11 AM

thank you for your post.

Posted By: office 2010 On: 05/09/11 5:12 AM

Thank you so much for the nice blog.......

Posted By: Buy darvocet online On: 05/09/11 9:39 AM

Fantastic post, I really look forward to updates from you..

Posted By: Flowers UK On: 05/11/11 1:44 AM

Thanks for the exciting article, I believe you've great style of writing and really talent of journalist

Posted By: phentermine without prescription On: 05/11/11 2:46 PM


Thanks for featuring my craft fair table! There are some fabulous ideas out there. Right now mine are stacked on top of each other and used as a side table
http://www.cheapjordans2011forsale.com

Posted By: Cheap Jordans Online On: 05/13/11 4:40 AM


Thanks for featuring my craft fair table! There are some fabulous ideas out there. Right now mine are stacked on top of each other and used as a side table
http://www.cheapjordans2011forsale.com

Posted By: Cheap Jordans Online On: 05/13/11 4:45 AM

Interesting slides. Good content. Nicely presented.

Posted By: Working Capital On: 05/16/11 5:11 PM

I’m impressed, I need to say. Really not often do I encounter a blog that’s each educative and entertaining, and let me tell you, you have got hit the nail on the head. Your thought is excellent; the issue is something that not enough people are talking intelligently about. I’m very happy that I stumbled across this in my search for something referring to this....

Posted By: cell phone spyware On: 05/17/11 12:27 AM

Brian, it is a interesting day for Microsoft. MSN just spent 8.5 billion to buy Skype.

Linda, I am looking forward to what Google has in mind to compete in the iPad market. This is just the start of Google's offerings to attract Apple users.

Posted By: jack stand On: 05/17/11 12:55 AM

around A look at Maybe you'll find happiness in your sight shopping heaven and earth You'll find our price is

Posted By: hydraulic bottle jack On: 05/17/11 12:56 AM

We need your support and trust!!!http://www.styshops.com/ Dear friends, please temporarily stop your footsteps To our website Walk

Posted By: Base cap On: 05/17/11 12:58 AM

I've move through your own outstanding weblog that place on the net, have quite a few associates together with me to looking through your own content articles. No matter what we are, and also whatever we would like, the primary concept you've been displayed was fulfilled by us. Thank you so much for sharing so excellent opinion, and it create us have a sense of relaxed and ease.

Posted By: cell phone spy software On: 05/17/11 4:49 AM

I hope it will start a discussion about how the world can benefit from the intersection between the 2-screen experience and the conc

Posted By: restasis On: 05/17/11 9:12 AM

I agree with some of your readers and will eagerly look forward to your coming updates. Just saying thanks will not just be adequate

Posted By: Movie torrent On: 05/18/11 3:52 AM

Finally, an issue that I am passionate about. I have looked for information of this caliber for the last several hours. Your site is greatly appreciated.

Posted By: essay writing On: 05/18/11 7:11 AM

All post here really a cool things for us searchers.

Posted By: tax accountant On: 05/18/11 9:31 AM

This is a well-written article. Very interesting and insightful. Thanks for sharing it with us. Excellent work on the Vernhindern!

Posted By: buy lomotil On: 05/19/11 3:21 AM

We're a group of volunteers and opening a new scheme in our community. Your website provided us with valuable information to work on. You have done a formidable job and our whole community will be thankful to you.

Posted By: http://www.lyricaonline.com On: 05/19/11 3:22 AM

I think more people need to read blogs like this. Its so important to know how to construct a great blog to get people interested and you've done just that. The content is great, the videos are perfect for what you're trying to say. Awesome, man.

Posted By: Dissertation Proposal On: 05/20/11 9:46 AM

Such posts are amazing And They Always Enlighten You With Something New.

Posted By: University Essaysl On: 05/20/11 9:51 AM

These are wonderful! Thank you for sharing

Posted By: gucci outlet On: 05/21/11 5:36 AM

A comprehensively detailed and attention grabbing review that you wrote in this article. I am really convinced the way you look. The way you describe the whole thing is simple and understandable

Posted By: Buy Essay On: 05/21/11 1:53 PM

Usually I do not post comments on blogs, but I would like to say that this blog really forced me to do so! Thanks,for a really nice read.

Posted By: essay help On: 05/21/11 1:56 PM

I am really impressed by this blog!Very clear explanation of issues is given and it is open to everyone.It contains true and fair information. Your website is very useful.

Posted By: Dissertation Help On: 05/21/11 1:57 PM

Love the way you write---very witty. Nice post.

Posted By: Essay Writing  On: 05/21/11 1:58 PM

Nice cold drinks. In summer it is must needed. I am starving from water. So i need it.

Posted By: Diamond buying guide On: 05/22/11 11:30 AM

The non-lined diagnostic system (NLS). Advanced information technologies in the field of active homeostasis control are being introduced into the world market.

Posted By: Bioenergetics Medicine On: 05/23/11 3:43 PM

I wanted to thank you for this great read!! I definitely enjoying every little bit of it I have you bookmarked to check out new stuff you post.

Posted By: event management delhi On: 05/25/11 4:32 AM

This is a great blog posting and very useful.

Posted By: personal loans in delhi On: 05/25/11 4:34 AM

Orbitz travel provides complete traveling facilities for any person who is planning for vacation. Cheapest airline tickets, car rentals and hotel reservation can be done with the help of orbitz travel.

Posted By: orbitz travel On: 05/25/11 10:16 AM

I wanted to thank you for this great read!! I definitely enjoying every little bit of it I have you bookmarked to check out new stuff you post.

Posted By: Super bowl jerseys On: 05/26/11 3:22 AM


I like the details of your blog.

may I suggest this link for added details on fruits to that would make your skin beautiful.

Posted By: CNA Classes Online On: 05/26/11 4:38 AM

I really loved reading your blog. It was very well authored and easy to understand.

Posted By: CNA Certification On: 05/26/11 4:39 AM

I completely agree with you. I really like this article. It contains a lot of useful information. I can set up my new idea from this post. It gives in depth information.

Posted By: House And Land Packages Melbourne On: 05/27/11 4:30 AM

complete traveling facilities for any person who is planning for vacation. Cheapest airline tickets, car rentals and hotel reservation can be done with the help of orbitz travel.

Posted By: pv solar panels On: 05/27/11 10:32 AM

The site was informative and contain useful content for the visitors. It got good posts as well. I will bookmark this site for future viewing. Thanks for sharing.

Posted By: train fares On: 05/28/11 9:43 AM

Interesting post and thanks for sharing. Some things in here I have not thought about before.Thanks for making

Posted By: dubai web design On: 05/30/11 11:10 AM

I declare that professional Master's writers are hired at the norm paper writing services. As a result, essays finished by these academic writers will be the perfect one.

Posted By: Payday Loans On: 06/01/11 8:27 AM


Gathering together ideas is very difficult to do and for that I salute the one who made this blog for I know this has been a product of a combination of diverse brilliant ideas
<a href="http://www.retractablebabygate.org/take-advantage-of-the-retractable-baby-gate/">retractable baby gate</a>

Posted By: Blog_Commenting_Service On: 06/02/11 5:02 AM

http://www.retractablebabygate.org/

Posted By: Blog_Commenting_Service On: 06/02/11 5:03 AM


Gathering together ideas is very difficult to do and for that I salute the one who made this blog for I know this has been a product of a combination of diverse brilliant ideas

Posted By: retractable baby gate On: 06/02/11 5:04 AM

your creative writing ability has inspired me. Really the article is spreading its wings rapidly

Posted By: ECN Broker On: 06/02/11 12:12 PM

Wow, this is superb!!i am impressed with the quality of writing here.Keep up the good work!

Posted By: cheap logo design On: 06/03/11 7:39 AM

I appreciate this wonderful post!

Posted By: fathers day gifts delivery Chile On: 06/04/11 7:20 AM

The slides are pretty effective and I like it to be used in presentations. But you could get sleepy very easily.

Posted By: auto insurance quotes On: 06/04/11 9:48 AM

best price watches

Posted By: buy watches On: 06/04/11 4:04 PM

Hey, just looking around some blogs, seems a pretty nice platform you are using.

Posted By: Furla handbags On: 06/07/11 6:47 AM

Add Comment

Comments have been closed.

Transcript

no image

Slide Text

Slide Notes


Slide 1

no text exists for this slide

no notes exist for this slide

Slide 2

no text exists for this slide

Somewhere Over the Rainbow Conference

Slide 3

no text exists for this slide

We will look at: Transferring your knowledge of SQL to HQL Learning how to let hibernate do a whole load of work for you Look at some common gotchas (and how to solve them) how we can use objects in our code instead of queries Image credit: http://www.flickr.com/photos/24293932@N00/2752221871/

Slide 4

no text exists for this slide

At the end of this you will not be: A master of hibernate A OOP guru Wishing you were a PHP developer (hopefully!) Image credit: http://www.flickr.com/photos/24293932@N00/2752221871/

Slide 5

no text exists for this slide

Who is this guy? Devon CFUG Aliaspooryorik Crisp Group Certified Expert in Advanced ColdFusion Image credit: http://www.flickr.com/photos/shereen84/3187315381/sizes/l/

Slide 6

no text exists for this slide

This is my first time speaking at a conference so be nice Image credit: http://www.flickr.com/photos/prh/490428886/sizes/l/

Slide 7

no text exists for this slide

Some twitter hash tags if you want to follow along Image credit: http://www.flickr.com/photos/tveskov/3387394098/

Slide 8

no text exists for this slide

What is HQL? HQL is an acronym for Hibernate Query Language It’s similar to SQL, except you query the objects and properties instead of the underlying database tables and columns Means you can write much more object orientated code (if you want to) Can return objects, which can have associations and behaviour image credit: http://www.flickr.com/photos/dullhunk/358365339/sizes/l/

Slide 9

no text exists for this slide

What is Hibernate? Hibernate is: an open source Java persistence framework now built-in to ColdFusion 9 (and soon Railo). It primarily focuses on mapping Objects to a Relation Database – a technique known as Object Relational Mapping (ORM). It sits between your persistence layer and the database – it acts as a gateway to the database. Wikipedia says: “Hibernate is an object-relational mapping (ORM) library for the Java language, providing a framework for mapping an object-oriented domain model to a traditional relational database. Hibernate solves object-relational impedance mismatch problems by replacing direct persistence-related database accesses with high-level object handling functions. “ Image credit: http://www.flickr.com/photos/oberazzi/318947873/sizes/l/

Whats ORM


What’s ORM?

So what is Object Relational Mapping (ORM)? Quote from: http://en.wikipedia.org/wiki/Object-relational_impedance_mismatch “Solves the object-relational impedance mismatch is a set of conceptual and technical difficulties that are often encountered when a relational database management system (RDBMS) is being used by a program written in an object-oriented programming language or style; particularly when objects or class definitions are mapped in a straightforward way to database tables or relational schemata. This practice has been recommended and documented by some object-oriented literature as a way to use databases in object-oriented programs” I say: “Object Relational Mapping is a way of mapping objects to a relational database. The idea is that you as a developer can think in terms of objects, rather than thinking about how to persist the objects in a database. “ Image credit: http://www.flickr.com/photos/oberazzi/318947873/sizes/l/

Slide 11

no text exists for this slide

Hibernate generates SQL for you; so you don’t have to do the slow and boring process of writing 4 SQL queries per object (Insert, Select, Update & Delete). This means you’re more productive because: You don’t have to write repetitive code and can focus on the cool stuff The database schema will be created for you (great for dev worth tweaking for production) Less code for you to maintain Less typos / bugs Easier for multi-developers to work on the same app All of which means you have more time to manage your fantasy football team. Image credit: http://www.flickr.com/photos/wherearethejoneses/1070506827/sizes/o/

Hibernate Facts


Hibernate Facts...

Mature - 80k lines of code Stable - 25k lines of unit tests Database Agnostic - Microsoft SQL Server, MySQL (best with innodb), PostgreSQL, Oracle, Sybase, Derby, SQLite, DB2... - Doesn’t support MS Access (which is a great selling point!) Performance - Tuned per database (for example for update only includes dirty fields) - Lazy loading (associations can be fetched when needed) - Caching Image credit: http://www.flickr.com/photos/stewart/461099066/sizes/l/

Slide 13

no text exists for this slide

No! SQL is useful for: Bulk update/insert/delete (although hibernate can handle bulk updates). Populating database. Complex reports which don't need objects Caveat about changes caused by HQL bulk operations or SQL operations might not be match Hibernate cache. Image credit: http://www.flickr.com/photos/unloveable/2387709961/sizes/o/

Slide 14

no text exists for this slide

So how do I run HQL statements? Meet your new friend: ORMExecuteQuery( hql ); Introduced in ColdFusion 9.

Slide 15

no text exists for this slide

Time to look at some simple HQL examples. Got next slide! Image credit: http://www.flickr.com/photos/andyjarrett/524195523/

Slide 16

no text exists for this slide

Before we write any HQL we need to look at our persistent CFCs and how they map to the database. Image credit: http://www.flickr.com/photos/shortbread1015/2668073706/

Slide 17

no text exists for this slide

From Examples (01) http://localhost/sotr2010/ex01_from/ My First HQL: The simplest HQL statement you can write is “from myEntity”. This will return an array of “myEntity” objects. Case Gotcha! HQL Entity names are case sensitive. With SQL we don’t have to worry about this so be warned! Displaying the Results: As ORMExecuteQuery() returns an array, we can simply loop through the array and then call the implied getters which ColdFusion creates for you. Miss Query recordsets?: The new EntityToQuery() function can convert an array of objects to a recordset. Obviously you now can’t access the getters and setters. Image credit: http://www.flickr.com/photos/35014792@N00/337187361/

Slide 18

no text exists for this slide

Where Clause Examples (02) http://localhost/sotr2010/ex02_where/ Where Clause: The standard SQL expressions are available in HQL Case Sensitivity: This works because case sensitivity does not apply to property names. Expressions: The standard SQL expressions work. Alternative Expressions: You can also use the != expression for not equal. Functions & Wildcards: The lower and upper functions can be used for comparing performing like matches. In and between work the same as in SQL Image credit: http://www.flickr.com/photos/35014792@N00/337187361/

Slide 19

no text exists for this slide

Select Examples (03) http://localhost/sotr2010/ex02_select/ Using an Alias: You can use select statements in HQL. This example returns an array of Artist objects (same as "from Artist" in previous example). In this example I have used an alias. The alias tends to be the entity name as lowercase (from the Java world), although it is up to you. Gotcha: You need to use an alias if you want to reference it in the select statement otherwise you’ll get an nasty error. Gotcha again: The alias that we used is “artist”, whereas in the select we are called “Artist”. Remember that HQL is case-sensitive Will This Work? Yes it does. You know I said it's case sensitive, well this is only partially true, as keywords (select / from etc ) can be any case. It's applies to entity names and property names. Incidentally the “AS” keyword is optional. I tend to include it as I think it makes the code easier to read. Selecting Specific Properties: So far we have only returned objects in our HQL. What if you just wanted to return specific properties. Well, you can. Unfortunately it returns an array inside an array, which is not particular nice to work with. Yet Another Gotcha: You may think that we could solve the problem of having to work with nested arrays by using EnityToQuery. Sadly, this doesn’t work. Displaying: We need to write code that references each value by it’s position in the array to show our results in a simple list. This is not ideal as it makes it hard to see what will be displayed by looking at the code that we use to display the result. Image credit: http://www.flickr.com/photos/35014792@N00/337187361/

Slide 20

no text exists for this slide

Ordering http://localhost/sotr2010/ex04_orderby/ Not very interesting – it does what you’d expect. Image credit: http://www.flickr.com/photos/35014792@N00/337187361/

Slide 21

no text exists for this slide

Group By http://localhost/sotr2010/ex05_groupby/ Distinct: same as SQL Group by: Same as SQL. Group by is often faster to execute that Distinct. Group by and functions: Same result as SQL, although we are back to having nested arrays. A better way? A different way to get a list of unique states, you can use a subquery. You may find that you may get better performance by doing this as the database isn’t having to compare each row, this does depend on the database vendor. Image credit: http://www.flickr.com/photos/35014792@N00/337187361/

Slide 22

no text exists for this slide

Parameters http://localhost/sotr2010/ex06_parameters/ Positional Parameters: We are used to passing parameters with the cfqueryparam tag, which you should do for security and performance. We can do something similar in ORMExecuteQuery() and HQL. This example uses positional parameters. The values are passed in as an array which must be in the correct order. Named Parameters: A nicer way to pass values is to use named parameters. These don’t need to match up the property names, they just need to be value variable names. The values are passed in as a struct and can be in any order. The parameters names are not case-sensitive. Image credit: http://www.flickr.com/photos/35014792@N00/337187361/

Slide 23

no text exists for this slide

Functions http://localhost/sotr2010/ex07_functions/ Substring: Substring is the HQL equivalent of CFML's Mid function.  Length: length() and trim() functions are available. This example needs trim as the password fieldtype is char. Locate: Locate is the HQL equivalent of CFML's Find. Like Find(), it is case sensitive. Aggregates: max() returns max value min() returns min value avg() returns average value sum() returns sum abs() returns absolute value (no - sign) Image credit: http://www.flickr.com/photos/35014792@N00/337187361/

Slide 24

no text exists for this slide

Expressions http://localhost/sotr2010/ex08_expressions/ Concatenation: Either method works Create Artists: Need to set up some Artists with null data to demonstrate. Case Statement: simple case statement. Note the 3 different version of "is not null". Coalesce: Coalesce returns the first not null value. Simpler version of previous example. Delete: Yes, you can delete data with HQL! Note that it returns the number of deleted records. Image credit: http://www.flickr.com/photos/35014792@N00/337187361/

Slide 25

no text exists for this slide

Although HQL is like SQL you can lots of things in HQL that you can't in SQL. Image credit: http://www.flickr.com/photos/nereski/3861447

Slide 26

no text exists for this slide

Relationships Undefined ORM relationship: In SQL you create the relationships between tables using joins. We can do this in HQL as well. Art Entity: To get the previous example to work we needed to have a property for the artistid foreign key in the Art table so that we could reference it in the HQL. We also ended up with a nested array – more on this later. Gotcha: You can't use "JOIN ON" syntax Set up a many-to-one relationship in the Art Entity to Artist ------------------------------------------- http://localhost/sotr2010/ex12_relationships/join.cfm Get all art objects by an artist in the 'SD' state. Don't need to specify the properties in the join. ------------------------------------------- http://localhost/sotr2010/ex12_relationships/implicit-join.cfm Improving on the last example, you don't even need to specify a join. Cool huh!

Slide 27

no text exists for this slide

Many-to-One Define relationship in Art.cfc: ColdFusion ORM lets you create the relationships between Entities by defining them in the CFC. Here we have a many-to-one relationship between art and artist. Note that we don’t have the artistid property in Art anymore. Join: Now we can simply use a join without needed to specify how the join is constructed. Implicit Join: We can improve on the previous example by not even mentioning the Artist Entity. Cool huh! What we are doing is using the artist property in Art.cfc to then match the id of the Artist object.

Slide 28

no text exists for this slide

Bi-directional Artist.cfc: Artist has a one-to-many relationship with Art Art.cfc: Art has a many-to-one relationship with Artist Size of a Collection: We want to find all artists who have one piece of art Size of a Collection (alternative): The same as the last example with alternative syntax Many to one null: Find all the Art objects that don’t have an Artist (which will be none!)

Slide 29

no text exists for this slide

Inheritance Inheritance and ORM is a whole presentation in itself, so I’ll leave that for another day. For now all you need to know is that Inheritance is a Object Orientated Term meaning an “IS-A” relationship. Part.cfc: Imagine you were building a stock system for a garage. You’d might create a Super Class of Part which the more specialised sub classes Tyre and DiscBrake extend. Tyre.cfc: Extends Part and adds additional properties DiscBrake.cfc: Extends Part and adds additional properties Populate: Let’s add some Parts to our application. Filter By Class: We want to know what Tyres we need to re-order as we have less that 4 in stock. Delete By Class: You can also find multiple tyres using IN.

Slide 30

no text exists for this slide

Tips and Tricks HashMap: So far, when selecting properties, the nested arrays we get have not been very nice to work with. A hashmap can help. Displaying a Map: The hashmap means we can have much more descriptive code. Map Gotcha: Unlike a ColdFusion struct, the map keys are case sensitive. Debugging HQL: One of the things I like about using queries in ColdFusion is being able to see the SQL statement that is executed. Well, there is a setting: this.ormsettings.logsql="true“ You can use which logs the SQL statement that hibernate creates to the console. You can have ColdFusion log directly to the console or a file. There is an excellent post by Rupesh Kumar (one of the ColdFusion engineering team) about how to do it: http://www.rupeshk.org/blog/index.php/2009/07/coldfusion-orm-how-to-log-sql/ Personally, I like to be able to see the SQL as debugging info, so I have a method in a super class, which gets the SQL hibernate generates and logs it (I use LogBox) if I’m in development mode. I find this really useful. Params List Problem: One problem that has been identified with the ORM implementation in ColdFusion is passing lists. This script demonstrates the problem. Params List Solution: This solution was posted by Barney Boisvert, which works nicely. Again you would want to have this all encapsulated in a super class, so you can largely forget about it. Image credit: http://www.flickr.com/photos/nozzer/3990622685/sizes/o/

Slide 31

no text exists for this slide

Cf-orm-dev http://groups.google.com/group/cf-orm-dev Hibernate HQL docs: http://docs.jboss.org/hibernate/core/3.3/reference/en/html/queryhql.html Rupesh Kumar on Logging the SQL: http://www.rupeshk.org/blog/index.php/2009/07/coldfusion-orm-how-to-log-sql/ Image credit: http://www.flickr.com/photos/tomsen/443379474/

Slide 32

no text exists for this slide

Thank you all for not leaving. I’ll let you head off for lunch now. Image credit: http://www.flickr.com/photos/dreyboblue/2299422762/