• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how to get primary key from MSACESS database using jdbc driver

 
amar senapati
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i have problem during getting the primary key column name from the MSAcess database with the jdbcdriver using the method getPrimaryColumn() with the database metadata...
i am able to get the column names and everything regarding the columns and tables...
when i used this method the error shows that this driver is not compatible with the getPrimaaryColumn() method.
please help me
with regards
amar
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
use a new driver that supports this feature! Or better yet, upgrade your database!
I don't think MSAccess has any system tables available for querying the information so I think you are S.O.L.
Jamie
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic