Errors in named queries: Ant & Junit

paulsjv · **Joined:** Fri Feb 06, 2009 2:24 pm **Posts:** 12

Hi,

Sorry I don't know all the information being requested as I'm still very new to Hibernate and didn't implement what we are using. My question is hopefully pretty simple. I'm trying to run my junit tests inside ant 1.7.1 and I keep getting the exception that is below. It seems that Hibernate is complaining about my named queries have errors in them. However, when I run them in Eclipse 3.4 everything runs fine. It's only when I try to run them via ant that the unit tests fail with the exception below.

Any help would be great and if you need anything else from me to help please just let me know and I will do my best to find it. I'm hoping that the 4 days I have spent on this so far is almost over. :)

Thanks!

Hibernate version:
3.2

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:
java.lang.ExceptionInInitializerError at com.e2open.common.util.persistence.HibernateUtil.init(HibernateUtil.java:72) at com.e2open.pcm.spi.builder.JunitSetup.setup(Unknown Source) at com.e2open.pcm.spi.builder.xmlbuilders.ItemAvlXmlBuilderTest.setup(Unknown Source)Caused by: javax.persistence.PersistenceException: org.hibernate.HibernateException: Errors in named queries: importer:itemOwnerSelect, importer:rebateSelect, importer:sourcingLaneSelect, dashboard:newUnassignedItems, dashboard:pendingCostRecords at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:720) at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:121) at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:51) at com.e2open.common.util.persistence.HibernateUtil.init(HibernateUtil.java:64)Caused by: org.hibernate.HibernateException: Errors in named queries: importer:itemOwnerSelect, importer:rebateSelect, importer:sourcingLaneSelect, dashboard:newUnassignedItems, dashboard:pendingCostRecords at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:365) at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1294) at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:713)N/A

java.lang.NullPointerException at com.e2open.pcm.spi.builder.xmlbuilders.ItemAvlXmlBuilderTest.tearDown(Unknown Source)

Name and version of the database you are using:
Oracle 10.2.0

The generated SQL (show_sql=true):
<named-native-query name="importer:itemOwnerSelect"
result-set-mapping="mapping:itemOwnerSelect">
<query>
<![CDATA[
SELECT
DISTINCT ASSIGNMENT_KEY,
ITEM_IDENTIFIER,
OWNER_NAME,
BUSINESS_ENTITY_IDENTIFIER,
BUSINESS_ENTITY_TYPE_KEY,
DATA_SOURCE,
LAST_REV_CHANGE_DATE
FROM IV_ITEM_OWNER
WHERE ((LAST_REV_CHANGE_DATE <= :update_date)
OR
(LAST_REV_CHANGE_DATE IS NULL))
ORDER BY ASSIGNMENT_KEY ASC
]]>
</query>
</named-native-query>

Debug level Hibernate log excerpt:

Sounie · **Posted:** Fri Feb 06, 2009 4:28 pm

Hi,

Can you show us the code from:

ItemAvlXmlBuilderTest.tearDown

- as that appears to be the source of the NullPointerException.

--
Stephen Souness

paulsjv · **Joined:** Fri Feb 06, 2009 2:24 pm **Posts:** 12

The code is below. The "updateDb" is a private class variable.

Code:

   @After
   public void tearDown() {
      // Make sure to restore the db by setting the current flag to Y
      updateDb.setFlag("Y");
      updateDb.updateDb();
   }

Sounie · **Posted:** Sat Feb 07, 2009 11:07 am

Can you confirm that the updateDb object is successfully being set up?

(This may just be a symptom of something else failing).

--
Stephen Souness

paulsjv · **Joined:** Fri Feb 06, 2009 2:24 pm **Posts:** 12

I really can't. I would assume that it isn't.

mmerder · **Posted:** Mon Feb 09, 2009 11:28 am

Please post the whole class or at least the code, where updateDb is initialized.

