Re: [eclipselink-users] JPA caching of ResultSets only?

[polyphenol@xxxxxxxxxxxx]

On Wed, 28 Sep 2011 14:50:25 +0200 Guy Pelletier 
<guy.pelletier@xxxxxxxxxx> wrote:
>Did you looking Shaun's suggestion of configuring the returning 
>policy?
>
>http://wiki.eclipse.org/Using_EclipseLink_JPA_Extensions_(ELUG)#Usi
ng_EclipseLink_JPA_Extensions_for_Returning_Policy 

Yes, however I'm required to use MySQL and thus:

# Exception [EclipseLink-0] (Eclipse Persistence Services - 
2.3.0.v20110604-r9504): 
org.eclipse.persistence.exceptions.IntegrityException
# Descriptor Exceptions: 
# ---------------------------------------------------------
# 
# Exception [EclipseLink-193] (Eclipse Persistence Services - 
2.3.0.v20110604-r9504): 
org.eclipse.persistence.exceptions.DescriptorException
# Exception Description: There is no custom [InsertObjectQuery] 
set, but ReturningPolicy contains field(s) to be returned and 
[MySQLPlatform] doesnt support generating call with returning.
# Descriptor: RelationalDescriptor(foo.Bar --> [DatabaseTable(bar)])
# 
# Runtime Exceptions: 
# ---------------------------------------------------------
# 
#    at 
org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.initia
lizeDescriptors(DatabaseSessionImpl.java:535)
#    at 
org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.initia
lizeDescriptors(DatabaseSessionImpl.java:476)
#    at 
org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.initia
lizeDescriptors(DatabaseSessionImpl.java:435)
#    at 
org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.postCo
nnectDatasource(DatabaseSessionImpl.java:673)
#    at 
org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginA
ndDetectDatasource(DatabaseSessionImpl.java:618)
#    at 
org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.lo
gin(EntityManagerFactoryProvider.java:206)
#    at 
org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(E
ntityManagerSetupImpl.java:472)
#    at 
org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.ge
tDatabaseSession(EntityManagerFactoryDelegate.java:188)
#    at 
org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.cr
eateEntityManagerImpl(EntityManagerFactoryDelegate.java:277)
#    at 
org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.create
EntityManagerImpl(EntityManagerFactoryImpl.java:290)
#    at 
org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.create
EntityManager(EntityManagerFactoryImpl.java:268)
#    [...]
# 
# Descriptor Exceptions: 
# ---------------------------------------------------------
# 
# 
# Local Exception Stack: 
# Exception [EclipseLink-193] (Eclipse Persistence Services - 
2.3.0.v20110604-r9504): 
org.eclipse.persistence.exceptions.DescriptorException
# Exception Description: There is no custom [InsertObjectQuery] 
set, but ReturningPolicy contains field(s) to be returned and 
[MySQLPlatform] doesnt support generating call with returning.
# Descriptor: RelationalDescriptor(foo.Bar --> [DatabaseTable(bar)])
#    at 
org.eclipse.persistence.exceptions.DescriptorException.noCustomQuery
ForReturningPolicy(DescriptorException.java:1883)
#    at 
org.eclipse.persistence.descriptors.ReturningPolicy.validationAfterD
escriptorInitialization(ReturningPolicy.java:896)
#    at 
org.eclipse.persistence.descriptors.ClassDescriptor.selfValidationAf
terInitialization(ClassDescriptor.java:3813)
#    at 
org.eclipse.persistence.descriptors.ClassDescriptor.validateAfterIni
tialization(ClassDescriptor.java:5627)
#    at 
org.eclipse.persistence.descriptors.ClassDescriptor.postInitialize(C
lassDescriptor.java:3517)
#    at 
org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.initia
lizeDescriptors(DatabaseSessionImpl.java:526)
#    at 
org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.initia
lizeDescriptors(DatabaseSessionImpl.java:476)
#    at 
org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.initia
lizeDescriptors(DatabaseSessionImpl.java:435)
#    at 
org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.postCo
nnectDatasource(DatabaseSessionImpl.java:673)
#    at 
org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.loginA
ndDetectDatasource(DatabaseSessionImpl.java:618)
#    at 
org.eclipse.persistence.internal.jpa.EntityManagerFactoryProvider.lo
gin(EntityManagerFactoryProvider.java:206)
#    at 
org.eclipse.persistence.internal.jpa.EntityManagerSetupImpl.deploy(E
ntityManagerSetupImpl.java:472)
#    at 
org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.ge
tDatabaseSession(EntityManagerFactoryDelegate.java:188)
#    at 
org.eclipse.persistence.internal.jpa.EntityManagerFactoryDelegate.cr
eateEntityManagerImpl(EntityManagerFactoryDelegate.java:277)
#    at 
org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.create
EntityManagerImpl(EntityManagerFactoryImpl.java:290)
#    at 
org.eclipse.persistence.internal.jpa.EntityManagerFactoryImpl.create
EntityManager(EntityManagerFactoryImpl.java:268)
#    [...]


Polyphenol