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

NameDescription

name

The JDBC datasource name

9.1.4. Options

NameDescription

-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

NameDescription

name

The JDBC datasource name (the one used at creation time)

9.2.4. Options

NameDescription

--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

NameDescription

--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

NameDescription

datasource

The JDBC datasource name

9.4.4. Options

NameDescription

--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

NameDescription

--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

NameDescription

datasource

The JDBC datasource

command

The SQL command to execute

9.6.4. Options

NameDescription

--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

NameDescription

datasource

The JDBC datasource to use

query

The SQL query to execute

9.7.4. Options

NameDescription

--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

NameDescription

datasource

The JDBC datasource to use

9.8.4. Options

NameDescription

--help

Display this help message