problem in hibernate code

[Hamzah khammash]

Hello , i am new to hibernate and this stuff ,i try to code a student-course example hibernate but always got a set of exception
this are the exception i will but the hibernate.cfg.xml file and the main class and factory class and hope somebody helps me in this example i used Mysql database:

Jan 25, 2012 5:46:42 PM org.hibernate.annotations.common.Version <clinit>
INFO: HCANN000001: Hibernate Commons Annotations {4.0.1.Final}
Jan 25, 2012 5:46:42 PM org.hibernate.Version logVersion
INFO: HHH000412: Hibernate Core {4.0.0.Final}
Jan 25, 2012 5:46:42 PM org.hibernate.cfg.Environment <clinit>
INFO: HHH000206: hibernate.properties not found
Jan 25, 2012 5:46:42 PM org.hibernate.cfg.Environment buildBytecodeProvider
INFO: HHH000021: Bytecode provider name : javassist
Jan 25, 2012 5:46:42 PM org.hibernate.cfg.Configuration configure
INFO: HHH000043: Configuring from resource: /hibernate.cfg.xml
Jan 25, 2012 5:46:42 PM org.hibernate.cfg.Configuration getConfigurationInputStream
INFO: HHH000040: Configuration resource: /hibernate.cfg.xml
Jan 25, 2012 5:46:42 PM org.hibernate.internal.util.xml.XMLHelper$ErrorLogger error
ERROR: HHH000197: Error parsing XML: /hibernate.cfg.xml(2) Content is not allowed in prolog.
Initial SessionFactory creation failed.org.hibernate.HibernateException: Could not parse configuration: /hibernate.cfg.xml
Exception in thread "main" java.lang.ExceptionInInitializerError
	at com.hibernate.Factory.<clinit>(Factory.java:17)
	at com.main.MainTest.listDatabase(MainTest.java:23)
	at com.main.MainTest.main(MainTest.java:18)
Caused by: org.hibernate.HibernateException: Could not parse configuration: /hibernate.cfg.xml
	at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:2010)
	at org.hibernate.cfg.AnnotationConfiguration.doConfigure(AnnotationConfiguration.java:201)
	at org.hibernate.cfg.AnnotationConfiguration.doConfigure(AnnotationConfiguration.java:46)
	at org.hibernate.cfg.Configuration.configure(Configuration.java:1922)
	at org.hibernate.cfg.AnnotationConfiguration.configure(AnnotationConfiguration.java:183)
	at org.hibernate.cfg.AnnotationConfiguration.configure(AnnotationConfiguration.java:46)
	at org.hibernate.cfg.Configuration.configure(Configuration.java:1901)
	at org.hibernate.cfg.AnnotationConfiguration.configure(AnnotationConfiguration.java:177)
	at com.hibernate.Factory.<clinit>(Factory.java:12)
	... 2 more
Caused by: org.dom4j.DocumentException: Error on line 2 of document  : Content is not allowed in prolog. Nested exception: Content is not allowed in prolog.
	at org.dom4j.io.SAXReader.read(SAXReader.java:482)
	at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:2002)
	... 10 more

here is the factory class which is the factory of SessionFactory

import org.hibernate.SessionFactory;
import org.hibernate.cfg.AnnotationConfiguration;

@SuppressWarnings("deprecation")
public class Factory {
	private static final SessionFactory sessionFactory;
	static {
		try {
			// Create the SessionFactory from hibernate.cfg.xml
			sessionFactory = new AnnotationConfiguration().configure()
					.buildSessionFactory();
		} catch (Throwable ex) {
			// Make sure you log the exception, as it might be swallowed
			System.err.println("Initial SessionFactory creation failed." + ex);
			throw new ExceptionInInitializerError(ex);
		}
	}

	public static SessionFactory getSessionFactory() {
		return sessionFactory;
	}
}

and my main class is :

package com.main;

import java.util.Iterator;
import java.util.List;

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

import com.hibernate.Course;
import com.hibernate.Factory;
import com.hibernate.Student;

public class MainTest {

	public static void main(String[] args) {
		MainTest mainTest = new MainTest();
		mainTest.listDatabase();

	}

	public void listDatabase() {
		SessionFactory session = Factory.getSessionFactory();
		Session session1 = session.getCurrentSession();
		Transaction transaction = session1.beginTransaction();
		List course = session1.createQuery("from course").list();
		Iterator iterator = course.iterator();
		while (iterator.hasNext()) {
			Course course1 = (Course) iterator.next();
			System.out.println(course1.getCourseId());
			System.out.println(course1.getCourseName());
			transaction.commit();
		}

	}
}

and my XML File is - <hibernate-configuration> - <session-factory> - <!-- Database connection settings --> <property name="connection.driver_class">org.postgresql.Driver</property> <property name="connection.url">jdbc:postgresql://localhost:3306/Hibernate </property> <property name="connection.username">root</property> <property name="connection.password">4896558</property> - <!-- JDBC connection pool (use the built-in) --> <property name="connection.pool_size">1</property> - <!-- SQL dialect --> <property name="dialect">org.hibernate.dialect.PostgreSQLDialect </property> - <!-- Disable the second-level cache --> <property name="cache.provider_class">org.hibernate.cache.internal.NoCacheProvider </property> - <!-- Echo all executed SQL to stdout --> <property name="show_sql">true</property> - <!-- Drop and re-create the database schema on startup --> <property name="hbm2ddl.auto">create</property> - <!-- Names the annotated entity class --> <mapping class="com.hibernate.Student" /> <mapping class="com.hibernate.Course" /> </session-factory> </hibernate-configuration>
so any help will be appropriated .

[Vijitha Kumara]

You have to define the xml declarations in the config file above <hibernate-configuration> tag. Check the sample code from Hibernate distribution to get the correct code.