ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Larry Meadors <larry.mead...@gmail.com>
Subject Re: Ibator and Microsoft Access
Date Sat, 12 Dec 2009 18:44:06 GMT
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 <promiller@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-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>
>

---------------------------------------------------------------------
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