|Home |Login |Registration |Struts Step by Step Tutorial |Hibernate Step by Step Tutorial |Spring Step by Step Tutorial |JSP Step by Step Tutorial |JDBC Step by Step Tutorial |Web Services Step by Step Tutorial |EJB fundamentals | ORACLE Step by Step Tutorial | SCJP 5.0 and SCJP 6.0 Study Guide | SCWCD 5.0 Study Guide | SCJP Tips
Java mock test | SCJP mock test | SCJP DUMP | SCBCD mock test |Java online test exam | JSP online test | ORACLE online test | Hibernate online test | Servlet online test | Struts online test | EJB online test | C online test | C++ online test | Aptitude online test

Java interview questions | JSP interview questions | ORACLE interview questions | Hibernate interview questions | Servlet interview questions | Struts interview questions | JDBC interview questions | C/C++ interview questions | Spring interview questions | JMS interview questions | Informatica interview questions | EJB interview questions | OOPS and Design Pattern interview questions
1600 PMP mock questions 1400 CAPM mock questions 800 SCJP 6 mock questions 600 OCAJP 7 mock questions 590 OCPJP 7 mock questions 556 SCWCD 5 mock questions 500 OCEJWCD 6 mock questions pdfDownload (java,struts, hibernet etc) JobsJobs and Walkins

 

Recent Questions

!!! Hibernate Frequently Asked Questions !!!

How to Execute Stored procedure in Hibernate ?

SCJP 1.5/1.6 Exam Kit

!!!Answer!!!- From Technical Expert

Option 1:
Connection con = null;


