Edit D:\app\Administrator\product\11.2.0\dbhome_1\md\jlib\oracle\spatial\network\NetworkAdapterSDO.class
?? 1K /? ,? ,? ,? ,?? ,? , , , , ? , ? ? ? , ? ** ,* , , , ! ,"*# ,$ ,%& ,'( ,) ,*+,-. / ,01 72 73 74 75 7678 79 7: ; <=>?@ ,A ,B ,C ,D ,E ,F ,G*HI ?JK,L MN ,OPQP RSTKUVWVX RYZ[\][^_[` ?a ?b[c[d[e ,f ,ghVij kl kmno kp oqrVstVu vw ?xyVz{V| \? ^? `?} ?~ R??*? ?? ??*? ??? ? ??? ??+?+?? ?? ?*?*????????*????????V????V?? ?? \? \? \? ?? \? \? \?*?*? ,? ?? ???? ,?? ,??V,V? ,? \?V? \? ,? ,?????? ,???????????*??????K?K?V??K??*??????? ???????????? ???????????????? * ,* \ ^? ? ^? ^? ^ , ^? ^? , , , !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~??*?*??????????? ??????? ???b ??? ?? ?? ???? ???? ?? ?? `? `? `??? ,?*? ????????????????? ,?? ?? ? ? ???? ,? ???????? ?? ,?>??>????>?*??*??*?*?>? ??? ???>? ?????>? ?? ?? ?? ,???? ,?K??? ?? ,? \? ,? ?? ,? ,? ??? ,? ,? ,? ,? ??? ,? ,? ?? ,? ,? ?? ?? ,? ? ?? ,? `? ,? ?? ,? ^? ?? ,? \? ?? , ? , 0 0 0? ? ? , , ? , , ? , , ? ? , ? , ?! ,"7#$ 4%& ?'() ?*+,-. ,/ ,0 ,12 H345K?67 H8 9:; Q3< ?=>? ?@ ?AB Q8CDEFG?GHG,IJKL*M ?NOP ?Q>?>RS ,T ,UVWXYZ[\]^ \_ ,` ^_ `_ ,aKb kl opKcdKef ,gKhiKjkKl \? \m \n \o*p \q \r \s \t \u ,vwxy>z{|}~?????? ^? ^? ^? ^m ^n ^? ^o*? ^q ^r ^? ^? ^? ^u ^?*??>??*?????????? ???????? `? `? `? `m `o `? `q ? ? ? ? ? ? m o q `??????????>??*????*m*?*???*?*??? 0m 0??? ??? ??? ?? ???? 3%?? ?????? ,? ?? ,? ???????>? \? ,?? 3 ,????>? ^? ,?? ,??>?? ????>??>??>??>??? 9? R??? logger Loracle/spatial/util/Logger; DB_VERSION_10G Ljava/lang/String; ConstantValue DB_VERSION_11G p_name p_version p_conn Ljava/sql/Connection; p_readForUpdate Z p_ioFunction #Loracle/spatial/network/UserDataIO; p_networkName <init> ()V Code LineNumberTable readNetwork I(Ljava/sql/Connection;Ljava/lang/String;)Loracle/spatial/network/Network; Exceptions J(Ljava/sql/Connection;Ljava/lang/String;Z)Loracle/spatial/network/Network; f(Ljava/sql/Connection;Ljava/lang/String;Loracle/spatial/network/MBR;Z)Loracle/spatial/network/Network; m(Ljava/sql/Connection;Ljava/lang/String;ZLoracle/spatial/network/UserDataIO;)Loracle/spatial/network/Network; ?(Ljava/sql/Connection;Ljava/lang/String;ZLoracle/spatial/network/UserDataIO;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Loracle/spatial/network/Network; ?(Ljava/sql/Connection;Ljava/lang/String;ZLoracle/spatial/network/UserDataIO;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Z)Loracle/spatial/network/Network; ?(Ljava/sql/Connection;Ljava/lang/String;ZLoracle/spatial/network/UserDataIO;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Z)Loracle/spatial/network/Network; ?(Ljava/sql/Connection;Ljava/lang/String;Loracle/spatial/network/MBR;ZLoracle/spatial/network/UserDataIO;)Loracle/spatial/network/Network; K(Ljava/sql/Connection;Ljava/lang/String;IZ)Loracle/spatial/network/Network; n(Ljava/sql/Connection;Ljava/lang/String;IZLoracle/spatial/network/UserDataIO;)Loracle/spatial/network/Network; readNoOfPartitions @(Ljava/sql/Connection;Loracle/spatial/network/NetworkMetadata;)I readUserData e(Loracle/spatial/network/UserDataMetadata;Ljava/sql/ResultSet;Ljava/util/HashSet;Ljava/lang/Object;)V getUserData L(Ljava/sql/ResultSet;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/Object; setUserData 9(Ljava/lang/Object;Ljava/lang/String;Ljava/lang/Object;)V readNodeMap ?(Ljava/sql/Connection;Loracle/spatial/network/NetworkMetadata;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/util/HashMap; x(Ljava/sql/Connection;Loracle/spatial/network/NetworkMetadata;ZLjava/lang/String;Ljava/lang/String;Z)Ljava/util/HashMap; o(Ljava/sql/Connection;Loracle/spatial/network/NetworkMetadata;Loracle/spatial/network/MBR;Z)Ljava/util/HashMap; getNetworkNameFromID *(Ljava/sql/Connection;I)Ljava/lang/String; getNetworkIDFromName *(Ljava/sql/Connection;Ljava/lang/String;)I getNetworkIDs *(Ljava/sql/Connection;)Ljava/util/HashMap; getNetworkNames ;(Ljava/io/FileInputStream;)Loracle/spatial/network/Network; T(Ljava/sql/Connection;Loracle/spatial/network/NetworkMetadata;IZ)Ljava/util/HashMap; readLinkMap ?(Ljava/sql/Connection;Loracle/spatial/network/NetworkMetadata;Ljava/util/HashMap;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/util/HashMap; ?(Ljava/sql/Connection;Loracle/spatial/network/NetworkMetadata;Ljava/util/HashMap;ZLjava/lang/String;Ljava/lang/String;Z)Ljava/util/HashMap; getSQLNodeFilterString w(Ljava/sql/Connection;Loracle/spatial/network/NetworkMetadata;Ljava/lang/String;Ljava/lang/String;ZZ)Ljava/lang/String; v(Ljava/sql/Connection;Loracle/spatial/network/NetworkMetadata;Ljava/lang/String;Ljava/lang/String;Z)Ljava/lang/String; getSQLNodeGeomFilterString u(Ljava/sql/Connection;Loracle/spatial/network/NetworkMetadata;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String; getSQLNodeCostFilterString a(Loracle/spatial/network/NetworkMetadata;Ljava/lang/String;Ljava/lang/String;Z)Ljava/lang/String; `(Loracle/spatial/network/NetworkMetadata;Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String; getSQLLinkFilterString getSQLLinkGeomFilterString getSQLLinkCostFilterString ?(Ljava/sql/Connection;Loracle/spatial/network/NetworkMetadata;Ljava/util/HashMap;Loracle/spatial/network/MBR;Z)Ljava/util/HashMap; g(Ljava/sql/Connection;Loracle/spatial/network/NetworkMetadata;Ljava/util/HashMap;IZ)Ljava/util/HashMap; readLinkMapByNodePartition y(Ljava/sql/Connection;Loracle/spatial/network/NetworkMetadata;Ljava/util/HashMap;Ljava/lang/String;IZ)Ljava/util/HashMap; readPathMap ?(Ljava/sql/Connection;Loracle/spatial/network/NetworkMetadata;Ljava/util/HashMap;Ljava/util/HashMap;Ljava/lang/String;Z)Ljava/util/HashMap; ?(Ljava/sql/Connection;Loracle/spatial/network/NetworkMetadata;Ljava/util/HashMap;Ljava/util/HashMap;ZLjava/lang/String;)Ljava/util/HashMap; y(Ljava/sql/Connection;Loracle/spatial/network/NetworkMetadata;Ljava/util/HashMap;Ljava/util/HashMap;Z)Ljava/util/HashMap; readSubPathMap ?(Ljava/sql/Connection;Loracle/spatial/network/NetworkMetadata;Ljava/util/HashMap;Ljava/util/HashMap;Ljava/util/HashMap;Ljava/lang/String;Z)Ljava/util/HashMap; ?(Ljava/sql/Connection;Loracle/spatial/network/NetworkMetadata;Ljava/util/HashMap;Ljava/util/HashMap;Ljava/util/HashMap;ZLjava/lang/String;)Ljava/util/HashMap; ?(Ljava/sql/Connection;Loracle/spatial/network/NetworkMetadata;Ljava/util/HashMap;Ljava/util/HashMap;Ljava/util/HashMap;Z)Ljava/util/HashMap; getNodeFromMap 3(Ljava/util/HashMap;I)Loracle/spatial/network/Node; getLinkFromMap 3(Ljava/util/HashMap;I)Loracle/spatial/network/Link; getPathFromMap 3(Ljava/util/HashMap;I)Loracle/spatial/network/Path; writeNetwork 8(Ljava/sql/Connection;Loracle/spatial/network/Network;)V [(Ljava/sql/Connection;Loracle/spatial/network/Network;Loracle/spatial/network/UserDataIO;)V =(Ljava/io/FileOutputStream;Loracle/spatial/network/Network;)V readNetworkMetadata Q(Ljava/sql/Connection;Ljava/lang/String;)Loracle/spatial/network/NetworkMetadata; writeNetworkMetadata @(Ljava/sql/Connection;Loracle/spatial/network/NetworkMetadata;)V getDBVersion )(Ljava/sql/Connection;)Ljava/lang/String; readNetworkConstraint ;(Ljava/sql/Connection;Ljava/lang/String;)Ljava/lang/Object;??? readNetworkConstraint10g readNetworkConstraint11g readNetworkConstraints readJavaObject registerNetworkConstraint `(Ljava/sql/Connection;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)V deregisterNetworkConstraint *(Ljava/sql/Connection;Ljava/lang/String;)V registerJavaObject r(Ljava/sql/Connection;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)V deregisterJavaObject getName ()Ljava/lang/String; getVersion getUserDataSchema l(Loracle/spatial/network/Network;Ljava/util/HashSet;Ljava/lang/String;Ljava/lang/String;Z)Ljava/lang/String; getUserDataCount H(Loracle/spatial/network/Network;Ljava/util/HashSet;Ljava/lang/String;)I addNodeSchema \(Ljava/sql/Connection;Loracle/spatial/network/Network;Ljava/util/HashSet;)Ljava/lang/String; deleteNodeSchema 4(Loracle/spatial/network/Network;)Ljava/lang/String; modifyNodeSchema setAddUserDataPStmt z(Ljava/sql/Connection;Loracle/spatial/network/Network;Ljava/sql/PreparedStatement;Ljava/lang/Object;Ljava/util/HashSet;I)V setDataPStmt Y(Ljava/sql/Connection;Ljava/sql/PreparedStatement;Ljava/lang/String;ILjava/lang/Object;)Z getSQLType (Ljava/lang/String;)I setAddNodePStmt ?(Ljava/sql/Connection;Loracle/spatial/network/Network;Ljava/sql/PreparedStatement;Loracle/spatial/network/Node;Ljava/util/HashSet;)V setModifyNodePStmt addLinkSchema deleteLinkSchema setNodeParentNull setLinkParentNull modifyLinkSchema setAddLinkPStmt ?(Ljava/sql/Connection;Loracle/spatial/network/Network;Ljava/sql/PreparedStatement;Loracle/spatial/network/Link;Ljava/util/HashSet;)V setModifyLinkPStmt addPathSchema addSubPathSchema deletePathSchema deleteSubPathSchema modifyPathSchema modifySubPathSchema addPathLinkSchema I(Ljava/sql/Connection;Loracle/spatial/network/Network;)Ljava/lang/String; modifyPathLinkSchema deletePathLinkSchema setAddPathPStmt ?(Ljava/sql/Connection;Loracle/spatial/network/Network;Ljava/sql/PreparedStatement;Loracle/spatial/network/Path;Ljava/util/HashSet;)V setAddSubPathPStmt ?(Ljava/sql/Connection;Loracle/spatial/network/Network;Ljava/sql/PreparedStatement;Loracle/spatial/network/SubPath;Ljava/util/HashSet;)V setModifyPathPStmt setModifySubPathPStmt setAddPathLinkPStmt q(Ljava/sql/Connection;Loracle/spatial/network/Network;Ljava/sql/PreparedStatement;Loracle/spatial/network/Path;)V setModifyPathLinkPStmt addMetadataSchema <(Ljava/sql/Connection;Ljava/util/HashSet;)Ljava/lang/String; modifyMetadataSchema deleteMetadataSchema setAddMetadataPStmt o(Ljava/sql/Connection;Ljava/sql/PreparedStatement;Loracle/spatial/network/NetworkMetadata;Ljava/util/HashSet;)V setModifyMetadataPStmt addUserDataEntrySchema setAddUserDataEntryPStmt z(Ljava/sql/Connection;Loracle/spatial/network/Network;Ljava/sql/PreparedStatement;Loracle/spatial/network/UserDataEntry;)V deleteUserDataEntrySchema setDeleteUserDataEntryPStmt geometryToSTRUCT M(Ljava/sql/Connection;Loracle/spatial/geometry/JGeometry;)Loracle/sql/STRUCT; numberArrayToARRAY +(Ljava/sql/Connection;[I)Loracle/sql/ARRAY; findNetworkNode findNetwokLink findNetwokPath isLockException (Ljava/sql/SQLException;)Z isNumericOverflowException isFunctionName (Ljava/lang/String;)Z checkSQLLinkFilter checkSQLNodeFilter readNodesFromDB L(Ljava/sql/Connection;Loracle/spatial/network/Network;[I)Ljava/util/HashMap; readGeometryFromDB s(Ljava/sql/Connection;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;)Ljava/util/HashMap; readLinksFromDB readPathsFromDB readSubPathsFromDB getBatchSize ()I printArray ([ILjava/lang/String;)V setNetworkMaxIDs getObjectColumnNames <clinit> SourceFile NetworkAdapterSDO.java@A9:;<=>?4 Oracle Spatial74 11.0.0.0.084DMDKDL oracle/spatial/network/NDMTimer??? ??? TRUE ? +oracle/spatial/network/NetworkDataException@ ??hi java/lang/StringBuilder SQL Node Filter: ???kl???mnpi SQL Link Filter: qj?rjXZ Empty Node Information...eg Empty Link Information...wy{}A java/sql/SQLException java/lang/Exception@PQ "oracle/spatial/network/NetworkImpl@AAAAR?? ? workspace!V" savepoint??X[eswzDOXdet#$ %&' 'SELECT COUNT(UNIQUE PARTITION_ID) FROM ()*12 Query String: NetworkAdaptorSDO+,-./0123?456 oracle/spatial/network/Node789 oracle/spatial/network/Link:9 oracle/spatial/network/Path;9<?=&>?@?A?TUVW INTEGERBC java/lang/IntegerDE?@F NUMBER java/lang/DoubleGH@I VARCHAR2J? SDO_GEOMETRYKLMNOPQ DATERS TIMESTAMPTU oracle/spatial/network/SubPath readNodeMap sqlString: , readNodeMap geomSqlString: readNodeMap costSqlString: VWXY$Z?[?\? NODE_ID]^_`a Node Column: NODE_ID missing!bc dF0e java/util/HashMapfgh?i? Node Geometry Column: missing! GEOM_ID MEASURE ,Node LRS Column: GEOM_ID or MEASURE missing! TOPO_GEOMETRY (Node Topo Column: TOPO_GEOMETRY missing!j? HIERARCHY_LEVEL PARENT_NODE_ID DNode Hierarchical Column: HIERARCHY_LEVEL or PARENT_NODE_ID missing! NODE_NAME ACTIVE PARTITION_ID NODE_TYPE4? Y java/lang/String Nkl oracle/spatial/network/NodeImpl@mnFoFp qrsItFuIv?wxRSyz{|}?? Node Table Locked...?? =Maximum node id is larger than the Java maximum integer valueK~??k??IkjXY t SELECT .* FROM NODE?o .* FROM WHERE SDO_FILTER( . , ??? , 'querytype=window') = 'TRUE' FOR UPDATE NOWAIT +SELECT NODE_ID, sdo_net.get_node_geometry('?? ',node_id) From n WHERE SDO_FILTER(n. SELECT NODE_ID, From DSELECT NETWORK FROM ALL_SDO_NETWORK_METADATA WHERE NETWORK_ID =???J? @SELECT NETWORK_ID FROM ALL_SDO_NETWORK_METADATA WHERE NETWORK =??? :SELECT NETWORK_ID , NETWORK FROM ALL_SDO_NETWORK_METADATA ?W a LINK_LEVEL (SELECT n.NODE_ID FROM n, l WHERE l.LINK_LEVEL = ? " AND l.START_NODE_ID = n.NODE_ID) UNION AND l.END_NODE_ID = n.NODE_ID) SELECT a.* a, ( ) b WHERE a.NODE_ID = b.NODE_ID FOR UPDATE NOWAIT ',NODE_ID) From SELECT a.node_ID, a.?? LINK_ID Link Column: LINK_ID missing! START_NODE_ID #Link Column: START_NODE_ID missing! END_NODE_ID !Link Column: END_NODE_ID missing! Link Column: Link Geometry Column: START_MEASURE END_MEASURE BLink LRS Column: GEOM_ID or START_MEASURE or END_MEASURE missing! 1Link ToPo Geometry Column: TOPO_GEOMETRY missing! PARENT_LINK_ID 2Link Hierarchical Column: PARENT_LINK_ID missing! LINK_NAME LINK_TYPE?? BIDIRECTED?????? oracle/spatial/network/LinkImpl@??u? Link Table Locked... =Maximum link id is larger than the Java maximum integer value??qlrlef n SELECT .* WHERE SELECT distinct l.link_id FROM l, n % WHERE ( l.start_node_id = n.node_id AND ) OR (l.end_node_id = n.node_id ) ( SELECT l.start_node_id FROM l, ( ) u WHERE l.link_id = u.link_id UNION SELECT l.end_node_id FROM l, ( ) v WHERE l.link_id = v.link_id) WHERE n.node_id in ( SELECT l.start_node_id FROM SELECT l.end_node_id FROM ) WHERE n.node_id in (SELECT l.start_node_id FROM SELECT l.end_node_id FROM WHERE n.node_id in , SELECT NODE_ID, sdo_net.get_node_geometry(' ',node_id) FROM . SELECT n.NODE_ID, sdo_net.get_node_geometry(' ',n.node_id) FROM % SELECT l.start_node_id node_id FROM $ SELECT l.end_node_id node_id FROM WHERE l.link_id = v.link_id . SELECT n.node_id, sdo_net.get_node_geometry(' WHERE n.node_id = b.node_id ( (( SELECT l.start_node_id node_id FROM ) UNION $ (SELECT l.end_node_id node_id FROM )) b WHERE n.node_id = b.node_id SELECT node_id, FROM SELECT n.node_id, n. SELECT n.node_id, n. l LINK .* FROM %, ( SELECT a.link_id, n.node_id FROM n WHERE ! a.start_node_id = n.node_id AND ) u %, ( SELECT b.link_id, n.node_id FROM b, b.end_node_id = n.node_id AND ) v 6 WHERE l.link_id = u.link_id and l.link_id = v.link_id 0 l.link_id = u.link_id and l.link_id = v.link_id WHERE l.link_id in ( ) , SELECT LINK_ID, sdo_net.get_link_geometry(' ',link_id) FROM . SELECT l.LINK_ID, sdo_net.get_link_geometry(' ',l.link_id) FROM $ ( SELECT a.link_id, n.node_id FROM ( ) b WHERE l.link_id = b.link_id SELECT link_id, SELECT l.link_id, l. SELECT l.link_id, l. (SELECT NODE_ID from , 'querytype=window') = 'TRUE') SELECT l.* from l where l.start_node_id in and l.end_node_id in +SELECT LINK_ID, sdo_net.get_link_geometry(' ', LINK_ID ) (SELECT l.LINK_ID FROM n WHERE SDO_FILTER(n. #, 'querytype=window') = 'TRUE' AND l.START_NODE_ID = n.NODE_ID) INTERSECT l.END_NODE_ID = n.NODE_ID) SELECT a.LINk_ID, a. ( ) b WHERE a.LINK_ID = b.LINK_ID SELECT LINK_ID, SELECT a.LINK_ID, a. WHERE l.LINK_LEVEL = ',LINK_ID ) l WHERE l.LINK_LEVEL = SELECT * FROM n. = SELECT * from WHERE link_id in ( select distinct link_id from n WHERE % ( l.start_node_id = n.node_id and %OR ( l.end_node_id = n.node_id and )) ', LINK_ID) FROM ,SELECT link_id, sdo_net.get_link_geometry(' ', LINK_ID) from WHERE link_id in ( 2 WHERE link_id in ( select distinct link_id from ?W?$ PATH_ID Path Column: PATH_ID missing! #Path Column: START_NODE_ID missing! !Path Column: END_NODE_ID missing! COST Path Column: COST missing! Path Geometry Column: PATH_NAME PATH_TYPE java/util/Hashtable SEQ_NO select * from order by PATH_ID, SEQ_NO order by PATH_ID java/util/HashSet? java/util/Vector?&?z SIMPLE oracle/spatial/network/PathImpl@???? Path (Path-Link) Table Locked... =Maximum path id is larger than the Java maximum integer valuewx?W?? SUBPATH_ID #SubPath Column: SUBPATH_ID missing! START_LINK_INDEX )SubPath Column: START_LINK_INDEX missing! END_LINK_INDEX 'SubPath Column: END_LINK_INDEX missing! START_PERCENTAGE )SubPath Column: START_PERCENTAGE missing! END_PERCENTAGE 'SubPath Column: END_PERCENTAGE missing! SubPath Column: COST missing! REFERENCE_PATH_ID *SubPath Column: REFERENCE_PATH_ID missing! SubPath Geometry Column: SUBPATH_NAME SUBPATH_TYPE?? "oracle/spatial/network/SubPathImpl@? SubPath Table Locked... @Maximum subpath id is larger than the Java maximum integer value{|???????3??&???? Network: is read-only ... Network is null... Network Name is null...???$ !Network Node Table ame is null...?$ "Network Link Table Name is null...?$?$????? METADATA?? PATH SUBPATH????? oracle/jdbc/OracleConnection???????? Metadata Exists!?? #oracle/jdbc/OraclePreparedStatement?F?????????????????????? Path Metadata Does not Exist!?????????? " SubPath Metadata Does not Exist!?????????????????????????????????????????????????????????????????????????K? &oracle/spatial/network/NetworkMetadata?????????? $oracle/spatial/network/UserDataEntry?? # Sub Path Metadata Does not Exist!???????~?????????A?A >SELECT NETWORK FROM USER_SDO_NETWORK_METADATA order by NETWORK *oracle/spatial/network/NetworkMetadataImpl@? :SELECT * FROM ALL_SDO_NETWORK_CONSTRAINTS WHERE ROWNUM = 1 11g OWNER 10g?????? )oracle/spatial/network/JDBCClassLoader10g@? NSELECT class_name FROM user_sdo_network_constraints WHERE constraint = ? oracle/jdbc/OracleResultSet Given network constraint isn't found - 10g????? &oracle/spatial/network/JDBCClassLoader :?? [SELECT class_name FROM all_sdo_network_constraints WHERE owner = ? AND constraint = ? SELECT user FROM dual???? isn't found ISELECT owner, class_name, constraint FROM all_sdo_network_constraints (oracle/spatial/network/NetworkConstraint 0begin sdo_net.register_constraint(?,?,?,?); end;????? ,begin sdo_net.deregister_constraint(?); end; 3begin sdo_net.register_java_object(?,?,?,?,?); end; -begin sdo_net.deregister_java_object(?); end; = ? ???? INSERT INTO (NODE_ID ?& , GEOM_ID, MEASURE !, PARENT_NODE_ID, HIERARCHY_LEVEL???? ) values( ?, ?) DELETE FROM WHERE NODE_ID = ? UPDATE SET NODE_ID = ? , GEOM_ID = ?, MEASURE = ? ), PARENT_NODE_ID = ?, HIERARCHY_LEVEL = ?TL???????? MDSYS.SDO_GEOMETRY?? !oracle/spatial/geometry/JGeometry?? java/sql/Date java/sql/Timestamp??H ? ? HH?? '( LINK_ID, START_NODE_ID, END_NODE_ID #, GEOM_ID,START_MEASURE,END_MEASURE , PARENT_LINK_ID , BIDIRECTED ) values ( ?) WHERE LINK_ID = ? UPDATE . SET PARENT_NODE_ID = NULL WHERE NODE_ID = ? . SET PARENT_LINK_ID = NULL WHERE LINK_ID = ? UPDATE 6 SET LINK_ID = ?, START_NODE_ID = ?, END_NODE_ID = ? /, GEOM_ID = ?,START_MEASURE = ?,END_MEASURE = ? , PARENT_LINK_ID = ? = ???HH?? &(PATH_ID, START_NODE_ID, END_NODE_ID ? ) values (? 1(SUBPATH_ID, REFERENCE_PATH_ID,START_LINK_INDEX, 1 END_LINK_INDEX,START_PERCENTAGE,END_PERCENTAGE WHERE PATH_ID = ? WHERE SUBPATH_ID = ? UPDATE 7 SET PATH_ID = ?, START_NODE_ID = ?, END_NODE_ID = ? - SET SUBPATH_ID = ?, REFERENCE_PATH_ID = ?, * START_LINK_INDEX = ?, END_LINK_INDEX = ?, * START_PERCENTAGE =?, END_PERCENTAGE = ? ? (PATH_ID, LINK_ID) Values (?,?) (PATH_ID, LINK_ID, SEQ_NO) Values (?,?,?) SET PATH_ID = ?, LINK_ID = ? + SET PATH_ID = ?, LINK_ID = ? , SEQ_NO = ? ? !?"?#H$H%?fINSERT INTO USER_SDO_NETWORK_METADATA (NETWORK, NETWORK_CATEGORY, GEOMETRY_TYPE, NETWORK_TYPE, NO_OF_HIERARCHY_LEVELS, LRS_TABLE_NAME, LRS_GEOM_COLUMN, NODE_TABLE_NAME, NODE_GEOM_COLUMN, LINK_TABLE_NAME, LINK_GEOM_COLUMN, LINK_DIRECTION, LINK_COST_COLUMN, NODE_COST_COLUMN, PATH_TABLE_NAME, PATH_GEOM_COLUMN, PATH_LINK_TABLE_NAME, PARTITION_TABLE_NAME NODE_DURATION_COLUMN LINK_DURATION_COLUMN SUBPATH_TABLE_NAME SUBPATH_GEOM_COLUMN PARTITION_BLOB_TABLE_NAME COMPONENT_TABLE_NAME?PDATE USER_SDO_NETWORK_METADATA SET NETWORK = ?, NETWORK_CATEGORY = ?, GEOMETRY_TYPE = ?, NETWORK_TYPE = ?, NO_OF_HIERARCHY_LEVELS = ?, LRS_TABLE_NAME = ?, LRS_GEOM_COLUMN = ?, NODE_TABLE_NAME = ?, NODE_GEOM_COLUMN = ?, LINK_TABLE_NAME = ?, LINK_GEOM_COLUMN = ?, LINK_DIRECTION = ?, LINK_COST_COLUMN = ?, NODE_COST_COLUMN = ?, PATH_TABLE_NAME = ?, PATH_GEOM_COLUMN = ?, PATH_LINK_TABLE_NAME = ?, PARTITION_TABLE_NAME = ? WHERE NETWORK = ?&? WHERE NETWORK = ? LOGICAL SPATIAL LRS_GEOMETRY'?(W UNDIRECTED DIRECTED)$*$ USER_SDO_NETWORK_USER_DATA 9( NETWORK, TABLE_TYPE, DATA_NAME, DATA_TYPE,DATA_LENGTH +? AND TABLE_TYPE = ? AND DATA_NAME = ?,- MDSYS.SDO_NUMBER_ARRAY./0 oracle/sql/ARRAY@1234 ORA-00054 Numeric Overflow=5 ) l. L. N.??67??89 SELECT * FROM ',NODE_ID) FROM SELECT NODE_ID, WHERE NODE_ID IN ( ,:;<=?? IN (?? ',LINK_ID) FROM SELECT LINK_ID, WHERE LINK_ID IN (>?@A?? WHERE PATH_ID IN (?? WHERE SUBPATH_ID IN (BC printArray for:D ) SELECT MAX(NODE_ID) FROM EF SELECT MAX(LINK_ID) FROM FF SELECT MAX(PATH_ID) FROM GF SELECT MAX(SUBPATH_ID) FROM HF , (oracle/spatial/network/NetworkAdapterSDOIJ java/lang/Object %oracle/spatial/network/NetworkAdapter java/lang/ClassNotFoundException java/lang/InstantiationException java/lang/IllegalAccessException java/sql/Connection getAutoCommit ()Z setAutoCommit (Z)V createStatement ()Ljava/sql/Statement; %oracle/spatial/network/NetworkUtility validateMetadataNames %oracle/spatial/network/NetworkManager validateNetworkSchema ;(Ljava/sql/Connection;Ljava/lang/String;)Ljava/lang/String; equalsIgnoreCase (Ljava/lang/String;)V trim length append -(Ljava/lang/String;)Ljava/lang/StringBuilder; toString isLRSGeometry isTopoGeometry getNodeCostColumn getLinkCostColumn java/sql/Statement close (Ljava/lang/Exception;)V x(Loracle/spatial/network/NetworkMetadata;Ljava/util/HashMap;Ljava/util/HashMap;Ljava/util/HashMap;Ljava/util/HashMap;I)V findInOutLinks findPathInfo findPathLinkInfo findHierarchyInfo !oracle/spatial/network/UserDataIO setPersistentFlag setReadOnly getWorkspace getSavepoint oracle/spatial/network/Network '(Ljava/lang/String;Ljava/lang/Object;)V getPartitionTableName (Z)Ljava/lang/String; equals (Ljava/lang/Object;)Z java/sql/PreparedStatement oracle/spatial/util/Util checkSQLName '(Ljava/lang/String;I)Ljava/lang/String; oracle/spatial/util/Logger debug 9(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)V prepareStatement 0(Ljava/lang/String;)Ljava/sql/PreparedStatement; executeQuery ()Ljava/sql/ResultSet; java/sql/ResultSet next getInt (I)I error 'oracle/spatial/network/UserDataMetadata getNodeDataNames ()[Ljava/lang/String; getLinkDataNames getPathDataNames toUpperCase contains getNodeDataType &(Ljava/lang/String;)Ljava/lang/String; getLinkDataType getPathDataType getBigDecimal *(Ljava/lang/String;)Ljava/math/BigDecimal; java/math/BigDecimal intValue (I)V doubleValue ()D (D)V getString getObject &(Ljava/lang/String;)Ljava/lang/Object; oracle/spatial/util/JDBCUtil getOracleSTRUCT '(Ljava/lang/Object;)Loracle/sql/STRUCT; load 8(Loracle/sql/STRUCT;)Loracle/spatial/geometry/JGeometry; getDate #(Ljava/lang/String;)Ljava/sql/Date; getTimestamp ((Ljava/lang/String;)Ljava/sql/Timestamp; getNodeGeomMetadata +()Loracle/spatial/network/GeometryMetadata; 'oracle/spatial/network/GeometryMetadata getTableName getColumnName getLinkDurationColumn getSrid columnExists <(Ljava/sql/Connection;Ljava/lang/String;Ljava/lang/String;)Z java/lang/System out Ljava/io/PrintStream; java/io/PrintStream println setFetchSize ((Ljava/lang/String;)Ljava/sql/ResultSet; getColumnNames )(Ljava/sql/ResultSet;)Ljava/util/HashSet; isSpatial isSDOGeometry isHierarchical getDouble (Ljava/lang/String;)D w(ILjava/lang/String;ZD[Loracle/spatial/network/Link;[Loracle/spatial/network/Link;Loracle/spatial/geometry/JGeometry;)V setHierarchyLevel setPartitionID setType setHierarchyInfo (Ljava/lang/Integer;[I)V setDuration setGeomID setMeasure containsUserData getUserDataMetadata +()Loracle/spatial/network/UserDataMetadata; get &(Ljava/lang/Object;)Ljava/lang/Object; put 8(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object; java/util/Map (I)Ljava/lang/Object; setGeometry &(Loracle/spatial/geometry/JGeometry;)V (I)D setCost oracle/spatial/network/MBR toSDOGeometry (I)Ljava/lang/String; setInt (II)V setString (ILjava/lang/String;)V getLinkGeomMetadata (I)Ljava/lang/StringBuilder; getNoOfDims isUndirected isDirected getHierarchyLevel v(ILjava/lang/String;Loracle/spatial/network/Node;Loracle/spatial/network/Node;ZDILoracle/spatial/geometry/JGeometry;)V setBidirected (DD)V getPathGeomMetadata getPathLinkTableName java/util/Set add remove ?(ILoracle/spatial/network/Node;Loracle/spatial/network/Node;Z)V setPathLinks (Ljava/util/Vector;)V setName getSubPathGeomMetadata tableExists *(Ljava/sql/Connection;Ljava/lang/String;)Z I(ILjava/lang/String;Ljava/lang/String;Loracle/spatial/network/Path;IDID)V keySet ()Ljava/util/Set; iterator ()Ljava/util/Iterator; java/util/Iterator hasNext ()Ljava/lang/Object; containsKey isReadOnly getMetadata *()Loracle/spatial/network/NetworkMetadata; getNodeTableName getLinkTableName getPathTableName getSubPathTableName isPersistent %oracle/spatial/network/NetworkFactory createNetworkTables getNDMSchemaInfo \(Ljava/sql/Connection;Loracle/spatial/network/Network;Ljava/lang/String;)Ljava/util/HashSet; getNetworkCache '()Loracle/spatial/network/NetworkCache; #oracle/spatial/network/NetworkCache isEmpty oracleSetSavepoint ()Loracle/jdbc/OracleSavepoint; isBatchAddingMode getAddMetadataArray +()[Loracle/spatial/network/NetworkMetadata; networkExists setExecuteBatch executeUpdate sendBatch getAddNodeArray ()[Loracle/spatial/network/Node; isTemporary getAddLinkArray ()[Loracle/spatial/network/Link; getAddPathArray ()[Loracle/spatial/network/Path; getAddSubPathArray #()[Loracle/spatial/network/SubPath; getAddUserDataEntryArray )()[Loracle/spatial/network/UserDataEntry; isBatchDeletingMode getDeleteSubPathArray getID getDeletePathArray getDeleteLinkArray getDeleteNodeArray getDeleteMetadataArray getDeleteUserDataEntryArray getNetwork getTableType isBatchModifyingMode getModifyMetadataArray getModifyNodeArray getModifyLinkArray size getCacheItem ,(I)Loracle/spatial/network/NetworkCacheItem; 'oracle/spatial/network/NetworkCacheItem isAddingMode isMetadata isNode isLink isPath isSubPath isUserDataEntry isDeletingMode isModifyingMode elementAt writeUserData rollback (Ljava/sql/Savepoint;)V getMessage commit clear (Ljava/sql/Connection;)V loadClass &(Ljava/lang/String;Z)Ljava/lang/Class; java/lang/Class newInstance indexOf substring (II)Ljava/lang/String; prepareCall 0(Ljava/lang/String;)Ljava/sql/CallableStatement; java/sql/CallableStatement execute getNodeDurationColumn clone setNull setDouble (ID)V (IILjava/lang/String;)V setObject (ILjava/lang/Object;)V setDate (ILjava/sql/Date;)V setTimestamp (ILjava/sql/Timestamp;)V getType getState getCost getNodeGeomColumn getGeometry %()Loracle/spatial/geometry/JGeometry; getGeomID getMeasure getParentNode ()Loracle/spatial/network/Node; getDuration getStartNode getEndNode getLinkLevel getLinkGeomColumn getStartMeasure getEndMeasure getParentLink ()Loracle/spatial/network/Link; isBidirected getPathGeomColumn isLogical getSubPathGeomColumn hasPathSeqNo isSimple getReferencePath ()Loracle/spatial/network/Path; getStartLinkIndex getEndLinkIndex getStartPercentage getEndPercentage getLinkArray getMetadataViewName getNoOfHierarchyLevels getLRSGeomMetadata getPartitionBlobTableName getComponentTableName getLength store M(Loracle/spatial/geometry/JGeometry;Ljava/sql/Connection;)Loracle/sql/STRUCT; oracle/sql/ArrayDescriptor createDescriptor E(Ljava/lang/String;Ljava/sql/Connection;)Loracle/sql/ArrayDescriptor; F(Loracle/sql/ArrayDescriptor;Ljava/sql/Connection;Ljava/lang/Object;)V values ()Ljava/util/Collection; java/util/Collection (Ljava/lang/CharSequence;)Z arraycopy *(Ljava/lang/Object;ILjava/lang/Object;II)V putAll (Ljava/util/Map;)V getNode (I)Loracle/spatial/network/Node; setParentNode (Loracle/spatial/network/Node;)V getLink (I)Loracle/spatial/network/Link; setParentLink (Loracle/spatial/network/Link;)V getPath (I)Loracle/spatial/network/Path; print setMaxNodeID setMaxLinkID setMaxPathID setMaxSubPathID getLogger 0(Ljava/lang/String;)Loracle/spatial/util/Logger; ,/ 0 12 34 5 D 64 5 B 74 84 9: ;<