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.
避免困難: 請勿編輯 Script 程式庫中的 Script 程序。
如果要撰寫自訂 Script 程式庫程序,請利用 app_server_root/scriptLibraries
目錄中的 Script 作為 Jython 語法範例。請將自訂 Script 儲存在新的子目錄中,以免改寫程式庫。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")
參照主題