try {
con = session.connection();

CallableStatement st = con
.prepareCall("{call your_sp(?,?)}");
st.registerOutParameter(2, Types.INTEGER);
st.setString(1, "some_Seq");

st.executeUpdate();

Option 2:
<sql-query name="selectAllEmployees_SP" callable="true">
<return alias="emp" class="employee">
<return-property name="empid" column="EMP_ID"/>

<return-property name="name" column="EMP_NAME"/>
<return-property name="address" column="EMP_ADDRESS"/>
{ ? = call selectAllEmployees() }
</return>
</sql-query>

code :

SQLQuery sq = (SQLQuery) session.getNamedQuery("selectAllEmployees_SP");

List results = sq.list();

Answered By : null Replied Date : Mar 20 2012
Answer :


Answered By : null Replied Date : Mar 11 2012
Answer :


Answered By : null Replied Date : Mar 10 2012
Answer :


Answered By : null Replied Date : Mar 6 2012
Answer :


Answered By : null Replied Date : Feb 24 2012
Answer :


Answered By : null Replied Date : Feb 20 2012
Answer :


Answered By : null Replied Date : Feb 7 2012
Answer :


Answered By : null Replied Date : Jan 29 2012
Answer :


Answered By : null Replied Date : Jan 25 2012
Answer :


Answered By : null Replied Date : Jan 16 2012
Answer :


Answered By : null Replied Date : Jan 14 2012
Answer :


Answered By : null Replied Date : Dec 30 2011
Answer :


Answered By : null Replied Date : Dec 11 2011
Answer :


Answered By : null Replied Date : Nov 27 2011
Answer :


Answered By : null Replied Date : Nov 26 2011
Answer :


Answered By : null Replied Date : Nov 25 2011
Answer :


Answered By : null Replied Date : Nov 24 2011
Answer :


Answered By : null Replied Date : Nov 24 2011
Answer :


Answered By : null Replied Date : Nov 5 2011
Answer :


Answered By : null Replied Date : Nov 5 2011
Answer :


Answered By : null Replied Date : Oct 26 2011
Answer :


Answered By : null Replied Date : Oct 12 2011
Answer :


Answered By : null Replied Date : Sep 12 2011
Answer :


Answered By : null Replied Date : Sep 9 2011
Answer :


Answered By : null Replied Date : Aug 19 2011
Answer :


Answered By : null Replied Date : Jun 22 2011
Answer :


Answered By : null Replied Date : Jun 15 2011
Answer :


Answered By : null Replied Date : Jun 5 2011
Answer :


Answered By : null Replied Date : May 31 2011
Answer :


Answered By : null Replied Date : May 31 2011
Answer :


Answered By : null Replied Date : May 9 2011
Answer :


Answered By : null Replied Date : Apr 6 2011
Answer :


Answered By : null Replied Date : Apr 6 2011
Answer :


Answered By : null Replied Date : Mar 25 2011
Answer :


Answered By : null Replied Date : Mar 16 2011
Answer :


Answered By : null Replied Date : Mar 10 2011
Answer :


Answered By : null Replied Date : Feb 18 2011
Answer :


Answered By : null Replied Date : Feb 18 2011
Answer :


Answered By : null Replied Date : Feb 2 2011
Answer :


Answered By : null Replied Date : Jan 15 2011
Answer :


Answered By : null Replied Date : Dec 18 2010
Answer :


Answered By : null Replied Date : Dec 18 2010
Answer :


Answered By : null Replied Date : Dec 17 2010
Answer :


Answered By : null Replied Date : Dec 17 2010
Answer :


Answered By : null Replied Date : Dec 16 2010
Answer :


Answered By : null Replied Date : Dec 13 2010
Answer :


Answered By : null Replied Date : Dec 13 2010
Answer :


Answered By : null Replied Date : Dec 10 2010
Answer :


Answered By : null Replied Date : Dec 6 2010
Answer :


Answered By : null Replied Date : Dec 5 2010
Answer :


Answered By : null Replied Date : Dec 3 2010
Answer :


Answered By : null Replied Date : Nov 29 2010
Answer :


Answered By : null Replied Date : Nov 27 2010
Answer :


Answered By : null Replied Date : Nov 26 2010
Answer :


Answered By : null Replied Date : Nov 26 2010
Answer :


Answered By : null Replied Date : Nov 23 2010
Answer :


Answered By : null Replied Date : Nov 22 2010
Answer :


Answered By : null Replied Date : Nov 20 2010
Answer :


Answered By : null Replied Date : Nov 19 2010
Answer :


Answered By : null Replied Date : Nov 19 2010
Answer :


Answered By : null Replied Date : Nov 16 2010
Answer :


Answered By : null Replied Date : Nov 13 2010
Answer :


Answered By : null Replied Date : Nov 10 2010
Answer :


Answered By : null Replied Date : Nov 9 2010
Answer :


Answered By : null Replied Date : Nov 7 2010
Answer :


Answered By : null Replied Date : Nov 6 2010
Answer :


Answered By : null Replied Date : Nov 3 2010
Answer :


Answered By : null Replied Date : Oct 28 2010
Answer :


Answered By : null Replied Date : Oct 25 2010
Answer :


Answered By : null Replied Date : Oct 20 2010
Answer :


Answered By : null Replied Date : Oct 19 2010
Answer :


Answered By : null Replied Date : Oct 18 2010
Answer :


Answered By : null Replied Date : Oct 13 2010
Answer :


Answered By : null Replied Date : Oct 6 2010
Answer :


Answered By : null Replied Date : Oct 6 2010
Answer :


Answered By : null Replied Date : Oct 5 2010
Answer :


Answered By : null Replied Date : Sep 26 2010
Answer :


Answered By : null Replied Date : Sep 24 2010
Answer :


Answered By : null Replied Date : Sep 24 2010
Answer :


Answered By : null Replied Date : Sep 23 2010
Answer :


Answered By : null Replied Date : Sep 23 2010
Answer :


Answered By : null Replied Date : Sep 23 2010
Answer :


Answered By : null Replied Date : Sep 23 2010
Answer :


Answered By : null Replied Date : Sep 20 2010
Answer :


Answered By : null Replied Date : Sep 15 2010
Answer :


Answered By : null Replied Date : Sep 14 2010
Answer :


Answered By : null Replied Date : Sep 14 2010
Answer :


Answered By : null Replied Date : Sep 10 2010
Answer :


Answered By : null Replied Date : Sep 9 2010
Answer :


Answered By : null Replied Date : Sep 8 2010
Answer :


Answered By : null Replied Date : Sep 6 2010
Answer :


Answered By : null Replied Date : Sep 4 2010
Answer :


Answered By : null Replied Date : Sep 1 2010
Answer :


Answered By : null Replied Date : Sep 1 2010
Answer :


Answered By : null Replied Date : Aug 31 2010
Answer :


Answered By : null Replied Date : Aug 30 2010
Answer :


Answered By : null Replied Date : Aug 26 2010
Answer :


Answered By : null Replied Date : Aug 26 2010
Answer :


Answered By : null Replied Date : Aug 26 2010
Answer :


Answered By : null Replied Date : Aug 25 2010
Answer :


Answered By : null Replied Date : Aug 23 2010
Answer :


Answered By : null Replied Date : Aug 21 2010
Answer :


Answered By : null Replied Date : Aug 18 2010
Answer :


Answered By : null Replied Date : Aug 18 2010
Answer :


Answered By : null Replied Date : Aug 18 2010
Answer :


Answered By : null Replied Date : Aug 17 2010
Answer :


Answered By : null Replied Date : Aug 15 2010
Answer :


Answered By : null Replied Date : Aug 14 2010
Answer :


Answered By : null Replied Date : Aug 14 2010
Answer :


Answered By : null Replied Date : Aug 14 2010
Answer :


Answered By : null Replied Date : Aug 12 2010
Answer :


Answered By : null Replied Date : Aug 10 2010
Answer :


Answered By : null Replied Date : May 8 2012
Answer :


Answered By : null Replied Date : May 23 2012
Answer :


Answered By : null Replied Date : Jun 10 2012
Answer :


Answered By : null Replied Date : Jun 18 2012
Answer :


Answered By : null Replied Date : Aug 4 2012
Answer :


Answered By : null Replied Date : Aug 20 2012
Answer :


Answered By : null Replied Date : Sep 7 2012
Answer :


Answered By : null Replied Date : Sep 10 2012
Answer :


Answered By : null Replied Date : Sep 20 2012
Answer :


Answered By : null Replied Date : Oct 10 2012
Answer :


Answered By : null Replied Date : Oct 13 2012
Answer :


Answered By : null Replied Date : Oct 15 2012
Answer :


Answered By : null Replied Date : Nov 2 2012
Answer :


Answered By : null Replied Date : Nov 2 2012
Answer :


Answered By : null Replied Date : Nov 4 2012
Answer :


Answered By : null Replied Date : Nov 10 2012
Answer :


Answered By : null Replied Date : Dec 9 2012
Answer :


Answered By : null Replied Date : Dec 14 2012
Answer :


Answered By : null Replied Date : Dec 14 2012
Answer :


Answered By : null Replied Date : Jan 16 2013
Answer :


Answered By : null Replied Date : Feb 23 2013
Answer :


Answered By : null Replied Date : Feb 28 2013
Answer :


Answered By : null Replied Date : Mar 2 2013
Answer :


Answered By : null Replied Date : Mar 3 2013
Answer :


Answered By : null Replied Date : Mar 23 2013
Answer :


Answered By : null Replied Date : Mar 24 2013
Answer :


Answered By : null Replied Date : Apr 12 2013
Answer :


 

You can also contribute to this answer:

Your Name:
Answer:

 
Ask Question and get answer from Expert.
View Answers List from Expert.

The information you are posting should be related to java and ORACLE technology. Not political.