Eclipse Community Forums: EclipseLink » getting PSQLException Can't infer the SQL type to use with Native Query call

Home » Eclipse Projects » EclipseLink » getting PSQLException Can't infer the SQL type to use with Native Query call(getting PSQLException Can't infer the SQL type to use with Native Query call)

Show: Today's Messages :: Show Polls :: Message Navigator

getting PSQLException Can't infer the SQL type to use with Native Query call [message #667885]

Mon, 02 May 2011 15:16

Steven Dahlin

Messages: 18
Registered: May 2010

Junior Member

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.

I am calling the query setting up the parameter with:

query.setParameter( 1, myClass );

The receiving stored function has the following:

FUNCTION perform_schema.saveInfo( newrec boolean,
myClass <user defined type>,
myDtl <user defined type>[] )

I am unclear how to setup the pass fromm eclipselink to postgresql. Does anyone have any suggestions or can point to docs which speak to this specifically?

Thanks

Report message to a moderator

Re: getting PSQLException Can't infer the SQL type to use with Native Query call [message #667924 is a reply to message #667885]

Mon, 02 May 2011 19:09

James Sutherland

Messages: 1939
Registered: July 2009
Location: Ottawa, Canada

Senior Member

You cannot pass a Java object directly to PostgreSQL. Custom types in PostgreSQL require usage of java.sql.Struct types in JDBC.

You need to pass a Struct type directly, or use EclipseLink's object-relational data-type support to map the Struct to a class using an ObjectRelationalDataTypeDescriptor.

James : Wiki : Book : Blog : Twitter

Report message to a moderator

Re: getting PSQLException Can't infer the SQL type to use with Native Query call [message #667939 is a reply to message #667924]

Mon, 02 May 2011 20:38

Steven Dahlin

Messages: 18
Registered: May 2010

Junior Member

I was wondering if you knew any docs or examples that discusses this?

Thanks

Report message to a moderator

Re: getting PSQLException Can't infer the SQL type to use with Native Query call [message #668118 is a reply to message #667939]

Tue, 03 May 2011 19:55

Steven Dahlin

Messages: 18
Registered: May 2010

Junior Member

I have been chasing my tail trying to pull this together. Everything I read comes in snippets and most examples point to using stored procedures not stored functions which is what is used with Postgresql (cf. http://www.eclipse.org/forums/index.php?t=msg&goto=65118 4&S=2e33754641d6b4641dbf92071b8add6f). In the end I cannot pull this together and pass an object (as well as an array of objects) into Postgresql. Is there any tutorial that covers this ground thoroughly?

Report message to a moderator