ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Monky <promil...@yahoo.de>
Subject Ibator and Microsoft Access
Date Sat, 12 Dec 2009 16:32:18 GMT

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-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org


Mime
View raw message