Re: Help with Oracle SDOAPI

Hi Brian

Thanks for your help. can you please tell me how to set CLASSPATH and what will be the javac command to compile the program. I am trying to compile the SampleNewToSDO example given on the Oracle Technet.

Thanks
Sunil

Brian Peasland <dba_at_remove_spam.peasland.com> wrote in message news:<3F0B2EC0.79459171_at_remove_spam.peasland.com>...
> Are you sure that you have your CLASSPATH set correctly? Make sure your
> Oracle JDBC drivers are found in your CLASSPATH and re-compile your
> program.
>
> HTH,
> Brian
>
> Sunil wrote:
> >
> > I am a novice user to Oracle 9.2 and am trying to use the SDOAPI
> > library to convert a Shapefile to Oracle table. When I compile the
> > Samples files I get the following error:
> >
> > SampleShapefileToSDO.java:7: cannot resolve symbol
> > symbol : class STRUCT
> > location: package sql
> > import oracle.sql.STRUCT;
> > ^
> > SampleShapefileToSDO.java:8: package oracle.jdbc.driver does not exist
> > import oracle.jdbc.driver.*;
> > ^
> > SampleShapefileToSDO.java:49: cannot resolve symbol
> > symbol : class OracleDriver
> > location: class sample.SampleShapefileToSDO
> > DriverManager.registerDriver(new OracleDriver());
> > ^
> > SampleShapefileToSDO.java:72: cannot resolve symbol
> > symbol : class STRUCT
> > location: class sample.SampleShapefileToSDO
> > null, STRUCT.class, null, conn);
> > ^
> > SampleShapefileToSDO.java:71: cannot access
> > oracle.jdbc.OracleConnection
> > file oracle\jdbc\OracleConnection.class not found
> > GeometryAdapter sdoAdapter =
> > OraSpatialManager.getGeometryAdapter("SDO", "9.
> > 2.0",
> > ^
> > SampleShapefileToSDO.java:94: cannot resolve symbol
> > symbol : class STRUCT
> > location: class sample.SampleShapefileToSDO
> > STRUCT str = (STRUCT) sdoAdapter.exportGeometry(STRUCT.class,
> > g1);
> > ^
> > SampleShapefileToSDO.java:94: cannot resolve symbol
> > symbol : class STRUCT
> > location: class sample.SampleShapefileToSDO
> > STRUCT str = (STRUCT) sdoAdapter.exportGeometry(STRUCT.class,
> > g1);
> > ^
> > SampleShapefileToSDO.java:94: cannot resolve symbol
> > symbol : class STRUCT
> > location: class sample.SampleShapefileToSDO
> > STRUCT str = (STRUCT) sdoAdapter.exportGeometry(STRUCT.class,
> > g1);
> > ^
> > 8 errors
> >
> > Can someone please help me with the above.
> >
> > Thanks
> > Sunil
>
> --
> ===================================================================
>
> Brian Peasland
> dba_at_remove_spam.peasland.com
>
> Remove the "remove_spam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good. Now pick two out of
> the three"
Received on Mon Jul 14 2003 - 14:11:36 CDT