A B C D E F G H I L N O P Q R S T U W

A

Args - class org.skife.jdbi.Args.

Convenience class for building named argument maps

Args() - Constructor for class org.skife.jdbi.Args

add(String) - Method in interface org.skife.jdbi.Batch

A statement to be executed as part of the batch

add(Object[]) - Method in interface org.skife.jdbi.PreparedBatch

Add a batched statement execution with positional arguments

add(Collection) - Method in interface org.skife.jdbi.PreparedBatch

Collection containing arguments to bind positionally

add(Object) - Method in interface org.skife.jdbi.PreparedBatch

Map properties on bean to named parameters on the statement

add(Map) - Method in interface org.skife.jdbi.PreparedBatch

Populate named parameters via values in a map

addAll(Collection) - Method in interface org.skife.jdbi.Batch

Add statements en masse

addAll(Collection) - Method in interface org.skife.jdbi.PreparedBatch

Convenience method for adding a large number of statements to a batch.

addAll(Object[]) - Method in interface org.skife.jdbi.PreparedBatch

Convenience method for adding a large number of statements to a batch.

afterPropertiesSet() - Method in class org.skife.jdbi.spring.DBIBean

Ensures that a datasource has been set

and(String, Object) - Method in class org.skife.jdbi.Args

Add another named argument to the Args

B

BaseHandleDecorator - class org.skife.jdbi.unstable.decorator.BaseHandleDecorator.

Convenience class implementing Handle which delegates all method calls to the Handle instance passed into its constructor.

BaseHandleDecorator(Handle) - Constructor for class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

Batch - interface org.skife.jdbi.Batch.

Represents a batch of arbitrary statements to be executed together, see JDBC batched statements

batch() - Method in interface org.skife.jdbi.Handle

Create a new Batch instance which can be used to queue up and execute statements in a single batch.

batch() - Method in class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

begin() - Method in interface org.skife.jdbi.Handle

start a transaction

begin() - Method in class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

C

ConnectionFactory - interface org.skife.jdbi.ConnectionFactory.

Used when JDBC connections need to be obtained in an unusual manner, such as from a proprietary o/r mapping interface.

clearStatementCache() - Method in interface org.skife.jdbi.Handle

Clear this handle's cache of prepared statements.

clearStatementCache() - Method in class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

close() - Method in interface org.skife.jdbi.Handle

Close the connection

close() - Method in class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

commit() - Method in interface org.skife.jdbi.Handle

Commit transaction in progress

commit() - Method in class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

D

DBI - class org.skife.jdbi.DBI.

Entry point for operations.

DBI() - Constructor for class org.skife.jdbi.DBI

Attempt to auto-configure a DBi instance

DBI(String) - Constructor for class org.skife.jdbi.DBI

If wombat begins "jdbc:" the string will be treated as a jdbc driver otherwise it will be used as the key for a jndi lookup to findInternal a DataSrouce.

DBI(String, String, String) - Constructor for class org.skife.jdbi.DBI

If wombat begins "jdbc:" the string will be treated as a jdbc driver otherwise it will be used as the key for a jndi lookup to findInternal a DataSrouce.

DBI(DataSource) - Constructor for class org.skife.jdbi.DBI

Obtain a new DBI instance

DBI(DataSource, String, String) - Constructor for class org.skife.jdbi.DBI

Obtain a new DBI instance

DBI(ConnectionFactory) - Constructor for class org.skife.jdbi.DBI

Use a custom implementation of ConnectionFactory to obtain JDBC connections for handles created by this DBI

DBIBean - class org.skife.jdbi.spring.DBIBean.

Used to provide an IDBI instance to a Spring bean factory

Configuration might look like:

DBIBean() - Constructor for class org.skife.jdbi.spring.DBIBean

DBIError - error org.skife.jdbi.DBIError.

Base Error class

DBIError() - Constructor for class org.skife.jdbi.DBIError

DBIError(String) - Constructor for class org.skife.jdbi.DBIError

DBIError(String, Throwable) - Constructor for class org.skife.jdbi.DBIError

DBIError(Throwable) - Constructor for class org.skife.jdbi.DBIError

DBIException - exception org.skife.jdbi.DBIException.

Base exception class

DBIException() - Constructor for class org.skife.jdbi.DBIException

DBIException(String) - Constructor for class org.skife.jdbi.DBIException

DBIException(String, Throwable) - Constructor for class org.skife.jdbi.DBIException

DBIException(Throwable) - Constructor for class org.skife.jdbi.DBIException

DBIUtils - class org.skife.jdbi.spring.DBIUtils.

Utility functions for use with spring transaction systems

DBIUtils() - Constructor for class org.skife.jdbi.spring.DBIUtils

decorate(IDBI, Handle) - Method in interface org.skife.jdbi.unstable.decorator.HandleDecoratorBuilder

Called when a handle is created

E

eachRow(Handle, Map) - Method in interface org.skife.jdbi.RowCallback

Will be called for each row returned by a query.

execute() - Method in interface org.skife.jdbi.Batch

Execute all of the statements in this batch and clear the batch

execute(String) - Method in interface org.skife.jdbi.Handle

