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: 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")