Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

jdbc using access

 
Soumayajit Hazra
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 502
Java jQuery Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.,
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic