could not parse mapping resource.

[Arun Seshadri]

Hi

I am new to Hibernate and trying to map a hbm.xml file but for some reason I get this error
"Could not parse mapping document from resource deals.hbm.xml"

The following is the dump of events that I get on log4j on eclipse when I try to run the code. Could someone please let me know where I am going wrong?

23:06:38,125  INFO Environment:514 - Hibernate 3.2.4.sp1
23:06:38,140  INFO Environment:547 - hibernate.properties not found
23:06:38,140  INFO Environment:681 - Bytecode provider name : cglib
23:06:38,140  INFO Environment:598 - using JDK 1.4 java.sql.Timestamp handling
23:06:38,218  INFO Configuration:1426 - configuring from resource: /hibernate.cfg.xml
23:06:38,218  INFO Configuration:1403 - Configuration resource: /hibernate.cfg.xml
23:06:38,468 DEBUG DTDEntityResolver:38 - trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd]
23:06:38,468 DEBUG DTDEntityResolver:40 - recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
23:06:38,468 DEBUG DTDEntityResolver:50 - located [http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd] in classpath
23:06:38,515 DEBUG Configuration:1387 - hibernate.connection.driver_class=com.oracle.jdbc.Driver
23:06:38,515 DEBUG Configuration:1387 - hibernate.connection.url=jdbc :-o	 racle:thin:@localhost:1521
23:06:38,515 DEBUG Configuration:1387 - hibernate.connection.username=sa
23:06:38,515 DEBUG Configuration:1387 - hibernate.connection.password=sa
23:06:38,515 DEBUG Configuration:1387 - hibernate.connection.pool_size=10
23:06:38,515 DEBUG Configuration:1387 - show_sql=true
23:06:38,515 DEBUG Configuration:1387 - dialect=org.hibernate.dialect.Oracle9Dialect
23:06:38,515 DEBUG Configuration:1387 - hibernate.hbm2ddl.auto=update
23:06:38,515 DEBUG Configuration:1586 - null<-org.dom4j.tree.DefaultAttribute@1e859c0 [Attribute: name resource value "deals.hbm.xml"]
23:06:38,515  INFO Configuration:553 - Reading mappings from resource : deals.hbm.xml
23:06:38,515 DEBUG DTDEntityResolver:38 - trying to resolve system-id [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd]
23:06:38,531 DEBUG DTDEntityResolver:40 - recognized hibernate namespace; attempting to resolve on classpath under org/hibernate/
23:06:38,531 DEBUG DTDEntityResolver:50 - located [http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd] in classpath
23:06:38,687  INFO HbmBinder:300 - Mapping class: roseindia.tutorial.hibernate.Deals -> Deals
23:06:38,687 DEBUG HbmBinder:1270 - Mapped property: id -> ID
Could not parse mapping document from resource deals.hbm.xml
Exception in thread "main" java.lang.NullPointerException
at FirstExample.main(FirstExample.java:34)

The mapping deals.hbm.xml file looks like the one below.

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC 
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="roseindia.tutorial.hibernate.Deals" table="Deals">
  <id name="id" type="long" column="ID">
   <generator class="native"/>
  </id>
  <property name="RESULT_ID">
 <column name="RESULT_ID"/>
  </property>
  <property name="DEALS">
<column name="DEALS"/>
  </property>

<set name="deals" table="DEALS">
        <key column="RESULT_ID"/>
        <many-to-many column="RESULT_ID" class="roseindia.tutorial.hibernate.Deals"/>
    </set>
 
</class>
 
</hibernate-mapping>

[Edvins Reisons]

What does your Deals class look like?
Apparently, Hibernate stops at the RESULT_ID property.

[Arun Seshadri]

The deals class looks like the following.

//package roseindia.tutorial.hibernate;
 
/**
 * @author Deepak Kumar
 *
 * <a href="http://www.roseindia.net" target="_blank" rel="nofollow">http://www.roseindia.net</a>
 * Java Class to map to the datbase Contact Table
 */
public class Deals {
private int ResultID;
private String Deal;
private long id;
 
/**
 * @return Email
 */
public int getResultID() {
return ResultID;
}
 
/**
 * @return First Name
 */
public String getDeal() {
return Deal;
}
 
/**
 * @param string Sets the Email
 */
public void setResultID(int string) {
ResultID = string;
}
 
/**
 * @param string Sets the First Name
 */
public void setDeal(String string) {
Deal = string;
}
 
/**
 * @return ID Returns ID
 */
public long getId() {
return id;
}
 
/**
 * @param l Sets the ID
 */
public void setId(long l) {
id = l;
}
 
}
 

The project structure under Eclipse is

