Re: Help : Download loadjava

prateek wrote:
> Hi,
> I am in the process of creating my first Java SQL procedure, compiling
> and uploading using loadjava utility. I have a Oracle 10g db but I am
> trying to load the class files from a different client machine. I have
> tried searching for "loadjava" download but unable to find it
> successfully.
>
> 1. Can someone please direct me to where I can download loadjava from.
> 2. Also, 10g uses loadjava or do I need to use someother program.
> 3. Can loadjava connect to my remote server or it needs a local db
> installation?
>
> Thanks in advance,
> Prateek

1. loadjava and dropjava utilities are part of Oracle Client software (but not Instant Client!), installed when Oracle Java Utilties are selected for installation (the default), so if you have it installed on your client machine, you already have them. Otherwise, you need to use Oracle Client CD or download it from Oracle TechNet and install Oracle Java Utilities explicitly. Alternatively, you can upload your Java classes to the db host and use DBMS_JAVA.LOADJAVA() interface to load them from the db host file system. See the package documentation in Java Developer's Guide for your Oracle release. Yet another alternative is to compile the Java source code right in the database using CREATE JAVA SOURCE command.
2. Yes, 10g uses these utilities. Future releases probably will, too.
3. Yes, external loadjava/dropjava utilities can connect and load/drop Java to/from remote database.

Hth,

    Vladimir M. Zakharychev
    N-Networks, makers of Dynamic PSP(tm)     http://www.dynamicpsp.com Received on Fri Jan 05 2007 - 03:23:42 CST