O'Reilly logo

XML and Java™ from scratch by Nicholas Chase

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating the Inventory Database

The first thing we need to do is to create the inventory database. To do that, we're going to create a connection to our database, and then execute an SQL statement to create the table.

Creating the ODBC Connection

Because we're going to be using the JDBC-ODBC bridge, we need to create an ODBC connection. To make things simple, it doesn't matter what database you use, as long as you can create an ODBC connection to it.

Setting up an ODBC connection on a Microsoft Windows system involves the following steps:

1.
Create the database, if necessary. We can use a text database, so we can create it on the fly, so to speak. A Microsoft Access database can also be created this way, even if you don't have the actual software ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required