Posts

Showing posts from April, 2017

CPU locks at 700Mhz

Device : Laptop Acer Aspire S3 951, core i7 2637M upgraded to windows 10 from windows 7 64x. Cpu clock speed constantly locks at 700Mhz after running the laptop for a while. Able to resolve this in short term, by shut down the laptop, turn off the adaptor, but the lock will come back again after running some heavy task. try run prime95 to test it. updating BIOS somehow work in short term as well. As for long term solution, - updated the chipset driver with the latest provided by Intel ( just overwrite the one comes with Acer for windows 7 driver). - updated the Intel Management Engine with the one provided by Intel. Laptop has been running for few days (without shutting down) heavy processing sometime. Now without having CPU clock speed locks. - updated Not sure if it is related with hard drive failure. PC's hard drive fail soon when try to reformat the PC with windows 10 installer. upgraded to SSD now running smooth.

Task Manager not showing Network utilization

Network utilization was not working in task manager. Problem arised after enable the network discoverable setting in network property. Notice in the device manager the wireless driver automatically adding few other drivers. Problem solved by disabling the network discoverable setting. Both, via network properties setting in windows 10. and also have to manually change via control panel -- network and sharing -- advance sharing setings turn off network discovery.

Reuseable Java Database Connection Class.

Database Connection class. Which is reuseable. Note the select statement return a statement instead of a resultset, as closing the connection will cause the resultset to be closed as well. Without closing the connection, Mysql will throws error  'too many connections made' when user keep pressing refresh button. import java.sql.*; public class DBConn {     String m_Driver = "com.mysql.jdbc.Driver";     Connection connection = null;     Statement statement = null;     ResultSet rset = null;     String dbPassword = "test";     String dbUsername = "root";     String dbName = "testdb";     String connectionURL = "jdbc:mysql://localhost:3306/" + dbName + "?useSSL=false";         public DBConn() {         try {             Class.forName(m_Driver); ...

Mysql Warning -- Establishing SSL connection without server's identity verification is not recommended.

Warning while using lates MySQL J Driver: mysql-connector-java-5.1.41-bin.jar Following is the warning while running the project from eclipse: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification. Adding useSSL=false to the Database URL solves the problem. example : "jdbc:mysql://localhost:3306/" + dbName + "? useSSL=false";