Need code to create the connection pool in java? Not sure what the question is but don’t create yet another connection pool, use an existing solution like C3P0, Apache DBCP, Proxool or BoneCP (a new player in that field). I would use C3P0. How does we make sure that connection pool doesn’t return the same … Read more
Use JSch import com.jcraft.jsch.*; import java.io.InputStream; import java.io.InputStreamReader; import java.util.Scanner; /** * @author World */ public class SSHReadFile { public static void main(String args[]) { String user = “john”; String password = “mypassword”; String host = “192.168.100.23”; int port = 22; String remoteFile = “/home/john/test.txt”; try { JSch jsch = new JSch(); Session session = … Read more
I don’t know of any performance penalties in frequent closing/opening of the database (regardless of its size). I think the answer to this question also depends on what type of application is accessing the database. Do you “re-query” the database a lot? Then it seems rectified to keep it open. Do you fetch different data … Read more
First check if it’s a workbench or connection problem. 1) In your windows run ‘cmd’ to open a terminal Try both 2a) mysql -u root -p -h 127.0.0.1 -P 3306 2b) mysql -u root -p -h > localhost -P 3306 3) If the connection is good you will get a password prompt, see if you … Read more
have you ever used mysql_pconnect() ? mysql_pconnect() acts very much like mysql_connect() with two major differences. First, when connecting, the function would first try to find a (persistent) link that’s already open with the same host, username and password. If one is found, an identifier for it will be returned instead of opening a new … Read more
I reached out to the node-mysql folks on their Github page and got some firm answers. MySQL does indeed prune idle connections. There’s a MySQL variable “wait_timeout” that sets the number of second before timeout and the default is 8 hours. We can set the default to be much larger than that. Use show variables … Read more
Best way is to use Reachability code. Check here for apple sample code. That has a lot of convenience methods to check internet availability, Wifi/WAN connectivity check etc.. For eg:- [[NSNotificationCenter defaultCenter] addObserver:self selector:@selector(networkChanged:) name:kReachabilityChangedNotification object:nil]; reachability = [Reachability reachabilityForInternetConnection]; [reachability startNotifier]; – (void)networkChanged:(NSNotification *)notification { NetworkStatus remoteHostStatus = [reachability currentReachabilityStatus]; if(remoteHostStatus == NotReachable) { … Read more
I came up with this using the other answers and some from elsewhere: /** * Checks device switch files to see if an HDMI device/MHL device is plugged in, returning true if so. */ private boolean isHdmiSwitchSet() { // The file ‘/sys/devices/virtual/switch/hdmi/state’ holds an int — if it’s 1 then an HDMI device is connected. … Read more
Wifi: WifiManager wifiManager = (WifiManager)context.getSystemService(Context.WIFI_SERVICE); int linkSpeed = wifiManager.getConnectionInfo().getRssi(); In case of mobile it should work: TelephonyManager telephonyManager = (TelephonyManager)this.getSystemService(Context.TELEPHONY_SERVICE); CellInfoGsm cellinfogsm = (CellInfoGsm)telephonyManager.getAllCellInfo().get(0); CellSignalStrengthGsm cellSignalStrengthGsm = cellinfogsm.getCellSignalStrength(); cellSignalStrengthGsm.getDbm(); Then You should compare this signal levels and if WIFI signal is better keep it turn on, but if mobile is better disconnect wifi
When using asmack put some code like this in your app to make Dalvik load the ReconnectionManager class and run it’s static initialization block: static { try { Class.forName(“org.jivesoftware.smack.ReconnectionManager”); } catch (ClassNotFoundException ex) { // problem loading reconnection manager } }