[
https://issues.apache.org/jira/browse/OPENJPA-2565?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
kafku codoka updated OPENJPA-2565:
----------------------------------
Environment:
server side:
db2 on z/os version 10.5
client side:
eclipse jee 4.2
jdk1.6.0_30
jee 6
Driver: IBM Data Server Driver for JDBC and SQLJ 4.12.72 (jdbc driver)
openjpa 2.2.2
was:
server side:
db2 on z/os version 10.5
client side:
eclipse jee 4.2
jdk1.6.0_30
Driver: IBM Data Server Driver for JDBC and SQLJ 4.12.72 (jdbc driver)
openjpa 2.2.2
> org.apache.openjpa.persistence.PersistenceException: NULL IS NOT VALID IN THE
> CONTEXT WHERE IT IS USED.
> -------------------------------------------------------------------------------------------------------
>
> Key: OPENJPA-2565
> URL: https://issues.apache.org/jira/browse/OPENJPA-2565
> Project: OpenJPA
> Issue Type: Bug
> Components: jpa, kernel, query, sql
> Affects Versions: 2.2.2, 2.3.0
> Environment: server side:
> db2 on z/os version 10.5
> client side:
> eclipse jee 4.2
> jdk1.6.0_30
> jee 6
> Driver: IBM Data Server Driver for JDBC and SQLJ 4.12.72 (jdbc driver)
> openjpa 2.2.2
> Reporter: kafku codoka
>
> We encountered the following error log when processing the results of a query
> that its parameter set with null pointer (junit test method)..
> db2 10.5 for z/os
> openjpa 2.2.2
> Thanks,
> codoka
> --------------error log-----------------------
> <openjpa-2.2.2-r422266:1468616 fatal general error>
> org.apache.openjpa.persistence.PersistenceException: NULL IS NOT VALID IN THE
> CONTEXT WHERE IT IS USED. SQLCODE=-206, SQLSTATE=42703, DRIVER=4.12.72
> {prepstmnt 561094448 SELECT t0.ID, t0.NAME, t0.INSERT_TIME, t0.UPDATE_TIME
> FROM UNI.DEPT t0 WHERE (1 = 1 OR t0.ID IN (NULL)) } [code=-206,
> state=42703]SQLCA OUTPUT[Errp=DSNXORSO, Errd=-100, 0, 0, -1, 0, 0]
> NULL IS NOT VALID IN THE CONTEXT WHERE IT IS USED. SQLCODE=-206,
> SQLSTATE=42703, DRIVER=4.12.72
> null
> SQL_CURLH200C1
> FailedObject: SELECT d FROM entities.Dept d where ?1 is null or d.id in
> (?1) [java.lang.String]
> at
> org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4962)
> at
> org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4922)
> at
> org.apache.openjpa.jdbc.sql.DB2Dictionary.newStoreException(DB2Dictionary.java:570)
> at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136)
> at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:118)
> at
> org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:70)
> at
> org.apache.openjpa.jdbc.kernel.SelectResultObjectProvider.handleCheckedException(SelectResultObjectProvider.java:155)
> at
> org.apache.openjpa.lib.rop.EagerResultList.<init>(EagerResultList.java:40)
> at org.apache.openjpa.kernel.QueryImpl.toResult(QueryImpl.java:1251)
> at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:1007)
> at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:863)
> at org.apache.openjpa.kernel.QueryImpl.execute(QueryImpl.java:794)
> at
> org.apache.openjpa.kernel.DelegatingQuery.execute(DelegatingQuery.java:542)
> at org.apache.openjpa.persistence.QueryImpl.execute(QueryImpl.java:286)
> at
> org.apache.openjpa.persistence.QueryImpl.getResultList(QueryImpl.java:302)
> at
> queries.tests.FindByDeptIdTest.testPrintAllDeptsNameWhenDeptIdsIsNull(FindByDeptIdTest.java:84)
> ---------------junit test method-------------
> @Test
> public void testPrintAllDeptsNameWhenDeptIdsIsNull() {
> try {
> EntityManagerFactory emf =
> Persistence.createEntityManagerFactory("uni-pu");
> EntityManager em = emf.createEntityManager();
> em.getTransaction().begin();
> Query query = em.createQuery("SELECT d FROM
> entities.Dept d where ?1 is null or d.id in (?1)");
> List<Dept> deptIds = null;
> query.setParameter(1, deptIds);
> List<Dept> depts = (List<Dept>) query.getResultList();
> for (Dept d : depts) {
> System.out.println(d.getName());
> }
> em.close();
> emf.close();
> assertTrue(true);
> } catch (Exception e) {
> e.printStackTrace();
> assertTrue(false);
> }
> }
> -------------- persistance.xml file-----------
> <?xml version="1.0" encoding="UTF-8"?>
> <persistence 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/";
> version="1.0">
> <persistence-unit name="uni-pu" transaction-type="RESOURCE_LOCAL">
> <provider>org.apache.openjpa.persistence.PersistenceProviderImpl
> </provider>
> <class>entities.Dept</class>
> <properties>
> <property name="openjpa.jdbc.DBDictionary" value="db2"
> />
> <property name="javax.persistence.jdbc.user"
> value="uni" />
> <property name="javax.persistence.jdbc.password"
> value="uni" />
> <property name="openjpa.ConnectionURL"
>
> value="jdbc:db2://192.168.1.110:50000/UNI:retrieveMessagesFromServerOnGetMessage=true;emulateParameterMetaDataForZCalls=1;"
> />
> <property name="openjpa.ConnectionDriverName"
> value="com.ibm.db2.jcc.DB2Driver" />
> <property name="openjpa.Log"
> value="DefaultLevel=TRACE,Runtime=TRACE,Tool=TRACE,SQL=TRACE" />
> </properties>
> </persistence-unit>
> </persistence>
> ------------------------------------------------------
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
