getting this error when connecting to databse through hibernate

[Ritesh Pareek]

Hi all,

i am getting this error when connecting to databse through hibernate. stacktrace is..

java.net.SocketException: java.net.ConnectException: Connection refused
	at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
	at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)
	at com.mysql.jdbc.Connection.createNewIO(Connection.java:2641)
	at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
	at java.sql.DriverManager.getConnection(DriverManager.java:525)
	at java.sql.DriverManager.getConnection(DriverManager.java:140)
	at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
	at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
	at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
	at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:119)
	at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:57)
	at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1326)
	at com.monsoon.manglish.application.ApplicationDao.getAllObjects(ApplicationDao.java:275)
	at com.monsoon.manglish.dao.GenreDao.getAllGenresList(GenreDao.java:44)
	at com.monsoon.manglish.manager.GenreManager.getAllGenresList(GenreManager.java:42)
	at com.monsoon.manglish.controller.FacadController.home(FacadController.java:42)

and cfg is

<?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/new_manglish
        </property>
        <property name="connection.driver_class">
          com.mysql.jdbc.Driver
        </property>
        <property name="connection.username">
          root
        </property>
        <property name="connection.password">
          root
        </property>

        <property name="dialect">
            org.hibernate.dialect.MySQLDialect
        </property>
        <property name="hibernate.query.factory_class">
            org.hibernate.hql.classic.ClassicQueryTranslatorFactory
        </property>
        <property name="hibernate.transaction.factory_class">
            org.hibernate.transaction.JDBCTransactionFactory
        </property>
        <property name="hibernate.current_session_context_class">
            thread
        </property>
...
<hibernate-configuration>

i am always happy to see THE ERROR... Please help

[Paul Sturrock]

"shoot dead" please check your private messages.

[David Newton]

This question belongs in the Object-Relational-Mapping forum.

[Paul Sturrock]

Can you connect to jdbc:mysql://localhost/new_manglish as root normally? The error message sugegsts the username/password are not right, the database is not running or a firewall is preventing the connection.