Problem with Hibernate test application

[Eugene Shaforostov]

I have a simple test application using Hibernate and MySQL.
I got this error when I was trying to run project:

xception in thread "main" org.hibernate.InvalidMappingException: Could not parse mapping document from resource Product.hbm.xml
log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Exception in thread "main" org.hibernate.InvalidMappingException: Could not parse mapping document from resource Product.hbm.xml
at org.hibernate.cfg.Configuration.addResource(Configuration.java:539)
at org.hibernate.cfg.Configuration.addClass(Configuration.java:586)
at InsertProduct.main(InsertProduct.java:24)
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 com.intellij.rt.execution.application.AppMain.main(AppMain.java:78)
Caused by: org.hibernate.InvalidMappingException: Could not parse mapping document from input stream
at org.hibernate.cfg.Configuration.addInputStream(Configuration.java:508)
at org.hibernate.cfg.Configuration.addResource(Configuration.java:536)
... 7 more
Caused by: org.dom4j.DocumentException: Error on line 3 of document  : White spaces are required between publicId and systemId. Nested exception: White spaces are required between publicId and systemId.
at org.dom4j.io.SAXReader.read(SAXReader.java:482)
at org.hibernate.cfg.Configuration.addInputStream(Configuration.java:499)
... 8 more

The project content below files
hibernate.properties

hibernate.connection.username=root
hibernate.connection.password=
hibernate.connection.url=jdbc:mysql://localhost/hibernate
hibernate.connection.driver_class=com.mysql.jdbc.Driver
hibernate.dialect=net.sf.hibernate.dialect.MySQLDialect

Product.hbm.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping
PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN""http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd"> 
<hibernate-mapping>
<class name="Product"
table="products">
<id name="id" type="string"
unsaved-value="null">
<column name="id" sql-type="char(32)"
not-null="true"/>
<generator class="uuid.hex"/>
</id>
<property name="name">
<column name="name" sql-type="char(255)"
not-null="true"/>
</property>
<property name="price">
<column name="price" sql-type="double"
not-null="true"/>
</property>
<property name="amount">
<column name="amount" sql-type="integer"
not-null="true"/>
</property>
</class>
</hibernate-mapping>

Product.java

public class Product {
 
    private String id;
    private String name;
    private double price;
    private int amount;
 
    Product() {   }
 
    public String getId() {
        return id;
    }
    public void setId(String s) {
        id = s;
    }
    public String getName() {
        return name;
    }
    public void setName(String s) {
        name = s;
    }
    public double getPrice() {
        return price;
    }
    public void setPrice(double p) {
        price = p;
    }
    public String getAmount() {
        return name;
    }
    public void setAmount(int a) {
        amount = a;
    }
}

InsertProduct.java

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
 
import org.hibernate.SessionFactory;
 
 
public class InsertProduct {
 
public static void main(String[] args) throws Exception {
 
String name = "qwer";
int amount = 123;
double price = 12.0;
 
Product p = new Product();
p.setName(name);
p.setAmount(amount);
p.setPrice(price);
 
Configuration cfg = new Configuration().addClass(Product.class);
SessionFactory sf = cfg.buildSessionFactory();
Session sess = sf.openSession();
 
Transaction t = sess.beginTransaction();
sess.save(p);
t.commit();
sess.close();
}
}

All files be found in one package.

What's wrong?
[ August 12, 2007: Message edited by: Eugene Shaforostov ]

[Gregg Bolinger]

We have a forum for Hibernate questions; Object Relational Mapping (ORM). I'll move this question there as it's sure to get better/faster responses in the appropriate forum.

[Jaikiran Pai]

Caused by: org.dom4j.DocumentException: Error on line 3 of document : White spaces are required between publicId and systemId. Nested exception: White spaces are required between publicId and systemId.

Your hibernate mapping file looks like:

<!DOCTYPE hibernate-mapping
PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN""http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

Change this declaration to:

<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN"  "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

I just added some whitespaces there.

[Eugene Shaforostov]

Hi Jaikiran,
Thanks for your reply.
I`m change the declaration like you said, but now I get error while compiling:
Exception in thread "main" org.hibernate.HibernateException: Dialect class not found: net.sf.hibernate.dialect.MySQLDialect

[Mathias Nilsson]

I think this should be

org.hibernate.dialect.MySQLDialect

// Mathias

[Eugene Shaforostov]

Thank you!
Now everything works without any problem.