Use Derby DB from OpenOffice

  • From downloaded derby archive extract files named derby.jar and derbyclient.jar and place it somewhere on the hard disk. Remember where you put it.
  • Run OpenOffice. Open tools->Options. Go to
    OpenOffice.org->Java. Click on “Class path” button. Click on “Add
    archive”. Find and select the derby.jar and derbyclient.jar files and press “Open”. Press OK in Class Path window. Press OK in options window.
  • Open File->New->Database
  • Select “Connect to an existing database” and choose “JDBC” database. Press Next.
  • In the “Datasource URL” type “derby:” and then (without space)
    the URL for data. 
  • In the “JDBC Driver Class” type: org.apache.derby.jdbc.EmbeddedDriver or org.apache.derby.jdbc.ClientDriver
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s