Edit D:\app\Administrator\product\11.2.0\dbhome_1\md\jlib\oracle\spatial\network\NetworkUtility.class
?? 1? ?#$ #% & '( ) *??F??9AXM? +, +- +. ?/0 ?1 2 3 4 5 +6? 78 9 :; #< # => ? * @A BCD * E F G ?H ?I JK +L M NO RP RQ RR RSTUVWXYZY[Y)W)\] B^ ?_ ?`aTb ?c RdefegYhe)ijkl ?m ?nopWqr W#Ystutv Wwx yz ?{ ?|}~ ?? ??W? ????? R? W?? J? B? ???e? ?? ?? ?? ?? ?? ????? {# ?? ?? {w {?? {??????? ?? ?? ?? +? ??? ?????? ?? ???? ???? ?? ?? ?? R? ??? ?# ?? ??? ?? ?? ?? ?? ?? ???? ???? ?? ?? J??????? ?) ??? R? R? R????????????? ????????????????????????? ????????? ?? {?? ?? ????? ?? {? ?? ?? ?? ?? ?? ?? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?? ? ? ?? ? ? ?? ?? ?? ?? ? ? ? ? ? ? ? ? ? ?! ?" ?# ? ? ?$ ?% ?? ? ?& ? ? ? ? ? ? ?' ? ?(?)( ! (? !&(? !( !( ! !* !+(? !?(((,((-?.- 7 - 7---/ 70-1 72-3-4-5-6-7-8--9--:T;<=<f<>?<[ R@ ?AT) B)C D) E) FG FH FI??????? FJ FK LMNOP d@ ?QR ?S ?TUVWXYZ?[\]^ A^_<)`ab ?c ?de?fghijkl Rm?nopoq?r ?stwtut?t? ?v?w?x?yz{? ?|} ?~???T?T? ?? ???????????? <init> ()V Code LineNumberTable getStackTrace )(Ljava/lang/Throwable;)Ljava/lang/String; geodeticDistanceInMeters (DDDD)D splitGeometry J(Loracle/spatial/geometry/JGeometry;D)[Loracle/spatial/geometry/JGeometry; clipGeometry J(Loracle/spatial/geometry/JGeometry;DD)Loracle/spatial/geometry/JGeometry; geomOrds 7(Loracle/spatial/geometry/JGeometry;)Ljava/lang/String; locatePoint I(Loracle/spatial/geometry/JGeometry;D)Loracle/spatial/geometry/JGeometry; reverseGeometry H(Loracle/spatial/geometry/JGeometry;)Loracle/spatial/geometry/JGeometry; concatenateGeometry l(Loracle/spatial/geometry/JGeometry;Loracle/spatial/geometry/JGeometry;D)Loracle/spatial/geometry/JGeometry; connectFlag J(Loracle/spatial/geometry/JGeometry;Loracle/spatial/geometry/JGeometry;D)I isLineStringGeometry &(Loracle/spatial/geometry/JGeometry;)Z getSchemaName &(Ljava/lang/String;)Ljava/lang/String; getTableName getUser )(Ljava/sql/Connection;)Ljava/lang/String; tableExists *(Ljava/sql/Connection;Ljava/lang/String;)Z tableType ;(Ljava/sql/Connection;Ljava/lang/String;)Ljava/lang/String; dropTable *(Ljava/sql/Connection;Ljava/lang/String;)V getColumnNames )(Ljava/sql/ResultSet;)Ljava/util/HashSet; columnExists <(Ljava/sql/Connection;Ljava/lang/String;Ljava/lang/String;)Z insertGeomMetadata a(Ljava/sql/Connection;Ljava/lang/String;Ljava/lang/String;ILoracle/spatial/network/SDODimArray;)V Exceptions addColumn N(Ljava/sql/Connection;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Z )(Ljava/sql/ResultSet;Ljava/lang/String;)Z geomMetadataExists isGeodetic (Ljava/sql/Connection;I)Z linkGeometry B(Loracle/spatial/network/Link;)Loracle/spatial/geometry/JGeometry; getNodeArrayByNo B(Loracle/spatial/network/Network;ZI)[Loracle/spatial/network/Node; getLinkArrayByNo B(Loracle/spatial/network/Network;ZI)[Loracle/spatial/network/Link; getPartitionNetwork E(Loracle/spatial/network/Network;ZDD)Loracle/spatial/network/Network; readGraph 0(Ljava/io/File;)Loracle/spatial/network/Network; readPajekNetwork readLine ,(Ljava/io/BufferedReader;)Ljava/lang/String; makeSpatial Y(Loracle/spatial/network/Network;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)V makeLogical #(Loracle/spatial/network/Network;)V getNDMSchemaInfo \(Ljava/sql/Connection;Loracle/spatial/network/Network;Ljava/lang/String;)Ljava/util/HashSet; ptLinstringDistance *(Loracle/spatial/geometry/JGeometry;[DDD)D ptLineDistance ([[D[DDD)D geometryLength &(Loracle/spatial/geometry/JGeometry;)D nearestPoint H(Loracle/spatial/geometry/JGeometry;DD)[Loracle/spatial/network/MDPoint; computeDistanceRatio )(Loracle/spatial/geometry/JGeometry;DD)[D copyNode =(Loracle/spatial/network/Node;Loracle/spatial/network/Node;)V copyLink =(Loracle/spatial/network/Link;Loracle/spatial/network/Link;)V copyPath =(Loracle/spatial/network/Path;Loracle/spatial/network/Path;)V copySubPath C(Loracle/spatial/network/SubPath;Loracle/spatial/network/SubPath;)V qualifiedSQLName jdbcClose (Ljava/sql/ResultSet;)V (Ljava/sql/Statement;)V (Ljava/sql/Connection;)V ioClose (Ljava/io/InputStream;)V (Ljava/io/OutputStream;)V (Loracle/sql/BLOB;)V usedHeapMemory ()J validateMetadataNames @(Ljava/sql/Connection;Loracle/spatial/network/NetworkMetadata;)V rollbackWorkspace workspaceExists removeWorkspace versionTable versionNetwork isTableVersioned isNetworkVersioned getParentWorkspace M(Ljava/sql/Connection;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String; getWorkspace gotoWorkspace gotoSavepoint createWorkspace getSavepoint sameNetwork C(Loracle/spatial/network/Network;Loracle/spatial/network/Network;)Z getNetworkDiff ?(Ljava/sql/Connection;Loracle/spatial/network/Network;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/util/HashMap; splitString 9(Ljava/lang/String;Ljava/lang/String;)[Ljava/lang/String; SourceFile NetworkUtility.java?? java/io/StringWriter java/io/PrintWriter?????????????????? !oracle/spatial/geometry/JGeometry?????????????? Null geometry...???? java/lang/StringBuffer java/lang/StringBuilder?? : ???? (?? , ) ??????????????????? .??????????? SELECT USER FROM DUAL???????? java/sql/SQLException java/lang/Exception?????? FSELECT COUNT(*) FROM ALL_TABLES WHERE TABLE_NAME = ? AND OWNER = ?????????????? ESELECT COUNT(*) FROM ALL_VIEWS WHERE VIEW_NAME = ? AND OWNER = ? TABLE DSELECT COUNT(*) FROM ALL_VIEWS WHERE VIEW_NAME = ? AND OWNER = ? VIEW???? DROP ?? java/util/HashSet????????? SELECT * from ??????? ,Insert into user_sdo_geom_metadata values( ' ', '????? )???? Alter Table add ( )???? nselect count(*) from all_sdo_geom_metadata where table_name = ? and column_name = ? and owner = ???????? W select count(*) from mdsys.cs_srs a where a.srid = ? and a.wktext like 'GEOGCS%' ????????????????? java/util/Vector?????? oracle/spatial/network/Node?? [Loracle/spatial/network/Node;?? oracle/spatial/network/Link [Loracle/spatial/network/Link; P_LAYOUT????? ?? oracle/spatial/network/NodeImpl java/io/BufferedReader java/io/FileReader? ? LOGICAL DIRECTED?? java/util/StringTokenizer , ?? ?? java/util/HashMap? java/lang/Integer???? !"?#$%? NoOfNodes: &? , NoOfLinks: '??? #(???)?*+,-./.0.1234?567686 NODE9: LINK;: PATH<: SUBPATH=: PLINK>: METADATA USER_SDO_NETWORK_METADATA?? [D???? "oracle/spatial/network/MDPointImpl?@A oracle/spatial/network/MDPoint ![Loracle/spatial/network/MDPoint; java/lang/Double?BCDE?FGHIJKLMN?OP?QRSTUV?W?XY?Z[??\?]?^_`abcdefghi_jakl?m[nopq?rstU@uvw!xyiz oracle/spatial/network/PathImpl{|}~i? "oracle/spatial/network/SubPathImpl???????????????i 7begin ? := SYS.DBMS_ASSERT.qualified_sql_name(?); end; ??????? java/lang/String??? java/io/IOException?????? ? ??????? is not a qualified SQL name +oracle/spatial/network/NetworkDataException No node table metadata found?: Node table name ??? Node table column name No link table metadata found Link table name Link table column name Path table name Path table column name ?. Sub-path table name Sub-path table column name Path-link table name '{ call DBMS_WM.rollbackWorkspace(?) } ; Select count(*) from all_workspaces Where workspace = ? %{ call DBMS_WM.removeWorkspace(?) } %{ call DBMS_WM.enableVersioning(?) } ??? Q Select count(*) from all_wm_versioned_tables Where owner = ? and table_name = ??? P Select parent_workspace from all_workspaces Where workspace = ? and owner = ? ) Select DBMS_WM.getWorkspace() From Dual "{ call DBMS_WM.gotoWorkspace(?) } "{ call DBMS_WM.gotoSavepoint(?) } ${ call DBMS_WM.createWorkspace(?); } ({ call DBMS_WM.GetSessionInfo(?,?,?) } ????????`??????????????? Network is null Network node/link table is null? Network is not versioned? LATEST workspace &source network not in source workspace???[?? .begin DBMS_WM.SetDiffVersions(?,?,?,?); end; _DIFF SELECT NODE_ID FROM WHERE WM_DIFFVER = 'DiffBase' SELECT LINK_ID FROM WHERE WM_DIFFVER = 'DiffBase' DiffNodes DiffLinks %oracle/spatial/network/NetworkUtility java/lang/Object (Ljava/io/Writer;)V java/lang/Throwable printStackTrace (Ljava/io/PrintWriter;)V close toString ()Ljava/lang/String; java/lang/Math sin (D)D cos acos getSRID ()I getDimensions getOrdinatesArray ()[D getNumPoints sqrt createLinearLineString )([DII)Loracle/spatial/geometry/JGeometry; isPoint ()Z getPoint append -(Ljava/lang/Object;)Ljava/lang/StringBuilder; -(Ljava/lang/String;)Ljava/lang/StringBuilder; ,(Ljava/lang/String;)Ljava/lang/StringBuffer; (D)Ljava/lang/StringBuilder; getFirstPoint createPoint getLastPoint java/lang/System arraycopy *(Ljava/lang/Object;ILjava/lang/Object;II)V abs getType hasCircularArcs indexOf (Ljava/lang/String;)I substring (II)Ljava/lang/String; trim (I)Ljava/lang/String; java/sql/Connection createStatement ()Ljava/sql/Statement; java/sql/Statement executeQuery ((Ljava/lang/String;)Ljava/sql/ResultSet; java/sql/ResultSet next getString prepareStatement 0(Ljava/lang/String;)Ljava/sql/PreparedStatement; toUpperCase java/sql/PreparedStatement setString (ILjava/lang/String;)V ()Ljava/sql/ResultSet; getInt (I)I execute (Ljava/lang/String;)Z getMetaData ()Ljava/sql/ResultSetMetaData; java/sql/ResultSetMetaData getColumnCount getColumnName add (Ljava/lang/Object;)Z oracle/spatial/util/Util checkSQLName '(Ljava/lang/String;I)Ljava/lang/String; "oracle/spatial/network/SDODimArray toSQLString (I)Ljava/lang/StringBuilder; executeUpdate equalsIgnoreCase contains err Ljava/io/PrintStream; getMessage java/io/PrintStream println (Ljava/lang/String;)V setInt (II)V isLogical getStartNode ()Loracle/spatial/network/Node; getEndNode getMDPoint "()Loracle/spatial/network/MDPoint; getOrd (I)D getSrid oracle/spatial/network/Network getNodeArray ()[Loracle/spatial/network/Node; getPartitionID getComponentNo size toArray (([Ljava/lang/Object;)[Ljava/lang/Object; getLinkArray ()[Loracle/spatial/network/Link; %oracle/spatial/network/NetworkFactory createSDONetwork 8(Ljava/lang/String;IZII)Loracle/spatial/network/Network; %oracle/spatial/network/NetworkManager findConnectedComponents #(Loracle/spatial/network/Network;)I random ()D createSDONode 4(ILjava/lang/String;DD)Loracle/spatial/network/Node; setSize (D)V addNode (Loracle/spatial/network/Node;)V (Ljava/io/File;)V (Ljava/io/Reader;)V '(Ljava/lang/String;Ljava/lang/String;)V countTokens nextToken compareToIgnoreCase createLogicalNetwork 6(Ljava/lang/String;IZ)Loracle/spatial/network/Network; containsKey get &(Ljava/lang/Object;)Ljava/lang/Object; intValue (I)V put 8(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object; createLogicalNode 2(ILjava/lang/String;)Loracle/spatial/network/Node; parseDouble (Ljava/lang/String;)D getNode (I)Loracle/spatial/network/Node; createLogicalLink m(ILjava/lang/String;Loracle/spatial/network/Node;Loracle/spatial/network/Node;D)Loracle/spatial/network/Link; addLink (Loracle/spatial/network/Link;)V parseInt createSDOLink ?(ILjava/lang/String;Loracle/spatial/network/Node;Loracle/spatial/network/Node;DLoracle/spatial/geometry/JGeometry;)Loracle/spatial/network/Link; out getNoOfNodes getNoOfLinks startsWith length getMetadata *()Loracle/spatial/network/NetworkMetadata; &oracle/spatial/network/NetworkMetadata getNodeGeomMetadata +()Loracle/spatial/network/GeometryMetadata; getLinkGeomMetadata getPathGeomMetadata setCategory setGeometryType 'oracle/spatial/network/GeometryMetadata setColumnName setNodeGeomMetadata ,(Loracle/spatial/network/GeometryMetadata;)V setLinkGeomMetadata setPathGeomMetadata getNodeTableName (Z)Ljava/lang/String; getLinkTableName getPathTableName getSubPathTableName getPathLinkTableName clear (DD)V setSrid elementAt (I)Ljava/lang/Object; doubleValue getID getCost setCost getDuration setDuration getGeometry %()Loracle/spatial/geometry/JGeometry; setGeometry &(Loracle/spatial/geometry/JGeometry;)V getGeomID setGeomID getHierarchyLevel setHierarchyLevel setMDPoint #(Loracle/spatial/network/MDPoint;)V getMeasure setMeasure getName setName setPartitionID getState setState (Z)V setType getParentNode setParentNode getUserData ()Ljava/lang/Object; setUserData (Ljava/lang/Object;)V getNetwork "()Loracle/spatial/network/Network; getUserDataMetadata +()Loracle/spatial/network/UserDataMetadata; 'oracle/spatial/network/UserDataMetadata getNodeDataNames ()[Ljava/lang/String; &(Ljava/lang/String;)Ljava/lang/Object; '(Ljava/lang/String;Ljava/lang/Object;)V isBidirected setBidirected setEndNode getFlow setFlow getLinkLevel setLinkLevel getStartMeasure getEndMeasure getParentLink ()Loracle/spatial/network/Link; setParentLink setStartNode getLinkDataNames oracle/spatial/network/Path getPathLinksVector ()Ljava/util/Vector; setPathLinks (Ljava/util/Vector;)V getPathDataNames oracle/spatial/network/SubPath getStartPercentage setStartPercentage getEndPercentage setEndPercentage getReferencePath ()Loracle/spatial/network/Path; setReferencePath (Loracle/spatial/network/Path;)V getStartLinkIndex setStartLinkIndex getEndLinkIndex setEndLinkIndex getSubPathDataNames prepareCall 0(Ljava/lang/String;)Ljava/sql/CallableStatement; java/sql/CallableStatement registerOutParameter java/io/InputStream java/io/OutputStream oracle/sql/BLOB java/lang/Runtime getRuntime ()Ljava/lang/Runtime; totalMemory freeMemory runFinalization gc java/lang/Thread yield getSubPathGeomMetadata readNetworkMetadata Q(Ljava/sql/Connection;Ljava/lang/String;)Loracle/spatial/network/NetworkMetadata; isVersioned equals getNodes ()Ljava/util/Iterator; java/util/Iterator hasNext containsNode (I)Z getInLinks java/util/Set removeAll (Ljava/util/Collection;)Z getOutLinks getLinks containsLink getLink (I)Loracle/spatial/network/Link; getAutoCommit setAutoCommit ?? D ?? ? *? ? ? ] ?? ? G ? Y? L? Y+? M*,? ,? +? ? ? a b c d e ?? ? ? O 9 9 (k9k9&k9k9? ? k? ? kg? kc? k9? ? "