Kbase P132029: SQL UPDATE and INSERT statements fail to execute
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/06/2009 |
|
Status: Verified
SYMPTOM(s):
SQL UPDATE and INSERT statements fail to execute
Queries issued from SQL Explorer
UPDATE and INSERT statements produce the following error:
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-210022
[JDBC Progress Driver]:Failed during dynamic load of Java dynamic
library. Reason = [126]The specified module could not be found.
[jvm].
SELECT statements succeed
Database contains SQL triggers
sql_env.bat run from Proenv
Database started with Procontrol
FACT(s) (Environment):
Windows
Progress 9.1E
CAUSE:
The SQL triggers were developed using SQL Explorer in the Proenv command window. The environment variables set by sql_env.bat in Proenv were only set for that Proenv session. They had not been set to the same values when the database was later started using Procontrol; therefore the environment variables in the Windows registry had different values when the triggers were invoked. Specifically, the registry PATH did not include the path to jvm.dll. This is the Java virtual machine, which is necessary for running SQL triggers and stored procedures.
FIX:
Make sure that the PATH variable in the environment where the database is started includes the path to jvm.dll.