Chapter 9. jdbc
9.1. jdbc:ds-create
9.1.1. Description
Create a JDBC datasource config for pax-jdbc-config from a DataSourceFactory
9.1.2. Syntax
jdbc:ds-create [options] name
9.1.3. Arguments
| Name | Description |
|---|---|
| name | The JDBC datasource name |
9.1.4. Options
| Name | Description |
|---|---|
| -p, --password | The database password |
| --help | Display this help message |
| -dt, --databaseType | The database type (ConnectionPoolDataSource, XADataSource or DataSource) |
| -dbName | Database name to use |
| -dn, --driverName | org.osgi.driver.name property of the DataSourceFactory |
| -url | The JDBC URL to use |
| -dc, --driverClass | org.osgi.driver.class property of the DataSourceFactory |
| -u, --username | The database username |
9.2. jdbc:ds-delete
9.2.1. Description
Delete a JDBC datasource
9.2.2. Syntax
jdbc:ds-delete [options] name
9.2.3. Arguments
| Name | Description |
|---|---|
| name | The JDBC datasource name (the one used at creation time) |
9.2.4. Options
| Name | Description |
|---|---|
| --help | Display this help message |
9.3. jdbc:ds-factories
9.3.1. Description
List the JDBC DataSourceFactories
9.3.2. Syntax
jdbc:ds-factories [options]
9.3.3. Options
| Name | Description |
|---|---|
| --help | Display this help message |
9.4. jdbc:ds-info
9.4.1. Description
Display details about a JDBC datasource
9.4.2. Syntax
jdbc:ds-info [options] datasource
9.4.3. Arguments
| Name | Description |
|---|---|
| datasource | The JDBC datasource name |
9.4.4. Options
| Name | Description |
|---|---|
| --help | Display this help message |
9.5. jdbc:ds-list
9.5.1. Description
List the JDBC datasources
9.5.2. Syntax
jdbc:ds-list [options]
9.5.3. Options
| Name | Description |
|---|---|
| --help | Display this help message |
9.6. jdbc:execute
9.6.1. Description
Execute a SQL command on a given JDBC datasource
9.6.2. Syntax
jdbc:execute [options] datasource command
9.6.3. Arguments
| Name | Description |
|---|---|
| datasource | The JDBC datasource |
| command | The SQL command to execute |
9.6.4. Options
| Name | Description |
|---|---|
| --help | Display this help message |
9.7. jdbc:query
9.7.1. Description
Execute a SQL query on a JDBC datasource
9.7.2. Syntax
jdbc:query [options] datasource query
9.7.3. Arguments
| Name | Description |
|---|---|
| datasource | The JDBC datasource to use |
| query | The SQL query to execute |
9.7.4. Options
| Name | Description |
|---|---|
| --help | Display this help message |
9.8. jdbc:tables
9.8.1. Description
List the tables on a given JDBC datasource
9.8.2. Syntax
jdbc:tables [options] datasource
9.8.3. Arguments
| Name | Description |
|---|---|
| datasource | The JDBC datasource to use |
9.8.4. Options
| Name | Description |
|---|---|
| --help | Display this help message |
