[Java lista] eclipselink+postgresql+stored procedure

[zamek]

hello,

Cserep Janos írta:
> Native query-nél is át tudod adni, hogy milyen entitásokat map-peljen
> ki a resultsetből:
> 
> Query query = em.createNativeQuery(
>  "select * from users where username = ?", User.class)

hat nem! Mivel ez egy stored procedure.

a psql-ben _teljesen_ azonos a tabla deklaracio es az sp (mivel 
resultset%permission).

Query qry = em.createNativeQuery("select * from 
userpermissions(?)",Permissions.class);
         qry.setParameter(1, usr.getId());
         List result = qry.getResultList();
         return result;

Ezt kapom:

select * from userpermissions(?)
         bind => [10]
Local Exception Stack:
Exception [EclipseLink-6044] (Eclipse Persistence Services - 
1.1.2.v20090612-r4475): org.eclipse.persistence.exceptions.QueryException
Exception Description: The primary key read from the row [DatabaseRecord(
          => 100
          => teachers
          => 15)] during the execution of the query was detected to be 
null.  Primary keys must not contain null.
Query: ReadAllQuery(referenceClass=Permissions sql="select * from 
userpermissions(?)")

pedig a primary key az elso mezo (100).
Osszesen 3 mezo van, id,name,mask.

+valami otlet?

-- 
  thx,
----------------------------------
Zoltan Zidarics programmer
PTE-PMMFK H-7621 Pecs, Boszorkany u. 2. Hungary
E-Mail: zamek at vili.pmmf.hu
----------------------------------