This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
Well, you ask the java.sql.Connection for the database metadata object:
Then you ask the DatabaseMetaData for a list of tables:
Joined: Dec 30, 2003
Thanks, I got it. But why I got more than what I want. In my case, I have only one table -"Employees" in my Access database, but the system returns other objects which belong to Access. Do you have a clue for that? the output is: __________________________________ MSysACEs MSysModules MSysModules2 MSusObjects MSysQueries MSysRelationships Employees ______________________________________ only "Employees" is what I want. Thanks!
Judging from the names, MSysQueries and MSysRelationships in particular, I'd say they are system tables where Access does it's housekeeping. If you look at the documentation for DatabaseMetaData.getTables() you'll see that the result set it returns had a column called TABLE_TYPE which may help you weed out the unwanted tables.
"Shining Star" Welcome to Javaranch. We don't have too many rules around these parts, but we do have a Naming Policy. Please adjust your name accordingly. You can change your display name here Thanks! [ January 08, 2004: Message edited by: Gregg Bolinger ]
Future Klein Thanks for changing you name. However, you are still in violation of the policy. The policy states: Obviously fictitious names may be locked out. In order to continue using Javaranch, please adjust your display name appropriately. Thank You
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
subject: how to retrieve the table list in Access database through JDBC?