Sybase SQLAnywhere jConnect 例程？
我有一个数据库，它是封闭系统的一部分，系统的最终用户希望我使用 Sybase SQL Anywhere 数据库中包含的数据编写一些报告。系统不提供他们正在寻找的报告，但可以通过连接到此 ASA 数据库来访问数据。
该软件的供应商可能希望我不更新数据库，并且我基本上是只读的，因为我只是在做一些报告。一切都很好，密封没有损坏，保修仍然完好无损，等等。
我的主要问题是我使用 jConnect 来读取数据库，而 jConnect 需要将一些“jConnect 例程”安装到数据库中。我发现只需执行“Alter Database Upgrade JConnect On”即可实现此目的，但我只是不完全了解其作用以及是否存在与之相关的任何风险。
所以，我的问题是有人确切知道 jConnect 例程是什么以及它们如何使用吗？将这些添加到数据库中是否存在风险？我应该担心这个吗？
I have a database which is part of a closed system and the end-user of the system would like me to write some reports using the data contains in a Sybase SQL Anywhere Database. The system doesn't provide the reports that they are looking for, but access to the data is available by connecting to this ASA database.
The vendor of the software would likely prefer I not update the database and I am basically read-only as I am just doing some reporting. All is good, seal is not broken, warranty still intact, etc,etc..
My main problem is that I am using jConnect in order to read from the database, and jConnect requires some "jConnect Routines" to be installed into the database. I've found that I can make this happen by just doing an "Alter Database Upgrade JConnect On", but I just don't fully understand what this does and if there is any risks associated with it.
So, my question is does anyone know exactly what jConnect routines are and how are they used? Is there any risk adding these to a database? Should I be worried about this?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
如果供应商希望您使用 jConnect 编写报告，他们必须允许安装 JConnect 表。
这些是非常安全的，我工作的 DBA 团队理所当然地安装了这些，并且我们在生产中运行巨大的数据库，没有任何影响。
您可以使用一个名为 jTDS 的替代驱动程序。它是开源的并支持MS SQL Server 和Sybase。我不确定他们是否需要 JConnect 表。
我认为额外的桌子在当今时代有点不合时宜。
If the vendor wants you to write reports using jConnect they will have to allow the installation of the JConnect tables.
These are quite safe, where I work the DBA team install these as a matter of course and we run huge databases in production with no impact.
There is an alternative driver that you could use called jTDS. Its open source and supports MS SQL Server and Sybase. I'm not sure if they require the JConnect tables or not.
I think that the additional tables are a bit of anachronism in this day and age.
查看 ASA 10 文档，还有另一个驱动程序：iAnywhere JDBC 驱动程序，它似乎正在通过 ODBC 驱动程序，因此可能不需要更改数据库。
另一方面，安装“jConnect 系统对象”是通过运行脚本
scrits/jcatalog.sql来完成的...如果您想让 DBA 放心，您可以向他们展示。它创建一些过程、表、变量。对该脚本的需求可能来自于 jConnect 与 ASE (Sybase) 和 iAnywhere 数据库通信的事实，因此它需要在数据库中安装兼容层...
Looking at ASA 10 docs, there is another driver: the iAnywhere JDBC driver which seems to be going through the ODBC driver, and as such, probably will not require an alteration of the database.
On the other hand, installing the "jConnect system objects" is done by running the script
scrits/jcatalog.sql... You can show it the DBAs, if you want to reassure them. It creates some procedures, tables, variables.The need for this script probably comes from the fact that jConnect talks to both ASE (Sybase) and iAnywhere databases, so it needs a compatibility layer installed in the database...