find all tables used in a hibernate/jdbc project? - 未名空间MITBBS历史存档

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

Redian新闻

>未名空间

>Java - 爪哇娇娃

find all tables used in a hibernate/jdbc project?

find all tables used in a hibernate/jdbc project?# Java - 爪哇娇娃

c*n2011-11-30 08:11

1 楼

I would need to replicate all the tables used in my project to another DB,
which has less background load,
the existing project uses a combination of JDBC and hibernate, with
hibernate being the majority.
I guess I COULD scrape hibernate query logs and find the tables accessed,
but that presents problems since in the test or production, the test data
may omit some access patterns.
is there some code analysis tool to generate all the tables accessed by a
hibernate project?

e*t2011-11-30 08:11

2 楼

why not just export and import your db schema?

【在 c******n 的大作中提到】

: I would need to replicate all the tables used in my project to another DB,
: which has less background load,
: the existing project uses a combination of JDBC and hibernate, with
: hibernate being the majority.
: I guess I COULD scrape hibernate query logs and find the tables accessed,
: but that presents problems since in the test or production, the test data
: may omit some access patterns.
: is there some code analysis tool to generate all the tables accessed by a
: hibernate project?

c*n2011-11-30 08:11

3 楼

for example my DB has 1000 tables,
but my project only uses 100,
theoretically I only need to replicate those 100 tables to the new DB,
which takes much less load on both the new and old db than replicating all
the 1000

【在 e*****t 的大作中提到】

: why not just export and import your db schema?

g*g2011-11-30 08:11

4 楼

Practically replicating DB online doesn't sound a good idea, as you'll
lose some data on the go.

【在 c******n 的大作中提到】

: for example my DB has 1000 tables,
: but my project only uses 100,
: theoretically I only need to replicate those 100 tables to the new DB,
: which takes much less load on both the new and old db than replicating all
: the 1000

c*n2011-11-30 08:11

5 楼

?
oracle db provides replication natively, it's very common.

【在 g*****g 的大作中提到】

: Practically replicating DB online doesn't sound a good idea, as you'll
: lose some data on the go.

r*s2011-11-30 08:11

6 楼

tho I don't like the idea to replicate db in this way,
this is how you can achieve what you want:
Write an interceptor that extends EmptyInterceptor,
overrides all the cases
onLoad/onSave/onDelete/...
and save the table/class names.
Register it as hibernate.ejb.interceptor.

【在 c******n 的大作中提到】

c*n2011-11-30 08:11

7 楼

cool thanks

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

: tho I don't like the idea to replicate db in this way,
: this is how you can achieve what you want:
: Write an interceptor that extends EmptyInterceptor,
: overrides all the cases
: onLoad/onSave/onDelete/...
: and save the table/class names.
: Register it as hibernate.ejb.interceptor.