hibernateexample
+ bin
+ roseindia/tutorial/Hibernate/ (All class files here)
deals.hbm.xml file here
hibernate.cfg.xml file here
+ src
+ roseindia/tutorial/hibernate

I tried to run the code now and I get this error.

Exception in thread "main" java.lang.NoClassDefFoundError: roseindia/tutorial/hibernate/Deals (wrong name: Deals)
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClass(ClassLoader.java:620)
at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:124)
at java.net.URLClassLoader.defineClass(URLClassLoader.java:260)
at java.net.URLClassLoader.access$100(URLClassLoader.java:56)
at java.net.URLClassLoader$1.run(URLClassLoader.java:195)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:268)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:164)
at org.hibernate.util.ReflectHelper.classForName(ReflectHelper.java:100)
at org.hibernate.mapping.PersistentClass.getMappedClass(PersistentClass.java:96)
at org.hibernate.tuple.PropertyFactory.getGetter(PropertyFactory.java:168)
at org.hibernate.tuple.PropertyFactory.buildIdentifierProperty(PropertyFactory.java:44)
at org.hibernate.tuple.entity.EntityMetamodel.<init>(EntityMetamodel.java:123)
at org.hibernate.persister.entity.AbstractEntityPersister.<init>(AbstractEntityPersister.java:434)
at org.hibernate.persister.entity.SingleTableEntityPersister.<init>(SingleTableEntityPersister.java:109)
at org.hibernate.persister.PersisterFactory.createClassPersister(PersisterFactory.java:55)
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:226)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1294)
at FirstExample.main(FirstExample.java:21)
 

[Edvins Reisons]

Originally posted by Arun Seshadri:

I tried to run the code now and I get this error.

By "now", do you mean "after having commented out the package statement"?
The version you referred to in your original post was closer to working code; you need to return to that one and modify the mapping element at which Hibernate stopped:

 
<property name="RESULT_ID">
 <column name="RESULT_ID"/>
</property>   

The property name should be the name of the field in the Deals class, which is ResultID (case sensitive).

[Arun Seshadri]

Yes after commenting out the package statement it seems to be doing something but there are still some errors.

I have changed the hbm.xml file as per your suggestion and I corrected the ResultID field in the XML document. When I execute the code I am getting the following error message.

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC 
    "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
  <class name="Deals" table="DEAL">
   <id name="id" type="long" column="RESULT_ID" >
       <generator class="assigned"/>
   </id>
<property name="ResultID">
<column name="ResultID"/>
</property>
<property name="deal">
<column name="deal"/>
 </property>
<property name="id">
<column name="id"/>
 </property>
 
  </class>
</hibernate-mapping>

