Using MySQL

Revision as of 14:48, 24 August 2006 (edit)
Amayze ( | contribs)

← Previous diff

Current revision (03:21, 12 February 2008) (edit) (undo)
Sardisson (Talk | contribs)
m (fixing double redirect)

(2 intermediate revisions not shown.)

Line 1:

+

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

Line 51:

Line 53:

# Ensure that no error message appears and that there is an entry in the white box.

-

====Detailed Installation for NeoOffice 2.0 Beta and above====

+

====Detailed Installation and Usage for NeoOffice 2.0 Beta and above====

-

# 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).

+

=====Installation=====

-

# 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).

+

# 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 (~~I chose <tt>~~~/~~lib<~~/~~tt>~~).

+

# 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/J.

+

# Launch NeoOffice.

-

# From the '''NeoOffice/J''' menu, choose '''Preferencesâ€¦'''.

+

# From the '''NeoOffice''' menu, choose '''Preferencesâ€¦'''.

-

# On the left is a tree of items. At the very top is "NeoOffice/J". Indented and underneath is a list of other items. Click on "~~Security~~".

+

# 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 ~~bottom~~ of ~~the right~~ panel ~~is a "Java" section~~; click the "~~Browse~~" ~~button in that section~~.

+

# 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 "~~Select Archives~~" window. Make sure that there are no other Connector/J versions installed (e.g., 3.1) or they will make life messy. To remove them, click the jar file to select, then click ~~Delete~~. Repeat as necessary. (Note: not all items here are necessarily Connector/J archives, use some caution).

+

# 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" button.

+

# Click the "Add Archiveâ€¦" button.

-

# Browse to the directory where you installed the Connector/J 3.0 jar file (in step 4). Select the .jar file and click the "Open" 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/J.

+

# Exit NeoOffice.

-

# Restart NeoOffice/J.

+

# Restart NeoOffice.

-

# From the '''~~Tools~~''' menu, select '''~~Data Sources...~~'''; this opens the ~~"Data Source Administration" window~~.

+

-

# ~~Above~~ the panel ~~on the left is a button that says~~ '''~~New Data Source~~'''~~. Click it.~~

+

You are now ready to use MySQL Databases with NeoOffice 2.0

-

~~# In~~ the ~~right panel,~~ select "MySQL" ~~for "~~Database ~~Type"~~ and click ~~"Apply"~~.

+

-

# ~~Click~~ the "MySQL~~" tab at~~ the ~~top~~ of ~~the right panel~~.

+

=====Usage=====

-

# In the ~~"Type of connection" section, select~~ the ~~radio button next to "Use Connector~~/~~J3"~~.

+

# From the '''File''' menu, select '''New''' and then '''Database''' from the hierarchical menu; this opens the Database Wizard.

-

# ~~Set the "~~MySQL JDBC driver class~~" to~~: <tt>com.mysql.jdbc.Driver</tt>

+

# In the right hand panel, select '''Connect to an existing databae''' and from the list below select "MySQL".

-

# In the ~~"General" section, change~~ the ~~non-grey part of the "Data source URL" to: <tt~~>~~localhost:3306/test</tt~~>

+

# Click '''Next >>>'''.

-

# ~~Set~~ the user ~~name~~ and check the password ~~box~~, ~~if required~~.

+

# Select '''Connect using JDBC (Java Database Connectivity)''' and click '''Next >>>''' again.

-

# ~~Click~~ the ~~"Tables" tab at~~ the ~~top of the right panel.~~

+

# Enter the name of your MySQL database in the '''Name of database''' field (e.g. <tt>test</tt>).

-

~~# Fill out~~ your password ~~if necessary~~.

+

# In the Server URL field enter <tt>localhost</tt>

-

# ~~Ensure that no error message~~ appears ~~and that there is an entry~~ in the ~~white box~~.

+

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

Line 112:

Line 126:

[[Category:Tips and Hints]][[Category:NeoOffice]][[Category:OpenOffice.org]][[Category:Fixme]]

+

-->

From NeoWiki

Current revision

Views

Personal tools

Navigation

Search

Toolbox

+#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.
 # Ensure that no error message appears and that there is an entry in the white box.
-====Detailed Installation for NeoOffice 2.0 Beta and above====
+====Detailed Installation and Usage for NeoOffice 2.0 Beta and above====
-# 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).
+=====Installation=====
-# 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).
+# 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 (I chose <tt>~/lib</tt>).
+# 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/J.
+# Launch NeoOffice.
-# From the '''NeoOffice/J''' menu, choose '''Preferencesâ€¦'''.
+# From the '''NeoOffice''' menu, choose '''Preferencesâ€¦'''.
-# On the left is a tree of items.  At the very top is "NeoOffice/J".  Indented and underneath is a list of other items.  Click on "Security".
+# 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 bottom of the right panel is a "Java" section; click the "Browse" button in that section.
+# 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 "Select Archives" window.  Make sure that there are no other Connector/J versions installed (e.g., 3.1) or they will make life messy.  To remove them, click the jar file to select, then click Delete.  Repeat as necessary.  (Note: not all items here are necessarily Connector/J archives, use some caution).
+# 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" button.
+# Click the "Add Archiveâ€¦" button.
-# Browse to the directory where you installed the Connector/J 3.0 jar file (in step 4).  Select the .jar file and click the "Open" 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/J.
+# Exit NeoOffice.
-# Restart NeoOffice/J.
+# Restart NeoOffice.
-# From the '''Tools''' menu, select '''Data Sources...'''; this opens the "Data Source Administration" window.
-# Above the panel on the left is a button that says '''New Data Source'''.  Click it.
+You are now ready to use MySQL Databases with NeoOffice 2.0
-# In the right panel, select "MySQL" for "Database Type" and click "Apply".
-# Click the "MySQL" tab at the top of the right panel.
+=====Usage=====
-# In the "Type of connection" section, select the radio button next to "Use Connector/J3".
+# From the '''File''' menu, select '''New''' and then '''Database''' from the hierarchical menu; this opens the Database Wizard.
-# Set the "MySQL JDBC driver class" to: <tt>com.mysql.jdbc.Driver</tt>
+# In the right hand panel, select '''Connect to an existing databae''' and from the list below select "MySQL".
-# In the "General" section, change the non-grey part of the "Data source URL" to: <tt>localhost:3306/test</tt>
+# Click '''Next >>>'''.
-# Set the user name and check the password box, if required.
+# Select '''Connect using JDBC (Java Database Connectivity)''' and click '''Next >>>''' again.
-# Click the "Tables" tab at the top of the right panel.
+# Enter the name of your MySQL database in the '''Name of database''' field (e.g. <tt>test</tt>).
-# Fill out your password if necessary.
+# In the Server URL field enter <tt>localhost</tt>
-# Ensure that no error message appears and that there is an entry in the white box.
+# 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 ====
 <br style="clear:both;" />
 [[Category:Tips and Hints]][[Category:NeoOffice]][[Category:OpenOffice.org]][[Category:Fixme]]
+-->