JAVASHAPEFILECONVERTER DESCRIPTIONTheJavaShapefileConvertertransformsanESRIShapefileintoanOracledatabasetableforusewithOracleSpatialandLocator.TheShapefileConverterusestheOracleSpatialJava-basedShapefileAdapterandSampleShapefileToJGeomFeatureclassestoloadaShapefiledirectlyintoadatabasetable,withtheOracle-equivalent.dbfdatatypesfortheattributecolumnsandtheSDO_GEOMETRYdatatypeforthegeometrycolumn.TheShapefileAdaptercanalsobeusedtocreateyourownapplicationsandinterfacesthattransformShapefilestoSDO_GEOMETRYorJGeometrydatatypes(seetheOracleSpatialJavaAPIformoreinformation).TosimplyloadaShapefileintothedatabase,usetheSampleShapefileToJGeomFeatureclassasillustratedbelow. NOTESTherequirementsforusingtheShapefileConverterorShapefileAdapterare:•AnOracle10gorlaterdatabasewithLocatororOracleSpatial•Auser/passwordountforthedatabase•TheOracleutilitiesandJDBClibraries(JARs):ojdbc14.jarorojdbc5.jar,sdoutl.jar, andsdoapi.jar•SunJDKversion1.4.2_04orhigher:JDK1.5isrequiredforOracle11g•ESRIShapefile(s)(.shp,.shx,and.dbffiles)tobeconverted USAGE>java-cp[ORACLE_HOME]/jdbc/lib/ojdbc5.jar:./sdoutl.jar:./sdoapi.jaroracle.spatial.util.SampleShapefileToJGeomFeature-hdb_host-pdb_port-sdb_sid-udb_username-ddb_password-tdb_table-fshapefile_name[-itable_id_column_name][rsrid][-gdb_geometry_column][-xmax_x,min_x][-ymax_y,min_y][-otolerance] Explanationofusageparameters:•-h:HostmachinewithexistingOracledatabase•-p:Hostmachine'sport(e.g.1521)•-s:Hostmachine'sSID•-u:Databaseuser•-d:Databaseuser'spassword•-t:TablenamefortheconvertedShapefile•-f:FilenameofaninputShapefile(withoutextension)•-i:ColumnnameforuniquenumericID;ifrequired•-r:ValidOracleSRIDforcoordinatesystem;use0ifunknown•-g:PreferredSDO_GEOMETRYcolumnname•-x:BoundsfortheXdimension;use-180,180ifunknown•-y:BoundsfortheYdimension;use-90,90ifunknown•-o:Loadtolerancefields(xandy)inmetadata,ifnotspecified,tolerancefieldsare0.05•-a:AppendShapefiledatatoanexistingtable•-n:StartIDforcolumnspecifiedin-iparameter •-c:Commitinterval.Default,mitsevery1000conversionsandattheend•-v:Printlninterval.Default,displaysevery10conversions LinuxExample:>setenvclpath$ORACLE_HOME/jdbc/lib/ojdbc5.jar:$ORACLE_HOME/md/jlib/sdoutl.jar:$ORACLE_HOME/md/jlib/sdoapi.jar>java-cp$clpathoracle.spatial.util.SampleShapefileToJGeomFeature-hgis01-p1521sorcl-uscott-dtiger-tstates-fstates-r8307-ggeom WindowsExample:>java-classpath%ORACLE_HOME%\jdbc\lib\ojdbc5.jar;%ORACLE_HOME%\md\jlib\sdoutl.jar;%ORACLE_HOME%\md\jlib\sdoapi.jaroracle.spatial.util.SampleShapefileToJGeomFeaturehgis01-p1521-sorcl-uscott-dtiger-tstates-fstates-r8307-ggeom