aspose file tools*
The moose likes JDBC and the fly likes jdbc using access Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "jdbc using access" Watch "jdbc using access" New topic
Author

jdbc using access

Soumayajit Hazra
Greenhorn

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