Database Access in GWT – The Missing Tutorial
A programmer's guide on integrating MySQL into Google Web Toolkit Applications
using the Eclipse Programming Environment
Human-Computer Interaction MA Program
Department of Psychology
Department of Computer Science
State University of New York,College at Oswego
Oswego, NY, USA
DB Access in GWT Tutorial 2
This tutorial explains the principle method of adding MySQL support to dynamic GWT Web
Applications using asynchronous callback with Remote Procedure Call providers. Even though there
are already plenty information on this topic available on the Internet, a detailed, step-by-step
explanation seems to be missingso far. The mission of this tutorial is to provide such an explanation in
a more detailed fashion than the GWT Examples  provide.
2. Table of Content.
2. Table of Content.
6. The Missing Tutorial
6.1 The Short Version
6.2 Necessary Software
6.3 Add MySQL to Java
56.4 Add MySQL configuration to GWT.
6.5. Clean your project.
6.6. Make the client side be aware of the Servlet.
6.7. Create serializable objects for callbacks.
6.8 Create the Servlet.
6.9. Prepare an RPC Provider in your GWT App.
6.10. Make Remote Procedure Calls from your GWT application.
DB Access in GWT Tutorial 3
This tutorial is my attempt to summarize my findings in search the Internet on how to do so,
along with massive findings that I discovered myself in “taming” the beast of GWT and MySQL. I
neither claim this document to be correct, nor flawlessly correct. If you notice any glitches, please
contact me for revisions.
This documentmay be used, (re-)distributed, shared and made available in printed or electronic
version for personal, educational, and scientific use without explicit permission. You may not gain any
financial profit or any other profit from my work without explicit prior written permission. Prerequisite
for any distribution and use of this document is that used in it's entirety, with copyright noticesintact.
Why this tutorial? Isn't there enough info on this on the Intertubes? Well, yes. And no. There are
a few good sources, especially the ones from the makers , but none really explains the special
nuances, like that the DB driver has to live in a Servlet. In fact, that is the most important take-home
message: The actual database queries are handled by a Servlet and youneed to make RPC calls, using
a callback handler to have the client side GUI (recall that the GWT application is executed client side
in the browser, not on the server!) talk to the database. The mission of this tutorial is hence to show the
necessary steps needed to integrate MySQL with GWT applications and explain what happens at each
I will assume that you have anunderstanding of how to do GWT in first place. At least you
the main class implements the EntryPoint interface and all the other stuff to get a very basic GWT App
working in your browser. I will also assume that you know basic Java, like classpaths, dependencies
and such. I also will assume that youhave some dynamic web server, like Tomcat, at your disposal, and
that you can use the world's largest knowledge base  to find out how to configure it.
DB Access in GWT Tutorial 4
6. The Missing Tutorial.
In this little tutorial, we will implement a simple thing – a LoginScreen that will allow you to
enter a user name and a password, and authenticate this combination. Assuming, of...