NAME | Synopsis | Description | Options | Operands | Examples | Exit Status | See Also
create-jdbc-resource <connect_options> [--echo|-e] [--no-prompt|-Q] [--verbose|-v] [--min-connections|-m count] [--max-connections|-x count] [--idle-timeout|-l time-in-seconds] [--wait-timeout|-o time-in-seconds] [--no-enabled|-n] [--isolation-level|-L level] [--isolation-level-guaranteed|-g boolean] [--connection-validation|-r false/auto-commit/meta-data/table] [--connection-validation-table-name|-t name] [--fail-all-connections|-f boolean] --config|-c name --datasource-class|-d name jndi-name
Use this command to create a new JDBC resource. A JDBC data source is an implementation of a data source in the Java programming language. A data source can be a complex database for a large corporation or as simple as a file with rows and columns.
You can create and manage a JDBC data source through Sun Java System Web Server. The JDBC API provides a set of classes for Java with a standard SQL database access interface to ensure uniform access to a wide range of relational databases. Using JDBC, SQL statements can be sent to virtually any database management system (DBMS). It is used as an interface for both relational and object DBMSs.
For connect_options description, see help(1).
Specify this option to print this command on the standard output before executing. This option also prints the default value for all the non-mandatory options that you do not provide in the command.
If you specify this option, wadm will not prompt you for passwords while executing this command. Use this option if you have defined all passwords in a password file and specified the file using the --password-file connect_option.
Specify this option to display a verbose output.
Specify the minimum number of concurrent connections to be maintained by the database server. The range of values is 1–4096. The default value is 8.
Specify the maximum number of concurrent connections to be maintained by the database server. The range of values is 1–4096. The default value is 32.
Specify the timeout (in seconds) after which an idle connection to the database server closes. The range of values is 0–3600 and –1 for no timeout.
Specify the timeout (in seconds) after which a caller waiting for an available connection to the database server will receive an error. The range of values is 0.001–3600 and –1 for no timeout.
Specify this option if you want to disable the JDBC resource at runtime.
Specify the transaction isolation level. The accepted values are read-uncommitted, read-committed, repeatable-read, or serializable.
If you specify this option, the server sets the isolation level each time a connection is leased to an application. The default value is false.
Specify this option to indicate whether the server validates a connection before leasing it to an application. The value can be false, auto-commit, meta-data or table.
Specify the table used when connection-validation-method is table.
If you specify this option, all connections are closed and re-established if there is an error while validating an individual connection. The default value is false.
Specify the name of the configuration for which you want to create the JDBC resource.
Specify the name of the JDBC drive class.
wadm create-jdbc-resource --user=admin --host=serverhost --password-file=../admin.passwd --port=8989 --ssl=true --no-prompt --rcfile=null --config=config1 --datasource-class=com.pointbase.jdbc. jdbcDataSource jdbc |
The following exit values are returned:
command executed successfully
error in executing the command
help(1), create-jdbc-resource-userprop(1), delete-jdbc-resource-userprop(1), list-jdbc-resource-userprops(1), set-jdbc-resource-prop(1), delete-jdbc-resource(1), list-jdbc-resources(1), get-jdbc-resource-prop(1)
NAME | Synopsis | Description | Options | Operands | Examples | Exit Status | See Also