Click OK | Sun Microsystems 820433510 specification

Working with JDBC Connection Pools

9Click OK.

▼Creating a JDBC Connection Pool and JDBC Resource Using the CLI

1Use the asadmin create-jdbc-connection-poolcommand to create a JDBC connection pool.

Sample command to create a JDBC connection pool:

asadmin create-jdbc-connection-pool --datasourceclassname oracle.jdbc.pool.OracleDataSource --restype javax.sql.DataSource --property user=dbuser:password=dbpassword:url="jdbc:oracle\:thin\:@localhost\:1521\:ORCL" myjdbc_oracle-pool

2Use the asadmin create-jdbc-resourcecommand to create a JDBC resource assicated with this connection pool.

Sample command to create a JDBC resource:

asadmin create-jdbc-connection-pool --connectionpoolid myjdbc_oracle-pool jdbc/oracle-resource

3Test the connection settings are correct by pinging the connection pool using the asadmin ping-connection-pool command.

asadmin ping-connection-pool myjdbc_oracle-pool

4To edit JDBC connection pool properties, use the asadmin list, get, and set commands.

Sample list command to list a JDBC connection pool: asadmin list myjdbc_oracle-pool

The sample output of this command: domain.resources.jdbc-connection-pool.oracle-pool Sample get command to list all properties of a JDBC connection pool: asadmin list myjdbc_oracle-pool

Sample get command to get all properties of a JDBC connection pool:

asadmin get domain.resources.jdbc-connection-pool.myjdbc_oracle-pool Sample get command to set a properties of a JDBC connection pool:

asadmin set domain.resources.jdbc-connection-pool.myjdbc_oracle-pool.steady-pool-size=20

Chapter 3 • JDBC Resources

47

Image 47

Sun Microsystems 820433510 manual Click OK

Contents

