What is UART?
UART is universal asynchronous receiver and transmitter. It is used in many embedded systems for interfacing with other devices. Its purpose is to convert data to and from serial interface. A very popular standard for serial interface is RS-232.
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
I am getting following exception while connecting to mysql. Please let me know where am I wrong? Thank in advance.
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver at java.net.URLClassLoader$1.run(Unknown Source) at java.security.AccessController.doPrivileged(Native Method) at java.net.URLClassLoader.findClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClass(Unknown Source) at java.lang.ClassLoader.loadClassInternal(Unknown Source) at java.lang.Class.forName0(Native Method) at java.lang.Class.forName(Unknown Source) at MySqlTest.main(MySqlTest.java:18)
Restoring mysql dump file
We have a complex database involving foreign keys and we want to restore such database from dump file. If we try to run mysql dump file directly then there might be some errors related to foreign key constrain. The cause for such errors is that a table restore is called while it has foreign key dependency to some other table which has not been restored yet. To ignore such errors, we need to put one simple sql line (SET FOREIGN_KEY_CHECKS=0;) in the beginning of sql dump file. After adding “SET FOREIGN_KEY_CHECKS=0;” remember to add the “SET FOREIGN_KEY_CHECKS=1;” at the end of the dump file.