Re: Object Type Translator - trouble installing/configuring

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_at_b.com> wrote in message news:40CD4D65.9060305_at_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 - 07:57:42 CDT