Hibernate cfg xml and Eclipse problem

[Priety Sharma]

I have Eclipse Europa and am trying to do a hibernate example in it.
I am trying to simply add an entry to the database.

My hibernate.cfg.xml file is as follows:

    

<?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-configuration>
  <session-factory>
   <property name="hibernate.connection.driver_class">org.derby.Driver</property>
   <property name="hibernate.connection.url">jdbc:derby://localhost:1527/myDB</property>
   <property name="hibernate.connection.username">me</property>
   <property name="hibernate.connection.password">mine</property>
   <property name="hibernate.connection.pool_size">10</property>
   <property name="show_sql">true</property>
   <property name="dialect">org.hibernate.dialect.DerbyDialect</property>
   <property name="hibernate.hbm2ddl.auto">update</property>
   <mapping resource="Job.hbm.xml"/>
  </session-factory>
 
 </hibernate-configuration>

Eclipse keeps showing errors for this xml.

An when I run the class with the hibernate code it shows/throws the following error.

    

Nov 15, 2009 12:24:58 AM org.slf4j.impl.JCLLoggerAdapter info
INFO: Hibernate 3.3.0.CR1
Nov 15, 2009 12:24:59 AM org.slf4j.impl.JCLLoggerAdapter info
INFO: hibernate.properties not found
Nov 15, 2009 12:24:59 AM org.slf4j.impl.JCLLoggerAdapter info
INFO: Bytecode provider name : cglib
Nov 15, 2009 12:24:59 AM org.slf4j.impl.JCLLoggerAdapter info
INFO: using JDK 1.4 java.sql.Timestamp handling
Nov 15, 2009 12:25:00 AM org.slf4j.impl.JCLLoggerAdapter info
INFO: configuring from resource: /hibernate.cfg.xml
Nov 15, 2009 12:25:00 AM org.slf4j.impl.JCLLoggerAdapter info
INFO: Configuration resource: /hibernate.cfg.xml
Nov 15, 2009 12:25:00 AM org.slf4j.impl.JCLLoggerAdapter error
[b]SEVERE: Error parsing XML: /hibernate.cfg.xml(2) The markup in the document preceding the root element must be well-formed.
org.hibernate.HibernateException: Could not parse configuration: /hibernate.cfg.xml
 at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1505)
 at org.hibernate.cfg.Configuration.configure(Configuration.java:1439)
 at org.hibernate.cfg.Configuration.configure(Configuration.java:1425)
 at AddJob.main(AddJob.java:19)
Caused by: org.dom4j.DocumentException: Error on line 2 of document  : The markup in the document preceding the root element must be well-formed. Nested exception: The markup in the document preceding the root element must be well-formed.
 at org.dom4j.io.SAXReader.read(SAXReader.java:482)
 at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1495)[/b] ... 3 more
Exception in thread "main" java.lang.NullPointerException
 at AddJob.main(AddJob.java:34)

My java classes are in the src folder, there is no package hierarchy. The hibernate.cfg.xml file is placed in the bin folder.
Is this an Eclipse issue is there an error in the way the xml is written.
How do I get this resolved.

[Vijitha Kumara]

    
<! DOCTYPE hibernate-mapping PUBLIC    
 "-//Hibernate/Hibernate Mapping DTD ....

Use the correct DOCTYPE element for configuration file, you have used the one for the mapping file.

[Priety Sharma]

Hi,

Here is the hibernate.cfg.xml again:

<?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="hibernate.connection.driver_class">org.derby.Driver</property>
   <property name="hibernate.connection.url">jdbc:derby://localhost:1527/myDB</property>
   <property name="hibernate.connection.username">me</property>
   <property name="hibernate.connection.password">mine</property>
   <property name="hibernate.connection.pool_size">10</property>
   <property name="show_sql">true</property>
   <property name="dialect">org.hibernate.dialect.DerbyDialect</property>
   <property name="hibernate.hbm2ddl.auto">update</property>
   <mapping resource="Job.hbm.xml"/>
  </session-factory>

