problem with resultset in web service method

[benjamin yap]

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

    @WebMethod(operationName = "db")
    public ResultSet db(@WebParam(name = "keyword")
    String keyword) {
        //RESULTSET RS =NULL;
        //DATABASE CONNETION
        //CREATING NEW STATEMENT "SELECT * FROM APP_"+KEYWORD";
       //RS = EXECUTE THE STATEMENT
        return RS
    }

[Ivan Krizsan]

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]

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]

Try this: http://java.sun.com/docs/books/tutorial/jdbc/basics/