Failed To Add Table in Openmrs Context (org.hibernate.MappingException: Unknown entity)

samuel34 · July 2, 2018, 12:35pm

Hi all,

I’m trying to create a table for the mergepatientdata module that will store Audits.

I tried to map my entity but on running the test below I got the following error

@Test
public void saveAuditMessage_shouldSaveMessage() {
	PaginatedAuditMessage message = new PaginatedAuditMessage();
	message.setOperation(Operation.EXPORT);
	message.setStatus(Status.Failure);
	message.setResources(resources);
	message.setFailurDetails(errorDetails);
	service.saveAuditMessage(message);
}

Hibernate Mappping.

gist.github.com

https://gist.github.com/samuelmale/05ab2671226566209ab4db74ff9ed912

AuditMessage.hbm.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="org.openmrs.module.mergepatientdata.api.model.audit">
    <class name="AuditMessage" table="mergepatientdata_audit_message">
        <id column="mergepatientdata_audit_id" name="id" unsaved-value="0">
            <generator class="native">
                <param name="sequence">mergepatientdata_audit_id_seq</param>
            </generator>
        </id>

This file has been truncated. show original

Config.xml

gist.github.com

https://gist.github.com/samuelmale/688474aefd8f878821da21eff880d8c9#file-config-xml-L65-L67

config.xml

<?xml version="1.0" encoding="UTF-8"?>

<module configVersion="1.2">
	
	<!-- Base Module Properties -->
	<id>${project.parent.artifactId}</id>
	<name>${project.parent.name}</name>
	<version>${project.parent.version}</version>
	<package>org.openmrs.module.mergepatientdata</package>
	<author>Samuel34</author>

This file has been truncated. show original

Application context

gist.github.com

https://gist.github.com/samuelmale/e8591e28d1de0bafcbf34b3921763f02

moduleApplicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>

<!-- Beans to add to the current Application context definition -->

<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xmlns:p="http://www.springframework.org/schema/p"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:jee="http://www.springframework.org/schema/jee"
       xmlns:tx="http://www.springframework.org/schema/tx"

This file has been truncated. show original

The Entity.

gist.github.com

https://gist.github.com/samuelmale/378792bd9a87bbd0eef9b192b5541509

AuditMessage.java

package org.openmrs.module.mergepatientdata.api.model.audit;

import java.util.Date;

import org.hibernate.annotations.Persister;
import org.hibernate.persister.entity.SingleTableEntityPersister;

@Persister(impl = SingleTableEntityPersister.class)
public class AuditMessage {

This file has been truncated. show original

@cc: @dkayiwa, @ssmusoke

dkayiwa · July 2, 2018, 12:42pm

You need to share the log.

samuel34 · July 2, 2018, 12:43pm

I had shared it.

cc: @dkayiwa

dkayiwa · July 2, 2018, 12:59pm

Did you take a look at this? dataset error "NO such Table Exception"

samuel34 · July 2, 2018, 2:26pm

Thanks, the issue is resolved