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.
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.gotchalistDataSources
This script displays a list of configuration IDs for the data sources in your configuration.
| 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.
| 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.
| 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.
| 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")
Tópico de Referência