I'm trying to write a bit of code that's portable between JPA providers and ran into a few differences and I'd like to know if they are undefined bits of the spec or just me doing something silly.

1.  0 is considered null for primary key fields (@(protected)?

2.  Return value of native queries is an Object[] or a List - Consider the following snippets
   
    // LOG is table name with a 'sequence' column/field of Java type 'long'
    final Query query = entityManager.createNativeQuery("SELECT MIN(e.sequence), MAX(e.sequence) FROM LOG e");
    final Object result = query.getSingleResult();
   
   With OpenJPA a Object[] is returned, in EclipseLink a List is returned. Is this defined anywhere? How can I define it.


Thanks,
-Nathan

----------------------------------------------------------------------
CONFIDENTIALITY NOTICE This message and any included attachments are from Cerner Corporation and are intended only for the addressee. The information contained in this message is confidential and may constitute inside or non-public information under international, federal, or state securities laws. Unauthorized forwarding, printing, copying, distribution, or use of such information is strictly prohibited and may be unlawful. If you are not the addressee, please promptly delete this message and notify the sender of the delivery error by e-mail or you may call Cerner's corporate offices in Kansas City, Missouri, U.S.A at (+1) (816)221-1024.