DatabaseProcApplicationCreatedLinks
sybsystemprocssp_ijdbc_getisolationlevels  14 déc. 14Defects Propagation Dependencies

1     
2     
3     /**
4      * sp_ijdbc_getisolationlevels
5      */
6     
7     
8     /**
9      * 

This procedure is used to determine which transaction isolation 10 * levels are supported by this ASE server. This proc is registered 11 * with the spt_mda table to be executed when the user calls: 12 * DatabaseMetaData.supportsTransactionIsolationLevel(int) . 13 * If the int specified is found in the row returned by this procedure, 14 * then that level is supported. The levels are indicated by using the 15 * integer mappings found in the java.sql.Connection interface. 16 *

19 * 21 *

This procedure accesses the @@version string, determines the 22 * version of ASE, and returns the appropriate levels. 23 *

WARNING: Should future versions of ASE support more transaction 24 * isolation levels (e.g., TRANSACTION_REPEATABLE_READ (4)), this proc 25 * must be modified. 26 */ 27 28 create or replace procedure sp_ijdbc_getisolationlevels as 29 30 select 8, 2, 1 31 32 return (0) 33



exec sp_procxmode 'sp_ijdbc_getisolationlevels', 'AnyMode'
go

Grant Execute on sp_ijdbc_getisolationlevels to public
go
RESULT SETS
sp_ijdbc_getisolationlevels_rset_001

DEFECTS
 MGTP 3 Grant to public sybsystemprocs..sp_ijdbc_getisolationlevels  
 MUCO 3 Useless Code Useless Brackets 32
 QNAM 3 Select expression has no name 1 30
 QNAM 3 Select expression has no name 2 30
 QNAM 3 Select expression has no name 8 30
 MRST 2 Result Set Marker 30
 MTR1 2 Metrics: Comments Ratio Comments: 88% 28
 MTR2 2 Metrics: Cyclomatic Complexity Cyclo: 2 = 1dec - 1exi + 2 28
 MTR3 2 Metrics: Query Complexity Complexity: 3 28

DEPENDENCIES
PROCS AND TABLES USED
writes table sybsystemprocs..sp_ijdbc_getisolationlevels_rset_001