Error ##### org.hibernate.exception.GenericJDBCException: Cannot open connection

[Vinod Vinu]

Hi, i'm getting the following error on eclipse's console:-

%%%% Success Creating SessionFactory %%%%
------HIBERNATE SESSION SUCCESSFULLY READ-------
INSERTING RECORDS
Dec 4, 2010 6:22:11 AM org.hibernate.util.JDBCExceptionReporter logExceptions
WARNING: SQL Error: 0, SQLState: null
Dec 4, 2010 6:22:11 AM org.hibernate.util.JDBCExceptionReporter logExceptions
SEVERE: Communication failure during handshake. Is there a server running on localhost:3306?
Error ##### org.hibernate.exception.GenericJDBCException: Cannot open connection


I'm developing a web application using struts, java, hibernate, tomcat 6 and mysql database.

Hibernate configuration:-

<?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">com.microsoft.sqlserver.jdbc.SQLServerDriver</property> 
  <property name="hibernate.connection.url">jdbc:sqlserver://192.168.230.214:1433;DatabaseName=vinod</property> 
  <property name="hibernate.connection.username">sa</property> 
  <property name="hibernate.connection.password">vinod</property> 
  <property name="hibernate.connection.pool_size">10</property> 
  <property name="show_sql">true</property> 
  <property name="dialect">org.hibernate.dialect.SQLServerDialect</property> 
 -->
  <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property> 
  <property name="dialect">org.hibernate.dialect.MySQLDialect</property> 
  <property name="hibernate.connection.url">jdbc:mysql://localhost/vinod</property> 
  <property name="hibernate.connection.username">root</property> 
  <property name="hibernate.connection.password">password</property> 
  <property name="hibernate.connection.pool_size">10</property> 
  <property name="show_sql">true</property> 
  
  
 <!-- <property name="hibernate.hbm2ddl.auto">update</property> -->
      <!-- Mapping files -->
      <mapping resource="/hibernate/login.hbm.xml"/>
      <mapping resource="/hibernate/reg.hbm.xml"/>
     
</session-factory>
</hibernate-configuration>

I'm sure that i have given correct database information like its db name, username and password, but don't know what is wrong with it.
Using Navicat i can connect easily with 'vinod' database by providing the same credentials. But why cannot be with hibernate ?
Any idea?

Thanks in advance

[Vitaliy Kravchenko]

May be your mySQL Server is off? check this
jdbc:mysql://localhost:3306/vinod

[Vinod Vinu]

May be your mySQL Server is off? check this
jdbc:mysql://localhost:3306/vinod

Please explain me how can i check that if my mysql server is running or not ?

thanks

[Vitaliy Kravchenko]

If you have installed mySQL Server as service, check MyComputer -> right click ->control -> and find there Mysql, then check that service is running
Or you can start Client command line, if everything will be ok, then you Server is running

[Vinod Vinu]

I did it, the only solution i found to be is to remove a mysql jar file named 'mysql-connector-java-2.0.14'

It is working now fine.