background image

<< Contents - Derby system tables | Contents - Derby property reference >>

Contents - JDBC 4.0 and 4.1 features

<< Contents - Derby system tables | Contents - Derby property reference >>

Version 10.8 Derby Reference Manual

vi

Connection functionality not supported............................................................. 306

java.sql.DatabaseMetaData interface................................................................... 307

DatabaseMetaData result sets.......................................................................... 307
java.sql.DatabaseMetaData.getProcedureColumns method............................. 307
Parameters to getProcedureColumns............................................................... 307
Columns in the ResultSet returned by getProcedureColumns.......................... 307
java.sql.DatabaseMetaData.getBestRowIdentifier method................................308

java.sql.Statement interface..................................................................................309

ResultSet objects ............................................................................................. 309
Autogenerated keys...........................................................................................310

java.sql.CallableStatement interface.................................................................... 311

CallableStatements and OUT Parameters .......................................................311
CallableStatements and INOUT parameters ....................................................311

java.sql.PreparedStatement interface.................................................................. 313

Prepared statements and streaming columns ..................................................313

java.sql.ResultSet interface.................................................................................. 314

ResultSets and streaming columns ................................................................. 315

java.sql.ResultSetMetaData interface.................................................................. 316
java.sql.SQLException class................................................................................ 316
java.sql.SQLWarning class................................................................................... 316
java.sql.Savepoint interface..................................................................................316
Mapping of java.sql.Types to SQL types............................................................ 316

Mapping of java.sql.Blob and java.sql.Clob interfaces...................................... 317

JDBC Package for Connected Device Configuration/Foundation Profile (JSR
169).......................................................................................................................... 319
JDBC 4.0 and 4.1 features.................................................................................... 320

Refined subclasses of SQLException............................................................... 321
java.sql.Connection interface: JDBC 4.0 features.............................................321
java.sql.DatabaseMetaData interface: JDBC 4.0 features................................ 321
java.sql.Statement interface: JDBC 4.0 features...............................................322
javax.sql.DataSource interface: JDBC 4.0 features.......................................... 322
java.sql.SQLXML interface................................................................................ 322

JDBC 4.1-only features......................................................................................... 322

java.sql.Connection interface: JDBC 4.1 features.............................................322

JDBC escape syntax ............................................................................................ 323

JDBC escape keyword for call statements....................................................... 323
JDBC escape syntax for LIKE clauses............................................................. 324
JDBC escape syntax for fn keyword.................................................................324
JDBC escape syntax for outer joins..................................................................330
JDBC escape syntax for time formats.............................................................. 331
JDBC escape syntax for date formats.............................................................. 331
JDBC escape syntax for timestamp formats..................................................... 332

Setting attributes for the database connection URL ....................................................333

bootPassword=key attribute................................................................................. 333
collation=collation attribute.................................................................................. 333
create=true attribute.............................................................................................. 334
createFrom=path attribute.................................................................................... 335
databaseName=nameofDatabase attribute..........................................................336
dataEncryption=true attribute...............................................................................336
deregister=false attribute...................................................................................... 337
drop=true attribute................................................................................................. 337
encryptionKey=key attribute.................................................................................338
encryptionProvider=providerName attribute.......................................................338
encryptionAlgorithm=algorithm attribute............................................................ 339
failover=true attribute............................................................................................ 340