File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Object Relational Mapping and the fly likes .JDBCConnectionException Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark ".JDBCConnectionException" Watch ".JDBCConnectionException" New topic
Author

.JDBCConnectionException

Mirela Muntean
Greenhorn

Joined: Aug 17, 2007
Posts: 13
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
Ranch Hand

Joined: Oct 17, 2001
Posts: 153
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.


Shailesh Kini.
Mirela Muntean
Greenhorn

Joined: Aug 17, 2007
Posts: 13
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
Ranch Hand

Joined: Oct 17, 2001
Posts: 153
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
Greenhorn

Joined: Aug 17, 2007
Posts: 13
hello,

I replaced the connector, and it worked.

Thanks very much
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: .JDBCConnectionException
 
Similar Threads
Hibernate Without Transactions
hibernate with struts
hbm2ddl.auto
how to resolve getting "Dialect class not found: org.hibernate.dialect.Oracle10gDialect " exception
Application Hang when delete() method execute