NeoJEnablemySQL

From NeoWiki

Revision as of 09:15, 2 January 2005 (edit) Waldo ( | contribs) (from old wiki) ← Previous diff		Current revision (03:20, 12 February 2008) (edit) (undo) Sardisson (Talk | contribs) m (fixing double redirect)
(5 intermediate revisions not shown.)
Line 1:		Line 1:
-	== Enabling NeoOffice/J or OpenOffice.org/X11 to connect to MySQL databases ==	+	#REDIRECT [[NeoBase]]
-		+
-	* Download Connector/J from the [http://www.mysql.com/products/connector/ 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	+
-		+
-	*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 [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.	+

---

Current revision

1. REDIRECT NeoBase