</hibernate-configuration>

The DOCTYPE element has been modified.

Still getting error:

Nov 15, 2009 5:50:32 PM org.slf4j.impl.JCLLoggerAdapter info
INFO: Hibernate 3.3.0.CR1
Nov 15, 2009 5:50:32 PM org.slf4j.impl.JCLLoggerAdapter info
INFO: hibernate.properties not found
Nov 15, 2009 5:50:32 PM org.slf4j.impl.JCLLoggerAdapter info
INFO: Bytecode provider name : cglib
Nov 15, 2009 5:50:32 PM org.slf4j.impl.JCLLoggerAdapter info
INFO: using JDK 1.4 java.sql.Timestamp handling
Nov 15, 2009 5:50:32 PM org.slf4j.impl.JCLLoggerAdapter info
INFO: configuring from resource: /hibernate.cfg.xml
Nov 15, 2009 5:50:32 PM org.slf4j.impl.JCLLoggerAdapter info
INFO: Configuration resource: /hibernate.cfg.xml
Nov 15, 2009 5:50:33 PM org.slf4j.impl.JCLLoggerAdapter error
SEVERE: Error parsing XML: /hibernate.cfg.xml(2) The markup in the document preceding the root element must be well-formed.
org.hibernate.HibernateException: Could not parse configuration: /hibernate.cfg.xml
	at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1505)
	at org.hibernate.cfg.Configuration.configure(Configuration.java:1439)
	at org.hibernate.cfg.Configuration.configure(Configuration.java:1425)
	at AddJob.main(AddJob.java:19)
Caused by: org.dom4j.DocumentException: Error on line 2 of document  : The markup in the document preceding the root element must be well-formed. Nested exception: The markup in the document preceding the root element must be well-formed.
	at org.dom4j.io.SAXReader.read(SAXReader.java:482)
	at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1495)
	... 3 more
Exception in thread "main" java.lang.NullPointerException
	at AddJob.main(AddJob.java:34)

[Vijitha Kumara]

May be the changes are still not visible?

[Priety Sharma]

The changes were in place when I restarted Eclipse.

[Vijitha Kumara]

Priety Sharma wrote:The changes were in place when I restarted Eclipse.

You don't need to restart eclipse but the file should be copied to the classpath when you run it in order to read it.

[Priety Sharma]

Hi,

A little confused here.
I have the hibernate.cfg.xml file in the bin folder of my project.
If I remove it from there it says hibernate.cfg.xml not found.
Which means that it is where it should be.

After putting it back there it still gives the same error.

[Vijitha Kumara]

Priety Sharma wrote:If I remove it from there it says hibernate.cfg.xml not found. Which means that it is where it should be.

Yes, that's what I mean, it should be found in the CLASSPATH. If you still get the parse exception all I can say is just check your xml against the reference of the Hibernate version you are using thoroughly.

[Priety Sharma]

Ok.


Now I have somehow managed to get rid of the xml error.

I am using hibernate3.3.0. Database is derby.


Getting a new error.
java.lang.NoClassDefFoundError

This piece of code is throwing an exception when the buildSessionFactory() method is called.

    
	Configuration cf = new Configuration().configure();
	factory = cf.buildSessionFactory();

Even though its in the try block the control goes directly to the finally block and then the exception is printed.

Exception message:

    

Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/commons/collections/map/LRUMap
	at org.hibernate.util.SimpleMRUCache.init(SimpleMRUCache.java:47)
	at org.hibernate.util.SimpleMRUCache.<init>(SimpleMRUCache.java:31)
	at org.hibernate.util.SimpleMRUCache.<init>(SimpleMRUCache.java:26)
	at org.hibernate.engine.query.QueryPlanCache.<init>(QueryPlanCache.java:43)
	at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:153)
	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1304)
	at AddJob.main(AddJob.java:23)

My AddJob class:

    

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;



public class AddJob {

