Example: Configuring a new WAS40 connection pool using wsadmin

• Identify the parent ID:

  Using Jacl:

  set new40ds [$AdminConfig getid /Cell:mycell/Node:mynode/Server:server1/JDBCProvider:JDBC1/WAS40DataSource:was4DS1/]

  Example output:

  was4DS1(cells/mycell/nodes/mynodes:resources.xml$WAS40DataSource_1)

  Using Jython:

  new40ds = AdminConfig.getid('/Cell:mycell/Node:mynode/Server:server1/JDBCProvider:JDBC1/WAS40DataSource:was4DS1/')
  print new40ds

• Get required attributes:

  Using Jacl:

  $AdminConfig required WAS40ConnectionPool

   

  Example

  output:

  Attribute      	Type
  minimumPoolSize     Integer
  maximumPoolSize     Integer
  connectionTimeout   Integer
  idleTimeout        Integer
  orphanTimeout       Integer
  statementCacheSize  Integer

  Using Jython:

  print AdminConfig.required('WAS40ConnectionPool')

• Set up required attributes:

  Using Jacl:

  set mps [list minimumPoolSize 5]
  set minps [list minimumPoolSize 5]
  set maxps [list maximumPoolSize 30]
  set conn [list connectionTimeout 10]
  set idle [list idleTimeout 5]
  set orphan [list orphanTimeout 5]
  set scs [list statementCacheSize 5]
  set cpAttrs [list $minps $maxps $conn $idle $orphan $scs]

   

  Example

  output:

  {minimumPoolSize 5} {maximumPoolSize 30} 
  {connectionTimeout 10} {idleTimeout 5} 
  {orphanTimeout 5} {statementCacheSize 5}

  Using Jython:

  minps = ['minimumPoolSize', 5]
  maxps = ['maximumPoolSize', 30]
  conn = ['connectionTimeout', 10]
  idle = ['idleTimeout', 5]
  orphan = ['orphanTimeout', 5]
  scs = ['statementCacheSize', 5]
  cpAttrs = [minps, maxps, conn, idle, orphan, scs]
  print cpAttrs

  Example output:

  [[minimumPoolSize, 5], [maximumPoolSize, 30], 
  [connectionTimeout, 10], [idleTimeout, 5],  
  [orphanTimeout, 5], [statementCacheSize, 5]]

• Create was40 connection pool:

  Using Jacl:

  $AdminConfig create WAS40ConnectionPool $new40ds $40cpAttrs
  

  Example output:

  (cells/mycell/nodes/mynode:resources.xml#WAS40ConnectionPool_1)

  Using Jython:

  print AdminConfig.create('WAS40ConnectionPool', new40ds, 40cpAttrs)

• Save the changes with the following command:

  Using Jacl:

  $AdminConfig save

  Using Jython:

  AdminConfig.save()

    

 

---