Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
The moose likes JDBC and the fly likes Little hitch trying to use the JDBC tool Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Little hitch trying to use the JDBC tool" Watch "Little hitch trying to use the JDBC tool" New topic
Author

Little hitch trying to use the JDBC tool

Femi Alla
Ranch Hand

Joined: Jul 05, 2002
Posts: 79
Hi all,
I tried to use the TableGen tool I mentioned in the previous post with a database I had created using Microsoft Access (This is because there's this application I'm currently developing and the end user wants it to work with MS Access), but ran into a problem. The output when run shown below:

Here's the portion of the code I figured generated all them Exceptions.

Question [1]
I'm begining to think that it may be that MS Access doesn't support the use of foreign keys. Is my diagnosis right?
Question [2]
On the web page for TableGen, it was tested on MySQL,Oracle, DB2, Prostgressql and Sybase. All the big RDBMS.... Someone who should know once told me MS Access is an RDBMS too (and I've believed this all these while), is this true? I mean if it doesn't support the use of foriegn keys, then how can it be relational?
Please let me know what you think.
Thanks.


SCJP
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30361
    
150

Femi,
Access is definitely a relational database. It does support foreign keys. Apparently, the driver doesn't support the metadata methods you are calling though.
I'm linking to your other thread in case someone wants to find it later.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Femi Alla
Ranch Hand

Joined: Jul 05, 2002
Posts: 79
Thanks Jeanne, for that answer.
The instructions page of this tool warn against using Drivers that don't support metaData... You are right.
What do you think of the tool by the way?
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30361
    
150

The tool looks interesting. If I had to do that sort of thing, I would probably use JDO though.
 
wood burning stoves
 
subject: Little hitch trying to use the JDBC tool