This content has been marked as final.
Show 3 replies
-
1. Re: Problem with Native Queries
rcherchi Sep 18, 2007 10:19 AM (in response to rcherchi)Here is the exception generated by postgresql :
org.postgresql.util.PSQLException: The column name x was not found in this ResultSet.
Would you need any other information to solve the problem ?
Thanks -
2. Re: Problem with Native Queries
mapoitras Jul 17, 2008 12:40 PM (in response to rcherchi)Have you found a solution to this problem? I'm having the exact same issue and I can't seem to figure it out. In my case I get
[IntegerType] could not read column value from result set: FINC1_18_0_;
In my SQL statement, all the columns have alias so I have no idea where FINC1_18_0_ comes from.
the only integer is the key so I suspect its related to that but I'm not sure. Any help would be appreciated.
@Id @GeneratedValue
@Column(name="FINC_TRN_ID")
public Integer getId() {
return id;
} -
3. Re: Problem with Native Queries
rcherchi Jul 17, 2008 1:58 PM (in response to rcherchi)No sorry,
I just replaced all my native queries by standard EJB/QL queries :)
Cheers