Using MySQL

From NeoWiki

(Difference between revisions)
Jump to: navigation, search
Revision as of 23:26, 16 September 2005 (edit)
Sardisson (Talk | contribs)
(work on conformance to Neo/J style guide, add intro)
← Previous diff		 Current revision (03:21, 12 February 2008) (edit) (undo)
Sardisson (Talk | contribs)
m (fixing double redirect)
 
(11 intermediate revisions not shown.)
Line 1: Line 1:
-While NeoOffice/J 1.1 and OpenOffice.org/X11 do not include a separate database component like Microsoft Access, it is possible to use either program to connect to existing MySQL databases and enter or manipulate data, including creating detailed forms and reports. This article contains information on installing, configuring, and using a MySQL database with NeoOffice/J or OpenOffice.org/X11.+#REDIRECT [[NeoBase]]
 +<!--
 +While NeoOffice 1.2 Alpha, NeoOffice/J 1.1 and OpenOffice.org/X11 do not include a separate database component like Microsoft Access, it is possible to use either program to connect to existing MySQL databases and enter or manipulate data, including creating detailed forms and reports. This article contains information on installing, configuring, and using a MySQL database with NeoOffice or OpenOffice.org/X11.
-''If you do not have a MySQL database, you can [[Creating a Database|create a simple database]] in NeoOffice/J or OpenOffice.org/X11—or even use a Calc table if your needs are very simple.''+''If you do not have a MySQL database, you can [[Creating a Database|create a simple database]] in NeoOffice or OpenOffice.org/X11—or even use a Calc table if your needs are very simple.''
-==Enabling NeoOffice/J or OpenOffice.org/X11 to connect to MySQL databases==+==Enabling NeoOffice or OpenOffice.org/X11 to connect to MySQL databases==
===Using JDBC and Connector/J=== ===Using JDBC and Connector/J===
====Installation Overview==== ====Installation Overview====
-* Download Connector/J 3.0 from the [http://www.mysql.com/products/connector/ MySQL website].+* Download Connector/J 3.1 or later from the [http://www.mysql.com/products/connector/ MySQL website].
** The included README gives much information. ** The included README gives much information.
** The most important keypoints are: ** The most important keypoints are:
*** the class name of the JDBCdriver: <tt>com.mysql.jdbc.Driver</tt> *** the class name of the JDBCdriver: <tt>com.mysql.jdbc.Driver</tt>
*** the URL format: <tt>jdbc:mysql://host.domain/database_name</tt> *** the URL format: <tt>jdbc:mysql://host.domain/database_name</tt>
-** You will need a version of Connector/J that supports Java 1.3.x, since that is the version of Java used in NeoOffice/J.+** For NeoOffice/J 1.1 and below, you will need a version of Connector/J (3.0) that supports Java 1.3.x, since that is the version of Java used in NeoOffice/J. NeoOffice 1.2 Alpha uses Java 1.4.2 and should use versions of Connector/J that support Java 1.4.2.
*** Note: Connector/J 3.1 and, presumably, later versions are not Java 1.3.x compatible. *** Note: Connector/J 3.1 and, presumably, later versions are not Java 1.3.x compatible.
*The jar file location: *The jar file location:
** for OOo/X11: you can put it where you want. To let OOo know, you shoud go to "Tools->Options" menu item. Then in the "security" pane, there is a place to add directories to classpath. Click on browse and find your jar file. ** for OOo/X11: you can put it where you want. To let OOo know, you shoud go to "Tools->Options" menu item. Then in the "security" pane, there is a place to add directories to classpath. Click on browse and find your jar file.
-** for Neo/J: I had to put it in the <tt><NeoOffice>/Contents/MacOS/classes</tt> folder to get it found. Didn't check with recent release if the previous classpath setting does work.+** for Neo: I had to put it in the <tt><NeoOffice>/Contents/MacOS/classes</tt> folder to get it found. Didn't check with recent release if the previous classpath setting does work.
::: FYI. I just tried adding the MySQL jar file using the Security pane in the Tools->Options menu item Neo/J 1.1 Alpha 2. After adding the jar file in that pane and restarting Neo/J, I successfully connected to my MySQL database. ::: FYI. I just tried adding the MySQL jar file using the Security pane in the Tools->Options menu item Neo/J 1.1 Alpha 2. After adding the jar file in that pane and restarting Neo/J, I successfully connected to my MySQL database.
-::: This works with Neo/J 1.1 final. The former option is probably better for providing it to all users, whereas this is well suited for +::: This works with Neo/J 1.1 final and newer. The former option is probably better for providing it to all users, whereas this is well suited for
: ''There is also an attachment (.sxw) to [http://www.openoffice.org/issues/show_bug.cgi?id=13753 OpenOffice.org Issue 13753] which contains screenshots and a different location for placing the Connector/J file.'' : ''There is also an attachment (.sxw) to [http://www.openoffice.org/issues/show_bug.cgi?id=13753 OpenOffice.org Issue 13753] which contains screenshots and a different location for placing the Connector/J file.''
-==== Detailed Installation ====+====Detailed Installation for NeoOffice/J 1.1 and below====
-# If you haven't already, install NeoOffice/J (I am using v1.1, downloaded 2005-08-14) and MySQL (I am using 4.1.13-standard).+''Parts of this tutorial are out-of-date and incorrect for NeoOffice 1.2 Alpha and later''
 +# If you haven't already, install NeoOffice/J (I am using v1.1, released 2005-06-22) and MySQL (I am using 4.1.13-standard).
# Download Connector/J 3.0 from http://www.mysql.com and save it to the Desktop. (I downloaded v3.0.17, the tar.gz version). # Download Connector/J 3.0 from http://www.mysql.com and save it to the Desktop. (I downloaded v3.0.17, the tar.gz version).
# Extract the Connector/J jar from the tar.gz archive. # Extract the Connector/J jar from the tar.gz archive.
Line 49: Line 52:
# Fill out your password if necessary. # Fill out your password if necessary.
# Ensure that no error message appears and that there is an entry in the white box. # Ensure that no error message appears and that there is an entry in the white box.
 +
 +====Detailed Installation and Usage for NeoOffice 2.0 Beta and above====
 +=====Installation=====
 +# If you haven't already, install NeoOffice 2.0 (I am using v2.0 Aqua Beta 2 Patch 3, released 2006-08-24) and MySQL (I am using 5.0.24-standard).
 +# Download Connector/J 3.1 from http://www.mysql.com and save it to the Desktop. (I downloaded v3.1.13, the tar.gz version).
 +# Extract the Connector/J jar from the tar.gz archive.
 +# Copy the .jar file to wherever you like (Perhaps ~/Library/MySQL/ for personal use, or /Library/MySQL/ for all users of the Mac).
 +# Launch NeoOffice.
 +# From the '''NeoOffice''' menu, choose '''Preferences…'''.
 +# On the left is a tree of items. At the very top is "NeoOffice". Indented and underneath is a list of other items. Click on "Java".
 +# This changes the panel on the right. At the right of this panel there are three buttons; click the bottom one marked "Class Path…".
 +# This opens the "Class Path" window. Make sure that there are no other Connector/J versions installed (e.g., 3.0) or they will make life messy. To remove them, click the jar file to select, then click Remove. Repeat as necessary. (Note: not all items here are necessarily Connector/J archives, use some caution).
 +# Click the "Add Archive…" button.
 +# Browse to the directory where you installed the Connector/J 3.1 jar file (in step 4). Select the .jar file and click the "Open" button.
 +# Click the "OK" button.
 +# Exit NeoOffice.
 +# Restart NeoOffice.
 +
 +You are now ready to use MySQL Databases with NeoOffice 2.0
 +
 +=====Usage=====
 +# From the '''File''' menu, select '''New''' and then '''Database''' from the hierarchical menu; this opens the Database Wizard.
 +# In the right hand panel, select '''Connect to an existing databae''' and from the list below select "MySQL".
 +# Click '''Next >>>'''.
 +# Select '''Connect using JDBC (Java Database Connectivity)''' and click '''Next >>>''' again.
 +# Enter the name of your MySQL database in the '''Name of database''' field (e.g. <tt>test</tt>).
 +# In the Server URL field enter <tt>localhost</tt>
 +# The '''Port number''' should be left as the default <tt>3306</tt> unless you have modified your MySQL installation.
 +# The '''MySQL JDBC driver class:''' should also be left as the default <tt>com.mysql.jdbc.Driver</tt>.
 +# To check that the JDBC Driver is working click '''Test class'''; if all is well a dialogue should appear reporting that the driver was loaded correctly.
 +# Click '''Next >>>'''.
 +# Enter your MySQL User name in the field provided and select '''Password required''' if you have a password set for that user. N.B. If you do not select this option you will never be prompted for a password and all connections will fail if one was set.
 +# To check you have entered all the details correctly so far click '''Test connection'''.
 +# If you need to enter a password you will now be prompted to enter it, and optionally have it remembered until you quit NeoOffice.
 +# If all is well a dialogue will tell you so. If not go back to the previous screen and check the database name before returning to this screen and checking your username and password.
 +# If you don't want to register the database (so it doesn't appears in the ---) then select '''No, do not register the database'''
 +# Click '''Finish''' and choose a name and location to save the database.
 +
 +You are now read to create queries and forms that use your MySQL database.
==== Configuration ==== ==== Configuration ====
Line 56: Line 98:
There are additional pointers available in [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&t=1004 this thread on trinity] on other MySQL configuration issues. There are additional pointers available in [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&t=1004 this thread on trinity] on other MySQL configuration issues.
-=== Using OBDC ===+=== Using ODBC ===
-'''mansky''' posts some steps for getting '''OBDC''' to work with MySQL and [[OpenOffice.org_Mac_OS_X_(X11)|OpenOffice.org/X11]] in [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=6428#6428 this post on trinity]; it also contains other OOo/MySQL pointers. +'''mansky''' posts some steps for getting '''ODBC''' to work with MySQL and [[OpenOffice.org_Mac_OS_X_(X11)|OpenOffice.org/X11]] in [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=6428#6428 this post on trinity]; it also contains other OOo/MySQL pointers.
-'''kervalen''' posts some steps for getting '''OBDC''' to work with MySQL and [[NeoOffice/J]] in [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&t=1100 this post on trinity].+'''kervalen''' posts some steps for getting '''ODBC''' to work with MySQL and [[NeoOffice/J]] in [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&t=1100 this post on trinity].
-== Using the Database with your NeoOffice/J Documents ==+More tips on ODBC in [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&t=2501 this thread].
-information on how to use the database+[http://bugzilla.neooffice.org/bug.php?op=show&bugid=1535 This bug] offers confirmation that NeoOffice 2.0 Alpha works with the ODBC driver from Actual Technologies.
 +==Enabling NeoOffice to connect to an hsqldb database==
-[[Category:Tips and Hints]][[Category:NeoOffice/J]][[Category:OpenOffice.org]]+[http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&t=2081 This thread on trinity] describes how to connect NeoOffice to an hsqldb database (hsqldb is used as the core of the Base component in OpenOffice.org 2.0).
 + 
 +==Enabling NeoOffice to connect to an postgresql database==
 +[http://bugzilla.neooffice.org/bug.php?op=show&bugid=1535 This bug] has tips to help you connect to a postgresql database via JDBC using NeoOffice 2.0 Alpha.
 + 
 +==Enabling NeoOffice to connect to a FileMaker Pro database==
 +[http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=21006#21006 This post on trinity] lists some general steps for connecting to a FileMaker Pro database.
 + 
 +If your database is simple and you want to convert it to NeoOffice Base, [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&p=20997#20997 this post] has some tips.
 + 
 +== Using the Database with your NeoOffice Documents ==
 +{{imageboxRight|[[image:neoj11_database.jpg|371px]]|NeoOffice/J 1.1 (in Italian) forms and queries<br> interacting with a MySQL database (108 KB)|Using the Database}}
 + 
 +information on how to use the database
 +<br style="clear:both;" />
 +[[Category:Tips and Hints]][[Category:NeoOffice]][[Category:OpenOffice.org]][[Category:Fixme]]
 +-->

Current revision

  1. REDIRECT NeoBase
Retrieved from "https://neowiki.neooffice.org/index.php/Using_MySQL"
Personal tools