something wrong with the installation of J cartridge

There is something wrong with the installation of JCHEM3.1.5. Could you help me?


The following is what I have:


Apache-tomcat-5.5.17


Oracle database 10g express edition


JDK1.5.0_06


Jchem3.1.5


Windows2000





The initial steps gone very smoothly, but when I tried to install J cartridge, something was wrong.


First I couldn’t understand the step about “User credentials and privileges for the JDBC connection”


-----------


Beginning with JChem version 3.0.12 the recommended way to achieve this is for users to call the PL/SQL procedure jchem_core_pkg.use_password(password VARCHAR2) with their password as the parameter at the beginning of each database session.


-------------


It’s new and difficult for me to use PL/SQL, so I don’t know how to use “call”. Would you give me a detailed command with examples?





Second, In the step of Installing JChem Data Cartridge on Oracle


------------------


1.Make sure that your Oracle database is JVM-enabled and properly configured for use of Java Stored Procedures. To do so, follow the instructions in the sections Initializing a Java-Enabled Database and Configuring Oracle JVM in the chapter Java Installation and Configuration of Oracle's Java Developer's Guide.


----------------------


What I use is Oracle database 10g express edition. The installation procedure is very easy.


So I don’t know if the default parameters have been set correctly. If not, what should I do?


---------------------


4 grant connect and resolve permissions (java.net.SocketPermission) to the cartridge owner. You can do this as follows: assuming that


• Tomcat is located on the same host as the Oracle RDBMS,


• Tomcat is configured to accept HTTP requests on the 8080 port and


• the cartridge owner is called JCHEM


the PL/SQL command to do this is:


call dbms_java.grant_permission( 'JCHEM', 'SYS:java.net.SocketPermission', '127.0.0.1:8080', 'connect,resolve' )


-------------------------


the following command was input:


call dbms_java.grant_permission ( 'mary', 'SYS:java.net.SocketPermission', '127.0.0.1:9090', 'connect,resolve' )


tomcat is configured to accept http on the 9090 port


the user is mary





the result shows “invalid”





However I continue to install the next steps.


Go to the directory of jchem\cartridge, input:


install.bat user/passwd@XE http://localhost:9090/jchemstreams/





the installation failed.


And it even couldn’t find loadjava in the <oracle_home>\bin directory, I just found loadpsp.exe.





There’re so many problems in the installation, Could you give me a very detailed WHOLE installation procedure with examples?


My email address:[email protected]





Look forward to your reply!


With many thanks,





Regards


mary

Hi,





It appears that Oracle Express Edition does not support Java stored procedures. (I say "it appears", because I could not find a proper/official feature comparison between Oracle XE and other Oracle editions. However, certain Java-related program files and directories are clearly missing from the XE installation which is a strong indication that you cannot use Java stored procedures with Oracle XE.)





JChem Cartridge needs support for both Java stored procedures and extensible indexes on the Oracle end. The most cost-effective Oracle edition which can be used with JChem Cartridge is, I believe, Oracle Standard Edition One.





Regards,


Peter

We have found feature comparisons:





http://www.oracle.com/technology/products/database/oracle10g/pdf/twp_general_10gdb_product_family.pdf


http://www.oracle.com/database/product_editions.html





They confirm (indirectly) that JChem Cartridge will not work with Oracle XE.





Regards,


Peter

hi, Peter





Thanks a lot! :-)





mary