Execute an sql statement which does not return any results.

execute(String, Object[]) - Method in interface org.skife.jdbi.Handle

Execute an sql statement which does not return any results.

execute(String, Collection) - Method in interface org.skife.jdbi.Handle

Execute an sql statement which does not return any results.

execute(String, Map) - Method in interface org.skife.jdbi.Handle

Execute an sql statement which does not return any results.

execute(String, Object) - Method in interface org.skife.jdbi.Handle

Execute a statement with named parameters pulling values from a JavaBean

execute() - Method in interface org.skife.jdbi.PreparedBatch

Execute the batch returning an array of the number of rows modified

execute(String) - Method in class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

execute(String, Object[]) - Method in class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

execute(String, Collection) - Method in class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

execute(String, Map) - Method in class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

execute(String, Object) - Method in class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

F

first(String) - Method in interface org.skife.jdbi.Handle

Returns the first row matched by the query

first(String, Object) - Method in interface org.skife.jdbi.Handle

Returns the first row matched by the query

first(String, Map) - Method in interface org.skife.jdbi.Handle

Returns the first row matched by the query

first(String, Object[]) - Method in interface org.skife.jdbi.Handle

Returns the first row matched by the query

first(String, Collection) - Method in interface org.skife.jdbi.Handle

Returns the first row matched by the query

first(String) - Method in class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

first(String, Object) - Method in class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

first(String, Map) - Method in class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

first(String, Object[]) - Method in class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

first(String, Collection) - Method in class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

G

getConnection() - Method in interface org.skife.jdbi.ConnectionFactory

Must return a usable JDBC Connection instance, will be called to obtain a Connection for each Handle opened

getConnection() - Method in interface org.skife.jdbi.Handle

Obtain the JDBC connection used by this handle

getConnection() - Method in class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

getDataSource() - Method in class org.skife.jdbi.spring.DBIBean

getHandle(IDBI) - Static method in class org.skife.jdbi.spring.DBIUtils

Obtain a handle from dbi, using the transactionally bound one if there is one, otherwise a new one.

getNamedStatements() - Method in class org.skife.jdbi.DBI

Obtain an unmodifiable map of all the named statements known to this DBI instance.

getNamedStatements() - Method in interface org.skife.jdbi.IDBI

Obtain an unmodifiable map of all the named statements known to this DBI instance.

getObject() - Method in class org.skife.jdbi.spring.DBIBean

getObjectType() - Method in class org.skife.jdbi.spring.DBIBean

H

Handle - interface org.skife.jdbi.Handle.

Represents a connection to the RDBMS.

HandleCallback - interface org.skife.jdbi.HandleCallback.

Callback interface to be used with DBI instances a la

HandleDecoratorBuilder - interface org.skife.jdbi.unstable.decorator.HandleDecoratorBuilder.

Used to decorate Handle instances obtained from a DBI instance.

I

IDBI - interface org.skife.jdbi.IDBI.

Provides an interface based system to access all of the DBI instance methods.

inTransaction(TransactionCallback) - Method in interface org.skife.jdbi.Handle

Execute transactionCallback in a transaction, cleaning up as necesary around it

inTransaction(Handle) - Method in interface org.skife.jdbi.TransactionCallback

Called within context of a transaction

inTransaction(TransactionCallback) - Method in class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

isInTransaction() - Method in interface org.skife.jdbi.Handle

Has a transaction been started?

isInTransaction() - Method in class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

isOpen() - Method in interface org.skife.jdbi.Handle

Checks to make sure the connection is live

isOpen() - Method in class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

isSingleton() - Method in class org.skife.jdbi.spring.DBIBean

L

load(String) - Method in class org.skife.jdbi.DBI

Eagerly load a named query from the filesystem.

load(String) - Method in interface org.skife.jdbi.Handle

Eagerly load a named query from the filesystem.

load(String) - Method in interface org.skife.jdbi.IDBI

Eagerly load a named query from the filesystem.

load(String) - Method in class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

N

name(String, String) - Method in class org.skife.jdbi.DBI

Prepared a named sql statement

name(String, String) - Method in interface org.skife.jdbi.Handle

Prepared a named sql statement

name(String, String) - Method in interface org.skife.jdbi.IDBI

Prepared a named sql statement

name(String, String) - Method in class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

O

open() - Method in class org.skife.jdbi.DBI

Obtain a new Handle instance

open(HandleCallback) - Method in class org.skife.jdbi.DBI

Execute the callback with an open handle, closing, and cleaning up resources, after the callback exits or excepts

open(String) - Static method in class org.skife.jdbi.DBI

Obtain a handle directly from a datasource

open(String, String, String) - Static method in class org.skife.jdbi.DBI

Obtain a handle directly from a datasource

open(DataSource) - Static method in class org.skife.jdbi.DBI

open(DataSource, String, String) - Static method in class org.skife.jdbi.DBI

Obtain a handle directly from a datasource

open(String, HandleCallback) - Static method in class org.skife.jdbi.DBI

Execute callback with an opened handle, closing the handle, and cleaning up resources when the callback finishes.

open(String, String, String, HandleCallback) - Static method in class org.skife.jdbi.DBI

