Kbase P142955: Insufficient Memory error trying to create a trigger in sql-92
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/29/2010 |
|
Status: Verified
SYMPTOM(s):
Insufficient Memory error trying to create a trigger in sql-92
=== SQL Exception 1 ===
SQLState=HY000
ErrorCode=-210021
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Insufficient Memory. Memory allocation failed at 490 in /vobs_sql/sql/src/sqlsp/cxx/javac.cxx. Contact Progress Technical Support
FACT(s) (Environment):
UNIX
OpenEdge 10.1C
OpenEdge 10.1C03
CAUSE:
JDKHOME set to a Java JRE installation
FIX:
Adding SQL92 triggers requires Java compilation code.
JDKHOME needs to point to a Java JDK installation
Example for setting the correct environment on a machine where JDK 1.5 is installed on the directory /usr/java/jdk1.5 :
JDKHOME=/usr/java/jdk1.5; export JDKHOME
JREHOME=/usr/java/jdk1.5/jre; export JREHOME
sql_env
proserve demodb -S 4567
sqlexp demodb -S 4567 -infile trigger_create_query.sql