Yes, the jdbc-odbc bridge is not really intended for real use, and sucks pretty bad.
Without knowing why you are using access, it's hard to recommend a course of action - if you can use a different DB, by all means, do. Access is hands down the crappiest choice you could make. :) If you are using it because you have to (it's tied to another system that uses access directly), then you may need to look for a commercial driver. The jdbc-odbc bridge will not work. If you are creating a new system, then look at postgresql, mysql, or derby. Larry On Sat, Dec 12, 2009 at 9:32 AM, Monky <promil...@yahoo.de> wrote: > > 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 > > --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org
