Re: Object Type Translator - trouble installing/configuring

From: Chetan <a_at_b.com>
Date: Mon, 14 Jun 2004 12:31:57 +0530
Message-ID: <40CD4D65.9060305@b.com>

Did you do a custom installation? If so, check if sqlj got installed part of it. Looks like it didn't.

Workaround is to do a admin/client install and get all the required sqlj components.

-Chetan

Alfie wrote:
> Hi,
>
> I've got 10g and am trying to run the OTT in a windows environment agains
> the OCCI examples.
>
> I get this error:
>
>

>>Exception in thread "main" java.lang.NoClassDefFoundError:

>
> sqlj/framework/error/
>

>>ErrorLog
>>at oracle.ott.c.CMain.main(CMain.java:9)

>
>
> when I enter "ott" at the command prompt.
>
> I have researched the error and found the SQLJ FAQ here
>
> http://otn.oracle.com/tech/java/sqlj_jdbc/htdocs/faq.html
>
> states:
>

>>Most likely, your CLASSPATH is missing the SQLJ translator.zip file

>
>
> but my 10g instalation has no zip file, just a "runtime.jar" and I read
> here:
>
> http://otn.oracle.com/tech/java/sqlj_jdbc/index.html
>
> that
>

>>Starting with Oracle Database 10g, we are desupporting the SQLJ translator

>
>
> So I try to set up the environment thus:
>
> set ORACLE_HOME=d:\oracle10\product\10.0.1\Db_1
> set
> CLASSPATH=%ORACLE_HOME%\jdbc\lib\classes12.zip;%ORACLE_HOME%\sqlj\lib\runtim
> e12.jar;%ORACLE_HOME%\oc4j\sqlj\lib\translator.jar
>
> (and various combinations) with no success. I just get the same error when I
> run <ott> at the command line.
>
> This is my first encounter with OTT so I don't know how to install and
> confirm the installation is OK - I hope just entering <ott> and receiving
> the given error shows there is a problem with the install.
>
> Any help appreciated.
>
> TIA.
>
>
>
Received on Mon Jun 14 2004 - 02:01:57 CDT