안녕하세요? 여기에 질문 해보기는 처음이네요.
앞으로 뻔질나게 드나들게 될것 같습니다. 처음 뵙는 모든분들께 인사드립니다.
xml을 쓸 일이 생겨서 인포믹스 홈에서 아래의 예제를 다운받아
테스트 중입니다.
XML in Informix Internet Foundation.2000
Exercise/Demo
New Orleans Sales Kickoff 2000
Robert Burgess
Martin Siegenthaler
근데 설치중 에러가 발생하는데 도저히 원인을 알수가 없네요.
아래는 설치문서의 내용입니다.
This is a quick and dirty guide to setting up the XML demo.
I'm assuming :
- You have J/Foundation configured for java.
- You have the WebBlade 4.0
- You have a Java compiler.
- You have make
What you need todo : all files should be in the xml directory below.
- Copy the XML support files (xsl4j.jar, xslLotus.jar) into a
well known directory. I put mine in d:/classes.
- Modify your servers onconfig file JVPCLASSPATH setting
to includ the additional jar files xsl4j.jar and xslLotus.jar.
Mine looks like :
JVPCLASSPATH
D:\INFORMIX\extend\krakatoa\krakatoa_g.jar;D:\INFORMIX\extend\krakatoa\jdbc_g.jar;d:\classes\xml4j.jar;d:\classes\lotusxsl.jar
<=== 이부분은 리눅스에 맞게 /opt/informix/extend/krakatoa/ 로 수정했음.
- Modify the Makefile. Set the CLASSPATH and DB correctly.
- Build the XslTran.jar file
make XslTran.jar
- Modify the install.sql. Set the path to the XslTran.jar file
created in the previous step.
- Install the Java Udr.
make install <======== 현재 이부분에서 에러가 납니다. ㅠㅠ
- Run the simple test.
make simple
- Install the xsl pages.
make data
- Test the loaded xsl pages.
make smart
- Load the AppScript and data set
make apbpages
- Run APB and access the /Main.html
make install 부분에서 에러가 나서 진행이 안되고 있습니다.
에러 메세지 입니다.
[informix@vrnara xml]$ make install
dbaccess -e web install.sql
Database selected.
-- This installs the jar fine and the function in the database.
-- install the Java UDR jar file (customize the URL for your installation)
--
-- NOTE : you must modify the install_jar to use the correct path to
--- the jar file.
--
execute procedure install_jar(
"/tmp/iif_xml/xml/XslTran.jar", "XslTran_jar", 0);
9799: User Defined Routine (install_jar) VP context switch failed.
Error in line 9
Near character position 19
-- register the Java UDRs
drop function xslTranslate(lvarchar, lvarchar);
Routine dropped.
create function xslTranslate(lvarchar, lvarchar)
returns lvarchar
external name 'XslTran_jar:XslTran.translate( java.lang.String, java.lang.String)'
language java;
Routine created.
;
Database closed.
make: *** [install] Error 255
이렇게 에러메세지가 출력됩니다. 혹 이유를 아실만한 분 안계신가요???
아래는 에러 내용을 출력한 것입니다.
[informix@vrnara xml]$ finderr 9799
/opt/informix/bin/finderr: test: integer expression expected before -ge
-9799 User-defined routine virtual-processor context-switch failed.
Could not switch to or back from the needed VP during load, unload, or
execution. VP class could be wrong in the routine definition. The
following error messages appear in the log:
ERROR: Routine execution VP switch failed -- new VP error_string
ERROR: Routine execution VP switch failed -- old VP id = VP_ID
[informix@vrnara xml]$
[informix@vrnara xml]$ finderr 255
/opt/informix/bin/finderr: test: integer expression expected before -ge
-255 Not in transaction.
The database server cannot execute this COMMIT WORK or ROLLBACK WORK
statement because no BEGIN WORK was executed to start a transaction.
Because no transaction was started, you cannot end one. Any database
modifications that were made are now permanent; they cannot be rolled
back but do not need to be committed. Review the sequence of SQL
statements to see where the transaction should have started.
This error can occur when you open a cursor for update and have not started
a transaction yet.
[informix@vrnara xml]$
아래는 제가 수정한 onconfig 파일의 내용입니다.
################################################################################
###
##
# The following are default settings for enabling Java in the database.
# Replace all occurrences of /usr/informix with the value of $INFORMIXDIR.
#VPCLASS jvp,num=1 # Number of JVPs to start with
JVPJAVAHOME /opt/informix/extend/krakatoa/jre/
# JRE installation root directory
JVPHOME /opt/informix/extend/krakatoa # Krakatoa installation directory
JVPPROPFILE /opt/informix/extend/krakatoa/.jvpprops # JVP property file
JDKVERSION 1.2 # JDK version supported by this server
JVMTHREAD native # Java VM thread type (green or native)
# The path to the JRE libraries relative to JVPJAVAHOME
JVPJAVALIB /lib/i386/
# The JRE libraries to use for the Java VM
JVPJAVAVM hpi:jvm:java:net:math:zip:jpeg
# Classpath to use upon Java VM start-up (use _g version for debugging)
# JVPCLASSPATH /usr/informix/extend/krakatoa/krakatoa.jar:/usr/informix/extend/krakatoa/jdbc.jar
JVPCLASSPATH /opt/informix/extend/krakatoa/krakatoa_g.jar:/opt/informix/extend/krakatoa/jdbc_g.jar:/opt/informix/extend/kra
katoa/xml4j.jar:/opt/informix/extend/krakatoa/lotusxsl.jar
아래는 Makefile 중 수정한 부분입니다.
CLASSPATH = "/opt/informix/extend/krakatoa/xml4j.jar:/opt/informix/extend/krakatoa/lotusxsl.jar:/usr/jdk1.2.2/lib/classes.zip:
/opt/informix/extend/krakatoa/jdbc.jar:/opt/informix/extend/krakatoa/krakatoa.jar"
DB = web
아래는 install.sql 수정한 부분입니다.
execute procedure install_jar(
"/tmp/iif_xml/xml/XslTran.jar", "XslTran_jar", 0);
현재 이 부분에서 에러가 나는 것 같은데 허접한 저로선 이유를 알수가 없네요.ㅠㅠ
이 예제 readme파일은 윈도우에서의 설치법만 나와있는데 전 지금 리눅스에서
테스트 중입니다.
와우6.2, IIF921, webdata blade410, jdk122 입니다.
미치기 직전입니다. 혹 아시는 분 삽질의 방향이라도 좀 잡아주세요 -,.-;;;
끝까지 읽어주셔서 감사합니다.
|