From: | Muhammad Altaf <mmalik_altaf(at)yahoo(dot)com> |
---|---|
To: | jonykapil <jony(dot)kapil(at)gmail(dot)com>, "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Re: Issues with IN-OUT parameters for Array of Objects in EDB using Java |
Date: | 2012-05-16 00:10:12 |
Message-ID: | 1337127012.43561.YahooMailNeo@web121302.mail.ne1.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Use setTimestamp and no need to cast.
-- Altaf Malik
________________________________
From: jonykapil <jony(dot)kapil(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Sent: Tuesday, 15 May 2012 10:46 PM
Subject: [JDBC] Re: Issues with IN-OUT parameters for Array of Objects in EDB using Java
Hello Altaf,
Thanks for your reply.
I changed my calling code as following.
*
objCstmt = objConn.prepareCall("{? = call SFBLPRDBILLDATA(?,?,?, cast(? as
timestamp without time zone),cast(? as timestamp without time zone),cast(?
as timestamp without time zone) )}");
objCstmt.registerOutParameter(1,Types.VARCHAR);
objCstmt.setInt(2,iBillDay);
objCstmt.setInt(3,iBillDay);
objCstmt.setString(4,strBillFrequency);
objCstmt.setDate(5,dtSysDate);
objCstmt.registerOutParameter(6,Types.DATE);
objCstmt.registerOutParameter(7,Types.DATE);
objCstmt.execute();*
Exception thrown by Postgres is ::
*org.postgresql.util.PSQLException: ERROR: cannot cast type void to
timestamp without time zone Position:84*
I am not able to understand why now it is taking registerOutParameter as
void.
Please help me out of this...
Thanks & regards
jony
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Issues-with-IN-OUT-parameters-for-Array-of-Objects-in-EDB-using-Java-tp5620617p5708766.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Jesper Pedersen | 2012-05-17 16:43:53 | Pull request: Use .valueOf() |
Previous Message | jonykapil | 2012-05-15 12:46:15 | Re: Issues with IN-OUT parameters for Array of Objects in EDB using Java |