Solved

Hibernate

Posted on 2006-06-15
3
1,264 Views
Last Modified: 2013-11-24
Hi

Present we are using Oracle stored procedures and Callable statements to invoke those procedures to deal with data in our applicaiton JDBC part.  Now we are planning to re-develop that part using Hibernate.  I have some doubts

1. Can we write complex queries using HQL and how fast those are?

2. Can we avoid connection pooling provided by hibernate? Instead of that can we use weblogic container managed pooling mechanism?  Which one is faster.

3. If we call stored procedures how hibernate will handle? is it faster. Im asking about performance.

4. In JDBC we will get ResultSet. In which form we will get results if we use hibernate?

5. Is Hibernate is more reliable if we are having more secured and complicated transactions?

6. If i want to pass one hibernate session into other how i can do?

7. Is there any other technology which is simple and more reilable than hibernate in my senario?

we will deal with wast product data information in our applicaiton.

Good suggestions please. and please dont give references like hibernate.org etc.. i have gone through all those. I need answers form experts who worked extensively on hibernate.
0
Comment
Question by:anumalas
  • 2
3 Comments
 
LVL 4

Accepted Solution

by:
orhanbaba earned 250 total points
ID: 16926632
you can use complex queries in hibernate it can be slow alittle bit  there is no bigger difference.
you can use hibernates pools it is easy to manage and has strong caching capabilities.
calling sp is faster not because of hibernate. stored procedures are compiled on dbserver. there is no difference between hibernate or others
you can use list array list or whatever you want. jdk 5 has serious advantegers about generics it is easy to code.
yes it is reliable .
hibernate session factory will be helpfull.

hibernate is  EJB3 (it is not but looklike that :) ) container. you can use oracle toplink or EJB3 supported app. servers.

The main goel is isolating your applications from database. It is very important because if you change sth from db you dont need to change full of your source.

sorry about bad english
0
 
LVL 3

Author Comment

by:anumalas
ID: 17041160
Suppose if i convert exisitng stored procedures into prepared statements and complex queries is there any performance leak using hibernate ??
0
 
LVL 4

Expert Comment

by:orhanbaba
ID: 17042578
you can use stor. proc. in hibernate. you dont need to convert them to hql.
if you want to convert them to sql queries yes you can have some performance issues. at this point hibernate uses some caching techniques.
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
github account with ecipse 1 47
HashTable highest marks enumeration alternative 9 37
servlet example 17 30
throw exception 21 44
Introduction This article is the second of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers the basic installation and configuration of the test automation tools used by…
Java functions are among the best things for programmers to work with as Java sites can be very easy to read and prepare. Java especially simplifies many processes in the coding industry as it helps integrate many forms of technology and different d…
Viewers learn about the third conditional statement “else if” and use it in an example program. Then additional information about conditional statements is provided, covering the topic thoroughly. Viewers learn about the third conditional statement …
Viewers learn how to read error messages and identify possible mistakes that could cause hours of frustration. Coding is as much about debugging your code as it is about writing it. Define Error Message: Line Numbers: Type of Error: Break Down…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question