最好的Type 4 Oracle JDBC驱动程序是什么? [英] What's the best type 4 Oracle JDBC driver?

问题描述

什么是最好的Type 4 Oracle JDBC驱动程序?

What's the best type 4 Oracle JDBC driver?

我想要什么:

• 稳定，少量错误和快速修复
• 应该警告通常的JDBC陷阱(连接泄漏等)
• 必须支持CLOB

我的免费" Oracle Type 4驱动程序的主要问题是:

My main issues with the "free" Oracle Type 4 driver are:

• 我花了两周的时间来寻找CLOB支持代码中的游标泄漏(关闭流不会关闭底层游标)
• 从ResultSet中获取值时，必须按顺序处理它们(这样，在获取第4列之后就无法再获得第3列)
在获取第一行之后，结果集上的
• getMetaData()才起作用.
• 还有许多其他错误和缺陷，但我已经不记得了.

• I spent two weeks hunting down a cursor leak in the CLOB support code (closing the stream would not close the underlying cursor)
• When you fetch values from a ResultSet, you must process them in order (so you can't get column #3 anymore after fetching column #4)
• getMetaData() on a result set doesn't work until after fetching the first row.
• There were many other bugs and deficiencies but I don't remember them anymore.

因此，总的来说，每个座位花费​​1,000美元的司机比Oracle的免费"司机更便宜".关于该驱动程序的唯一好处是，我不必将数据库放入TNSNAMES中，并且可以使用单个驱动程序来访问Oracle 8、9和10.这就是我问的原因.

So all in all, a driver which costs me $1,000 per seat is more "cheap" than the "free" one from Oracle. The only good thing about the driver was that I didn't have to put databases into TNSNAMES and that I could use a single driver to access Oracle 8, 9 and 10. That's why I ask.

推荐答案

Oracle的4型JDBC驱动程序非常好.显然，与任何软件一样，这里有一些错误，但是它们通常都不错.而且价格(免费)无法超越.

Oracle's type 4 JDBC driver is pretty good. Obviously, as with any software, there are bugs, but they're generally not bad. And the price (free) can't be beat.

如果您正在寻找第三方商业驱动程序，那么我在此领域对DataDirect产品一直有很好的经验.通常，我不会费心获得4型JDBC驱动程序的许可，但是如果您有特别高端的要求，那可能是值得的.

If you are looking for third-party commercial drivers, I have always had good experiences with DataDirect products in this realm. I wouldn't normally bother licensing a type 4 JDBC driver, but if you have particularly high end requirements, it may be worthwhile.

这篇关于最好的Type 4 Oracle JDBC驱动程序是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！