File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Web Services and the fly likes problem with resultset in web service method Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » Web Services
Bookmark "problem with resultset in web service method" Watch "problem with resultset in web service method" New topic
Author

problem with resultset in web service method

benjamin yap
Greenhorn

Joined: Aug 06, 2009
Posts: 2
Hi, i actually have a webservice method that retrieve datas from my oracle database.

I have resultset as a return type. I have problem running this method. I cant return a resultset in a web service method.

I am using netbeans 6.7 IDE

Ivan Krizsan
Ranch Hand

Joined: Oct 04, 2006
Posts: 2198
    
    1
Hi!
Right, you cannot return the result set itself but you can extract the data returned in the result set and return the data, perhaps in some kind of data transfer object.
Best wishes!
benjamin yap
Greenhorn

Joined: Aug 06, 2009
Posts: 2
Ivan Krizsan wrote:Hi!
Right, you cannot return the result set itself but you can extract the data returned in the result set and return the data, perhaps in some kind of data transfer object.
Best wishes!


Hmm could you give me more details or some sample code? that would be good. thanks
Ivan Krizsan
Ranch Hand

Joined: Oct 04, 2006
Posts: 2198
    
    1
Try this: http://java.sun.com/docs/books/tutorial/jdbc/basics/
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: problem with resultset in web service method
 
Similar Threads
Unit testing using dbunit
Method keeps returning null
Reusing ResultSet object in Servlets.
jsf and database connection problem
Closing Statements