JavaDeploy
SiteMap
JSP - Servlets
JDBC
EJB Concepts
Entity Beans
JDBC
«Prev
Servlet Intro
Java Servlets
HTTP Stateless Information
Problems with CGI
Java Servlet Advantages.
Servlet GET Requests
Software Configuration
Java Servlet Development Kit
Text Editor
Configuring JSDK
Servlet Page Generation
doGet Servlet Method.
Simple Servlet generates HTML
Generating Page from Servlet
Maintaining Servlet State
HTML Form Creation
Form Servlet Communication
Generating Servlet Form
Start Web Server
Processing Servlet Form
Web Page Generation
Servlet Database Connection
What is JDBC?
Applet Servlet Interaction
Display Servlet Response
Setting up JDBC[Data Source] - Exercise
Setting up A JDBC data source
Objective:
Create a data source to be used in later lessons.
Exercise scoring
This exercise is worth 2 points. The exercise is auto-scored, which means that all you have to do to receive credit for it is click the
Submit
button below.
Background/overview
Before your servlets can access a file on your hard drive, you must set up a data source. Since we’ll be using the JDBC-ODBC bridge, you set up an ODBC data source.
Download files
You need to use the following file from the Exercise download: servletsample.mdb (The starter database).
Instructions
Bring up the control panel, then ODBC or 32-bit ODBC (it’s the same product, with different names in different versions of Windows.).
On the System DSN tab, click Add.
Choose the Microsoft Access Driver, and click Finish.
Enter the name of the DSN,
javadeploy.com
, and a sensible description.
Click Select, and browse to the directory where you downloaded the sample database.
Click OK to see your new DSN included on the System DSN tab.