This week's book / license giveaways are in the JDBC and Relational Databases and Java in General forums.
We're giving away four copies each of PostGIS in Action and Java Advanced Topics Training and have the authors on-line!
See this thread and this one for details.
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