Execute callback with an opened handle, closing the handle, and cleaning up resources when the callback finishes.

open(DataSource, HandleCallback) - Static method in class org.skife.jdbi.DBI

Execute callback with an opened handle, closing the handle, and cleaning up resources when the callback finishes.

open(DataSource, String, String, HandleCallback) - Static method in class org.skife.jdbi.DBI

Execute callback with an opened handle, closing the handle, and cleaning up resources when the callback finishes.

open() - Method in interface org.skife.jdbi.IDBI

Obtain a new Handle instance

open(HandleCallback) - Method in interface org.skife.jdbi.IDBI

Execute the callback with an open handle, closing, and cleaning up resources, after the callback exits or excepts

org.skife.jdbi - package org.skife.jdbi

Core classes for jDBI

org.skife.jdbi.spring - package org.skife.jdbi.spring

Classes here provide integration hooks for working with the Spring framework.

org.skife.jdbi.unstable - package org.skife.jdbi.unstable

Contains classes and interfaces whose behavior is subject to change within a version (1.X).

org.skife.jdbi.unstable.decorator - package org.skife.jdbi.unstable.decorator

Provides facilities for decorating Handles, and possible other interfaces eventually (if you need that, let us know!).

P

PreparedBatch - interface org.skife.jdbi.PreparedBatch.

Represents a JDBC batch statement of the prepared variety.

prepareBatch(String) - Method in interface org.skife.jdbi.Handle

Create a new PreparedBatch instance from arbitrary SQL or a named statement

prepareBatch(String) - Method in class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

Q

query(String) - Method in interface org.skife.jdbi.Handle

Retrieve a collection of map instances from a query.

query(String, RowCallback) - Method in interface org.skife.jdbi.Handle

Iterate (once) over a resultset in order calling the callback for each row processed

query(String, Object[], RowCallback) - Method in interface org.skife.jdbi.Handle

Iterate (once) over a resultset in order calling the callback for each row processed

query(String, Map, RowCallback) - Method in interface org.skife.jdbi.Handle

Iterate (once) over a resultset in order calling the callback for each row processed

query(String, Map) - Method in interface org.skife.jdbi.Handle

Execute query using name parameters of the form: select id, name from something where id = :something and the key to the params map is "something"

query(String, Object) - Method in interface org.skife.jdbi.Handle

Execute statement with JavaBean mapped named parameter

query(String, Object[]) - Method in interface org.skife.jdbi.Handle

Execute statement with positional arguments

query(String, Collection) - Method in interface org.skife.jdbi.Handle

Execute statement with positional arguments

query(String) - Method in class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

query(String, RowCallback) - Method in class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

query(String, Object[], RowCallback) - Method in class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

query(String, Map, RowCallback) - Method in class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

query(String, Map) - Method in class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

query(String, Object) - Method in class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

query(String, Object[]) - Method in class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

query(String, Collection) - Method in class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

R

RowCallback - interface org.skife.jdbi.RowCallback.

Callback interface for use with queries.

rollback() - Method in interface org.skife.jdbi.Handle

Rollback a transaction in progress

rollback() - Method in class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

S

script(String) - Method in interface org.skife.jdbi.Handle

Find and execute the sql script name.

script(String) - Method in class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

setDataSource(DataSource) - Method in class org.skife.jdbi.spring.DBIBean

Specify the datasource to be used to draw connections from.

setHandleDecoratorBuilder(HandleDecoratorBuilder) - Method in class org.skife.jdbi.DBI

Specify a decorator builder to decorate all handles created by this DBI instance

setHandleDecoratorBuilder(HandleDecoratorBuilder) - Method in class org.skife.jdbi.spring.DBIBean

Specify a decorator builder to decorate all handles created by this DBI instance

T

TransactionCallback - interface org.skife.jdbi.TransactionCallback.

Callback interface for use with Handle instances.

U

Unstable - interface org.skife.jdbi.unstable.Unstable.

Tag interface used to flag things as being unstable

update(String) - Method in interface org.skife.jdbi.Handle

Execute a statement of the form update foo set bar = foo_id

update(String, Object[]) - Method in interface org.skife.jdbi.Handle

Execute a statement of the form update foo set bar = foo_id

update(String, Collection) - Method in interface org.skife.jdbi.Handle

Execute a statement of the form update foo set bar = foo_id

update(String, Map) - Method in interface org.skife.jdbi.Handle

Execute a statement of the form update foo set bar = foo_id

update(String, Object) - Method in interface org.skife.jdbi.Handle

Execute an update with named parameters pulling values from a JavaBean

update(String) - Method in class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

update(String, Object[]) - Method in class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

update(String, Collection) - Method in class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

update(String, Map) - Method in class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

update(String, Object) - Method in class org.skife.jdbi.unstable.decorator.BaseHandleDecorator

W

with(String, Object) - Static method in class org.skife.jdbi.Args

Create a new Args instance, typically to be used for named parameters

withHandle(Handle) - Method in interface org.skife.jdbi.HandleCallback

Will be called by the dbi instance

A B C D E F G H I L N O P Q R S T U W