JDBC, Java Server Pages, and MySQL Questions

• JSP and ASP not only look alike but their underlying technology is quite similar.
• MySQL is just as powerful as Oracle and is half the price.
• JDBC stands for Java Database Connectivity
• MySQL surrogate keys are given the property AUTO_INCREMENT.
• An applet is a Java bytecode program that is sent to the user via HTTP and is invoked using the HTTP protocol on the user's computer.
• Sun defines four JDBC driver types.
• The JVM (Java virtual machine) interprets Java bytecode at run time.
• A servlet is a Java program that is invoked via HTTP on the Web server.
• Java bytecode is machine-specific code.
• With JSP, the coding is done in Java and only in Java.
• JDBC Type 1 drivers are JDBC-ODBC bridge drivers.
• Apache Web server does not support servlets.
• MySQL is pronounced "my See-quel."
• MySQL maintains metadata in the database meta_sql.
• Type 3 and Type 4 JDBC drivers can be used for sevlets and applets.
• Java and C/C++ are so close that there are no incompatibilities between them. Therefore, a driver is not necessary.
• JSP pages provide a means to create dynamic Web pages using HTML and the Java programming language.
• Even though Java is machine-independent, JSPs are not.
• JDBC Type 2 drivers connect to the native API of the DBMS.
• Java programs are compiled into bytecode.