Edit D:\app\Administrator\product\11.2.0\dbhome_1\jlib\oracle\sysman\vdb\VdbSession.class
?? /? ? ? ?? ? ? ? ? ? "? ! " # $ % & ' ( ) * + ,- . / 0 1 2 3 4 5 6 789 A?: A; < A< => 7?@ I? =A B C D EF GH I JK T? LMI ?NOP TQRJS 7T AUV W ,X YZ [\] h^_` =abc ?de fg hi hjk hlmno wp wqrst uvwxyz{|{} < ~ ?? ??? A?? 7? 7? 7? 7? 7? 7? 7? 7??? ?? 7?????? 7? ?? 7? ?? ??? G?? 7?? ??? L?? L? ??y? ?y? 7?????????? ??{? ????? 7? =???? ??? ??? ?? ??? ? A?? ? ? "??????? ?? 7? "?y}? ? ,????????? "???? ?^? ?? "Q?? ??? ????? ?? ? ??? ????? 7??????? ? ???y? } ? ?? ? !"#$% &' ()*+,-./0123456 ?789:;<=>?@ABCDE ?FG HI J K LMN O P QRS \T AUV \W \X \YZ[ \?\]^_ `abc m? md me mfgh ?i ?j?} kl mnopqrstuvwxy Lz{ |}~?????? ? ?????????? ? ?? ?? ???? ?? ??y?? ^ ? ? ? ? ? ? ? ? ? ? ? ? ??? ?????? ? 7? ??? ? ?? ?< ? ? ? ? ? ?? ,? ?? ?? ?U ?? ,??? ?? ?? ??? 7??? ?p????? ?? ???????? ? ?? ? =? } ????????? ?? ?? ? ? ? ????????? "? ????? AutoCommitSession I ConstantValue TransactionSession usingOrb Z idCounter jdbcProtocol Ljava/lang/String; m_sSessionClosedInFinalizer m_factory %Loracle/sysman/vdb/VdbSessionFactory; m_nCRSActive _crsLock Ljava/lang/Object; type id dbSid userCount attemptingReconnect credentials (Loracle/sysman/vxx/VxxTargetCredentials; m_servHost m_servPort m_servSID connectDescriptor connectString m_sessLocale m_sessLocaleMaybe m_realVersion m_compatibleVersion m_banner jdbcExt Loracle/sysman/vdb/VdbJdbcExt; connection Ljava/sql/Connection; connectMade connectionProperties Ljava/util/Properties; msgBundle .Loracle/sysman/emSDK/common/nls/MessageBundle; m_locale Ljava/util/Locale; m_NLSDateFormat m_NLSTimestampFormat m_OptionSupported [S m_filemapSupported S m_userHasSYSDBAPrivilege m_userHasAdditionalDbappsPrivs m_f &Loracle/sysman/vxx/VxxAuxFinalizeable; NOT_AVAILABLE NOT_MOUNTED ? NOT_OPEN ? NOT_EXISTS ? SYSDBA SYSOPER dbBlockSize m_oemUserName _spfileInfo 8Loracle/sysman/vdb/VdbCORBASessionPackage/VdbSPFileInfo; m_htArrayDescriptors Ljava/util/Hashtable; m_htStructDescriptors m_statementTable m_statementTrackingEnabled m_useURA SQL_TAGGING_ENABLED OEM_SQL_TAG <init> !(Loracle/sysman/vdb/VdbSession;)V Code LineNumberTable Exceptions P(Loracle/sysman/vxx/VxxTargetCredentials;Loracle/sysman/vdb/VdbSessionFactory;)V c(Loracle/sysman/vxx/VxxTargetCredentials;Loracle/sysman/vdb/VdbSessionFactory;Ljava/lang/String;Z)V Q(Loracle/sysman/vxx/VxxTargetCredentials;Loracle/sysman/vdb/VdbSessionFactory;Z)V doConstruct setFactory ((Loracle/sysman/vdb/VdbSessionFactory;)V setCRSActive (Z)V getCRSActive ()Z incrIdCounter ()I getLocale ()Ljava/util/Locale; getNLSDateFormat ()Ljava/lang/String; getNLSTimestampFormat getMessageBundle 0()Loracle/sysman/emSDK/common/nls/MessageBundle; getSessionLocale setStatementTracking isStatementTrackingEnabled readNLSDateFormat ()V setSessionLocale (Ljava/lang/String;)V processError (Ljava/sql/SQLException;)V establishConnection Q(Loracle/sysman/vxx/VxxTargetCredentials;Ljava/lang/String;)Ljava/sql/Connection; c(Loracle/sysman/vxx/VxxTargetCredentials;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection; checkForWarnings (Ljava/sql/SQLWarning;)Z close disconnect isConnected getArrayDescriptor 0(Ljava/lang/String;)Loracle/sql/ArrayDescriptor; getStructDescriptor 1(Ljava/lang/String;)Loracle/sql/StructDescriptor; getARRAY C(Loracle/sql/ArrayDescriptor;[Ljava/lang/Object;)Loracle/sql/ARRAY; 2(Loracle/sql/ArrayDescriptor;[I)Loracle/sql/ARRAY; 2(Loracle/sql/ArrayDescriptor;[J)Loracle/sql/ARRAY; getCredentials *()Loracle/sysman/vxx/VxxTargetCredentials; getSessionId getServerHostName getServerPort getServerSID getInstanceHostName getInstanceName getDatabaseProductName getDatabaseCompatibleVersion getDatabaseRealVersion getDatabaseProductVersion compareDatabaseProductVersionTo (Ljava/lang/String;)I "compareDatabaseCompatibleVersionTo compareVersion '(Ljava/lang/String;Ljava/lang/String;)I getDatabaseParameter &(Ljava/lang/String;)Ljava/lang/String; getDBBlockSize getDatabaseProductOption (Ljava/lang/String;)Z isOptionSupported (S)Z isItemInstalled getSupportedOptions (Z)[S setSupportedOption (SS)V getDatabaseBannerText isEnterpriseEdition getSPFileInfo :()Loracle/sysman/vdb/VdbCORBASessionPackage/VdbSPFileInfo; resetCache getBaseBanner checkSysPrivs isRealConnection incrUserCount decrUserCount getUserCount getUsername getPassword getService getRole getLoginMode getConnectString supportsQueryBatchOperations getQueryBatchSize setQueryBatchSize (I)V supportsDMLBatchOperations createStatement 4(Ljava/lang/String;)Loracle/sysman/vdb/VdbStatement; "()Loracle/sysman/vdb/VdbStatement; createCallableStatement <(Ljava/lang/String;)Loracle/sysman/vdb/VdbCallableStatement; setSQLTaggingOn (Z)Z startupDB (Ljava/lang/String;ZZ)V? (Ljava/lang/String;ZZI)V shutdownDB (II)V getArchiveDetails ()[Ljava/lang/String; archive (IILjava/lang/String;)V extractTripletFromDescriptor buildConnectionInformation =(Loracle/sysman/vxx/VxxTargetCredentials;Ljava/lang/String;)V O(Loracle/sysman/vxx/VxxTargetCredentials;Ljava/lang/String;Ljava/lang/String;)V getTnsDescriptor getConnectDescriptor isJavaOptionSupported isFilemapSupported resetCacheForDynamicParameters hasAdditionalDbappsPrivs hasCMPrivs userHasSYSDBAPrivilege doFinalization setNextFinalizeable )(Loracle/sysman/vxx/VxxAuxFinalizeable;)V getNextFinalizeable (()Loracle/sysman/vxx/VxxAuxFinalizeable; finalize getDatabaseState processExceptionToSetDBState (J)I setConnection cancelUPI setOemUserName getOemUserName logSQL isSpatialViewExist forcedClose isVersioningInstalled replicateOptionCheck olapOptionCheck xdbOptionCheck statementClosed #(Loracle/sysman/vdb/VdbStatement;)V forceStatementClose (Ljava/sql/Statement;)V _getJdbcExt ()Loracle/sysman/vdb/VdbJdbcExt; _started _shutdowned <clinit> SourceFile VdbSession.javaWs java/lang/Object"#$ %&'()*+,-0??i56 dd-Mon-yyyy7 dd-Mon-yyyy HH:MI:SS AM89:;<=>?@KLMN java/util/HashtableOPQPRPSTUhijklkmn34./?e !ok???k12?kqepc??W]?? java/lang/StringBuffer &VdbSession construction; credentials: ???k?? java/lang/Throwable?_\xz??xy Vdbm`afg java/util/Properties? internal_logon sysdba Connecting as sysoper #VdbSession.setFactory: factory is >? <X NLS_DATE_FORMAT ? )oracle/sysman/dateFormat/OracleDateFormatWu 5oracle/sysman/dateFormat/BadOracleDateFormatException NLS_DATE_FORMAT error ?u NLS_TIMESTAMP_FORMAT NLS_TIMESTAMP_FORMAT error VdbSession.setSessionLocale: h *VdbSession.setSessionLocale: using defaultk )VdbSession.setSessionLocale - nlsLocale: java/util/StringTokenizer _Wk java/util/NoSuchElementException "ALTER SESSION SET NLS_LANGUAGE = " "rs %ALTER SESSION SET NLS_DATE_FORMAT = ' ' NLS_TERRITORY = "??}s?? java/sql/SQLExceptiongk $VdbSession.processError: errorCode >? #VdbSession.processError: errorMsg > !"#$%&' (VdbSession.processError: lost connection ,oracle/sysman/vdb/VdbLostConnectionExceptionW ( : ..../.... @ /VdbSession.processError: invalid connect string !oracle/sysman/vdb/VdbSQLException)W*+?,-? 2003. 2VdbSession.processError: database connection error/ VdbSession.establishConnection?? GVdbSession.establishConnection: attempting to connect to service with > user0 password?12345{|678 ;VdbSession.establishConnection: connected to service with >9:k .VdbSession.establishConnection: using driver >;k <kvw !select distinct SID from V$MYSTAT=>?u?@eABC?D VdbSession.checkforWarnings 7VdbSession.checkForWarnings: Connection warnings found 'VdbSession.checkForWarnings: SQLState >EFk &VdbSession.checkForWarnings: Message > %VdbSession.checkForWarnings: Vendor >G5 VdbSession.close; isConnected: e?H ; userCount: ?g?gIJKLeMN oracle/sysman/vdb/VdbStatement .***WARNING: VdbSession: statement not closed: Ok??Ps !VdbSession.close: CLOSED SESSION ?gQR #VdbSession.close: RELEASED SESSION OVdbSession.close: session not really closed since session still being used by > < user(s) $VdbSession.disconnect; isConnected: ,VdbSession.disconnect: DISCONNECTED SESSION ZVdbSession.disconnect: session not really disconnected since session still being used by > VdbSession.isConnected )VdbSession.Fetching Array desc of type : S oracle/sql/StructDescriptor java/lang/RuntimeException / type name is already defined as an struct type oracle/sql/ArrayDescriptorTU *VdbSession.Fetching Struct desc of type : . type name is already defined as an array typeTV oracle/sql/ARRAYWW VdbSession.getCredentials #VdbSession.getSessionId returning > java/lang/StringX?Y?kZ? java/lang/NumberFormatException?u )select distinct HOST_NAME from V$INSTANCE[, -select distinct INSTANCE_NAME from V$INSTANCE\ !VdbSession.getDatabaseProductName?k Oracle .VdbSession.getDatabaseProductName: returning > compatible???k !VdbSession.getDatabaseRealVersion SELECT VERSION FROM V$INSTANCE ]^_=` 8.0.0.0.0 oracle/sysman/vdb/VdbJdbcExtaub .cd java/lang/Exception 2002 .VdbSession.getDatabaseRealVersion: returning > *VdbSession.compareDatabaseProductVersionTo?k 6VdbSession.compareDatabaseProductVersionTo comparing > < to >?? 7VdbSession.compareDatabaseProductVersionTo: returning > -VdbSession.compareDatabaseCompatibleVersionTo?k 9VdbSession.compareDatabaseCompatibleVersionTo comparing > :VdbSession.compareDatabaseCompatibleVersionTo: returning > ,select value from v$parameter where name = ' value[? VdbSession.getDBBlockSize :SELECT value FROM v$parameter WHERE name = 'db_block_size' ************* dbBlockSize = 4VdbSession.getDBBlockSize: dbBlockSize>< has value > #VdbSession.getDatabaseProductOptionek 3SELECT VALUE FROM V$OPTION WHERE UPPER(PARAMETER)=?fg VALUE TRUE -VdbSession.getDatabaseProductOption: option > < has value > VdbSession.isOptionSupported?? 8.0?? 8.0.4 'PARTITIONING' ,'OBJECTS' ,'BIT-MAPPED INDEXES' ,'DATABASE QUEUING' ",'INCREMENTAL BACKUP AND RECOVERY' ,'PARALLEL BACKUP AND RECOVERY' 8.1.7 ,'PARALLEL SERVER' ,'REAL APPLICATION CLUSTERS' ,'PARALLEL QUERY' ,'PARALLEL EXECUTION' PARTITIONING java/lang/IntegerW? OBJECTS BIT-MAPPED INDEXES DATABASE QUEUING INCREMENTAL BACKUP AND RECOVERY PARALLEL BACKUP AND RECOVERY PARALLEL SERVER REAL APPLICATION CLUSTERS PARALLEL QUERY PARALLEL EXECUTION 8.1.6 ,'SPATIAL' SPATIAL GSELECT UPPER(PARAMETER), VALUE FROM V$OPTION WHERE UPPER(PARAMETER)IN ( )hg FALSE?e 8.2?s?s?e SQL Exception: 8.1.5?e?s?? VdbSession.getDatabaseBannerText java/util/VectorW?ig eSELECT lower(parameter) FROM V$OPTION where value='TRUE' and lower(parameter) not like '%procedural%'jkelg 3001 , 3002 3003 3004m -VdbSession.getDatabaseBannerText: returning > Enterprise Edition 6oracle/sysman/vdb/VdbCORBASessionPackage/VdbSPFileInfonop 9.0.1 >select value, isdefault from v$parameter where name = 'spfile'qrse?s 9SELECT BANNER FROM V$VERSION WHERE BANNER LIKE '%Oracle%'?g 9.0 Rselect sign(count(*)) from session_privs where privilege = 'SELECT ANY DICTIONARY' VdbSession.checkSysPrivs Mselect sign(count(*)) from session_privs where privilege = 'SELECT ANY TABLE' O7_DICTIONARY_ACCESSIBILITY Kselect sign(count(*)) from session_roles where role = 'SELECT_CATALOG_ROLE' VdbSession.incrUserCount VdbSession.decrUserCount VdbSession.getUserCount "VdbSession.getUsername returning > "VdbSession.getPassword returning > !VdbSession.getService returning >t VdbSession.getRole returning >?k NORMAL #VdbSession.getLoginMode returning > jdbc:oracle: 'VdbSession.getConnectString returning > oracle/jdbc/OracleConnectionug 4VdbSession.supportsQueryBatchOperations: returning > )VdbSession.getQueryBatchSize: returning >?evwxy? ;VdbSession.setQueryBatchSize: setting query batch size to > BVdbSession.setQueryBatchSize: query batch operations not supportedzg 2VdbSession.supportsDMLBatchOperations: returning > VdbSession.createStatement: >VW{|}W~ %VdbSession.createCallableStatement: > &oracle/sysman/vdb/VdbCallableStatemente 2010???k?k?g???s????~s???s?? 1VdbSession: Exception from ShutdownDB with error for session ID: ?g 1013 1017 00106 3114 6VdbSession: Exception from ShutdownDB for session ID: ????? ?VdbSession.getArchiveDetails: failed to get archive information java/lang/Boolean?Wc??????????????????????? thin:???? 2000? oracle/sysman/vdn/VdnTarget oracle_sysman_database??? oracle/sysman/vdn/VdnException VdbSession.isJavaOptionSupported TSELECT count(*) FROM sys.dba_objects WHERE object_type = 'JAVA CLASS' and rownum < 2?kq? VdbSession.isFilemapSupported 9.0.2 !SELECT lib_idx from v$map_library Fselect sign(count(*)) from session_roles where role = 'CM_SELECT_ROLE' internal ******* doFinalization :????k? ??? SELECT status FROM v$instance STARTED MOUNTED OPEN 4select value from v$parameter where name = 'db_name' "select thread# from v$recovery_log select user from dual??? Exception list : tu *VdbSession.setConnection: VdbSQLException 4VdbSession.setConnection: VdbLostConnectionException dSELECT 1 FROM dba_views WHERE owner = 'MDSYS' and view_name = 'ALL_SDO_GEOM_METADATA' and ROWNUM = 1 %VdbSession.forcedClose; isConnected: #SELECT DBMS_WM.getVersion from dual 6SELECT 1 FROM dba_views WHERE view_name = 'DBA_REPCAT' 9.2 ,select 1 from dba_users where username='XDB'?S?s )*** JDBC SESSION CLOSED IN FINALIZER! *** /* OracleOEM */ oracle/sysman/vdb/VdbSession $oracle/sysman/vxx/VxxAuxFinalizeable "java/lang/IllegalArgumentException java/util/Locale getDefault #oracle/sysman/vdb/VdbSessionFactory protocol oracle/sysman/vdb/Vdb SESSION_DEBUG append ,(Ljava/lang/String;)Ljava/lang/StringBuffer; toString oracle/sysman/vxx/vxxt/VxxtTRACE out (Ljava/lang/String;I)V VERBOSE_SESSION_DEBUG (Ljava/lang/Object;)V ,oracle/sysman/emSDK/common/nls/MessageBundle T(Ljava/lang/String;Ljava/util/Locale;)Loracle/sysman/emSDK/common/nls/MessageBundle; &oracle/sysman/vxx/VxxTargetCredentials role equalsIgnoreCase put 8(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object; ,(Ljava/lang/Object;)Ljava/lang/StringBuffer; releaseCRSSession oracle/net/common/NetGetEnv get equals (Ljava/lang/Object;)Z oracle/sysman/vxx/VxxLocale &(Ljava/lang/String;)Ljava/util/Locale; oracle/sysman/vxx/VxxNLSLocale getInstance "()Loracle/sysman/vxx/VxxNLSLocale; getNLSLocale &(Ljava/util/Locale;)Ljava/lang/String; '(Ljava/lang/String;Ljava/lang/String;)V nextToken java/sql/Connection ()Ljava/sql/Statement; java/sql/Statement execute getErrorCode getMessage (I)Ljava/lang/StringBuffer; OracleInternalErrorHostDef OracleInstanceTerminated OracleProcessTerminated OracleOperationBlock OracleDatabaseNotStarted OracleEndOfCommChannel OracleTnsLostContact OracleTnsUnableToConnect OracleInvalidConnectString InvalidConnectString )(Ljava/lang/String;IILjava/lang/String;)V InvalidSID (I)Ljava/lang/String; indexOf '(Ljava/lang/String;Z)Ljava/lang/String; DatabaseConnectionError username java/sql/DriverManager getConnection ?(Ljava/lang/String;Ljava/util/Properties;)Ljava/sql/Connection; getWarnings ()Ljava/sql/SQLWarning; getMetaData ()Ljava/sql/DatabaseMetaData; VERBOSE_DEBUG java/sql/DatabaseMetaData getURL getDriverName getDriverVersion executeQuery ((Ljava/lang/String;)Ljava/sql/ResultSet; java/sql/ResultSet next getInt (I)I OracleNoSuchTableOrView (Ljava/lang/Exception;)V java/sql/SQLWarning getSQLState getNextWarning (Z)Ljava/lang/StringBuffer; elements ()Ljava/util/Enumeration; java/util/Enumeration hasMoreElements nextElement ()Ljava/lang/Object; getSQL clear releaseSession (IZ)V &(Ljava/lang/Object;)Ljava/lang/Object; createDescriptor E(Ljava/lang/String;Ljava/sql/Connection;)Loracle/sql/ArrayDescriptor; F(Ljava/lang/String;Ljava/sql/Connection;)Loracle/sql/StructDescriptor; F(Loracle/sql/ArrayDescriptor;Ljava/sql/Connection;Ljava/lang/Object;)V oracle/sysman/vdb/VdbUtil ((Ljava/lang/String;[Ljava/lang/String;)V parseInt getString DEBUG prepareStatement 0(Ljava/lang/String;)Ljava/sql/PreparedStatement; java/sql/PreparedStatement ()Ljava/sql/ResultSet; getDatabaseDetails versionNum releaseNum updateNum toUpperCase setString (ILjava/lang/String;)V intValue length addElement isEmpty size banner isSupported location isDefault valueOf '(Ljava/lang/String;)Ljava/lang/Boolean; booleanValue service getDefaultRowPrefetch java/lang/Math max (II)I setDefaultRowPrefetch getDefaultExecuteBatch H(Loracle/sysman/vdb/VdbSession;Ljava/lang/String;Ljava/sql/Connection;)V setLocale (Ljava/util/Locale;)V 6(Loracle/sysman/vdb/VdbSession;Ljava/sql/Connection;)V isClosed :(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;I)V N(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;ILjava/lang/String;ZZ)V O(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;ILjava/lang/String;ZZI)V ;(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;II)V <(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;III)V MissingNum archiveMode autoArchive destination oldestLogFile currentLogFile nextLogFile buildConnectURL getVdn ()Loracle/sysman/vdn/Vdn; buildConnectDescriptor `(Ljava/lang/String;Ljava/lang/String;ZZ[Ljava/lang/String;Ljava/lang/String;Z)Ljava/lang/String; M(Ljava/lang/String;Ljava/lang/String;ZZ[Ljava/lang/String;)Ljava/lang/String; 'oracle/sysman/vxx/VxxTargCredComparator getComparator %()Loracle/bali/share/sort/Comparator; getRepCredentials !oracle/bali/share/sort/Comparator compare '(Ljava/lang/Object;Ljava/lang/Object;)I buildAddressDescriptor findInTNSNAMES OracleTnsNameNotResolved oracle/sysman/vdn/Vdn getTNSAddress 1(Loracle/sysman/vdn/VdnTarget;)Ljava/lang/String; trim '(Ljava/lang/String;)Ljava/lang/Integer; getClass ()Ljava/lang/Class; java/lang/Class getName finalizerOut !oracle/sysman/vxx/VxxAuxFinalizer addFinalizeable oracleError remove! 6 ! " # $ % & ' ( ) * + ,- ./ 0 12 34 56 7 8 9: ;<