HintsAndTips - Db-derby Wiki

Hints, Tips and Useful Information from Derby Users

The HintsAndTips Wiki page contains links to helpful information about Derby submitted by members of the Derby community. This is the place to link in notes, check lists, how-to's and other information that you find helpful and would like to share with others. Create your write-up and add a link to the information in the table below.

Title	Description
CertifiedJvmRequired	What does it mean that Derby runs on any certified JVM?
CheckingForIndexStatistics	Got Cardinality Statistics for your indexes? (and how to get them)
CommandHistoryInIj	How to run ij with command history and similar features
DatabaseConsistencyCheck	Running SYSCS_UTIL.SYSCS_CHECK_TABLE on all tables in a database
DatabaseNamesRelativeAbsolute	Specifying the Database Name in a JDBC Connection URL
DebugPropertiesTmpl	Annotated `derby.properties` useful for development and test environments
DerbySQLroutines	How to implement SQL routines (functions and procedures) in Java
DerbyWindowsService	Pointer to programs that can help setup Derby to run as a Windows Service
DerbyEclipsePlugIn	Information about the Derby PlugIn for the Eclipse IDE
Embedded And Server	How to configure your embedded app to allow other clients to connect to Derby
HibernateHelp	Using Derby with Hibernate
Initializing Embedded Derby using JPA	How to create the database, its tables, and intial data when using JPA / Top-Link Essentials
ListKeyIndexes	Data dictionary query to list the index names support Primary and Foreign Keys
ListTableColumns	How to list information about the columns in a table
ListTableNames	Data dictionary query to return table names and schemas
LockDebugging	Hints on debugging a locking situation (deadlock or lock timeout)
LogStamentTextMsgs	Reading `logStatementText` messages to find the compile and execution times of a statement
PerformanceDiagnosisTips	Initial steps to help track down performance problems between Derby releases
StmtExecutionPlan	Interpreting Information in the Statement Execution Plan
UniqueIdentityAndInserts	Tips on inserting manually assigning values into identity columns used in unique keys
UnwindExceptionChain	How do I get more information when I get a SQLException?
UpgradingTen	Upgrading Derby 10.0 to 10.1 – Very Simple!
Upgrading Derby	Soft and hard upgrade information in a blog
VersionInfo	How to find out which version of Derby is on your disk or in your CLASSPATH, or which JDBC version your VM supports