Does it mean that I’m blocking reading any input from the Server/Client for this socket for 2000 millisecond and after this time the socket is ready to read data? No, it means that if no data arrives within 2000ms a SocketTimeoutException will be thrown. What does it mean timeout expire? It means the 2000ms (in … Read more
Oracle provides a utility called tnsping: R:\>tnsping someconnection TNS Ping Utility for 32-bit Windows: Version 9.0.1.3.1 – Production on 27-AUG-20 08 10:38:07 Copyright (c) 1997 Oracle Corporation. All rights reserved. Used parameter files: C:\Oracle92\network\ADMIN\sqlnet.ora C:\Oracle92\network\ADMIN\tnsnames.ora TNS-03505: Failed to resolve name R:\> R:\>tnsping entpr01 TNS Ping Utility for 32-bit Windows: Version 9.0.1.3.1 – Production on 27-AUG-20 … Read more
very old post but i would like to share my receiver no need to put your hands on manifest or other boring resources 🙂 USAGE YOUR ACTIVITY: /* * You need to implement NetworkStateReceiverListener. * This interface is described inside the NewtworkStateReceiver class */ public class MyActivity implements NetworkStateReceiverListener { /* … */ private NetworkStateReceiver … Read more
I fixed it =) I really had to root around to find the answer for this one. Basically, it comes down to loading metadata and the JDBC driver. It’s loading ALL META DATA, including comments beside sql columns and other various constructs, which are not needed for operation. I don’t know why this is on … Read more
The trick is that you need to subscribe to the server’s connection event which gives you the socket of the new connection. You need to remember this socket and later on, directly after having called server.close(), destroy that socket using socket.destroy(). Additionally, you need to listen to the socket’s close event to remove it from … Read more
This can help you: GRANT ALL PRIVILEGES ON *.* TO ‘root’@’localhost’ IDENTIFIED BY ‘%password%’ WITH GRANT OPTION; Execute it with command line or some GUI tool. Don’t forget to replace %password% with real password.
edit: This only applies if you are in control of the MySQL server… if you’re not take a look at Mysql password hashing method old vs new First check with the SQL query SHOW VARIABLES LIKE ‘old_passwords’ (in the MySQL command line client, HeidiSQL or whatever front end you like) whether the server is set … Read more
No, there is no built-in MySQL command for that. There are various tools and scripts that support it, you can kill some connections manually or restart the server (but that will be slower). Use SHOW PROCESSLIST to view all connections, and KILL the process ID’s you want to kill. You could edit the timeout setting … Read more
You should connect to the place that your actual application needs. Otherwise you’re testing whether you have a connection to somewhere irrelevant (Google in this case). In particular, if you’re trying to talk to a web service, and if you’re in control of the web service, it would be a good idea to have some … Read more
MySQL: ERROR 1040: Too many connections This basically tells that MySQL handles the maximum number of connections simultaneously and by default it handles 100 connections simultaneously. These following reasons cause MySQL to run out connections. Slow Queries Data Storage Techniques Bad MySQL configuration I was able to overcome this issues by doing the followings. Open … Read more