Using MySQL

From NeoWiki

(Difference between revisions)
Jump to: navigation, search
Revision as of 08:16, 21 January 2005 (edit)
Sardisson (Talk | contribs)
(move over updated article from old wiki)
← Previous diff		 Revision as of 05:44, 29 January 2005 (edit) (undo)
Sardisson (Talk | contribs)
(a report of working OBDC! reorg the page a bit)
Next diff →
Line 1: Line 1:
== Enabling NeoOffice/J or OpenOffice.org/X11 to connect to MySQL databases == == Enabling NeoOffice/J or OpenOffice.org/X11 to connect to MySQL databases ==
 +=== Using JDBC and Connector/J ===
 +
 +==== Installation ====
* Download Connector/J from the [http://www.mysql.com/products/connector/ MySQL website]. * Download Connector/J from the [http://www.mysql.com/products/connector/ MySQL website].
** The included README gives much information. ** The included README gives much information.
Line 11: Line 14:
** 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/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.
-*** 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.
 +: ''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.''
-With this basic setup the connection should work.+==== Configuration ====
-Then you come to the fine tuning stuff: charset, etc...+With the above basic setup, the connection should work. Then you come to the fine tuning stuff: charset, etc...
- +
-''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 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 ===
 +
 +'''mansky''' posts some steps for getting '''OBDC''' to work with MySQL and [[OpenOffice.orgX11|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.

Revision as of 05:44, 29 January 2005

Contents

Enabling NeoOffice/J or OpenOffice.org/X11 to connect to MySQL databases

Using JDBC and Connector/J

Installation

  • Download Connector/J from the MySQL website.
    • The included README gives much information.
    • The most important keypoints are:
      • the class name of the JDBCdriver: com.mysql.jdbc.Driver
      • the URL format: jdbc:mysql://host.domain/database_name
    • 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.
  • 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 Neo/J: I had to put it in the <NeoOffice>/Contents/MacOS/classes 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.
There is also an attachment (.sxw) to OpenOffice.org Issue 13753 which contains screenshots and a different location for placing the Connector/J file.

Configuration

With the above basic setup, the connection should work. Then you come to the fine tuning stuff: charset, etc...

There are additional pointers available in this thread on trinity on other MySQL configuration issues.

Using OBDC

mansky posts some steps for getting OBDC to work with MySQL and OpenOffice.org/X11 in this post on trinity; it also contains other OOo/MySQL pointers.

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