.JDBCConnectionException

[Mirela Muntean]

hello,

I am writing am application using Eclipse 3.1, MySQL Server 4.1, and hibernate 3.2.5
my hibernate.cfg.xml looks like this:

<session-factory>
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="connection.url">jdbc:mysql://localhost/eventdb</property>
<property name="connection.username"></property>
<property name="connection.password"></property>

<!-- JDBC connection pool (use the built-in) -->
<property name="connection.pool_size">1</property>


<!-- SQL dialect -->
<property name="dialect">org.hibernate.dialect.MySQLDialect</property>

<!-- Enable Hibernate's automatic session context management -->
<property name="current_session_context_class">thread</property>

<!-- Disable the second-level cache -->
<property name="cache.provider_class">org.hibernate.cache.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>
<mapping resource="events/Event.hbm.xml"/>
</session-factory>

I have made a little ant file, but when I want to run the application, I get the error:
"java.sql.SQLException: Communication link failure: java.io.IOException, underlying cause: Unexpected end of input stream"
Can anyone tell me what the problem is ?

thank you

[Shailesh Kini]

Hi Mirela,

Seems like your application is not able to communicate with MySQL db server. Do you know what port is your MySQL db running on? You might want to double check your connection.url.

[Mirela Muntean]

the MySql server is running on port 3306, and I have changed the hibernate.cfg.xml file, like his:

<property name="connection.driver_class">org.gjt.mm.mysql.Driver</property>
<property name="connection.url">jdbc:mysql://localhost:3306/eventdb</property>
<property name="connection.username"></property>
<property name="connection.password"></property>

and now the error is: " java.sql.SQLException: Communication link failure: Bad handshake "
What could be the problem now? What username and passowrd do I have to provide ? When I installed the server, there was already one username = root, and I put a password for hat user. These are the credentials I have to provide ,or they are not necesary ?

Thank you

[Shailesh Kini]

Hi Mirela,

Please checkout this link on mysql site
Connector/J

You might want to use a newer version of Connector/J which might hopefully fix the issue.

[Mirela Muntean]

hello,

I replaced the connector, and it worked.

Thanks very much