Sun Microsystems, Inc Network Circle Santa Clara, CA Sun GlassFish Enterprise Server 2.1 Administration Guide 090122@21808 Contents Jdbc Resources Java Business Integration Foreign JMS Providers Accessing Remote ServersConfiguring JMS Provider Properties IBM Informix Type 4 Driver CloudScape 5.1 Type 4 Driver Web and EJB Containers Configuring Security 127 153 141149 Virtual Servers 149 Http Listeners 150 163 What is the ORB? 162 Iiop Listeners158 161 219 About Management Rules 215 Configuring Management Rules 216Tuning the JVM Settings 219 215 244 Asadmin UtilityProfiler and SSL Commands 231Page Figures Page JVM Statistics for Java SE Runtime 189 Tables Deployment Commands 239 Remote Commands Required Options 234Server Lifecycle Commands 237 List and Status Commands 238 Examples Page Table P-1Books in the Enterprise Server Documentation Set PrefaceSun GlassFish Enterprise Server Documentation Set Table P-2Default Paths and File Names Default Paths and File Names Table P-3Typographic Conventions Symbol ConventionsSymbol Conventions Typographic Conventions Sun Welcomes Your Comments Documentation, Support, and TrainingThird-Party Web Site References This section contains the following topics Enterprise Server OverviewEnterprise Server Overview and Concepts Enterprise Server Overview Http//hostnameport Tools for AdministrationAdmin Console For example JConsole Command-line Interface asadmin UtilityTo list the commands available within asadmin Domain Domain Administration Server DASEnterprise Server Concepts Usage Profiles 1Features Available for Each Profile Node Agent Features Available for Each ProfileCluster 1Enterprise Server Instance Server Instance 2Enterprise Server Listeners that Use Ports Ports in the Enterprise Server Http//hostname5000 Basic Enterprise Server CommandsCreating a Domain Starting the Domain Deleting a DomainListing Domains Restarting the Domain Starting the Default Domain on WindowsStopping the Default Domain on Windows Stopping the Domain Starting a Node Agent Starting a ClusterStopping a Cluster Creating a Node Agent Restarting an Instance Stopping a Node AgentStarting an Instance Stopping an Instance To migrate the DAS Recreating the Domain Administration Server Change Page JBI Components Service EnginesJava Business Integration JBI Environment JBI Component Loggers Binding Components Service Assemblies JBI Descriptors Shared Libraries Jdbc Resources Jdbc Resources How Jdbc Resources and Connection Pools Work Together Jdbc Connection Pools Setting Up Database Access Creating a Jdbc Connection Pool Working with Jdbc Connection Pools Click OK Editing a Jdbc Connection Pool Change connection validation settings By calling the con.getAutoCommit and con.getMetaData methods Editing Jdbc Connection Pool Advanced Attributes Creation Retry Attempts is greater than Configurations for Specific Jdbc Drivers Configurations for Specific Jdbc Drivers DataSource Classname Specify one of the following Java DB Type 4 Driver DataSource Classname com.sun.sql.jdbcx.db2.DB2DataSource Sun GlassFish Jdbc Driver for DB2 Databases Sun GlassFish Jdbc Driver for Microsoft SQL Server Databases DataSource ClassnameSpecify one of the following IBM DB2 8.1 Type 2 DriverDataSource Classname com.ibm.db2.jcc.DB2SimpleDataSource DeferPrepares Set to false Com.mysql.jdbc.jdbc2.optional.MysqlDataSource MySQL Type 4 DriverInet Oraxo Jdbc Driver for Oracle 8.1.7 and 9.x Databases Jdbcinetoralocalhost1521payrolldb Inet Merlia Jdbc Driver for Microsoft SQL Server DatabasesDataSource Classname com.inet.ora.OraDataSource DataSource Classname com.inet.tds.TdsDataSource DataSource Classname com.inet.syb.SybDataSource Inet Sybelux Jdbc Driver for Sybase Databases Jdbcoracleoci@localhost1521customerdb OCI Oracle Type 2 Driver for Oracle 8.1.7 DatabasesJdbcoraclethin@localhost1521customerdb DataSource Classname com.ibm.db2.jcc.DB2DataSource IBM Informix Type 4 DriverCloudScape 5.1 Type 4 Driver Page JMS Resources Configuring Java Message Service Resources Relationship Between JMS Resources and Connector Resources JMS Physical Destinations JMS Connection FactoriesJMS Destination Resources Configuring JMS Provider Properties Foreign JMS Providers Accessing Remote Servers Resource Adapter Properties Configuring the Generic Resource Adapter False Foreign JMS Providers ManagedConnectionFactory Properties Activation Spec Properties Administered Object Resource Properties Configuring Java Message Service Resources Message causes a runtime exception Creating a JavaMail Session Configuring JavaMail Resources Creating a JavaMail Session Jndi Resources Java EE Naming Services Naming References and Binding Information 1JNDI Lookups and Their Associated References Using Custom ResourcesUsing External Jndi Repositories and Resources Using External Jndi Repositories and Resources An Overview of Connectors Connector Resources Specify this name when creating a connector resource Managing Connector Connection PoolsTo Create a Connector Connection Pool Create-connector-connection-pool To Edit a Connector Connection Pool Same transaction level as that specified in resource To Edit Connector Connection Pool Advanced Attributes Pool. Default value is false To Edit Connection Pool Properties To Delete a Connector Connection PoolTo create security maps for connector connection pools To Edit Security Maps for Connector Connection Pools Delete-connector-connection-pool Managing Connector ResourcesTo Set Up EIS Access To Create a Connector Resource Create-connector-resource To Edit a Connector ResourceTo Delete a Connector Resource Delete-connector-resource Managing Administered Object ResourcesTo Configure the Connector Service To Create an Administered Object Resource Delete-admin-object To Edit an Administered Object ResourceTo Delete an Administered Object Resource Create-admin-object SIP Servlet Container Web and EJB Containers Editing SIP Container Session Properties Editing the Properties of the SIP ContainerEditing SIP Container General Attributes Editing SIP Container Session Manager Properties Web ContainerEJB Container Page Understanding Application and System Security Configuring Security Tools for Managing Security Asadmin create-password-alias --user admin jms-password Managing Security of PasswordsEncrypting a Password in the domain.xml File Asadmin create-password-alias --user admin alias-name Restart the Enterprise Server Protecting Files with Encoded PasswordsChanging the Master Password Restart the Enterprise Server for the relevant domain Working with the Master Password and Keystores Changing the Admin Password 1Enterprise Server Authentication Methods About Authentication and AuthorizationAuthenticating Entities Verifying Single Sign-On Authorizing UsersSpecifying Jacc Providers Understanding Users, Groups, Roles, and Realms Configuring Message Security Groups Users Realms Roles Create a Jdbc realm To Configure a Jdbc Realm for a Web, EJB Application Following topics are discussed in this section Introduction to Certificates and SSLAbout Digital Certificates About Certificate Chains About Secure Sockets Layer About Ciphers Using Name-based Virtual Hosts About Certificate Files About Firewalls Changing the Location of Certificate Files Using Java Secure Socket Extension Jsse ToolsUsing the keytool Utility Delete a certificate from a keystore of type JKS Display certificate information from a keystore of type JKS Generating a Certificate Using thekeytool Utility Certificate was added to keystore Saving cacerts.jks Deleting a Certificate Using thekeytool Utility Keytool -delete Using Network Security Services NSS ToolsStorepass password Certutil -L -d $CERTDBDIR Using the certutil UtilityVerify the certificates generated in the previous bullet Display available certificates Move a certificate from an NSS database to JKS format Delete a certificate from an NSS certificate database List available token modules in an NSS store Modutil -list -dbdir $admin.domain.dir/$admin.domain/configAdd a new PKCS11 module or token Delete a PKCS11 module from an NSS store About Configuring Hardware Crypto Accelerators Using Hardware Crypto Accelerator With Enterprise Server Modutil -list -dbdir Asnssdb Configuring PKCS#11 TokensStandard output will look similar to the following This section describes the following topics Managing Keys And Certificates Standard output will be similar to the following Listing Keys and Certificates Working With Private Keys and Certificates Configuring J2SE 5.0 PKCS#11 ProvidersConfiguration for the SCA 1000 hardware accelerator Name=HW1000 Library=/opt/SUNWconn/crypto/lib/libpkcs11.so Property name=mytoken value=&InstallDir/mypkcs11.cfg 126 Overview of Message Security Configuring Message Security Assigning Message Security Responsibilities System AdministratorUnderstanding Message Security in the Enterprise Server About Username Tokens Application DeployerApplication Developer About Message Protection Policies About Digital SignaturesAbout Encryption Response Policy Glossary of Message Security Terminology Securing a Web Service Securing the Sample Application Configuring the Enterprise Server for Message SecurityConfiguring Application-Specific Web Services Security Actions of Request and Response Policy Configurations After You Finish Configuring Other Security FacilitiesConfiguring a JCE Provider Security.provider.1=sun.security.provider.Sun Save and close the file Enabling Providers for Message Security Message Security Setup To specify the default client provider Configuring the Message Security ProviderTo specify the default server provider Enabling Message Security for Application Clients Creating a Message Security Provider Response-policy Further Information Diagnostic Service Framework Configuring the Diagnostic ServiceWhat is the Diagnostic Framework? Generating a Diagnostic Report About Transactions What is a Transaction?Transactions Transactions in Java EE Technology What is a Transaction? on Configuring Transactions on Workarounds for Specific Databases Admin Console Tasks for TransactionsConfiguring Transactions This section explains how to configure transaction settings Set any needed properties To set a transaction timeout value To set the location of the transaction logs To set the keypoint interval Default value is Virtual Servers Configuring the Http Service Http Listeners Configuring the Http Service 151 152 Overview of Web Services Managing Web Services Java EE Web Service Standards Web Services Standards Deploying Web Services Deploying and Testing Web Services Web Services Security Using Web Services RegistriesViewing Deployed Web Services Testing Web Services Adding a Registry Publishing a Web Service to a Registry Transforming Messages with Xslt Filters Monitoring Web Services Monitoring Web Service Messages Viewing Web Service Statistics 160 An Overview of the Object Request Broker Configuring the Object Request Broker Iiop Listeners Configuring the ORBWhat is the ORB? Managing Iiop Listeners Thread Pools Working with Thread Pools Log Records Configuring LoggingAbout Logging 1Enterprise Server Logger Namespaces Logger Namespace Hierarchy JTS Enterprise Server Logger Namespaces Configuring Log Levels Configuring LoggingConfiguring General Logging Settings Details Viewing Server Logs171000.000 ThreadID=13 Monitoring in the Enterprise Server Monitoring Components and ServicesAbout Monitoring Following sections describe these sub-trees Overview of MonitoringAbout the Tree Structure of Monitorable Objects Applications Tree Http Service Tree Resources Tree Connector Service TreeJMS Service Tree Orb Connection-managers Connection-manager-1 About Statistics for Monitored Components and ServicesORB Tree Thread Pool Tree 1EJB Statistics EJB Container Statistics 3EJB Session Store Statistics 2EJB Method Statistics EJB Session Store Statistics 5EJB Cache Statistics 4EJB Pool Statistics 7Web Container Servlet Statistics 6Timer StatisticsWeb Container Statistics 8Web Container Web Module Statistics Http Service Statistics Jdbc Connection Pools Statistics 9HTTP Service Statistics Developer Profile 10JDBC Connection Pool Statistics 11Connector Connection Pool Statistics JMS/Connector Service Statistics 13Connection Manager in an ORB Statistics 12Connector Work Management StatisticsStatistics for Connection Managers in an ORB 14Thread Pool Statistics Transaction Service Statistics15Transaction Service Statistics Thread Pools Statistics 17JVM Statistics for Java SE- Class Loading 15 Transaction Service StatisticsJava Virtual Machine JVM Statistics JVM Statistics 20JVM Statistics for Java SE- Memory 18JVM Statistics for Java SE- Compilation19JVM Statistics for Java SE- Garbage Collection 22JVM Statistics for Java SE Runtime Following table21JVM Statistics for Java SE Operating System 23JVM Statistics for Java SE Thread Info 24JVM Statistics for Java SE Threads Enabling and Disabling Monitoring Returns Configuring Monitoring Levels Using the Admin ConsoleTo Configure Monitoring Levels Using asadmin Viewing Monitoring Data Viewing Monitoring Data in the Admin ConsoleViewing Monitoring Data With the asadmin Tool To Use the asadmin monitor Command to View Monitoring Data 531628032 45940736 Understanding and Specifying Dotted Names Command returns the following attributes and dataAsadmin get --user adminuser --monitor server.jvm Server.http-service Server.applications.petstore Examples of the list and get Commands Asadmin list --user admin-user--monitor server.applications Examples for the list --user admin-user --monitor CommandExamples for the get --user admin-user --monitor Command Asadmin list --user admin-user--monitor server Attempt to get all attributes from a Java EE application Asadmin get --user admin-user--monitor server.jvm Returns output will be similar to Asadmin get --user admin-user--monitor server.jvm.badnameTo Use the PetStore Example Attempt to get a specific attribute from a subsystem Returns with dotted name removed for space considerations Server.http-service Server.resources Server.thread-poolsAsadmin list -m server.applications.petstore.signon-ejbjar Monitoring Components and Services 201 Expected Output for list and get Commands at All Levels Applications Level Top Level Application has been deployed. It is not applicable if a Monitoring Components and Services 205 List -m Server.applications.app1 29Thread-Pools Level 28HTTP-Service Level ORB Level 31Transaction-Service LevelResources Level JVM Level Using JConsoleLevel Securing JConsole to Application Server Connection Connecting JConsole to Application Server Prerequisites for Connecting JConsole to Application Server Connecting JConsole Securely to Application Server Monitoring Components and Services 213 214 About Management Rules Configuring Management Rules Configuring Management Rules Configuring Management Rules 217 218 Tuning the JVM Settings Java Virtual Machine and Advanced Settings Configuring Advanced Settings This Appendix contains the following topics Automatically Restarting a Domain or Node AgentRestarting Automatically on Solaris Restarting Automatically on Solaris Restarting Automatically on the Microsoft Windows Platform Creating a Windows Service Start= auto DisplayName= display-name Jvm-options-Xrs/jvm-options Process name=as-service-name Sysproperty key=-XrsSecurity for Automatic Restarts 226 Top Level Elements Dotted Name Attributes for domain.xml Top Level Elements Elements Not Aliased Elements Not Aliased 230 Asadmin Utility Asadmin Utility Appendix C The asadmin Utility 233 Table C-1Remote Commands Required Options Common Options for Remote Commands Prefix followed by the password name in uppercase letters Multimode Command Get, Set, and List Commands Table C-2Server Lifecycle Commands Server Lifecycle Commands Table C-3List and Status Commands List and Status CommandsTable C-2 Server Lifecycle Commands Table C-4Deployment Commands Deployment Commands Table C-6Message Queue Commands Version CommandsMessage Queue Administration Commands Table C-5Version Commands Table C-7Resource Management Commands Resource Management Commands Table C-7 Resource Management Commands Table C-8IIOP Listener Commands Configuration CommandsHttp and Iiop Listener Commands Lifecycle and Audit Module Commands Table C-10Profiler and SSL Commands Profiler and SSL CommandsJVM Options and Virtual Server Commands Table C-9Lifecycle Module Commands Table C-12Threadpool and Auth-Realm Commands Threadpool and Auth-Realm CommandsTransaction and Timer Commands Table C-11JVM Options and Virtual Server Commands Table C-14Transaction Commands User Management CommandsRegistry Commands Table C-13Transaction Commands Table C-16Rules and Monitoring Commands Rules and Monitoring CommandsDatabase Commands Table C-18Diagnostic and Logging Commands Diagnostic and Logging CommandsWeb Service Commands Table C-17Database Commands Table C-20Security Commands Security Service Commands Table C-21Password Commands Password Commands Service Command Verify CommandCustom MBean Commands Table C-25Property Command Property Command ACC Index JMS Logging ORB 256