paulsjv · **Joined:** Fri Feb 06, 2009 2:24 pm **Posts:** 12

Code:

public class ItemAvlXmlBuilderTest {
   
   protected static final Log logger = LogFactory.getLog(ItemAvlXmlBuilderTest.class);
   private XmlBuilder xmlBuilder = null;
   private UpdateDb updateDb = null;
   
   private static final String MESSAGE = "ItemAvlMessage";
   private static final int YEAR = 2008;
   private static final int MONTH = 10; // 0 is january
   private static final int DAY = 12;
   private static final int HOUR = 11;
   private static final int MIN = 59;
   private static final int SEC = 59;
   
   private static final int AVL_MAX = 10;
   private static final int AVL_MIN = 0;
   
   private static final String SQL_ITEM_AVL = "SELECT COUNT(*) AS COUNT FROM ITEM_AVL " +
                                 "WHERE ((UPDATE_DT <= ? AND CURRENT_FLAG = 'N') OR (UPDATE_DT IS NULL AND CURRENT_FLAG = 'N'))";
   private static final String SQL_ITEM_AVL_VIEW = "SELECT COUNT(*) " +
                                 "FROM IV_ITEM_AVL " + 
                                 "WHERE ((UPDATE_DT <= ? AND CURRENT_FLAG = 'N') OR (UPDATE_DT IS NULL AND CURRENT_FLAG = 'N'))";
   
   @Before
   public void setup() {
      JunitSetup.setup();
      // set up Hibernate connection
      Map extractMap = JunitSetup.builderSetup(MESSAGE, YEAR, MONTH, DAY, HOUR, MIN, SEC);
      
      // create new xmlProduct
      XmlProduct xmlProduct = new XmlProduct();
      xmlProduct.setMessage(MESSAGE);
      xmlBuilder = new ItemAvlXmlBuilder();
      xmlBuilder.setXmlProduct(xmlProduct);
      xmlBuilder.setCurrentDate((Calendar) extractMap.get(JunitSetup.getStrDate()));
         
      updateDb = new ItemAvlUpdateDb(xmlBuilder);
      updateDb.updateDb();
         
      
   }
   
   @After
   public void tearDown() {
      // Make sure to restore the db by setting the current flag to Y
      updateDb.setFlag("Y");
      updateDb.updateDb();
   }
   
   @Test
   public void writeToFileTest() {            
      // Validate file.
      JunitSetup.validateXml(xmlBuilder);
   }
   
   @Test
   public void updateDbTest() {
      try {
         EntityManager em = xmlBuilder.getEntityManager();
         
         logger.debug(SQL_ITEM_AVL + " : " + xmlBuilder.getCurrentDate().getTime());
         Query query = em.createNativeQuery(SQL_ITEM_AVL);
         query.setParameter(1, xmlBuilder.getCurrentDate(), TemporalType.DATE);
         List results = query.getResultList();
         BigDecimal itemAvlRows = (BigDecimal) results.get(0);
         logger.debug(itemAvlRows.intValue());
         
         logger.debug(SQL_ITEM_AVL_VIEW + " : " + xmlBuilder.getCurrentDate().getTime());
         query = em.createNativeQuery(SQL_ITEM_AVL_VIEW);
         query.setParameter(1, xmlBuilder.getCurrentDate(), TemporalType.DATE);
         results = query.getResultList();
         BigDecimal numRows = (BigDecimal) results.get(0);
         logger.debug(numRows.intValue());
         
         xmlBuilder.setNumResults(numRows.intValue());
         
         if (numRows.intValue() <= 0) {
            logger.debug("Nothing to update because there are no rows to update!");
            fail("Nothing to update because there are no rows to update!");
         } else {
            // doing the test here
            Map<String, Integer> rowsUpdated = xmlBuilder.updateDb();
            logger.debug(rowsUpdated.get("itemAvl"));
            if (rowsUpdated.get("itemAvl").compareTo(itemAvlRows.intValue()) != 0) {
               fail("ItemAvl UpdateDb() failed!");
            }
         }
         
      } catch (ExtractException ex) {
         fail("ExtractException: " + ex.getMessage() + ex.toString());
         ex.printStackTrace();
      } catch (Exception ex) {
         fail("Exception: " + ex.getMessage() + ex.toString());
         ex.printStackTrace();
      }
   }
}

