SchemaUpdate 如何让它正确找schema?

最新推荐文章于 2024-06-14 15:14:38 发布

最新推荐文章于 2024-06-14 15:14:38 发布 · 698 阅读

文章标签：

#Oracle #Hibernate #Ant #XP #PHP

Programming 专栏收录该内容

47 篇文章

订阅专栏

本文记录了在Oracle9i中使用Hibernate进行SchemaUpdate时遇到的问题。具体表现为，当数据库实例中有多个用户（如CS和TEST）且这些用户下存在同名表时，SchemaUpdate会错误地匹配到其他用户的表，导致表结构更新混乱。

DB:oracle 9i
在同一个数据库实例里面有两个用户：CS 和TEST ，为了测试两个用户下面建了很多同名的表，比如cs.card和test.card表。
我用test用户连接db调用SchemaUpdate 发现竟然去找的cs下面的表，然后更新表结构就更是不知道更新到哪个schema去了。后面发现可以设置hibernate.default_schema=test，但是去匹配的表还是 cs下面的表，而去更新的确实test下面的表，真晕。
ant结果如下：
[quote]
[schemaupdate] 信息: table found: CS.CARD
[schemaupdate] 2007-3-30 13:32:12 org.hibernate.tool.hbm2ddl.TableMetadata <init>
[schemaupdate] 信息: columns: [times_y, distrustful_times, card_limit, owe_amount, id, card_number, monthly_pay, id_type, customer_id, correct_percent_hy, limit_use_pecent_y, last_adjust_date, record_date, amount_y, daily_balance_y, open_date, card_class, distrustful_amount, owe_times, correct_amount_y, correct_percent_y, times_hy, customr_limit, amount_hy, correct_amount_hy, limit_use_pecent_hy, state, daily_balance_hy]
...
[schemaupdate] alter table TEST.CARD add ACCOUNT_LIMIT double precision default 0 not null
[/quote]
事实上TEST.CARD 表里面ACCOUNT_LIMIT 已经存在，CS.CARD里面确实还没有ACCOUNT_LIMIT

问题参考：http://forum.hibernate.org/viewtopic.php?t=972447&sid=a5e67497d46c525eaf1e766f64062fbb
[quote]

I'm trying to create a schema upgrade script via HBM2DDL and I'm running into an anomaly. When the tool looks up a table in the Oracle catalog, it doesn't specify the "owner" or "schema" name (the user id that I specified in the JDBC connection parms). It finds the first table with a matching name and creates SQL Alter Table stmts accordingly. Unfortunately, the table names as specified in my HBM files occur many times within my Oracle instance, under many different User IDs. Sometimes it finds the correct table but most times it encounters the wrong table.

Is there a parameter I can specify that would limit the tool to finding only tables owned by a specific User ?

I'm using the tool from within an ANT target on Widows XP.
[/quote]