InvalidMappingException

[shah rah]

  Login.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> 
<class name="local.aaa.testhibernateproject.hibernate.Login" table="login"> 
<id name="id" column="id" type="java.lang.Integer">
<generator class="increment"/>
</id>  
<property name="loginname" column="loginname" type="java.lang.String" />
<property name="password" column="password" type="java.lang.String" /> 
</class>
</hibernate-mapping>
 
Database:
 
CREATE TABLE login(  `id` int(11) NOT NULL auto_increment,
`loginname` varchar(250),  password varchar(250),  PRIMARY KEY  (`id`))
 
 

  TestHibernate.java
public static void main(String[] args) {


 
SessionFactory factory=null;
//System.out.println ("Creating factory");
try
{
                Configuration cfg = new Configuration();
System.out.println ("1.");
cfg.configure("hibernate.cfg.xml");
System.out.println ("2.");
cfg.addResource("Login.hbm.xml");
System.out.println ("3.");
System.out.println ("end Creating configuration");
System.out.println ("Creating factory");
factory = cfg.buildSessionFactory();
System.out.println("factory ready");
Session session = factory.openSession(); 
System.out.println("session ready");

}catch(){}
}


 
 
  

Following is printed
1.
2.
org.hibernate.InvalidMappingException: Could not parse mapping document from resource Login.hbm.xml

C:\myws\testhibernateproject\JavaSource\local\aaa\testhibernateproject\hiber
nate-->Login.java(POJO) and TestHibernate.java


c:\myws\testhibernateproject\WebContent\WEB-INF\classes-->

hibernate.cfg.xml
Login.hbm.xml

What is it that I am doing wrong?

[ October 21, 2008: Message edited by: shah rah ]
[ October 21, 2008: Message edited by: shah rah ]

[Jaikiran Pai]

Is this all that you see in the exception? If not, please post the entire exception stacktrace. Also ensure that you have placed this hbm.xml file at the right location. What location have your specified in your hibernate.cfg.xml file? Can you post the contents of that file?

[Adeel Ansari]

Is it because, the ID column is auto-increment in your actual database table? It should not, because you are implmenting auto-increment through Hibernate. It should be something like int, integer, number or something.

Lets give a try after changing.

[shah rah]

Here is the code.. THere is no stack race and I get only one line of error

RAD: v6
Hibernate: hibernate-distribution-3.3.1.GA-dist.zip
mysqldrivwer: mysql-connector-java-5.1.6
JDK 1.5

  CREATE TABLE login(  `id` int(11) NOT NULL,
  `loginname` varchar(250),  password varchar(250),  PRIMARY KEY  (`id`))  

C:\myws\testhibernateproject\WebContent\WEB-INF\classes\Login.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> 
<class name="local.aaa.testhibernateproject.hibernate.Login" table="login"> 
<id name="id" column="id" type="java.lang.Integer">
<generator class="increment"/>-->[B]same error if I remove or keep this line[/B]
</id>  
<property name="loginname" column="loginname" type="java.lang.String" />
<property name="password" column="password" type="java.lang.String" /> 
</class>
</hibernate-mapping>  

C:\myws\testhibernateproject\WebContent\WEB-INF\classes\Hibernate.cfg.xml---> the db connection works if I write a JDBC program with below parameters

 
<?xml version='1.0' encoding='UTF-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
  <session-factory>
  <property name="connection.url">jdbc:mysql://localhost:3307/test</property>
  <property name="connection.username">root </property>
  <property name="connection.password">password</property>
  <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
  <property name="dialect">org.hibernate.dialect.MySQLDialect</property>
  <property name="transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory
  </property>
  <property name="current_session_context_class">thread </property>
  <!-- this will show us all sql statements -->
  <property name="hibernate.show_sql">true </property>  
  <mapping resource="Login.hbm.xml" />
</session-factory>
</hibernate-configuration>
   

 
 
[B]C:\myws\testhibernateproject\JavaSource\local\aaa\testhibernateproject\hibernate\Login.java[/B]
public class Login {

  private Integer id;
  private String loginname;
  private String password;
 
 
 
/**
 * @return Returns the loginname.
 */
public String getLoginname() {
return loginname;
}
/**
 * @param loginname The loginname to set.
 */
public void setLoginname(String loginname) {
this.loginname = loginname;
}
  public String getPassword() {
    return password;
  }
  public void setPassword(String password) {
    this.password = password;
  }
 
/**
 * @return Returns the id.
 */
public Integer getId() {
return id;
}
/**
 * @param id The id to set.
 */
public void setId(Integer id) {
this.id = id;
}
}
 

C:\myws\testhibernateproject\JavaSource\local\aaa\testhibernateproject\hibernate\TestHibernate.java

   
public class TestHibernate {
 
public static void main(String[] args) {
 
SessionFactory factory=null;
try
{
Configuration cfg =new Configuration();
System.out.println ("1.Creating configuration");
cfg.configure("hibernate.cfg.xml");
System.out.println ("2.Creating configuration");
 
//cfg.addResource("Login.hbm.xml");
 
[B]Erorr I get if I remove comments//org.hibernate.InvalidMappingException: Could not parse mapping document from resource Login.hbm.xml[/B]
 
cfg.addClass(Login.class);
 
[B]Error I get//org.hibernate.MappingNotFoundException: resource: local/aaa/testhibernateproject/hibernate/Login.hbm.xml not found[/B]
 
System.out.println ("end Creating configuration");
System.out.println ("Creating factory");
factory = cfg.buildSessionFactory();
System.out.println("factory ready");
Session session = factory.openSession(); 
System.out.println("session ready");
}
catch(Exception e1)
{ 
System.out.println(""+e1);
}
 


 


}
}
 

[ October 22, 2008: Message edited by: shah rah ]
[ October 22, 2008: Message edited by: shah rah ]

[Adeel Ansari]

There is no Exception stack trace in your post. From one of the line you mentioned, it looks it is unable to locate your Login.hbm.xml

[Paul Sturrock]

Why are you using hibernate.cfg.xml and configuring your SessionFactory programatically? Pick one or the other.

As Adeel mentions, the reason you see this is because Hibernate cannot find the mapping file you are trying to add to the configuration.

If you do this:

cfg.addResource("Login.hbm.xml");

you asking Hibernate to find a resource called "Login.hbm.xml" that is located in the default package.

If you do this:

cfg.addClass(Login.class)

you are asking Hibernate to configure a resource from a file (assuming you are not using annotations) called "Login.hbm.xml" that sits in the same package as your class file. So if the fully qualified name of your class is local.aaa.testhibernateproject.hibernate.Login your mapping file must be in the folder local/aaa/testhibernateproject/hibernate/. Given Hibernate cannot find this file, I assume this is not the case.

If you do this:

cfg.configue();

you are asking Hibernate to configure a SessionFactory based on the resources it finds in hibernate.cfg.xml. Currently, this will require a file called "Login.hbm.xml" existing in the default package.

[shah rah]

I followed this tutorial and it works fine now.

http://www.hibernate.org/hib_docs/v3/reference/en/html/tutorial-firstapp.html