Acceso a base de datos Oracle vía http
Estimados:
La presente pregunta va para los que sepan de Java y/o Oracle.
Mi empresa tiene un servidor RBDMS Oracle, al cual se accede mediante
navegadores.
Los que usan Win, no tienen problema. Se carga Java y el Oralcel
JInitiator 1.3.1_9 (jinit1319.exe).
Desde mi Debian, accedo a la pantalla de ingreso de la base, pero ahí se clava.
-----------
La máquina java reporta lo siguiente:
Java Plug-in 1.6.0_21
Usar versión JRE 1.6.0_21-b06 Java HotSpot(TM) 64-Bit Server VM
Directorio local del usuario = /home/usr129
cargar: clase oracle.forms.engine.Main no encontrada.
java.lang.ClassNotFoundException: oracle.forms.engine.Main
at sun.plugin2.applet.Applet2ClassLoader.findClass(Applet2ClassLoader.java:230)
at sun.plugin2.applet.Plugin2ClassLoader.loadClass0(Plugin2ClassLoader.java:249)
at sun.plugin2.applet.Plugin2ClassLoader.loadClass(Plugin2ClassLoader.java:179)
at sun.plugin2.applet.Plugin2ClassLoader.loadClass(Plugin2ClassLoader.java:160)
at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
at sun.plugin2.applet.Plugin2ClassLoader.loadCode(Plugin2ClassLoader.java:686)
at sun.plugin2.applet.Plugin2Manager.createApplet(Plugin2Manager.java:2990)
at sun.plugin2.applet.Plugin2Manager$AppletExecutionRunnable.run(Plugin2Manager.java:1481)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.net.ConnectException: Network is unreachable
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:529)
at sun.net.NetworkClient.doConnect(NetworkClient.java:161)
at sun.net.www.http.HttpClient.openServer(HttpClient.java:394)
at sun.net.www.http.HttpClient.openServer(HttpClient.java:529)
at sun.net.www.http.HttpClient.<init>(HttpClient.java:233)
at sun.net.www.http.HttpClient.New(HttpClient.java:306)
at sun.net.www.http.HttpClient.New(HttpClient.java:323)
at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(HttpURLConnection.java:860)
at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:801)
at sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java:726)
at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1049)
at java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:373)
at sun.plugin2.applet.Applet2ClassLoader.getBytes(Applet2ClassLoader.java:593)
at sun.plugin2.applet.Applet2ClassLoader.access$000(Applet2ClassLoader.java:52)
at sun.plugin2.applet.Applet2ClassLoader$1.run(Applet2ClassLoader.java:203)
at java.security.AccessController.doPrivileged(Native Method)
at sun.plugin2.applet.Applet2ClassLoader.findClass(Applet2ClassLoader.java:200)
... 8 more
Excepción: java.lang.ClassNotFoundException: oracle.forms.engine.Main
----------
El código fuente de la página es el siguiente:
<HTML>
<!-- FILE: basejpi.htm (Oracle Forms) -->
<!-- -->
<!-- This is the default base HTML file for running a form on the -->
<!-- web using the JDK Java Plugin. This is used for example when -->
<!-- running with Netscape on Unix. -->
<!-- -->
<!-- IMPORTANT NOTES: -->
<!-- Default values for all the variables which appear below -->
<!-- (enclosed in percent characters) are defined in the servlet -->
<!-- configuration file (formsweb.cfg). It is preferable to make -->
<!-- changes in that file where possible, rather than this one. -->
<!-- -->
<!-- This file will be REPLACED if you reinstall Oracle Forms, so -->
<!-- you are advised to create your own version if you want to make -->
<!-- any modifications. You should then set the baseHTMLjpi -->
<!-- parameter in the Forms Servlet configuration file (formsweb.cfg) -->
<!-- to point to your new file instead of this one. -->
<HEAD><TITLE>XXXXXXXXXXXXXXXXX</TITLE></HEAD>
<BODY >
<!-- Forms applet definition (start) -->
<OBJECT classid="clsid:8AD9C840-044E-11D1-B3E9-00805F499D93"
codebase="http://java.sun.com/products/plugin/1.3/jinstall-13-win32.cab#Version=1,3,0,0"
WIDTH="800"
HEIGHT="600"
HSPACE="0"
VSPACE="0">
<PARAM NAME="TYPE" VALUE="application/x-java-applet;version=1.3">
<PARAM NAME="CODEBASE" VALUE="/forms90/java">
<PARAM NAME="CODE" VALUE="oracle.forms.engine.Main" >
<PARAM NAME="ARCHIVE" VALUE="f90all.jar" >
<PARAM NAME="serverURL"
VALUE="/forms90/l90servlet?ifcfs=/forms90/f90servlet?form=RBDMS.fmx&config=rbdms">
<PARAM NAME="networkRetries" VALUE="0">
<PARAM NAME="serverArgs"
VALUE="module=RBDMS.fmx userid= sso_userid= debug=no
buffer_records=no debug_messages=no array=no query_only=no quiet=yes
render=no host= port= record= tracegroup= log= term=">
<PARAM NAME="separateFrame" VALUE="true">
<PARAM NAME="splashScreen" VALUE="">
<PARAM NAME="background" VALUE="">
<PARAM NAME="lookAndFeel" VALUE="Oracle">
<PARAM NAME="colorScheme" VALUE="teal">
<PARAM NAME="serverApp" VALUE="default">
<PARAM NAME="logo" VALUE="no">
<PARAM NAME="imageBase" VALUE="DocumentBase">
<PARAM NAME="formsMessageListener" VALUE="">
<PARAM NAME="recordFileName" VALUE="">
<COMMENT>
<EMBED SRC="" PLUGINSPAGE="http://java.sun.com/products/plugin/1.3/plugin-install.html"
TYPE="application/x-java-applet;version=1.3"
java_codebase="/forms90/java"
java_code="oracle.forms.engine.Main"
java_archive="f90all.jar"
WIDTH="800"
HEIGHT="600"
HSPACE="0"
VSPACE="0"
serverURL="/forms90/l90servlet?ifcfs=/forms90/f90servlet?form=RBDMS.fmx&config=rbdms"
networkRetries="0"
serverArgs="module=RBDMS.fmx userid= sso_userid= debug=no
buffer_records=no debug_messages=no array=no query_only=no quiet=yes
render=no host= port= record= tracegroup= log= term="
separateFrame="true"
splashScreen=""
background=""
lookAndFeel="Oracle"
colorScheme="teal"
serverApp="default"
logo="no"
imageBase="DocumentBase"
recordFileName=""
>
<NOEMBED>
</COMMENT>
</NOEMBED></EMBED>
</OBJECT>
<!-- Forms applet definition (end) -->
</BODY>
</HTML>
------------
De java, no entiendo ni una línea.
El acceso a esa maldita base, me obliga mantener una máquina virtual
con XP, para poder acceder a la maldita base de datos.
¿Alguna sugerencia?
Dejo constancia de haber googleado en castellano, ingles y algo de
alemán, probado todo lo que encontré y sin resultados.
En varios lados he visto de "engañar" a Iceweasel modificando el
archivo ~/.mozilla/firefox/6a335aap.default/pluginreg.dat, pero no he
tenido éxito, pues al reiniciar el navegador, sobre escribe mis
modificaciones.
Escucho sugerencias.
Muchas gracias
JAP
Reply to: