EasyManuals Logo

IBM DB2 User Manual

IBM DB2
585 pages
To Next Page IconTo Next Page
To Next Page IconTo Next Page
To Previous Page IconTo Previous Page
To Previous Page IconTo Previous Page
Page #472 background imageLoading...
Page #472 background image
// Set the delegated credential
properties.put("securityMechanism",
new String("" +
com.ibm.db2.jcc.DB2BaseDataSource.KERBEROS_SECURITY + ""));
// Set security mechanism to
// Kerberos
String url = "jdbc:db2://mvs1.sj.ibm.com:5021/san_jose";
// Set URL for the data source
Connection con = DriverManager.getConnection(url, properties);
// Create the connection
For the DataSource interface: If you create and deploy the DataSource object, set
the Kerberos server, delegated credential, and security mechanism by invoking the
DataSource.setKerberosServerPrincipal, DataSource.setGssCredential, and
DataSource.setSecurityMechanism methods after you create the DataSource object.
For example:
DB2SimpleDataSource db2ds = new com.ibm.db2.jcc.DB2SimpleDataSource();
// Create the DataSource object
db2ds.setDriverType(4); // Set the driver type
db2ds.setDatabaseName("san_jose"); // Set the location
db2ds.setServerName("mvs1.sj.ibm.com"); // Set the server name
db2ds.setPortNumber(5021); // Set the port number
db2ds.setKerberosServerPrincipal(
"sample/srvlsj.ibm.com@SRVLSJ.SJ.IBM.COM");
// Set the Kerberos server
db2ds.setGssCredential(delegatedCredential);
// Set the delegated credential
db2ds.setSecurityMechanism(
com.ibm.db2.jcc.DB2BaseDataSource.KERBEROS_SECURITY);
// Set security mechanism to
// Kerberos
Related tasks
“Connecting to a data source using the DataSource interface” on page 15
“Connecting to a data source using the DriverManager interface with the IBM
Data Server Driver for JDBC and SQLJ” on page 11
“Creating and deploying DataSource objects” on page 19
Related reference
“Properties for the IBM Data Server Driver for JDBC and SQLJ” on page 201
IBM Data Server Driver for JDBC and SQLJ trusted context support
The IBM Data Server Driver for JDBC and SQLJ provides methods that allow you
to establish and use trusted connections in Java programs.
Trusted connections are supported for:
v IBM Data Server Driver for JDBC and SQLJ type 4 connectivity to DB2
Database for Linux, UNIX, and Windows Version 9.5 or later, and DB2 for z/OS
Version 9.1 or later
v IBM Data Server Driver for JDBC and SQLJ type 2 connectivity to DB2 for z/OS
Version 9.1 or later
A three-tiered application model consists of a database server, a middleware server
such as WebSphere Application Server, and end users. With this model, the
middleware server is responsible for accessing the database server on behalf of end
users. Trusted context support ensures that an end user’s database identity and
database privileges are used when the middleware server performs any database
requests on behalf of that end user.
456 Application Programming Guide and Reference for Java

Table of Contents

Questions and Answers:

Question and Answer IconNeed help?

Do you have a question about the IBM DB2 and is the answer not in the manual?

IBM DB2 Specifications

General IconGeneral
DeveloperIBM
Initial Release1983
LicenseProprietary
Written inC, C++
CategoryDatabase Management System (RDBMS)
Operating SystemLinux, Windows
Programming LanguagesC, C++
Data ModelsRelational
EditionsCommunity, Standard, Advanced
Key Featureshigh availability, scalability