paulsjv · **Joined:** Fri Feb 06, 2009 2:24 pm **Posts:** 12

So I have reduced my external query mapping to only one query and hibernate gives me the following error. My mapping xml file is below and I really can't see any errors in it that would cause this error. I'm thinking that a second pair of eyes will help?

2009-Feb-10 13:54:54:841 util.persistence.HibernateUtil ERROR Initial SessionFactory creation failed.
javax.persistence.PersistenceException: org.hibernate.HibernateException: Errors in named queries: importer:itemOwnerSelect
at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:720)
at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:121)
at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:51)
at com.xxx.common.util.persistence.HibernateUtil.init(HibernateUtil.java:64)
at com.xxx.pcm.spi.builder.JunitSetup.setup(Unknown Source)
at com.xxx.pcm.spi.builder.xmlbuilders.ItemOwnerXmlBuilderTest.setUp(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:27)
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:73)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:46)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:180)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:41)
at org.junit.runners.ParentRunner$1.evaluate(ParentRunner.java:173)
at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
at org.junit.runners.ParentRunner.run(ParentRunner.java:220)
at junit.framework.JUnit4TestAdapter.run(JUnit4TestAdapter.java:39)
at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(JUnitTestRunner.java:420)
at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.launch(JUnitTestRunner.java:911)
at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.main(JUnitTestRunner.java:768)
Caused by: org.hibernate.HibernateException: Errors in named queries: importer:itemOwnerSelect
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:365)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1294)
at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:713)
... 26 more

Code:

<?xml version="1.0" encoding="UTF-8"?>
<entity-mappings xmlns="http://java.sun.com/xml/ns/persistence/orm"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://java.sun.com/xml/ns/persistence/orm http://java.sun.com/xml/ns/persistence/orm_1_0.xsd"
    version="1.0">

<named-native-query name="importer:itemOwnerSelect" result-set-mapping="mapping:itemOwnerSelect">
        <query>
                <![CDATA[
                SELECT
                        DISTINCT ASSIGNMENT_KEY,
                        ITEM_IDENTIFIER,
                        OWNER_NAME,
                        BUSINESS_ENTITY_IDENTIFIER,
                        BUSINESS_ENTITY_TYPE_KEY,
                        DATA_SOURCE,
                        LAST_REV_CHANGE_DATE
                FROM IV_ITEM_OWNER
                WHERE  ((LAST_REV_CHANGE_DATE <= :update_date)
                                OR
                        (LAST_REV_CHANGE_DATE IS NULL))
                ORDER BY ASSIGNMENT_KEY ASC
                ]]>
        </query>
</named-native-query>

<sql-result-set-mapping name="mapping:itemOwnerSelect">
        <entity-result entity-class="com.xxx.xxx.xxx.xxxx.xxxxx.ItemOwnerXmlBuilderRecord"/>
</sql-result-set-mapping>

</entity-mappings>

paulsjv · **Joined:** Fri Feb 06, 2009 2:24 pm **Posts:** 12

So I continued my work on debugging this and I thought I would update to see if anyone could still help. :)

I found that the below in my mapping file for my external queries works if I have the below code. However, the code under it doesn't work but it's the one that I have to get working.

Working file but not the mapping code I need.

Code:

<?xml version="1.0" encoding="UTF-8"?>
<entity-mappings xmlns="http://java.sun.com/xml/ns/persistence/orm"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://java.sun.com/xml/ns/persistence/orm http://java.sun.com/xml/ns/persistence/orm_1_0.xsd"
    version="1.0">

