WebSphere:*,type=DataSourceCfgHelper
MBean DataSourceCfgHelper
Management interface for helper class that performs several admin functions for the JDBC DataSource.
Operation Summary | |
---|---|
java.util.List | getPropertiesForDataSource( Creates a list of all settable properties available for a DataSource. |
void | reload() Reloads resources. |
java.lang.String | testConnectionToDataSource( Tests getting a connection to the specified DataSource and returns a message suitable for display to the user containing any warnings and errors. |
int | testConnection( Tests getting a connection to the specified resource and returns a 0 for success, 1 for warnings and throws exceptions for failures. |
java.lang.String | testConnectionToDataSource( Tests getting a connection to the specified DataSource and returns a message suitable for display to the user containing any warnings and errors. |
Operation Detail |
---|
public java.util.List getPropertiesForDataSource(
java.lang.String dsClassName,
java.lang.String providerLibPath
)
Creates a list of all settable properties available for a DataSource. The list is an ArrayList of DSPropertyEntry -- consisting of (propertyName, propertyType, isRequired, defaultValue). Required properties are listed first, and no duplicates may appear in the list. The list also contains properties required by the WebSphere DataSource implementation (informixLockWaitMode, enable2Phase).
dsClassName
-
the class name of the JDBC provider data source class to retrieve the properties for providerLibPath
-
the path to the folder containing the needed JDBC provider classes
administrator
operator
configurator
monitor
deployer
adminsecuritymanager
public void reload()
Reloads resources.xml. This function may be called to bind a new data source after server start. It does not impact existing data sources.
administrator
operator
public java.lang.String testConnectionToDataSource(
java.lang.String dsClassName,
java.lang.String user,
java.lang.String password,
java.util.Properties dataSourceProps,
java.lang.String providerLibPath,
java.lang.String language,
java.lang.String country
)
Tests getting a connection to the specified DataSource and returns a message suitable for display to the user containing any warnings and errors. Loads the specified data source class, sets the data source properties as specified, and attempts to open a connection. If all of this works as planned, we return a null message, indicating success. If everything works with the exception that some properties are not found or are invalid, we return a message like this: 'Successfully connected to data source, with N warnings.' where N is the number of warnings. The message also contains a description of each warning. If we can't open a connection, we return a message with the exception that states failure. If it's a SQLException we also include the Error Code and SQL State. This method also tests whether the DataStoreHelper class specified in the DataSource properties exists and implements the DataStoreHelper interface. If it does not, a warning explaining the problem is added to the message.
dsClassName
-
the class name of the JDBC provider data source class to retrieve the properties for user
-
user name for connecting to the database. password
-
password for connecting to the database. dataSourceProps
-
list of the properties you wish to set when testing the data source providerLibPath
-
the path to the folder containing the needed JDBC provider classes language
-
the langauge of the locale to use for any warnings returned by the test connection country
-
the country of the locale to use for any warnings returned by the test connection
administrator
operator
configurator
monitor
deployer
adminsecuritymanager
public int testConnection(
java.lang.String resURI
)
Tests getting a connection to the specified resource and returns a 0 for success, 1 for warnings and throws exceptions for failures. Exception messages with details are logged in the server logs.
resURI
-
The resource URI. This will be use to retrieve the resource properties from WCCM.ResourceInstanceIdentifier
The resource being modified for the MBean is of type ResourceURI
The instance is identified by the value of the parameter
administrator
operator
configurator
monitor
deployer
adminsecuritymanager
public java.lang.String testConnectionToDataSource(
java.lang.String dsClassName,
java.lang.String user,
java.lang.String password,
java.util.Properties dataSourceProps,
java.lang.String providerLibPath,
java.util.Locale locale
)
Tests getting a connection to the specified DataSource and returns a message suitable for display to the user containing any warnings and errors. Loads the specified data source class, sets the data source properties as specified, and attempts to open a connection. If all of this works as planned, we return a null message, indicating success. If everything works with the exception that some properties are not found or are invalid, we return a message like this: 'Successfully connected to data source, with N warnings.' where N is the number of warnings. The message also contains a description of each warning. If we can't open a connection, we return a message with the exception that states failure. If it's a SQLException we also include the Error Code and SQL State. This method also tests whether the DataStoreHelper class specified in the DataSource properties exists and implements the DataStoreHelper interface. If it does not, a warning explaining the problem is added to the message. This method is being added only because it is described in the documentation.
dsClassName
-
the class name of the JDBC provider data source class to retrieve the properties for user
-
user name for connecting to the database. password
-
password for connecting to the database. dataSourceProps
-
list of the properties you wish to set when testing the data source providerLibPath
-
the path to the folder containing the needed JDBC provider classes locale
-
the locale to use for any warnings returned by the test connection
administrator
operator
configurator
monitor
deployer
adminsecuritymanager