Object Type Translator - trouble installing/configuring

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 Sun Jun 13 2004 - 09:23:31 CDT