<named-native-query name="importer:itemAvlSelect" result-set-mapping="mapping:itemAvlSelect">
        <query>
                <![CDATA[
    SELECT
     SUPPLIER_PART_KEY,
     ITEM_KEY,
     CURRENT_FLAG,
     UPDATE_DT,
     ITEM_IDENTIFIER,
     BUSINESS_ENTITY_IDENTIFIER,
     BUSINESS_ENTITY_TYPE_NAME,
     DATA_SOURCE,
     DECODE(ITEM_UPDATE_DT, NULL, ITEM_INSERT_DT, ITEM_UPDATE_DT) as ITEM_UPDATE_DT,
     V_SITE_IDENTIFIER,
     V_DESCRIPTION,
     V_BUSINESS_ENTITY_IDENTIFIER,
     V_BUSINESS_ENTITY_TYPE_NAME,
     V_ITEM_IDENTIFIER,
     V_ITEM_UNIQUE_IDENTIFIER,
     V_REVISION,
     V_VERSION,
     V_CONTACT_NAME,
     V_CONTACT_UNIQUE_ID,
     V_PREFERRED_STATUS_CODE,
     V_PREFERRED_STATUS_START,
     V_PREFERRED_STATUS_END,
     DECODE(V_UPDATE_DT, NULL, 'A', 'C') as OPERATION_CODE,
     DECODE(V_UPDATE_DT, NULL, V_INSERT_DT, V_UPDATE_DT) as V_UPDATE_DT
     FROM IV_ITEM_AVL
     WHERE DATA_SOURCE = 'DELL' AND
           ((UPDATE_DT <= :update_date AND CURRENT_FLAG = 'N')
            OR
            (UPDATE_DT IS NULL AND CURRENT_FLAG = 'N'))
     ORDER BY SUPPLIER_PART_KEY, ITEM_KEY ASC
                ]]>
        </query>
</named-native-query>

<sql-result-set-mapping name="mapping:itemAvlSelect">
        <column-result name="SUPPLIER_PART_KEY"></column-result>
             <column-result name="ITEM_KEY"></column-result>
             <column-result name="CURRENT_FLAG"></column-result>
             <column-result name="UPDATE_DT"></column-result>
             <column-result name="ITEM_IDENTIFIER"></column-result>
             <column-result name="BUSINESS_ENTITY_IDENTIFIER"></column-result>
             <column-result name="BUSINESS_ENTITY_TYPE_NAME"></column-result>
             <column-result name="DATA_SOURCE"></column-result>
             <column-result name="ITEM_UPDATE_DT"></column-result>
             <column-result name="V_SITE_IDENTIFIER"></column-result>
             <column-result name="V_DESCRIPTION"></column-result>
             <column-result name="V_BUSINESS_ENTITY_IDENTIFIER"></column-result>
             <column-result name="V_BUSINESS_ENTITY_TYPE_NAME"></column-result>
             <column-result name="V_ITEM_IDENTIFIER"></column-result>
             <column-result name="V_ITEM_UNIQUE_IDENTIFIER"></column-result>
             <column-result name="V_REVISION"></column-result>
             <column-result name="V_VERSION"></column-result>
             <column-result name="V_CONTACT_NAME"></column-result>
             <column-result name="V_CONTACT_UNIQUE_ID"></column-result>
             <column-result name="V_PREFERRED_STATUS_CODE"></column-result>
             <column-result name="V_PREFERRED_STATUS_START"></column-result>
             <column-result name="V_PREFERRED_STATUS_END"></column-result>
             <column-result name="OPERATION_CODE"></column-result>
             <column-result name="V_UPDATE_DT"></column-result
</sql-result-set-mapping>

</entity-mappings>

Not working file but the mapping code I need.

Code:

<?xml version="1.0" encoding="UTF-8"?>
<entity-mappings xmlns="http://java.sun.com/xml/ns/persistence/orm"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://java.sun.com/xml/ns/persistence/orm http://java.sun.com/xml/ns/persistence/orm_1_0.xsd"
    version="1.0">

