aspose file tools*
The moose likes JDBC and the fly likes null resultset Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "null resultset" Watch "null resultset" New topic
Author

null resultset

JayaSiji Gopal
Ranch Hand

Joined: Sep 27, 2004
Posts: 303
I am calling a stored procedure from a java program as follows:



When I run the Stored procedure, i get one record. The outparam in the above code also returns "SuCCESS". However, rs = st.getResultSet(), returns null.

What could be the reason? The same code, at exactly in a different method works perfectly fine.

Please assist.


SCJP 1.4, SCWCD 1.4<br /> <br />Thanks in advance!<br />Jayashree.
venkat vanukuri
Greenhorn

Joined: Mar 12, 2005
Posts: 3
Jayashree,

I guess one uses Result set to deal with objects returned. for example Oracle data type CURSOR.
In your case i see no reason to use result set.

I might be wrong.

Hope it helps


Venky<br />SCJP 1.4,IBM 285
venkat vanukuri
Greenhorn

Joined: Mar 12, 2005
Posts: 3
one more suggestion if you have to use Result Set,
try using rs = st.execute(); rather than boolean b = st.execute();.

Hope it helps.

Regards
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: null resultset
 
Similar Threads
got error: Invalid column index
procedure call
problem : callable statement / COBOL services How to get ResultSet(s)
CLI0612E Invalid parameter number error when executing a stored procedure
Call to Stored Proc Returns 1st Row of RS into callableStmt