SQLJ.REFRESH_CLASSES（）....

本文介绍了SQLJ.REFRESH_CLASSES（）....的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 Win XP上的UDB PE 8.1。 好​​吧，这个功能今天引起了很多悲痛。我的存储过程 是java存储过程，所有FENCED都直接放在 \sqllib \ function目录下（不内置到JAR文件中）。 虽然手册声明SQLJ.REFRESH_CLASSES（）只刷新内置于JAR文件中的 例程，但我已经成功刷新了我的 JDBC存储具有此功能的程序。 几天前，我开始开发SQLJ存储过程和 我花了很长时间才弄清楚所有的我试图运行SQLJ存储过程时收到的奇怪错误 （参数不兼容等消息）是因为 SQLJ .REFRESH_CLASSES（）没有在 \sqllib \ function中刷新我的SQLJ存储过程。我每次更改并重新编译存储过程时都必须停止并启动数据库管理器 。这解决了 问题。 在dbm config中保持加密状态。文件设置为YES（默认）。 无论如何，所以我的问题是：列表中有人知道 处理SQLJ.REFRESH_CLASSES的内容（）是？为什么它适用于JDBC 过程而不是SQLJ过程。实际上，按照手册的说法，对于JAR 文件中内置的存储过程，它只能* * 。由于我的JDBC存储过程没有内置到JAR文件中，因此即使使用JDBC，也不应该使用SQLJ.REFRESH_CLASSES（）。 您有什么经验这方面。 TIA Raquel。 UDB PE 8.1 on Win XP. ok, this function caused a lot of grief today. My stored proceduresare java stored procedures, all FENCED and directly placed in\sqllib\function directory (not built into JAR files). While the manuals state that SQLJ.REFRESH_CLASSES() only refreshes theroutines built into JAR files, I have been successfully refreshing myJDBC stored procedures with this function. A couple of days back, I started developing SQLJ stored procedures andit took me a long while to figure out that all the strange errors Iwas receiving while attempting to run the SQLJ stored procedures(messages like arguments not being compatible etc.) were becauseSQLJ.REFRESH_CLASSES() was NOT refreshing my SQLJ stored procedures in\sqllib\function. I had to stop and start the database managereverytime I changed and recompiled a stored procedure. This solved theproblem. KEEPFENCED in dbm config. file is set to YES (default). Anyway, so my question is: Is someone on the list aware of what thedeal with SQLJ.REFRESH_CLASSES() is? Why does it work with JDBCprocedures and not with SQLJ procedures. Actually, per the manual, itshould work *only* for stored procedures that are built into JARfiles. Since my JDBC stored procedures are not built into JAR files,SQLJ.REFRESH_CLASSES() should not have worked even with JDBC. What are your experiences in this regard. TIARaquel.推荐答案 我不太清楚DB2内部结构是否足以说明为什么它可以为你的案例中的一些 工作，但是： 如果手册没有*不*声明它适用于非jar文件，比你 不能依赖你的测试。你很幸运，它首先与JDBC 课程一起工作。 - Knut Stolze 信息集成 IBM德国/耶拿大学 I don''t know the DB2 internals well enough to say why it did work for someof your cases, but: If the manual does *not* state that it works for non-jar files, than youcan''t rely on your tests. You were just lucky that it did work with JDBCclasses in the first place. --Knut StolzeInformation IntegrationIBM Germany / University of Jena 这篇关于SQLJ.REFRESH_CLASSES（）....的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！