Object Type Translator - trouble installing/configuring

[Bert Zuber]

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/ErrorLogat 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

thatStarting 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.

[scott]

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/ErrorLogat 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 thatStarting 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.

[Bert Zuber]

No, I didn't do a custom installation, I just did the default 10g 10.1.0.2.0
Enterprise Edition (826mb) one.

So do I still need SQLJ translator.zip then, even though the docs say that
from 10g the SQLJ translator will not be supported?

If so, which option from the custom install menu will get it installed?

Thanks




"Chetan" <a@b.com> wrote in message news: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/ErrorLogat 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 thatStarting 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.

[Bert Zuber]

found an old sqlj download on the oracle site, installed it and now works.


"Alfie" <nothere@nothere.com> wrote in message
news:40cda0c6$0$25318$cc9e4d1f@news-text.dial.pipex.com... No, I didn't do a custom installation, I just did the default 10g
10.1.0.2.0 Enterprise Edition (826mb) one. So do I still need SQLJ translator.zip then, even though the docs say that from 10g the SQLJ translator will not be supported? If so, which option from the custom install menu will get it installed? Thanks "Chetan" <a@b.com> wrote in message news: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.