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.
listDataSources
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")