<< WARNING SQLState | Using sysinfo to check the classpath >>

sysinfo example

<< WARNING SQLState | Using sysinfo to check the classpath >>

Derby Tools and Utilities Guide

sysinfo

Use the

sysinfo

utility to display information about your Java environment and Derby

(including version information). To use

sysinfo

, do one of the following:

· If you are relatively new to the Java programming language, follow the

instructions in "Setting up your environment" in Getting Started with Derby
to set the

DERBY_HOME

and

JAVA_HOME

environment variables and to add

DERBY_HOME/bin

to your path. Then use the following command:

sysinfo

· If you are a regular Java user but are new to Derby, set the

DERBY_HOME

environment variable, then use a

java

command to invoke the

derbyrun.jar

file:

(UNIX) java [options] -jar $DERBY_HOME/lib/derbyrun.jar sysinfo

(Windows) java [options] -jar %DERBY_HOME%\lib\derbyrun.jar sysinfo

· If you are familiar with both the Java programming language and Derby, you have

already set

DERBY_HOME

. Set your classpath to include the Derby jar files. Then

use a

java

command to invoke the

sysinfo

class directly.

java org.apache.derby.tools.sysinfo

sysinfo example

When you run the

sysinfo

command using the

derbyrun.jar

file, the output looks

something like this:

java -jar C:\db-derby-10.8.0.0-bin\lib\derbyrun.jar sysinfo
------------------ Java Information ------------------
Java Version: 1.6.0_24
Java Vendor: Sun Microsystems Inc.
Java home: C:\jdk1.6.0_24\jre
Java classpath: C:\db-derby-10.8.0.0-bin\lib\derbyrun.jar
OS name: Windows XP
OS architecture: x86
OS version: 5.1
Java user name: user1
Java user home: C:\Documents and Settings\user1
Java user dir: C:\DERBYDBS
java.specification.name: Java Platform API Specification
java.specification.version: 1.6
java.runtime.version: 1.6.0_24-b07
--------- Derby Information --------
JRE - JDBC: Java SE 6 - JDBC 4.0
[C:\db-derby-10.7.1.0-bin\lib\derby.jar] 10.8.0.0 - (1076370)
[C:\db-derby-10.7.1.0-bin\lib\derbytools.jar] 10.8.0.0 - (1076370)
[C:\db-derby-10.7.1.0-bin\lib\derbynet.jar] 10.8.0.0 - (1076370)
[C:\db-derby-10.7.1.0-bin\lib\derbyclient.jar] 10.8.0.0 - (1076370)
------------------------------------------------------
----------------- Locale Information -----------------
Current Locale : [English/United States [en_US]]
Found support for locale: [cs]
version: 10.8.0.0 - (1076370)
Found support for locale: [de_DE]
version: 10.8.0.0 - (1076370)
Found support for locale: [es]
version: 10.8.0.0 - (1076370)
Found support for locale: [fr]
version: 10.8.0.0 - (1076370)
Found support for locale: [hu]
version: 10.8.0.0 - (1076370)