		public static void main(String[] args) {
		Session session = null;
		SessionFactory factory;
		
		try
		{
						
			Configuration cf = new Configuration().configure();
			factory = cf.buildSessionFactory();
			session = factory.openSession();
			Transaction tr = session.beginTransaction();
			
			Job j1 = new Job(10000,"Sharu","e001");
			session.save(j1);
			tr.commit();
			System.out.println("Record added");
		}
		catch(Exception e)
		{
			//e.printStackTrace();
		}
		finally
		{
			//session.flush(); //session.close();
		}

	}

}

Please help.

[Vivek Singh]

Change the Name of all the files (xml & java)and try again.
What is your mapping file???

[Priety Sharma]

Hi,

Looks like I am almost there. Added commons-collections-3.2.1jar and got rid of an intermediate error.



Now I am getting a for:

  
org.hibernate.exception.JDBCConnectionException: Cannot open connection
	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:66)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
	at org.hibernate.jdbc.AbstractBatcher.openConnection(AbstractBatcher.java:384)
	at org.hibernate.jdbc.JDBCContext.connect(JDBCContext.java:141)
	at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:88)
	at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:49)
	at org.hibernate.transaction.JDBCTransactionFactory.beginTransaction(JDBCTransactionFactory.java:19)
	at org.hibernate.jdbc.JDBCContext.beginTransaction(JDBCContext.java:204)
	at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1007)
	at AddEmployee.main(AddEmployee.java:27)
Caused by: java.sql.SQLException: No suitable driver
	at java.sql.DriverManager.getConnection(DriverManager.java:559)
	at java.sql.DriverManager.getConnection(DriverManager.java:158)
	at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
	at org.hibernate.jdbc.AbstractBatcher.openConnection(AbstractBatcher.java:381)
	... 7 more

This is the driver I am trying to use to connect to derby.

<property name="hibernate.connection.driver_class">org.apache.derby.jdbc.EmbeddedDriver</property>

I put the import in my java file just to check if its available an the EmbeddedDrive class is there.

Still get the above mentioned error.
Which driver class should I use.

Derby version is 10.3.1

Stuck again.

[Vijitha Kumara]

 Caused by: java.sql.SQLException: No suitable driver 

Looks like your JDBC driver is not in the classpath.

[Priety Sharma]

It must be there.
Since in the same project I have a class called Derbyconnectiontest.java and it simply test connecting to derby.

It works.
In this class I have used

String driver = "org.apache.derby.jdbc.EmbeddedDriver";

as the driver.

This is the same driver I have mentioned in my hibernate.cfg.xml file in the same eclipse project.

The configuration xml again:

<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
  <session-factory>
   <property name="hibernate.connection.driver_class">org.apache.derby.jdbc.EmbeddedDriver</property>
   <property name="hibernate.connection.url">jdbc:derby://localhost:1527/emp1234;create=true</property>
   <property name="hibernate.connection.username">me</property>
   <property name="hibernate.connection.password">mine</property>
   <property name="hibernate.connection.pool_size">10</property>
   <property name="show_sql">true</property>
   <property name="dialect">org.hibernate.dialect.DerbyDialect</property>
   <property name="hibernate.hbm2ddl.auto">update</property>
   <mapping resource="Job.hbm.xml"/>
  </session-factory>

</hibernate-configuration>

Then why is it not working?

[Priety Sharma]

Hi Vijitha,

Good news here.
I have finally been able to run the hibernate code and put records in the derby database.
After trying for almost the whole day things fell into place.

The driver error mentioned was due to the url property not being as expected:

The value which works is:

<property name="hibernate.connection.url">jdbc:derby:mydb</property>

and not this:

<property name="hibernate.connection.url">jdbc:derby://localhost:1527/emp1234;create=true</property> 

Since my class to test the connection to the derby database was working properly and still the problem was present when connecting to derny through hibernate code I was confused.

I read a thread on another forum where someone had mentioned that it had to be a URL problem.
So finally got the URL right and code started working.



Thanks for all the replies and the help.

This is a relief.

[Vijitha Kumara]

Glad to hear that worked finally