aspose file tools*
The moose likes JDBC and the fly likes Get table names from a database in access  Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Get table names from a database in access  " Watch "Get table names from a database in access  " New topic
Author

Get table names from a database in access

Aditya Torvi
Greenhorn

Joined: Aug 12, 2004
Posts: 3
The following code works with Oracle, Sybase, MySQL.

public void listTables()
{
Connection connection = getConnection();
String catalogName, /* this can be null for all catalogs */
schemaName, /* this can be null for all schemas */
tableType = "TABLE"; /* this can be null for "any" type */


if ((connection != null) && (tableType != null)) {
DatabaseMetaData dmd = connection.getMetaData();
ResultSet rs;


rs = dmd.getTables(catalogName, schemaName, null, new String[]{tableType });

while (rs.next()) {
System.out.println("Table name = " +
rs.getString("TABLE_NAME"));
}
rs.close();
}
}

But gives this exception for Access-
[Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented

Any suggestions?
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Your driver doesn't implement the getTables method. Change your driver. From the java.sql.DatabaseMetaData JavaDoc:


Different relational DBMSs often support different features, implement features in different ways, and use different data types


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Get table names from a database in access
 
Similar Threads
jdbc and ms access with stored query
STORING Resultset in String variable
DatabaseMetaData API
Getting Table Name
How to get list of tables in MS access database into my java program