关于myeclipse中的DB Browser连接Oracle数据库的问题

我的myeclipse是6.5版, oracle是10.2.0.1的中文版.
   myeclipse启动是英文的,DB Browser死活连不上oracle,报两个错误(具体不记得了).后来看了如下文章,知道了原因。
---------------------------------------------------------------------------------------------------------------------------
Hi,
a quick update on this for all interested parties as I had to research into the very same problem and only found partial answers around.
I am not an Oracle representative so whatever I'm saying, you cannot blame Oracle for it, and you should check for yourself if in doubt.

This is a known bug for Oracle with 10.2.x (up to 10.2.0.1) drivers relating to mixing language and locales, e.g. en_DE or en_IT.
Normally you can set user.language and user.country or NLS_LANG with vmargs on the Eclipse command line, but these drivers will not be able to mix a language with a territory using a particular method, which seems to be the method mostly everybody uses today :-)
It is declared as fixed in 10.2.0.2, for en_DE at least according to the metalink db.
There is a patch for Oracle DBMS 10.2.0.2 on Windows available to supported customers, but it is not available as a public download as of today. I just checked and the 10.2.0.2 dist is available for public download for Linux; adventurers might want to try downloading the whole distro to extract the jdbc drivers. Check licenses carefully to understand if it's acceptable - I'm not going to do it so I didn't elaborate.
People with metalink access can monitor entry #4629654 (which is specific to en_DE) and related entries to stay updated.
Currently, the easiest workaround is downgrading to 10.1 drivers, unless you need 10.2 explicitly of course.

Generally speaking, if you routinely update your jdbc drivers only because they become available, well my advice is simply *change habit*, and update only if you need to do it for some specific reason. Bugs are frequently solved and re-introduced, unfortunately. This particular situation is not uncommon at all.

This said, I think MyEclipse should think about introducing support for setting language, locale and character sets option at the connection level for at least "major" databases, as this is a very common issue and for professional developers outside of USA, and it is very common to fight with mixed bags of these settings at the same time, even in the same project. It is inconvenient having to start a different instance of MyEclipse to work with different databases, considering the resources needed by MyEclipse to run smoothly, if the only way to set these parameters is on the command line.
I understand there is no standard way to approach setting this parameters programmatically at connection open time across databases, but we're sure the MyEclipse team can come out with a clever idea to work around this issue :-)

Keep up the good work!
Davide
-----------------------------------------------------------------------------------------------------------------------------

    原来是oracle jdbc driver(10.2.0.1)中的一个bug,不能混合使用连接的语言,我的oracle是中文版的,所以myeclipse的启动要用中文 (-Duser.language=en中的en改为zh)。用中文后,DB Browser可以正常使用了。
    有两个解决方法,一个是改用oracle jdbc driver(10.2.0.2),另一个是希望myeclipse中的DB Brower可以设置连接语言。

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值