I have a
JDBC question and would appreciate any answers or advice anyone
could give me. I've never used JDBC before so my question may be trivial
or obvious to someone.
I want to write a
Java application using JDBC to access a MS Access database.
The schema design is something like this example:
I have a table named "autoparts" which contains numerous, unique parts.
I also have a table name "autos" which has numerous references to the "autoparts" table. However, each "autoparts" entry may be used by numerous "autos", so I have a many-to-many relationship.
I wanted to keep an list/array/Vector of "autopart" entries in each "auto" record, but I don't see a "blob" type when defining a table in MS Access.
Can Access handle this datatype?
If not, is there another MS database which is installed with Win 2000 that will handle this? I don't have a lot of money to buy a high dollar database.
Also, is there a good JDBC book, ISBN # ???, that could show me the best way to write this?
Thanks....