Hi
I am getting the below given exception when I try to connect to NDB cluster
using my java application.
<openjpa-2.2.1-r422266:1396819 nonfatal general error>
org.apache.openjpa.persistence.PersistenceException: null
at
org.apache.openjpa.kernel.QueryImpl.compileForCompilation(QueryImpl.java:625)
at
org.apache.openjpa.kernel.QueryImpl.compileForExecutor(QueryImpl.java:682)
at
org.apache.openjpa.kernel.QueryImpl.getOrderedParameterTypes(QueryImpl.java:1577)
at
org.apache.openjpa.kernel.DelegatingQuery.getOrderedParameterTypes(DelegatingQuery.java:396)
at
org.apache.openjpa.persistence.QueryImpl.getParamTypes(QueryImpl.java:648)
at
org.apache.openjpa.persistence.AbstractQuery.getDeclaredParameters(AbstractQuery.java:497)
at
org.apache.openjpa.persistence.AbstractQuery.getParameterValues(AbstractQuery.java:77)
at
org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:284)
at
org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:302)
at com.cpt.calculations.SPYData.loadSPYData(SPYData.java:49)
at com.cpt.calculations.SPYData.getInstance(SPYData.java:29)
at
com.cpt.calculations.CalculationsManager.performHistoricalCalculations(CalculationsManager.java:159)
at
com.cpt.calculations.CalculationsManager.start(CalculationsManager.java:369)
at
com.cpt.calculations.CalculationsManager.main(CalculationsManager.java:421)
Caused by: java.lang.NullPointerException
at
org.apache.openjpa.kernel.ExpressionStoreQuery.newCompilation(ExpressionStoreQuery.java:154)
at
org.apache.openjpa.kernel.QueryImpl.newCompilation(QueryImpl.java:672)
at
org.apache.openjpa.kernel.QueryImpl.compilationFromCache(QueryImpl.java:654)
at
org.apache.openjpa.kernel.QueryImpl.compileForCompilation(QueryImpl.java:620)
... 13 more
The persistence file is given below.
<persistence xmlns="http://java.sun.com/xml/ns/persistence";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; version="1.0">
<persistence-unit name="cpt" transaction-type="RESOURCE_LOCAL">
<provider> org.apache.openjpa.persistence.PersistenceProviderImpl
</provider>
<class>com.calculations.className</class>
<properties>
PrettyPrintLineLength=500"/> -->
<property name="openjpa.DetachState"
value="fetch-groups(DetachedStateField=true)" />
<property name="openjpa.jdbc.SchemaFactory" value="native(ForeignKeys=true)"
/>
<property name="openjpa.AutoDetach" value="commit" />
<property name="openjpa.Multithreaded" value="true"/>
<property name="openjpa.ConnectionUserName" value="db" />
<property name="openjpa.ConnectionPassword" value="******" />
<property name="openjpa.ConnectionURL" value="jdbc:mysql://******:3306/db"
/>
<property name="openjpa.ConnectionDriverName" value="com.mysql.jdbc.Driver"
/>
<property name="openjpa.jdbc.SynchronizeMappings" value="buildSchema"/>
<property name="openjpa.jdbc.DBDictionary" value="batchLimit=500"/>
<property name="eclipselink.jdbc.batch-writing" value="JDBC"/>
<property name="eclipselink.jdbc.batch-writing.size" value="1000"/>
<property name="openjpa.BrokerFactory" value="ndb" />
<property name="openjpa.ndb.connectString" value="mysql-management2" />
<property name="openjpa.ndb.database" value="db" />
value="ForeignKeyDeleteAction=restrict,JoinForeignKeyDeleteAction=restrict"
/> -->
</properties>
</persistence-unit>
</persistence>
I am able to create the connection with the database but not able to fetch
the data. My java code is given below.
Query query =
EntityFactoryManager.getInstance().getEntityManager().createNativeQuery("select
r from tableName r WHERE r.symbol='SPY' order by r.date desc
",className.class);
dataList= (List<className>)(query.getResultList());
Thanks in advance for help.
-BUnty
--
View this message in context:
http://openjpa.208410.n2.nabble.com/Not-able-to-fetch-the-data-from-NDB-cluster-tp7583125.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.