21:02:52,093  INFO HbmBinder:300 - Mapping class: Deals -> DEAL
21:02:52,109 DEBUG HbmBinder:1270 - Mapped property: id -> RESULT_ID
21:02:52,125 DEBUG HbmBinder:1270 - Mapped property: ResultID -> ResultID
21:02:52,125 DEBUG HbmBinder:1270 - Mapped property: deal -> deal
21:02:52,125 DEBUG HbmBinder:1270 - Mapped property: id -> id
21:02:52,125  INFO Configuration:1541 - Configured SessionFactory: null
21:02:53,015 DEBUG AbstractEntityPersister:2738 - Static SQL for entity: Deals
21:02:53,015 DEBUG AbstractEntityPersister:2743 -  Version select: select RESULT_ID from DEAL where RESULT_ID =?
21:02:53,015 DEBUG AbstractEntityPersister:2746 -  Snapshot select: select deals_.RESULT_ID, deals_.ResultID as ResultID0_, deals_.deal as deal0_, deals_.id as id0_ from DEAL deals_ where deals_.RESULT_ID=?
21:02:53,015 DEBUG AbstractEntityPersister:2749 -  Insert 0: insert into DEAL (ResultID, deal, id, RESULT_ID) values (?, ?, ?, ?)
21:02:53,015 DEBUG AbstractEntityPersister:2750 -  Update 0: update DEAL set ResultID=?, deal=?, id=? where RESULT_ID=?
21:02:53,015 DEBUG AbstractEntityPersister:2751 -  Delete 0: delete from DEAL where RESULT_ID=?
21:02:53,046 DEBUG EntityLoader:79 - Static select for entity Deals: select deals0_.RESULT_ID as RESULT1_0_0_, deals0_.ResultID as ResultID0_0_, deals0_.deal as deal0_0_, deals0_.id as id0_0_ from DEAL deals0_ where deals0_.RESULT_ID=?
21:02:53,046 DEBUG EntityLoader:79 - Static select for entity Deals: select deals0_.RESULT_ID as RESULT1_0_0_, deals0_.ResultID as ResultID0_0_, deals0_.deal as deal0_0_, deals0_.id as id0_0_ from DEAL deals0_ where deals0_.RESULT_ID=?
21:02:53,046 DEBUG EntityLoader:79 - Static select for entity Deals: select deals0_.RESULT_ID as RESULT1_0_0_, deals0_.ResultID as ResultID0_0_, deals0_.deal as deal0_0_, deals0_.id as id0_0_ from DEAL deals0_ where deals0_.RESULT_ID=? for update
21:02:53,046 DEBUG EntityLoader:79 - Static select for entity Deals: select deals0_.RESULT_ID as RESULT1_0_0_, deals0_.ResultID as ResultID0_0_, deals0_.deal as deal0_0_, deals0_.id as id0_0_ from DEAL deals0_ where deals0_.RESULT_ID=? for update nowait
21:02:53,046 DEBUG EntityLoader:79 - Static select for entity Deals: select deals0_.RESULT_ID as RESULT1_0_0_, deals0_.ResultID as ResultID0_0_, deals0_.deal as deal0_0_, deals0_.id as id0_0_ from DEAL deals0_ where deals0_.RESULT_ID=? for update nowait
21:02:53,062 DEBUG EntityLoader:34 - Static select for action ACTION_MERGE on entity Deals: select deals0_.RESULT_ID as RESULT1_0_0_, deals0_.ResultID as ResultID0_0_, deals0_.deal as deal0_0_, deals0_.id as id0_0_ from DEAL deals0_ where deals0_.RESULT_ID=?
21:02:53,062 DEBUG EntityLoader:34 - Static select for action ACTION_REFRESH on entity Deals: select deals0_.RESULT_ID as RESULT1_0_0_, deals0_.ResultID as ResultID0_0_, deals0_.deal as deal0_0_, deals0_.id as id0_0_ from DEAL deals0_ where deals0_.RESULT_ID=?
21:02:53,078 DEBUG SessionFactoryObjectFactory:39 - initializing class SessionFactoryObjectFactory
21:02:53,078 DEBUG SessionFactoryObjectFactory:76 - registered: 8a81818213d8fea20113d8fea3860000 (unnamed)
21:02:53,078  INFO SessionFactoryObjectFactory:82 - Not binding factory to JNDI, no JNDI name configured
21:02:53,078 DEBUG SessionFactoryImpl:308 - instantiated session factory
21:02:53,078  INFO SchemaUpdate:115 - Running hbm2ddl schema update
21:02:53,078  INFO SchemaUpdate:126 - fetching database metadata
21:02:53,078 DEBUG DriverManagerConnectionProvider:93 - total checked-out connections: 0
21:02:53,078 DEBUG DriverManagerConnectionProvider:99 - using pooled JDBC connection, pool size: 0
21:02:53,093  INFO SchemaUpdate:138 - updating schema
21:02:53,093 DEBUG Configuration:1120 - processing extends queue
21:02:53,093 DEBUG Configuration:1124 - processing collection mappings
21:02:53,093 DEBUG Configuration:1135 - processing native query and ResultSetMapping mappings
21:02:53,093 DEBUG Configuration:1143 - processing association property references
21:02:53,093 DEBUG Configuration:1165 - processing foreign key constraints
21:02:53,281  INFO TableMetadata:39 - table found: VELOCITY.DEAL
21:02:53,281  INFO TableMetadata:40 - columns: [deal, result_id, resultid, id]
21:02:53,281  INFO TableMetadata:42 - foreign keys: []
21:02:53,281  INFO TableMetadata:43 - indexes: []
21:02:53,281  INFO SchemaUpdate:160 - schema update complete
21:02:53,296 DEBUG DriverManagerConnectionProvider:129 - returning connection to pool, pool size: 1
21:02:53,296 DEBUG SessionFactoryImpl:392 - Checking 0 named HQL queries
21:02:53,296 DEBUG SessionFactoryImpl:412 - Checking 0 named SQL queries
21:02:53,343 DEBUG SessionImpl:220 - opened session at timestamp: 11847565732
Inserting 1 Record
21:02:53,343 DEBUG DefaultSaveOrUpdateEventListener:158 - saving transient instance
21:02:53,343 DEBUG AbstractSaveEventListener:112 - generated identifier: 2, using strategy: org.hibernate.id.Assigned
21:02:53,343 DEBUG AbstractSaveEventListener:153 - saving [Deals#2]
21:02:53,359 DEBUG AbstractFlushingEventListener:58 - flushing session
21:02:53,359 DEBUG AbstractFlushingEventListener:111 - processing flush-time cascades
21:02:53,375 DEBUG AbstractFlushingEventListener:154 - dirty checking collections
21:02:53,375 DEBUG AbstractFlushingEventListener:171 - Flushing entities and processing referenced collections
21:02:53,375 DEBUG AbstractFlushingEventListener:210 - Processing unreferenced collections
21:02:53,375 DEBUG AbstractFlushingEventListener:224 - Scheduling collection removes/(re)creates/updates
21:02:53,375 DEBUG AbstractFlushingEventListener:85 - Flushed: 1 insertions, 0 updates, 0 deletions to 1 objects
21:02:53,375 DEBUG AbstractFlushingEventListener:91 - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
21:02:53,375 DEBUG Printer:83 - listing entities:
21:02:53,375 DEBUG Printer:90 - Deals{deal=This is a latest test deal, ResultID=1111, id=2}
21:02:53,375 DEBUG AbstractFlushingEventListener:290 - executing flush
21:02:53,375 DEBUG ConnectionManager:469 - registering flush begin
21:02:53,375 DEBUG AbstractEntityPersister:2204 - Inserting entity: [Deals#2]
21:02:53,375 DEBUG AbstractBatcher:366 - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
21:02:53,375 DEBUG ConnectionManager:421 - opening JDBC connection
21:02:53,375 DEBUG DriverManagerConnectionProvider:93 - total checked-out connections: 0
21:02:53,375 DEBUG DriverManagerConnectionProvider:99 - using pooled JDBC connection, pool size: 0
21:02:53,375 DEBUG SQL:401 - insert into DEAL (ResultID, deal, id, RESULT_ID) values (?, ?, ?, ?)
Hibernate: insert into DEAL (ResultID, deal, id, RESULT_ID) values (?, ?, ?, ?)
21:02:53,375 DEBUG AbstractBatcher:484 - preparing statement
21:02:53,375 DEBUG AbstractEntityPersister:1992 - Dehydrating entity: [Deals#2]
21:02:53,375 DEBUG AbstractBatcher:44 - Executing batch size: 1
21:02:53,390 DEBUG Expectations:53 - success of batch update unknown: 0
21:02:53,390 DEBUG AbstractBatcher:374 - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
21:02:53,390 DEBUG AbstractBatcher:533 - closing statement
21:02:53,390 DEBUG ConnectionManager:478 - registering flush end
21:02:53,390 DEBUG AbstractFlushingEventListener:321 - post flush
Done
21:02:53,390 DEBUG AbstractFlushingEventListener:58 - flushing session
21:02:53,390 DEBUG AbstractFlushingEventListener:111 - processing flush-time cascades
21:02:53,390 DEBUG AbstractFlushingEventListener:154 - dirty checking collections
21:02:53,390 DEBUG AbstractFlushingEventListener:171 - Flushing entities and processing referenced collections
21:02:53,390 DEBUG AbstractFlushingEventListener:210 - Processing unreferenced collections
21:02:53,390 DEBUG AbstractFlushingEventListener:224 - Scheduling collection removes/(re)creates/updates
21:02:53,390 DEBUG AbstractFlushingEventListener:85 - Flushed: 0 insertions, 0 updates, 0 deletions to 1 objects
21:02:53,390 DEBUG AbstractFlushingEventListener:91 - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
21:02:53,390 DEBUG Printer:83 - listing entities:
21:02:53,390 DEBUG Printer:90 - Deals{deal=This is a latest test deal, ResultID=1111, id=2}
21:02:53,390 DEBUG AbstractFlushingEventListener:290 - executing flush
21:02:53,390 DEBUG ConnectionManager:469 - registering flush begin
21:02:53,390 DEBUG ConnectionManager:478 - registering flush end
21:02:53,390 DEBUG AbstractFlushingEventListener:321 - post flush
21:02:53,390 DEBUG SessionImpl:273 - closing session
21:02:53,390 DEBUG ConnectionManager:380 - performing cleanup
21:02:53,390 DEBUG ConnectionManager:441 - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
21:02:53,390 DEBUG DriverManagerConnectionProvider:129 - returning connection to pool, pool size: 1
21:02:53,390 DEBUG JDBCContext:215 - after transaction completion
21:02:53,390 DEBUG ConnectionManager:404 - aggressively releasing JDBC connection
21:02:53,390 DEBUG SessionImpl:422 - after transaction completion
 

The database table looks like the following
 

CREATE TABLE DEAL
(
  RESULT_ID  NUMBER,
  DEAL       VARCHAR2(100 BYTE),
  ID         NUMBER(19)
)
TABLESPACE TEST
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          64K
            MINEXTENTS       1
            MAXEXTENTS       2147483645
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
LOGGING 
NOCACHE
NOPARALLEL;
 

[Edvins Reisons]

From the output that I see, the parsing issue is resolved, and the program works. Whether it works as intended is a different question, and I suggest a different thread for discussing it if needed.