java - MySQL JDBC Inactive Connection Timeout -


i have java (swing) desktop connected godaddy mysql database (online database). till time database offline, not @ problem, exception when try access menu involves database access. also, create static connection object when application start, , never close when application running.

this description of exception, please if can.
thanks :)

com.mysql.jdbc.exceptions.jdbc4.communicationsexception: communications link fai lure

last packet sent server 47 ms ago.

some more stack trace , chained cause

caused by: java.io.eofexception: can not read response server. expected read 4 bytes, read 0 bytes before connection unexpectedly lost.

i assuming on shared hosting. connecting such hosting publicly not advisable. dealing problem seems problem remote sql. there few things can 1. go cpanel or equivalent , navigate remote sql add address 0.0.0.0 allow connections public ip may want connect it. if using vpn aws have manually edit my.cnf or my.ini depending on weather hosted on linux or windows, add

bind-address = 0.0.0.0

under 

[mysqld]

tag

  1. next need create user can accessed ip root user has permission accessed locally

    grant on yourdatabasename.* user@'%' identified 'yourrootpassword';


Comments

Post a Comment

Popular posts from this blog

javascript - AngularJS custom datepicker directive -

i make custom datepicker directive custom template. but have no idea how start building it... how include date data directive? i appreciate guide or give me advice work on more precisely. it might you! follow below steps html code sample: <label>birth date</label> <input type="text" ng-model="birthdate" date-options="dateoptions" custom-datepicker/> <hr/> <pre>birthdate = {{birthdate}}</pre> <script type="text/ng-template" id="custom-datepicker.html"> <div class="enhanced-datepicker"> <div class="proxied-field-wrap"> <input type="text" ui-date-format="yy-mm-dd" ng-model="ngmodel" ui-date="dateoptions"/> </div> <label> <button class="btn" type="button"><i class="icon-calendar"></i>
Read more

javascript - jQuery date picker - Disable dates after the selection from the first date picker -

<!doctype html> <html lang="en"> <head> <meta charset="utf-8"> <title>jquery ui datepicker - default functionality</title> <link rel="stylesheet" href="//code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css"> <script src="//code.jquery.com/jquery-1.10.2.js"></script> <script src="//code.jquery.com/ui/1.11.4/jquery-ui.js"></script> <link rel="stylesheet" href="/resources/demos/style.css"> <script> $(function () { $("#datepicker1").datepicker(); }); </script> <script> $(function () { $("#datepicker2").datepicker(); }); </script> </head> <body> <p>date 1: <input type="text" id="datepicker1"></p> <p>date 2: <input type="t
Read more