Skip site navigation (1) Skip section navigation (2)

Re: Issues with IN-OUT parameters for Array of Objects in EDB using Java

From: jonykapil <jony(dot)kapil(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Issues with IN-OUT parameters for Array of Objects in EDB using Java
Date: 2012-05-15 12:46:15
Message-ID: 1337085975761-5708766.post@n5.nabble.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
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.

In response to

Responses

pgsql-jdbc by date

Next:From: Muhammad AltafDate: 2012-05-16 00:10:12
Subject: Re: Re: Issues with IN-OUT parameters for Array of Objects in EDB using Java
Previous:From: Muhammad AltafDate: 2012-05-15 10:59:46
Subject: Re: Re: Issues with IN-OUT parameters for Array of Objects in EDB using Java

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group