Function with RETURN TYPE RECORD Called From JAVA

Поиск
Список
Период
Сортировка
От Sumita Biswas
Тема Function with RETURN TYPE RECORD Called From JAVA
Дата
Msg-id 016a01c43bb4$16978f80$dc656540@amer.cisco.com
обсуждение исходный текст
Ответ на Re: Date addition using Interval  (Richard Huxton <dev@archonet.com>)
Ответы Re: Function with RETURN TYPE RECORD Called From JAVA  ("Carl E. McMillin" <carlymac@earthlink.net>)
Список pgsql-general
Hi All,

I have a Function that returns a variable of Type RECORD.
PFA the .sql file in which the Function is written.

When I execute this Function from JAVA and try to get the Return
Variable in a ResultSet object I get the following Error:

Exception in thread "main" java.lang.ClassCastException
        at com.cisco.ccm.car.general.Test.testStoredProc(Test.java:119)

Here is the JAVA Code that I am using:

---------------------------------------------------------------
    CARConnector objCARConn = new CARConnector();
    CallableStatement objCallStmt = null;

    objCallStmt = objCARConn.prepareCall("{ ? = call
Proc_ConferenceSummary(?,?,?,?,?) }");
    objCallStmt.registerOutParameter(1, 12);
    // '12/1/2003','1/23/2004',1,1,0,5001
    //'3/5/2004','3/5/2004',1,1,5001

    objCallStmt.setString(2,"3/5/2004");
    objCallStmt.setString(3,"5/5/2004");
    //objCallStmt.setString(3,"3/5/2004");
    objCallStmt.setInt(4,1);
    objCallStmt.setInt(5,1);
    objCallStmt.setInt(6,5001);
    objCallStmt.execute();
    ResultSet rs = (ResultSet)objCallStmt.getObject(1);//THIS IS
WHERE I GET THE CLASSCASTEXCEPTION
---------------------------------------------------------------

Please let me know in case I am doing something wrong, or there is a
different way of doing things.

Regards,
Sumita


В списке pgsql-general по дате отправления:

Предыдущее
От: "Valentin Petkov"
Дата:
Сообщение: About PostgreSQL
Следующее
От: "Ed L."
Дата:
Сообщение: Re: Am I locking more than I need to?