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 |
What does it mean that Derby runs on any certified JVM? |
|
Got Cardinality Statistics for your indexes? (and how to get them) |
|
How to run ij with command history and similar features |
|
Running SYSCS_UTIL.SYSCS_CHECK_TABLE on all tables in a database |
|
Specifying the Database Name in a JDBC Connection URL |
|
Annotated |
|
How to implement SQL routines (functions and procedures) in Java |
|
Pointer to programs that can help setup Derby to run as a Windows Service |
|
Information about the Derby PlugIn for the Eclipse IDE |
|
How to configure your embedded app to allow other clients to connect to Derby |
|
Using Derby with Hibernate |
|
How to create the database, its tables, and intial data when using JPA / Top-Link Essentials |
|
Some general observations on the performance of in-memory databases |
|
Data dictionary query to list the index names support Primary and Foreign Keys |
|
How to list information about the columns in a table |
|
Data dictionary query to return table names and schemas |
|
How to determine which table belongs to which file in SEG0 (java function included) |
|
Hints on debugging a locking situation (deadlock or lock timeout) |
|
Reading |
|
For use with versions 10.0 - 10.2 > Obtaining space usage information in a pre-10.3 database |
|
Initial steps to help track down performance problems between Derby releases |
|
Information about defining Java security policy for the Derby code |
|
Interpreting Information in the Statement Execution Plan |
|
Tips on inserting manually assigning values into identity columns used in unique keys |
|
How do I get more information when I get a SQLException? |
|
Upgrading Derby 10.0 to 10.1 – Very Simple! |
|
Soft and hard upgrade information in a blog |
|
How to find out which version of Derby is on your disk or in your CLASSPATH, or which JDBC version your VM supports |
|
Accessing the Network Server by using the IBM DB2 Driver for JDBC is no longer supported |
|
Special characters in the connection URL for a DB path need to be escaped |
|
Further information about using the servlet interface to the Network Server |