NeoJEnablemySQL

From NeoWiki

Revision as of 09:15, 2 January 2005 (edit) Waldo ( | contribs) (from old wiki) ← Previous diff		Revision as of 07:53, 21 January 2005 (edit) (undo) Sardisson (Talk | contribs) (update to latest text from old wiki) Next diff →
Line 4:		Line 4:
	** 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: com.mysql.jdbc.Driver	+	*** the class name of the JDBCdriver: <tt>com.mysql.jdbc.Driver</tt>
-	*** the URL format: jdbc:mysql://host.domain/database_name	+	*** 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.
	*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 <NeoOffice>/Contents/MacOS/classes 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.
	With this basic setup the connection should work.		With this basic setup the connection should work.
		+
	Then you come to the fine tuning stuff: charset, etc...		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 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.

---

Revision as of 07:53, 21 January 2005

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

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

With this basic setup the connection should work.

Then you come to the fine tuning stuff: charset, etc...

There is also an attachment (.sxw) to OpenOffice.org Issue 13753 which contains screenshots and a different location for placing the Connector/J file.

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