jQuery in Action, 3rd edition
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 />prabhu.venkatachalam@gmail.com
I agree. Here's the link: http://aspose.com/file-tools
subject: jdbc using access
It's not a secret anymore!