Using MySQL

From NeoWiki

Revision as of 07:50, 12 February 2005 (edit) Sardisson (Talk | contribs) (add neo obdc link) ← Previous diff		Revision as of 09:02, 27 March 2005 (edit) (undo) Sardisson (Talk | contribs) m (rename OOoX11) Next diff →
Line 25:		Line 25:
	=== Using OBDC ===		=== 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.	+	'''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.
	'''kervalen''' posts some steps for getting '''OBDC''' to work with MySQL and [[NeoJInfo|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 '''OBDC''' to work with MySQL and [[NeoJInfo|NeoOffice/J]] in [http://trinity.neooffice.org/modules.php?name=Forums&file=viewtopic&t=1100 this post on trinity].

---

Revision as of 09:02, 27 March 2005

Contents 1 Enabling NeoOffice/J or OpenOffice.org/X11 to connect to MySQL databases 1.1 Using JDBC and Connector/J 1.1.1 Installation 1.1.2 Configuration 1.2 Using OBDC 2 Using the Database with your NeoOffice/J Documents

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.

kervalen posts some steps for getting OBDC to work with MySQL and NeoOffice/J in this post on trinity.

Using the Database with your NeoOffice/J Documents

information on how to use the database