Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Object Type Translator - trouble installing/configuring

Re: Object Type Translator - trouble installing/configuring

From: Alfie <nothere_at_nothere.com>
Date: Tue, 15 Jun 2004 13:18:04 +0100
Message-ID: <40cee8fd$0$20510$cc9e4d1f@news-text.dial.pipex.com>


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

"Alfie" <nothere_at_nothere.com> wrote in message news:40cda0c6$0$25318$cc9e4d1f_at_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_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 Tue Jun 15 2004 - 07:18:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US