Use GeneXus Java and MySQL in 8 steps

1. Install Sun JDK 1.4 or higher (http://java.sun.com/j2se/1.4.2/download.html )

2. Install mySQL server (version 4.0 or higher : http://dev.mysql.com/downloads/)

3. Install the JDBC driver (version 3.0 or higher : http://dev.mysql.com/downloads/). (If you download the .zip file, uncompress the .jar file inside it to a folder)

4. Install mySQL Control Center (administration tool, available in http://dev.mysql.com/downloads/mysqlcc.html)

5. Execute mySQL Control Center and create a database, and a user.

6. Configure a GeneXus model with mySQL as DBMS. In 'DBMS Options' configure 'JDBC driver' with the value 'mySQL JDBC Driver (Type 4)', and set the properties about the server name, database name, user and password. In 'Execution Options' configure 'Sun SDK' in 'Platform', and add the JDBC .jar file to 'Classpath'.

7. Create the tables with GeneXus

8. Generate and compile you application

Notes:
-In order to use the Microsoft VM, and older drivers, you should use the following:
http://dev.mysql.com/downloads/connector/j/2.0.html

- To use NLS (national language support), use a custom URL in the DBMS Options in order to set some additional connection properties:
Example: "jdbc:mysql://myserver:3306/mydatabase?useUnicode=true&characterEncoding=utf8&characterSetResults=utf8"

Tip: Client and server cursors - using MySQL