Hello, I am having problems using Ibatis/Ibator (ibatis-2.3.4.726 and the latest ibator as eclipse plugin installed via http://ibatis.apache.org/tools/ibator) with a connection to Microsoft Access. When I use the Ibator eclipse Plugin to "Generate iBatis Artifacts" many things get generated properly but I get the warnings: "Generation Warnings Occured Cannot obtain primary key information from the database, generated objects may be incomplete" The second line appears once for every table.
I use the standard driver: Driver: sun.jdbc.odbc.JdbcOdbcDriver URL: jdbc:odbc:DRIVER={Microsoft Access Driver (*.mdb)};DBQ=[ABSOLUTE_PATH_TO_MY_DB_FILE];DriverID=22 I guess the sun JDBC-ODBC-Bridge does not fully support table meta data for Mircosoft Access. Am I supposing correct? Is there another (free) driver that could be used? Is there a way to tell iBator about primary keys manually? (Something like: every table has a "PKEY" column that is a integer auto increment primary key field) Any help appretiates. Regards, Sebastian -- View this message in context: http://old.nabble.com/Ibator-and-Microsoft-Access-tp26758969p26758969.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org