File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes jdbc using access Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "jdbc using access" Watch "jdbc using access" New topic

jdbc using access

Soumayajit Hazra

Joined: Nov 13, 2006
Posts: 8
I am connecting to access database using my java program.
When i do the same thing in oracle i got the name of tables using
"select * from tab" command. But what to do in access if i want to get the same result? Please help...
Prabhu Venkatachalam
Ranch Hand

Joined: Nov 16, 2005
Posts: 502

This is system table which oracle uses to store table names.Instead of using DB specific futures, JDBC supports DB independent way, Like finding database information use " DatabaseMetaData" interface. you can find databse version, name of the driver used to connect to DB, getting primary key of particular table etc.,

Prabhu Venkatachalam<br />SCJP 1.4,SCWCD 1.4<br />
I agree. Here's the link:
subject: jdbc using access
It's not a secret anymore!