OpenOffice and JDBC for data access - Revision history

MaciejBlizinski: OO version bump up.

2006-12-08T18:10:24Z

OO version bump up.

MaciejBlizinski at 20:08, 24 September 2005

2005-09-24T20:08:35Z

MaciejBlizinski at 19:38, 24 September 2005

2005-09-24T19:38:18Z

MaciejBlizinski at 19:37, 24 September 2005

2005-09-24T19:37:56Z

MaciejBlizinski at 13:39, 24 September 2005

2005-09-24T13:39:19Z

MaciejBlizinski at 09:07, 24 September 2005

2005-09-24T09:07:50Z

New page

It is possible to access the database directly from OpenOffice, using JDBC connection. To do it, take the following steps.

#Backup your data. See: [[data backup]].
#Download and install OpenOffice 1.9 (beta) or newer. You can get it from [http://www.openoffice.org]. Please note that this instruction will not work with OpenOffice 1.x. You need version at least 1.9.
#Download Derby from http://incubator.apache.org/derby/derby_downloads.html
#From downloaded derby archive extract file named <pre>derby.jar</pre> 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 <pre>derby.jar</pre> file 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 DataCollectionSoftware folder for data. It's normally named "EactsCongenitalDatabase" and placed in your home directory. It should look like this: <pre>jdbc:derby:c:\myfolder\EactsCongenitalDatabase</pre>
#In the "JDBC Driver Class" type exactly as shown below: <pre>org.apache.derby.jdbc.EmbeddedDriver</pre>
#Press "Next"
#You don't need to type in the user name. Press "Next"
#Press "Finish"
#Type in the file name, for example "eacts_direct". Press "Save"
#Click on "Tables" on the left side. You should see the list of tables in the database.

'''Warning!''' You can easily damage the database by changing its contents directly! ||

Above configuration was tested only on [[GNU/Linux]].

'''Please note:''' Only one program can access the database folder at a time. This means that you can't open OpenOffice Base and EACTS Congenital Database at the same time.

@@ Line 4: / Line 4: @@
 #Download and install OpenOffice 1.9 (beta) or newer. You can get it from [http://www.openoffice.org]. Please note that this instruction will not work with OpenOffice 1.x. You need version at least 1.9.
 #Download Derby from http://incubator.apache.org/derby/derby_downloads.html
-#From downloaded derby archive extract file named <tt>derby.jar</tt> and place it somewhere on the hard disk. Remember where you put it.
+#From downloaded derby archive extract file named '''derby.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 <tt>derby.jar</t> file and press "Open". Press OK in Class Path window. Press OK in options window.
+#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''' file 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.

←Older revision		Revision as of 13:39, 24 September 2005
Line 21:		Line 21:

	'''Please note:''' Only one program can access the database folder at a time. This means that you can't open OpenOffice Base and EACTS Congenital Database at the same time.		'''Please note:''' Only one program can access the database folder at a time. This means that you can't open OpenOffice Base and EACTS Congenital Database at the same time.
		+
		+	[[category:terminology]]

@@ Line 16: / Line 16: @@
 #Click on "Tables" on the left side. You should see the list of tables in the database.
-'''Warning!''' You can easily damage the database by changing its contents directly! ||
+'''Warning!''' You can easily damage the database by changing its contents directly!
 Above configuration was tested only on [[GNU/Linux]].