<named-native-query name="importer:itemAvlSelect" result-set-mapping="mapping:itemAvlSelect">
        <query>
                <![CDATA[
    SELECT
     SUPPLIER_PART_KEY,
     ITEM_KEY,
     CURRENT_FLAG,
     UPDATE_DT,
     ITEM_IDENTIFIER,
     BUSINESS_ENTITY_IDENTIFIER,
     BUSINESS_ENTITY_TYPE_NAME,
     DATA_SOURCE,
     DECODE(ITEM_UPDATE_DT, NULL, ITEM_INSERT_DT, ITEM_UPDATE_DT) as ITEM_UPDATE_DT,
     V_SITE_IDENTIFIER,
     V_DESCRIPTION,
     V_BUSINESS_ENTITY_IDENTIFIER,
     V_BUSINESS_ENTITY_TYPE_NAME,
     V_ITEM_IDENTIFIER,
     V_ITEM_UNIQUE_IDENTIFIER,
     V_REVISION,
     V_VERSION,
     V_CONTACT_NAME,
     V_CONTACT_UNIQUE_ID,
     V_PREFERRED_STATUS_CODE,
     V_PREFERRED_STATUS_START,
     V_PREFERRED_STATUS_END,
     DECODE(V_UPDATE_DT, NULL, 'A', 'C') as OPERATION_CODE,
     DECODE(V_UPDATE_DT, NULL, V_INSERT_DT, V_UPDATE_DT) as V_UPDATE_DT
     FROM IV_ITEM_AVL
     WHERE DATA_SOURCE = 'DELL' AND
           ((UPDATE_DT <= :update_date AND CURRENT_FLAG = 'N')
            OR
            (UPDATE_DT IS NULL AND CURRENT_FLAG = 'N'))
     ORDER BY SUPPLIER_PART_KEY, ITEM_KEY ASC
                ]]>
        </query>
</named-native-query>

<sql-result-set-mapping name="mapping:itemAvlSelect">
        <entity-result entity-class="com.xxx.xxx.xxx.xxxx.xxxxx.ItemAvlXmlBuilderRecord"/>
</sql-result-set-mapping>

</entity-mappings>

Stack trace

Code:

 2009-Feb-10 17:59:34:524 util.persistence.HibernateUtil ERROR      Initial SessionFactory creation failed.
 javax.persistence.PersistenceException: org.hibernate.HibernateException: Errors in named queries: importer:itemAVLSelect
         at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:720)
         at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:121)
         at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:51)
         at com.xxx.common.util.persistence.HibernateUtil.init(HibernateUtil.java:64)
         at com.xxx.pcm.spi.builder.JunitSetup.setup(Unknown Source)
         at com.xxx.pcm.spi.builder.xmlbuilders.ItemAvlXmlBuilderTest.setup(Unknown Source)
         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
         at java.lang.reflect.Method.invoke(Method.java:585)
         at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
         at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
         at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
         at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:27)
         at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
         at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:73)
         at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:46)
         at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:180)
         at org.junit.runners.ParentRunner.access$000(ParentRunner.java:41)
         at org.junit.runners.ParentRunner$1.evaluate(ParentRunner.java:173)
         at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:28)
         at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:31)
         at org.junit.runners.ParentRunner.run(ParentRunner.java:220)
         at junit.framework.JUnit4TestAdapter.run(JUnit4TestAdapter.java:39)
         at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(JUnitTestRunner.java:420)
         at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.launch(JUnitTestRunner.java:911)
         at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.main(JUnitTestRunner.java:768)
 Caused by: org.hibernate.HibernateException: Errors in named queries: importer:itemAVLSelect
         at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:365)
         at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1294)
         at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:713)
         ... 26 more

paulsjv · **Joined:** Fri Feb 06, 2009 2:24 pm **Posts:** 12

*bump*