JDBC query scripts

The scripting library provides many script procedures to manage Java™ Database Connectivity (JDBC) configurations in your environment. See the usage information for scripts that retrieve configuration IDs for your JDBC configuration. You can run each script individually or combine many procedures to create custom automation scripts for your environment.

Each AdminJDBC script procedure is located in the app_server_root/scriptLibraries/resources/JDBC/V70 directory.

A partir da Versão 7, a biblioteca de scripts Jython fornece funções de script para provedores JDBC, recursos JMS e provedores de recursos no escopo do servidor. É possível gravar seus próprios scripts customizados para configurar recursos no nível de célula, nó ou cluster.
Evitar Problemas Evitar Problemas: Não edite os procedimentos de script da biblioteca de scripts. Para gravar procedimentos de biblioteca de script customizados, use os scripts no diretório app_server_root/scriptLibraries como amostras de sintaxe Jython. Salve os scripts customizados em um novo subdiretório para evitar sobrescrever a biblioteca.gotcha
Fast path: Começando com o Fix Pack 5, a biblioteca de scripts Jython fornece funções de script para provedores JDBC, recursos JMS e provedores de recursos no escopo da célula, do nó, do servidor ou do cluster. Provedores de recursos incluem provedores de correio, provedores de URL e provedores de ambientes de recursos. Você não precisa gravar scripts customizados para configurar recursos em um determinado escopo.
Use the following script procedures to query your JDBC configuration:

listDataSources

This script displays a list of configuration IDs for the data sources in your configuration.

No input arguments are required for the script. However, you can specify a data source name to return a specific configuration id, as defined in the following table:
Table 1. listDataSources script. Run the script to list data sources.
Argument Description
dsName Optionally specifies the name of the data source of interest.

Syntax

AdminJDBC.listDataSources(dsName)

Example usage

AdminJDBC.listDataSources()
AdminJDBC.listDataSources("myDataSource")

listDataSourceTemplates

This script displays a list of configuration IDs for the data source templates in your environment.

No input arguments are required for the script. However, you can specify a template name to return a specific configuration id, as defined in the following table:
Table 2. listDataSourceTemplates script. Run the script to list data source templates.
Argument Description
templateName Optionally specifies the name of the template of interest.

Syntax

AdminJDBC.listDataSourceTemplates(templateName)

Example usage

AdminJDBC.listDataSourceTemplates()
AdminJDBC.listDataSourceTemplates("Derby JDBC Driver DataSource")

listJDBCProviders

This script displays a list of configuration IDs for the JDBC providers in your environment.

No input arguments are required for the script. However, you can specify a JDBC provider name to return a specific configuration id, as defined in the following table:
Table 3. listJDBCProviders script. Run the script to list JDBC providers.
Argument Description
jdbcName Optionally specifies the name of the JDBC provider of interest.

Syntax

AdminJDBC.listJDBCProviders(jdbcName)

Example usage

AdminJDBC.listJDBCProviders()
AdminJDBC.listJDBCProviders("myJDBCProvider")

listJDBCProviderTemplates

This script displays a list of configuration IDs for the JDBC provider templates in your environment.

No input arguments are required for the script. However, you can specify a template name to return a specific configuration id, as defined in the following table:
Table 4. listJDBCProviderTemplates script. Run the script to list JDBC provider templates.
Argument Description
templateName Optionally specifies the name of the template of interest.

Syntax

AdminJDBC.listJDBCProviderTemplates(templateName)

Example usage

AdminJDBC.listJDBCProviderTemplates()
AdminJDBC.listJDBCProviderTemplates("Derby JDBC Provider")

Ícone que indica o tipo de tópico Tópico de Referência



Ícone de registro de data e hora Última atualização: July 9, 2016 7:53
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=cord&product=was-nd-mp&topic=rxml_7adminjdbc2
Nome do arquivo: rxml_7adminjdbc2.html