[opencms-dev] Poblem to install OpenCMS with Oracle 9i

[Sunny L. S. Chan]

Hi everyone,

I have been trying to get opencms working with oracle 9i.
My setup is as follows:

MS Windows 2000 Professional,
tomcat 4.0.4
Solaris 8,  oracle9i [release 2] Enterprise
openCMS 4.7.7
JDK 1.4.0_01

I have copied oracle 9i[release 2]'s classes12.zip/jar to ocset/lib,
opencms/lib directory

I got this error when I submit the database details to openCMS install
(http://localhost/opencms/ocsetup/create_database.ocjsp):
via the genericsql method:
-----------------------------------------Start of Error
Description -------------------------------------java.lang.ArrayIndexOutOfBo
undsException
at oracle.security.o3logon.C1.r(C1)
at oracle.security.o3logon.C1.l(C1)
at oracle.security.o3logon.C0.c(C0)
at
oracle.security.o3logon.O3LoginClientHelper.getEPasswd(O3LoginClientHelper)
at oracle.jdbc.ttc7.O3log.(O3log.java:290)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:251)
at oracle.jdbc.driver.OracleConnection.(OracleConnection.java:252)
at
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:365)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.opencms.boot.CmsSetupDb.setConnection(CmsSetupDb.java:23)
at
org.apache.jsp.create_0005fdatabase$ocjsp._jspService(create_0005fdatabase$o
cjsp.java:158)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
.    ..----------------------------------------- End of Error
Description -------------------------------------If I install via the oci8
resource broker, the install
(http://localhost/opencms/ocsetup/create_database.ocjsp) failed with this
message:-----------------------------------------Start of Error
Description -------------------------------------javax.servlet.ServletExcept
ion: no ocijdbc8 in java.library.path
at
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp
l.java:471)
at
org.apache.jsp.create_0005fdatabase$ocjsp._jspService(create_0005fdatabase$o
cjsp.java:313)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.ja
va:201)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:381)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:473)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application
FilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:243)
.    ..----------------------------------------- End of Error
Description -------------------------------------

Then I read from newsgroups and found out the [%oracle]/bin, for oracle 9i,
there is no file such as ocijdbc8.dll, but a file ocijdbc9.dll
later I make a copy ocijdbc9.dll and renamed it to ocijdbc8.dll and try the
install, it failed with a different error message.

Has anyone tried to get openCMS working with oracle9i[9.0.2]?

if so, any tips u can get me going to install openCMS with oracle9i ?

I openCMS install succesfully on oracle8i[8.1.7] -  but I cannot get openCMS
working in oracle9i~

Thank you very much !

Sunny