java - unable to connect to remote database located on server -

-

i trying update database table hosted on server through mysql jdbc connector using eclipse. 

class.forname("com.mysql.jdbc.driver"); string url = "jdbc:mysql://49.**.***.115:3306/databasename"; string name = "user"; string password = "passs";

but not able connect database local machine. checked information provided above correct.

can please tell me next?

here error:

com.mysql.jdbc.exceptions.jdbc4.communicationsexception: communications link failure  last packet sent server 0 milliseconds ago. driver has not received packets server.     @ sun.reflect.nativeconstructoraccessorimpl.newinstance0(native method)     @ sun.reflect.nativeconstructoraccessorimpl.newinstance(unknown source)     @ sun.reflect.delegatingconstructoraccessorimpl.newinstance(unknown source)     @ java.lang.reflect.constructor.newinstance(unknown source)     @ com.mysql.jdbc.util.handlenewinstance(util.java:411)     @ com.mysql.jdbc.sqlerror.createcommunicationsexception(sqlerror.java:1121)     @ com.mysql.jdbc.mysqlio.<init>(mysqlio.java:357)     @ com.mysql.jdbc.connectionimpl.coreconnect(connectionimpl.java:2479)     @ com.mysql.jdbc.connectionimpl.connectonetryonly(connectionimpl.java:2516)     @ com.mysql.jdbc.connectionimpl.createnewio(connectionimpl.java:2301)     @ com.mysql.jdbc.connectionimpl.<init>(connectionimpl.java:834)     @ com.mysql.jdbc.jdbc4connection.<init>(jdbc4connection.java:47)     @ sun.reflect.nativeconstructoraccessorimpl.newinstance0(native method)     @ sun.reflect.nativeconstructoraccessorimpl.newinstance(unknown source)     @ sun.reflect.delegatingconstructoraccessorimpl.newinstance(unknown source)     @ java.lang.reflect.constructor.newinstance(unknown source)     @ com.mysql.jdbc.util.handlenewinstance(util.java:411)     @ com.mysql.jdbc.connectionimpl.getinstance(connectionimpl.java:416)     @ com.mysql.jdbc.nonregisteringdriver.connect(nonregisteringdriver.java:346)     @ java.sql.drivermanager.getconnection(unknown source)     @ java.sql.drivermanager.getconnection(unknown source)     @ connecttodb.getconnection(connecttodb.java:27)     @ updatedb.main(updatedb.java:17) caused by: java.net.connectexception: connection refused: connect     @ java.net.dualstackplainsocketimpl.connect0(native method)     @ java.net.dualstackplainsocketimpl.socketconnect(unknown source)     @ java.net.abstractplainsocketimpl.doconnect(unknown source)     @ java.net.abstractplainsocketimpl.connecttoaddress(unknown source)     @ java.net.abstractplainsocketimpl.connect(unknown source)     @ java.net.plainsocketimpl.connect(unknown source)     @ java.net.sockssocketimpl.connect(unknown source)     @ java.net.socket.connect(unknown source)     @ java.net.socket.connect(unknown source)     @ java.net.socket.<init>(unknown source)     @ java.net.socket.<init>(unknown source)     @ com.mysql.jdbc.standardsocketfactory.connect(standardsocketfactory.java:259)     @ com.mysql.jdbc.mysqlio.<init>(mysqlio.java:307)     ... 16 more

have verified can connect database server machine running code on? looks there network problem. idea first step diagnosing mysql connection problems try connecting command line rule out networking or credentials problems

mysql -uuser -p -h49.**.***.115 databasename

where "user" username "databasename" database , "49.**.***.115" ip of database server.


Comments

Post a Comment

Popular posts from this blog

html5 - What is breaking my page when printing? -

-
Image
i have questioner , don't know why when printing it's creating break before first question. live demo (link) i able resolve issue removing fieldset container had wrapped in.. having fieldset element causing of fields grouped together, , since not fit on first page, being pushed second page. removing fieldset element, able firefox print first 2 questions on page 1 identically chrome. it seems not new problem firefox , fieldset not playing nice found old bugzilla ticket 2008 has persisted , still being commented on in 2014 (link) if retaining fieldset important, found solution else came here (link) <script type='text/javascript'> $(window).bind('beforeprint', function(){ $('fieldset').each( function(item) { $(this).replacewith($('<div class="fieldset">' + this.innerhtml + '</div>')); } ) }); $(window).bind(
Read more

html - Unable to style the color of bullets in a list -

-
i'm trying change colour of list points it's not working? <div class="mobile-menu" id="mobile-menu"> <div id="mobile-menu-links"> <h4>general:</h4> <ul class="mobile-menu-links"> <li><a href="">news</a></li> <li><a href="">the boring rules!</a></li> <li><a href="">the rankings</a></li> </ul> .mobile-menu #mobile-menu-links ul{ list-style-type: none; margin:0; padding-left:3%; } .mobile-menu #mobile-menu-links ul li{ padding-bottom:2px; border-bottom:1px solid #bababa; } if add color:red in either of 2 css declarations, doesn't change colour. please note html closed in document, copi
Read more

c# - must be a non-abstract type with a public parameterless constructor in redis -

-
when save object, got below error must non-abstract type public parameterless constructor in order use parameter 't' in generic type or method 'servicestack.redis.redisclient.store<t>(t) redisclass.getinstnace().store(msg); // error here redisclass.getinstnace().save(); as third party's class, can not edit how save object? could create wrapper around third party object call constructor, store wrapper? e.g. public class mywrapper { public thirdpartyobject thirdpartyinstance { get; set; } public mywrapper() { thirdpartyinstance = new thirdpartyobject("constructors"); } }
Read more