laaqua.blogg.se

ResultSet rset = stmt.executeQuery ("select ENAME from EMP") Select the ENAME column from the EMP table

Statement stmt = conn.createStatement () You can put a database name after the sign in the connection URL. Props.put("_checksum_types_client", "( MD5 )") Props.put("_client", Service.getLevelString(level)) However, in the future, when multiple values are supported, specifying a list will result in a negotiation between the server and the client that determines which value is actually used.Įxample 10-1 is a complete class that sets data encryption and integrity parameters before connecting to a database to perform a query.Įxample 10-1 Setting Data Encryption and Integrity ParametersįileInputStream defaultStream = new FileInputStream(args) Currently, the JDBC Thin driver supports only one possible value in each case. The parentheses around the parameter values in the encryption_types_client and crypto_checksum_types_client settings allow for lists of values. OracleDataSource ods = new conn = ods.getConnection() Prop.put("_checksum_types_client", "( MD5 )") Prop.put("_checksum_client", "REQUESTED") The following example instantiates a Java properties object, uses it to set each of the parameters in Table 10-3, and then uses the properties object in opening a connection to the database: Use a Java properties object, that is, an instance of, to set the data encryption and integrity parameters supported by the JDBC Thin driver. Setting E ncryption and Integrity Parameters in Java