Little hitch trying to use the JDBC tool

[Femi Alla]

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:

TableGen Database JavaBean Generator v1.6
-----------------------------------------
Database version : 04.00.0000
Driver Name : JDBC-ODBC Bridge (odbcjt32.dll)
Driver Version : 2.1
Classes being created for the following tables...
Customers
Generating container : Customers
Error whilst getting keys for Customers
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Driver does not support
this function
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Driver does not support
this function
        at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6106)
        at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6263)
        at sun.jdbc.odbc.JdbcOdbc.SQLForeignKeys(JdbcOdbc.java:2727)
        at sun.jdbc.odbc.JdbcOdbcDatabaseMetaData.getImportedKeys(JdbcOdbcDataba
seMetaData.java:3058)
        at TableGen.getTableImportedKeys(TableGen.java:1029)
        at TableGen.generateContainers(TableGen.java:351)
        at TableGen.main(TableGen.java:86)

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

    ResultSet r = metaData.getImportedKeys( catalog, schema, tableName ) ;
    bMore= r.next();
    while ( bMore )
    {
      sFKName =  r.getString( 12);
      sFKTable= r.getString(7);
      sPKTable= r.getString(3);
      sequence = r.getShort(9);
      oldSequence =0;
      f = new FKDefinition( sPKTable, sFKTable, sFKName );
      while ( bMore && ( sequence > oldSequence ))
      {
        sFKColumn = r.getString(8);
        sPKColumn = r.getString(4);
        f.addField( sFKColumn, sPKColumn );
        oldSequence = sequence;
        bMore= r.next();
        if (bMore)
          sequence = r.getShort(9);
      }
      //foreignKeyData.add( f );
      foreignKeyData.addElement( f );
    }
    r.close();

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.

[Jeanne Boyarsky]

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.

[Femi Alla]

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]

The tool looks interesting. If I had to do that sort of thing, I would probably use JDO though.