Re: getting PSQLException Can't infer the SQL type to use with Native Query call

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Steven Dahlin <pgdb(dot)sldahlin(at)gmail(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: getting PSQLException Can't infer the SQL type to use with Native Query call
Date: 2011-05-02 16:30:18
Message-ID: 26841.1304353818@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Steven Dahlin <pgdb(dot)sldahlin(at)gmail(dot)com> writes:
> In trying to call a postgresql 8.4 stored function I am passing a
> class as well as a List (I have to save a master record as well as the
> detail records). This is being done with a native query using
> EclipseLink 2.1. However, I am getting back a message for the first
> item:

> PSQLException: Can't infer the SQL type to use for an instance of
> com.hwcs.veri.shared.dto.MyClass. Use setObject() with an explicit
> Types value to specify the type to use.

That looks like a complaint from JDBC, so possibly you'd have better
luck asking on pgsql-jdbc.

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Charles N. Charotti 2011-05-02 21:43:31 PLpgSQL variables persistance between several functions calls
Previous Message Tom Lane 2011-05-02 16:25:19 Re: FATAL: invalid cache id: 19