|
||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||
java.lang.Objectorg.h2.message.TraceObject
org.h2.jdbc.JdbcConnection
public class JdbcConnection
Represents a connection (session) to a database.
Thread safety: the connection is thread-safe, because access is synchronized. However, for compatibility with other databases, a connection should only be used in one thread at any time.
| Field Summary |
|---|
| Fields inherited from class org.h2.message.TraceObject |
|---|
ARRAY, BLOB, CALLABLE_STATEMENT, CLOB, CONNECTION, DATA_SOURCE, DATABASE_META_DATA, PARAMETER_META_DATA, PREPARED_STATEMENT, RESULT_SET, RESULT_SET_META_DATA, SAVEPOINT, SQL_EXCEPTION, STATEMENT, XA_DATA_SOURCE, XA_RESOURCE, XID |
| Fields inherited from interface java.sql.Connection |
|---|
TRANSACTION_NONE, TRANSACTION_READ_COMMITTED, TRANSACTION_READ_UNCOMMITTED, TRANSACTION_REPEATABLE_READ, TRANSACTION_SERIALIZABLE |
| Constructor Summary | |
|---|---|
JdbcConnection(ConnectionInfo ci,
boolean useBaseDir)
INTERNAL |
|
JdbcConnection(JdbcConnection clone)
INTERNAL |
|
JdbcConnection(SessionInterface session,
java.lang.String user,
java.lang.String url)
INTERNAL |
|
JdbcConnection(java.lang.String url,
java.util.Properties info)
INTERNAL |
|
| Method Summary | |
|---|---|
protected void |
afterWriting()
INTERNAL. |
protected void |
checkClosed()
INTERNAL. |
protected void |
checkClosed(boolean write)
INTERNAL. |
void |
clearWarnings()
Clears all warnings. |
void |
close()
Closes this connection. |
void |
commit()
Commits the current transaction. |
java.sql.Blob |
createBlob()
Create a new empty Blob object. |
Value |
createBlob(java.io.InputStream x,
long length)
Create a Blob value from this input stream. |
java.sql.Clob |
createClob()
Create a new empty Clob object. |
Value |
createClob(java.io.Reader x,
long length)
Create a Clob value from this reader. |
java.sql.Statement |
createStatement()
Creates a new statement. |
java.sql.Statement |
createStatement(int resultSetType,
int resultSetConcurrency)
Creates a statement with the specified result set type and concurrency. |
java.sql.Statement |
createStatement(int resultSetType,
int resultSetConcurrency,
int resultSetHoldability)
Creates a statement with the specified result set type, concurrency, and holdability. |
boolean |
getAutoCommit()
Gets the current setting for auto commit. |
java.lang.String |
getCatalog()
Gets the current catalog name. |
int |
getHoldability()
Returns the current result set holdability. |
java.sql.DatabaseMetaData |
getMetaData()
Gets the database meta data for this database. |
int |
getPowerOffCount()
INTERNAL |
int |
getQueryTimeout()
INTERNAL |
SessionInterface |
getSession()
INTERNAL |
int |
getTransactionIsolation()
Returns the current transaction isolation level. |
java.util.Map<java.lang.String,java.lang.Class<?>> |
getTypeMap()
Gets the type map. |
java.sql.SQLWarning |
getWarnings()
Gets the first warning reported by calls on this object. |
boolean |
isClosed()
Returns true if this connection has been closed. |
boolean |
isReadOnly()
Returns true if the database is read-only. |
boolean |
isValid(int timeout)
Returns true if this connection is still valid. |
java.lang.String |
nativeSQL(java.lang.String sql)
Translates a SQL statement into the database grammar. |
java.sql.CallableStatement |
prepareCall(java.lang.String sql)
Creates a new callable statement. |
java.sql.CallableStatement |
prepareCall(java.lang.String sql,
int resultSetType,
int resultSetConcurrency)
Creates a callable statement with the specified result set type and concurrency. |
java.sql.CallableStatement |
prepareCall(java.lang.String sql,
int resultSetType,
int resultSetConcurrency,
int resultSetHoldability)
Creates a callable statement with the specified result set type, concurrency, and holdability. |
java.sql.PreparedStatement |
prepareStatement(java.lang.String sql)
Creates a new prepared statement. |
java.sql.PreparedStatement |
prepareStatement(java.lang.String sql,
int autoGeneratedKeys)
Creates a new prepared statement. |
java.sql.PreparedStatement |
prepareStatement(java.lang.String sql,
int[] columnIndexes)
Creates a new prepared statement. |
java.sql.PreparedStatement |
prepareStatement(java.lang.String sql,
int resultSetType,
int resultSetConcurrency)
Creates a prepared statement with the specified result set type and concurrency. |
java.sql.PreparedStatement |
prepareStatement(java.lang.String sql,
int resultSetType,
int resultSetConcurrency,
int resultSetHoldability)
Creates a prepared statement with the specified result set type, concurrency, and holdability. |
java.sql.PreparedStatement |
prepareStatement(java.lang.String sql,
java.lang.String[] columnNames)
Creates a new prepared statement. |
void |
releaseSavepoint(java.sql.Savepoint savepoint)
Releases a savepoint. |
void |
rollback()
Rolls back the current transaction. |
void |
rollback(java.sql.Savepoint savepoint)
Rolls back to a savepoint. |
void |
setAutoCommit(boolean autoCommit)
Switches auto commit on or off. |
void |
setCatalog(java.lang.String catalog)
Set the default catalog name. |
void |
setExecutingStatement(java.sql.Statement stat)
INTERNAL |
void |
setHoldability(int holdability)
Changes the current result set holdability. |
void |
setPowerOffCount(int count)
INTERNAL |
void |
setQueryTimeout(int seconds)
INTERNAL |
void |
setReadOnly(boolean readOnly)
According to the JDBC specs, this setting is only a hint to the database to enable optimizations - it does not cause writes to be prohibited. |
java.sql.Savepoint |
setSavepoint()
Creates a new unnamed savepoint. |
java.sql.Savepoint |
setSavepoint(java.lang.String name)
Creates a new named savepoint. |
void |
setTraceLevel(int level)
INTERNAL |
void |
setTransactionIsolation(int level)
Changes the current transaction isolation level. |
void |
setTypeMap(java.util.Map<java.lang.String,java.lang.Class<?>> map)
[Partially supported] Sets the type map. |
java.lang.String |
toString()
INTERNAL |
| Methods inherited from class org.h2.message.TraceObject |
|---|
debugCode, debugCodeAssign, debugCodeCall, debugCodeCall, debugCodeCall, getNextId, getTrace, getTraceId, getTraceObjectName, isDebugEnabled, isInfoEnabled, logAndConvert, quote, quoteArray, quoteBigDecimal, quoteBytes, quoteDate, quoteIntArray, quoteMap, quoteTime, quoteTimestamp, setTrace, unsupported |
| Methods inherited from class java.lang.Object |
|---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait |
| Constructor Detail |
|---|
public JdbcConnection(java.lang.String url,
java.util.Properties info)
throws java.sql.SQLException
java.sql.SQLException
public JdbcConnection(ConnectionInfo ci,
boolean useBaseDir)
throws java.sql.SQLException
java.sql.SQLExceptionpublic JdbcConnection(JdbcConnection clone)
public JdbcConnection(SessionInterface session,
java.lang.String user,
java.lang.String url)
| Method Detail |
|---|
public java.sql.Statement createStatement()
throws java.sql.SQLException
createStatement in interface java.sql.Connectionjava.sql.SQLException - if the connection is closed
public java.sql.Statement createStatement(int resultSetType,
int resultSetConcurrency)
throws java.sql.SQLException
createStatement in interface java.sql.ConnectionresultSetType - the result set type (ResultSet.TYPE_*)resultSetConcurrency - the concurrency (ResultSet.CONCUR_*)
java.sql.SQLException - if the connection is closed or the result set type or
concurrency are not supported
public java.sql.Statement createStatement(int resultSetType,
int resultSetConcurrency,
int resultSetHoldability)
throws java.sql.SQLException
createStatement in interface java.sql.ConnectionresultSetType - the result set type (ResultSet.TYPE_*)resultSetConcurrency - the concurrency (ResultSet.CONCUR_*)resultSetHoldability - the holdability (ResultSet.HOLD* / CLOSE*)
java.sql.SQLException - if the connection is closed or the result set type,
concurrency, or holdability are not supported
public java.sql.PreparedStatement prepareStatement(java.lang.String sql)
throws java.sql.SQLException
prepareStatement in interface java.sql.Connectionsql - the SQL statement
java.sql.SQLException - if the connection is closed
public java.sql.DatabaseMetaData getMetaData()
throws java.sql.SQLException
getMetaData in interface java.sql.Connectionjava.sql.SQLException - if the connection is closedpublic SessionInterface getSession()
public void close()
throws java.sql.SQLException
close in interface java.sql.Connectionjava.sql.SQLException
public void setAutoCommit(boolean autoCommit)
throws java.sql.SQLException
setAutoCommit in interface java.sql.ConnectionautoCommit - true for auto commit on, false for off
java.sql.SQLException - if the connection is closed
public boolean getAutoCommit()
throws java.sql.SQLException
getAutoCommit in interface java.sql.Connectionjava.sql.SQLException - if the connection is closed
public void commit()
throws java.sql.SQLException
commit in interface java.sql.Connectionjava.sql.SQLException - if the connection is closed
public void rollback()
throws java.sql.SQLException
rollback in interface java.sql.Connectionjava.sql.SQLException - if the connection is closed
public boolean isClosed()
throws java.sql.SQLException
isClosed in interface java.sql.Connectionjava.sql.SQLException
public java.lang.String nativeSQL(java.lang.String sql)
throws java.sql.SQLException
nativeSQL in interface java.sql.Connectionsql - the SQL statement with or without JDBC escape sequences
java.sql.SQLException - if the connection is closed
public void setReadOnly(boolean readOnly)
throws java.sql.SQLException
setReadOnly in interface java.sql.ConnectionreadOnly - ignored
java.sql.SQLException - if the connection is closed
public boolean isReadOnly()
throws java.sql.SQLException
isReadOnly in interface java.sql.Connectionjava.sql.SQLException - if the connection is closed
public void setCatalog(java.lang.String catalog)
throws java.sql.SQLException
setCatalog in interface java.sql.Connectioncatalog - ignored
java.sql.SQLException - if the connection is closed
public java.lang.String getCatalog()
throws java.sql.SQLException
getCatalog in interface java.sql.Connectionjava.sql.SQLException - if the connection is closed
public java.sql.SQLWarning getWarnings()
throws java.sql.SQLException
getWarnings in interface java.sql.Connectionjava.sql.SQLException
public void clearWarnings()
throws java.sql.SQLException
clearWarnings in interface java.sql.Connectionjava.sql.SQLException
public java.sql.PreparedStatement prepareStatement(java.lang.String sql,
int resultSetType,
int resultSetConcurrency)
throws java.sql.SQLException
prepareStatement in interface java.sql.Connectionsql - the SQL statementresultSetType - the result set type (ResultSet.TYPE_*)resultSetConcurrency - the concurrency (ResultSet.CONCUR_*)
java.sql.SQLException - if the connection is closed or the result set type or
concurrency are not supported
public void setTransactionIsolation(int level)
throws java.sql.SQLException
setTransactionIsolation in interface java.sql.Connectionlevel - the new transaction isolation level:
Connection.TRANSACTION_READ_UNCOMMITTED,
Connection.TRANSACTION_READ_COMMITTED, or
Connection.TRANSACTION_SERIALIZABLE
java.sql.SQLException - if the connection is closed or the isolation level
is not supported
public void setQueryTimeout(int seconds)
throws java.sql.SQLException
java.sql.SQLException
public int getQueryTimeout()
throws java.sql.SQLException
java.sql.SQLException
public int getTransactionIsolation()
throws java.sql.SQLException
getTransactionIsolation in interface java.sql.Connectionjava.sql.SQLException - if the connection is closed
public void setHoldability(int holdability)
throws java.sql.SQLException
setHoldability in interface java.sql.Connectionholdability - ResultSet.HOLD_CURSORS_OVER_COMMIT or
ResultSet.CLOSE_CURSORS_AT_COMMIT;
java.sql.SQLException - if the connection is closed or the holdability is not
supported
public int getHoldability()
throws java.sql.SQLException
getHoldability in interface java.sql.Connectionjava.sql.SQLException - if the connection is closed
public java.util.Map<java.lang.String,java.lang.Class<?>> getTypeMap()
throws java.sql.SQLException
getTypeMap in interface java.sql.Connectionjava.sql.SQLException - if the connection is closed
public void setTypeMap(java.util.Map<java.lang.String,java.lang.Class<?>> map)
throws java.sql.SQLException
setTypeMap in interface java.sql.Connectionjava.sql.SQLException
public java.sql.CallableStatement prepareCall(java.lang.String sql)
throws java.sql.SQLException
prepareCall in interface java.sql.Connectionsql - the SQL statement
java.sql.SQLException - if the connection is closed or the statement is not valid
public java.sql.CallableStatement prepareCall(java.lang.String sql,
int resultSetType,
int resultSetConcurrency)
throws java.sql.SQLException
prepareCall in interface java.sql.Connectionsql - the SQL statementresultSetType - the result set type (ResultSet.TYPE_*)resultSetConcurrency - the concurrency (ResultSet.CONCUR_*)
java.sql.SQLException - if the connection is closed or the result set type or
concurrency are not supported
public java.sql.CallableStatement prepareCall(java.lang.String sql,
int resultSetType,
int resultSetConcurrency,
int resultSetHoldability)
throws java.sql.SQLException
prepareCall in interface java.sql.Connectionsql - the SQL statementresultSetType - the result set type (ResultSet.TYPE_*)resultSetConcurrency - the concurrency (ResultSet.CONCUR_*)resultSetHoldability - the holdability (ResultSet.HOLD* / CLOSE*)
java.sql.SQLException - if the connection is closed or the result set type,
concurrency, or holdability are not supported
public java.sql.Savepoint setSavepoint()
throws java.sql.SQLException
setSavepoint in interface java.sql.Connectionjava.sql.SQLException
public java.sql.Savepoint setSavepoint(java.lang.String name)
throws java.sql.SQLException
setSavepoint in interface java.sql.Connectionname - the savepoint name
java.sql.SQLException
public void rollback(java.sql.Savepoint savepoint)
throws java.sql.SQLException
rollback in interface java.sql.Connectionsavepoint - the savepoint
java.sql.SQLException
public void releaseSavepoint(java.sql.Savepoint savepoint)
throws java.sql.SQLException
releaseSavepoint in interface java.sql.Connectionsavepoint - the savepoint to release
java.sql.SQLException
public java.sql.PreparedStatement prepareStatement(java.lang.String sql,
int resultSetType,
int resultSetConcurrency,
int resultSetHoldability)
throws java.sql.SQLException
prepareStatement in interface java.sql.Connectionsql - the SQL statementresultSetType - the result set type (ResultSet.TYPE_*)resultSetConcurrency - the concurrency (ResultSet.CONCUR_*)resultSetHoldability - the holdability (ResultSet.HOLD* / CLOSE*)
java.sql.SQLException - if the connection is closed or the result set type,
concurrency, or holdability are not supported
public java.sql.PreparedStatement prepareStatement(java.lang.String sql,
int autoGeneratedKeys)
throws java.sql.SQLException
prepareStatement in interface java.sql.Connectionsql - the SQL statementautoGeneratedKeys - ignored
java.sql.SQLException - if the connection is closed
public java.sql.PreparedStatement prepareStatement(java.lang.String sql,
int[] columnIndexes)
throws java.sql.SQLException
prepareStatement in interface java.sql.Connectionsql - the SQL statementcolumnIndexes - ignored
java.sql.SQLException - if the connection is closed
public java.sql.PreparedStatement prepareStatement(java.lang.String sql,
java.lang.String[] columnNames)
throws java.sql.SQLException
prepareStatement in interface java.sql.Connectionsql - the SQL statementcolumnNames - ignored
java.sql.SQLException - if the connection is closedprotected void checkClosed()
DbException - if the connection or session is closedprotected void checkClosed(boolean write)
write - if the next operation is possibly writing
DbException - if the connection or session is closedprotected void afterWriting()
public int getPowerOffCount()
public void setPowerOffCount(int count)
public void setExecutingStatement(java.sql.Statement stat)
public java.sql.Clob createClob()
throws java.sql.SQLException
java.sql.SQLException
public java.sql.Blob createBlob()
throws java.sql.SQLException
java.sql.SQLExceptionpublic boolean isValid(int timeout)
timeout - the number of seconds to wait for the database to respond
(ignored)
public Value createClob(java.io.Reader x,
long length)
x - the readerlength - the length (if smaller or equal than 0, all data until the
end of file is read)
public Value createBlob(java.io.InputStream x,
long length)
x - the input streamlength - the length (if smaller or equal than 0, all data until the
end of file is read)
public java.lang.String toString()
toString in class java.lang.Objectpublic void setTraceLevel(int level)
|
||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||