aspose file tools*
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 Spring in Action this week in the Spring 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
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30762
    
156

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
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30762
    
156

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