Differences between revisions 29 and 30
Revision 29 as of 2012-05-14 17:34:52
Size: 3773
Comment:
Revision 30 as of 2014-02-01 16:13:19
Size: 3869
Comment:
Deletions are marked like this. Additions are marked like this.
Line 28: Line 28:
|| SecurityPolicyTips || Information about defining Java security policy for the Derby code ||

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

InMemoryDBPerformance

Some general observations on the performance of in-memory databases

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

ListFileNamesOfTables

How to determine which table belongs to which file in SEG0 (java function included)

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

OldSpaceTableVti

For use with versions 10.0 - 10.2 > Obtaining space usage information in a pre-10.3 database

PerformanceDiagnosisTips

Initial steps to help track down performance problems between Derby releases

SecurityPolicyTips

Information about defining Java security policy for the Derby code

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

UsingDb2Driver

Accessing the Network Server by using the IBM DB2 Driver for JDBC is no longer supported

EscapeSpecCharPaths

Special characters in the connection URL for a DB path need to be escaped

NetworkServerServletInterface

Further information about using the servlet interface to the Network Server

HintsAndTips (last edited 2014-02-01 16:13:19 by BryanPendleton)