You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by Monky <pr...@yahoo.de> on 2009/12/12 17:32:18 UTC
Ibator and Microsoft Access
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
Re: Ibator and Microsoft Access
Posted by Larry Meadors <la...@gmail.com>.
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 <pr...@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