Which POJO generator is better? - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Java - 爪哇娇娃

Which POJO generator is better?

Which POJO generator is better?# Java - 爪哇娇娃

m*o2012-01-30 08:01

1 楼

All,
I need to modify an old java project to use a new MySQL database. It sounds
simple enough at first, then I found out that the project is currently using
DB2 with all queries hard coded with table and column names. The new
database has different table and column names from the DB2 one. There are
also times when information in one table in DB2 are now in separate tables
in MySQL, or vice versa.
I know that there are actually multiple java projects that are in the same
boat - switching from that old DB2 database to the new MySQL one - so I'm
thinking of creating a data source project that offers all POJO classes for
the MySQL database so it can be used by all the java projects that will need
to be changed in near future.
Any thoughts about the approach? If a separate data source project sounds
like the right choice, which pojo generator is better to use in your
experience?
Big thanks for any input.

r*s2012-01-30 08:01

2 楼

didn't understand what you want: why is it about db migration?
for creating pojos i've used hiternate tools integrated with
eclipse, it's free.
there might be other non-free tools for reverse engineer
db schemas.

sounds
using
for

【在 m******o 的大作中提到】

: All,
: I need to modify an old java project to use a new MySQL database. It sounds
: simple enough at first, then I found out that the project is currently using
: DB2 with all queries hard coded with table and column names. The new
: database has different table and column names from the DB2 one. There are
: also times when information in one table in DB2 are now in separate tables
: in MySQL, or vice versa.
: I know that there are actually multiple java projects that are in the same
: boat - switching from that old DB2 database to the new MySQL one - so I'm
: thinking of creating a data source project that offers all POJO classes for

m*o2012-01-30 08:01

3 楼

It is because the DB2 database is going to be out of the picture permanently
, but the java program will stay and the only way for the java program to
get the needed data is this MySQL database. But, the two databases have
totally different schemas, not only every single table and every column has
different names, but also the number of tables and columns are different too
. (Don't ask me why because that's a long story and irrelevant to what I
have to achieve)
Thanks for the reply. I'm thinking of hibernate's pojo generator too.

【在 r*****s 的大作中提到】

: didn't understand what you want: why is it about db migration?
: for creating pojos i've used hiternate tools integrated with
: eclipse, it's free.
: there might be other non-free tools for reverse engineer
: db schemas.
:
: sounds
: using
: for

r*s2012-01-30 08:01

4 楼

then if your mysql dba wouldn't conform to db2's schema,
java devs have to develop some kind of mapping -- still
very bad -- maybe mapping first, and then based on unit-
tests, you will start to replace java entities one by one,
without affecting the impl above.

permanently
has
too

【在 m******o 的大作中提到】

: It is because the DB2 database is going to be out of the picture permanently
: , but the java program will stay and the only way for the java program to
: get the needed data is this MySQL database. But, the two databases have
: totally different schemas, not only every single table and every column has
: different names, but also the number of tables and columns are different too
: . (Don't ask me why because that's a long story and irrelevant to what I
: have to achieve)
: Thanks for the reply. I'm thinking of hibernate's pojo generator too.