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>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

Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s