openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Curtis <curti...@gmail.com>
Subject Re: Native SQL Query
Date Mon, 06 Jun 2011 15:23:48 GMT
I know this isn't a good answer, but is it possible to use JPQL as opposed
to native queries?

On Fri, Jun 3, 2011 at 3:40 PM, Chaos907 <david@edelements.com> wrote:

> Below is our persistence.xml. When we are using the persistence-unit
> platform
> (no sharding), then createNativeQuery works. But if we use the
> persistence-unit platform-slice, then createNativeQuery fails with the
> stacktrace in the previous post.
>
> <?xml version="1.0" encoding="UTF-8"?>
> <persistence version="2.0" xmlns="http://java.sun.com/xml/ns/persistence"
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
> http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd">
>    <persistence-unit name="platformTest_AWS"
> transaction-type="RESOURCE_LOCAL">
>        <provider>
>            org.apache.openjpa.persistence.PersistenceProviderImpl
>        </provider>
>
>        <properties>
>
>                        <property name="javax.persistence.jdbc.driver"
> value="com.mysql.jdbc.Driver"/>
>                        <property name="javax.persistence.jdbc.url"
> value="jdbc:mysql://
> platformtest.co7yazhl6rhc.us-east-1.rds.amazonaws.com:3306/platform"/>
>                        <property name="javax.persistence.jdbc.user"
> value="******"/>
>                        <property name="javax.persistence.jdbc.password"
> value="******"/>
>
>                        <property name="openjpa.Log"
> value="DefaultLevel=WARN, Tool=INFO"/>
>
>
>                        <property name="openjpa.QueryCache"
> value="ehcache"/>
>                        <property name="openjpa.DataCacheManager"
> value="ehcache"/>
>
>        </properties>
>    </persistence-unit>
>
>    <persistence-unit name="platform" transaction-type="RESOURCE_LOCAL">
>        <provider>
>            org.apache.openjpa.persistence.PersistenceProviderImpl
>        </provider>
>
>        <properties>
>
>                        <property name="openjpa.ConnectionDriverName"
>                                  value="com.mysql.jdbc.Driver"/>
>                        <property name="openjpa.ConnectionUserName"
> value="******"/>
>                        <property name="openjpa.ConnectionPassword"
> value="******"/>
>                        <property name="openjpa.ConnectionURL"
>                                  value="jdbc:mysql://
> 127.0.0.1:3306/platform"/>
>
>                        <property name="openjpa.jdbc.SchemaFactory"
> value="native(ForeignKeys=true)"/>
>
>                        <property name="openjpa.Log" value="Runtime=TRACE,
> SQL=TRACE,
> DefaultLevel=WARN, Tool=INFO"/>
>
>                        <property name="openjpa.QueryCache"
> value="ehcache"/>
>                        <property name="openjpa.DataCacheManager"
> value="ehcache"/>
>
>        </properties>
>    </persistence-unit>
>        <persistence-unit name="platform_slice">
>        <provider>
>            org.apache.openjpa.persistence.PersistenceProviderImpl
>        </provider>
>
>                <properties>
>                        <property name="openjpa.Log" value="Runtime=TRACE,
> SQL=TRACE,
> DefaultLevel=TRACE, Tool=TRACE"/>
>                        <property name="openjpa.BrokerFactory"
> value="slice"/>
>                        <property name="openjpa.slice.Names"
> value="platform,platform1,platform2"/>
>                        <property name="openjpa.slice.Master"
>  value="platform"/>
>
>                        <property name="openjpa.slice.Lenient"
> value="true"/>
>
>                        <property name="openjpa.ConnectionDriverName"
>                                  value="com.mysql.jdbc.Driver"/>
>                        <property name="openjpa.ConnectionUserName"
> value="root"/>
>                        <property name="openjpa.ConnectionPassword"
> value="99nfirst"/>
>                        <property
> name="openjpa.slice.platform.ConnectionURL"
>                                  value="jdbc:mysql://
> 127.0.0.1:3306/platform"/>
>                        <property
> name="openjpa.slice.platform1.ConnectionURL"
>                                  value="jdbc:mysql://
> 127.0.0.1:3306/platform1"/>
>                        <property
> name="openjpa.slice.platform2.ConnectionURL"
>                                  value="jdbc:mysql://
> 127.0.0.1:3306/platform2"/>
>
>                        <property name="openjpa.slice.DistributionPolicy"
>
>
> value="com.edelements.platform.service.openjpa.DistributeByInstitutionPolicy"/>
>                        <property name="openjpa.slice.FinderTargetPolicy"
>
> value="com.edelements.platform.service.openjpa.ShardFinderTargetPolicy"/>
>                        <property name="openjpa.slice.ReplicationPolicy"
>
> value="com.edelements.platform.service.openjpa.ShardReplicationPolicy"/>
>                        <property name="openjpa.slice.ReplicatedTypes"
>                                           value="********"/>
>
>
>                        <property name="openjpa.QueryCache" value="false"/>
>                        <property name="openjpa.DataCache" value="false"/>
>
>
>                        <property name="openjpa.QueryCompilationCache"
> value="false"/>
>                        <property name="openjpa.jdbc.QuerySQLCache"
> value="false"/>
>                        <property name="openjpa.jdbc.FinderCache"
> value="false"/>
>
>                        <property name="openjpa.DetachState"
> value="loaded(DetachedStateField=false)"/>
>
>                </properties>
>        </persistence-unit>
>
>    <persistence-unit name="testPlatform">
>        <provider>
>            org.apache.openjpa.persistence.PersistenceProviderImpl
>        </provider>
>
>                <properties>
>                        <property name="openjpa.Log" value="Runtime=TRACE,
> SQL=TRACE,
> DefaultLevel=TRACE, Tool=TRACE"/>
>                        <property name="openjpa.BrokerFactory"
> value="slice"/>
>                        <property name="openjpa.slice.Names"
> value="platform,platform1,platform2"/>
>                        <property name="openjpa.slice.Master"
>  value="platform"/>
>
>                        <property name="openjpa.slice.Lenient"
> value="true"/>
>
>                        <property name="openjpa.ConnectionDriverName"
>                                  value="com.mysql.jdbc.Driver"/>
>                        <property name="openjpa.ConnectionUserName"
> value="root"/>
>                        <property name="openjpa.ConnectionPassword"
> value="99nfirst"/>
>                        <property
> name="openjpa.slice.platform.ConnectionURL"
>                                  value="jdbc:mysql://
> 127.0.0.1:3306/platform"/>
>                        <property
> name="openjpa.slice.platform1.ConnectionURL"
>                                  value="jdbc:mysql://
> 127.0.0.1:3306/platform1"/>
>                        <property
> name="openjpa.slice.platform2.ConnectionURL"
>                                  value="jdbc:mysql://
> 127.0.0.1:3306/platform2"/>
>
>                        <property name="openjpa.slice.DistributionPolicy"
>
>
> value="com.edelements.platform.service.openjpa.DistributeByInstitutionPolicy"/>
>                        <property name="openjpa.slice.FinderTargetPolicy"
>
> value="com.edelements.platform.service.openjpa.ShardFinderTargetPolicy"/>
>                        <property name="openjpa.slice.ReplicatedTypes"
>                                           value="*******"/>
>
>
>                        <property name="openjpa.QueryCache" value="false"/>
>                        <property name="openjpa.DataCache" value="false"/>
>
>
>                        <property name="openjpa.QueryCompilationCache"
> value="false"/>
>                        <property name="openjpa.jdbc.QuerySQLCache"
> value="false"/>
>                        <property name="openjpa.jdbc.FinderCache"
> value="false"/>
>
>                        <property name="openjpa.DetachState"
> value="loaded(DetachedStateField=false)"/>
>                </properties>
>    </persistence-unit>
> </persistence>
>
>
> --
>



-- 
*Rick Curtis*

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message