-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 5 posts ] 
Author Message
 Post subject: Funny problem
PostPosted: Thu Sep 02, 2010 1:40 pm 
Newbie

Joined: Thu Sep 02, 2010 1:29 pm
Posts: 5
Hi. I create simple Hibernate application using Swing. It works perfectly. But only when I use database(MYSQL) into my local host. When I try to use database into our network it fails without any exception. Program just stopp when try to connect. I try to connect using MySQL Gui Tools - all perfect, I could even connect through NetBeans IDE, all is perfect. Why it can't connect - I don't know. Thank in advance for Your help.


Top
 Profile  
 
 Post subject: Re: Funny problem
PostPosted: Fri Sep 03, 2010 3:24 am 
Regular
Regular

Joined: Thu May 07, 2009 5:56 am
Posts: 94
Location: Toulouse, France
have you already tried to enable debug mode (log4j.logger.org.hibernate=debug)? what is tracing when the application stops?

_________________
everything should be made as simple as possible, but not simpler (AE)


Top
 Profile  
 
 Post subject: Re: Funny problem
PostPosted: Fri Sep 03, 2010 4:26 am 
Newbie

Joined: Thu Sep 02, 2010 1:29 pm
Posts: 5
INFO: Configuration resource: /hibernate.cfg.xml
03.09.2010 11:24:52 org.hibernate.cfg.Configuration addResource
INFO: Reading mappings from resource : tonakien/model/Inventoryitems.hbm.xml
03.09.2010 11:24:52 org.hibernate.cfg.Configuration doConfigure
INFO: Configured SessionFactory: null
03.09.2010 11:24:52 org.hibernate.cfg.HbmBinder bindRootPersistentClassCommonValues
INFO: Mapping class: tonakien.model.Inventoryitems -> inventoryitems
03.09.2010 11:24:52 org.hibernate.cfg.AnnotationConfiguration secondPassCompile
INFO: Hibernate Validator not found: ignoring
03.09.2010 11:24:52 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Using Hibernate built-in connection pool (not for production use!)
03.09.2010 11:24:52 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: Hibernate connection pool size: 20
03.09.2010 11:24:52 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: autocommit mode: false
03.09.2010 11:24:52 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://195.242.150.89:3306/e5lifedb
03.09.2010 11:24:52 org.hibernate.connection.DriverManagerConnectionProvider configure
INFO: connection properties: {user=root, password=****}

Here stop and the end of story :)


Top
 Profile  
 
 Post subject: Re: Funny problem
PostPosted: Fri Sep 03, 2010 8:15 am 
Regular
Regular

Joined: Thu May 07, 2009 5:56 am
Posts: 94
Location: Toulouse, France
I think you would track you connection in order to know what is happing behind...i guess you are experiencing a connection problem with you database when you want connect from a remote machine.

to trace JDBC driver activity, try P6Spy (http://www.p6spy.com) or place this code before start Hibernate
Code:
DriverManager.setLogWriter(new PrintWriter(System.out, true))

_________________
everything should be made as simple as possible, but not simpler (AE)


Top
 Profile  
 
 Post subject: Re: Funny problem
PostPosted: Fri Sep 03, 2010 9:34 am 
Newbie

Joined: Thu Sep 02, 2010 1:29 pm
Posts: 5
Now have error
DriverManager.getConnection("jdbc:mysql://195.242.150.89:3306/e5lifedb")
trying driver[className=sun.jdbc.odbc.JdbcOdbcDriver,sun.jdbc.odbc.JdbcOdbcDriver@1d99a4d]
*Driver.connect (jdbc:mysql://195.242.150.89:3306/e5lifedb)
trying driver[className=com.mysql.jdbc.Driver,com.mysql.jdbc.Driver@c9ba38]
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2103)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2009)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1292)
at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:859)
at tonalien3.utils.HibernateUtil.<clinit>(HibernateUtil.java:28)
at tonalien.dao.DataAccessObject.<clinit>(DataAccessObject.java:21)
at tonakien3.view.Tonakien3View.loadView(Tonakien3View.java:91)
at tonakien3.view.Tonakien3View.<init>(Tonakien3View.java:87)
at tonakien3.view.Tonakien3App.startup(Tonakien3App.java:19)
03.09.2010 16:10:37 org.hibernate.cfg.SettingsFactory buildSettings
at org.jdesktop.application.Application$1.run(Application.java:171)
WARNING: Could not obtain connection metadata
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)

at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(Last packet sent to the server was 0 ms ago.
EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
getConnection failed: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
Last packet sent to the server was 0 ms ago.
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2103)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:718)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84)
at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2009)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1292)
at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:859)
at tonalien3.utils.HibernateUtil.<clinit>(HibernateUtil.java:28)
at tonalien.dao.DataAccessObject.<clinit>(DataAccessObject.java:21)
at tonakien3.view.Tonakien3View.loadView(Tonakien3View.java:91)
at tonakien3.view.Tonakien3View.<init>(Tonakien3View.java:87)
at tonakien3.view.Tonakien3App.startup(Tonakien3App.java:19)
at org.jdesktop.application.Application$1.run(Application.java:171)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:597)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
Caused by: java.net.SocketException: Malformed reply from SOCKS server
at java.net.SocksSocketImpl.readSocksReply(SocksSocketImpl.java:90)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:429)
at java.net.Socket.connect(Socket.java:525)
at java.net.Socket.connect(Socket.java:475)
at java.net.Socket.<init>(Socket.java:372)
at java.net.Socket.<init>(Socket.java:215)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:253)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2026)
... 30 more


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 5 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.