Article:		An Introduction to WebObjects
Subject:		MySQL
Date:		2003-10-09 12:51:50
From:		anonymous2
can you provide a detail explanation of the connection properties in regards to MySQL - in particualr how to connect to a local MySQL server and a remote MySQL server. I have not been able to find this anywhere. Thanks

Showing messages 1 through 4 of 4.

• MySQL
  2003-10-09 13:46:45  Josh Paul | [View]
  
  
  Yup...MySQL. I initially had a tough time setting it up as well. Before I dive in here, I highly recommend OpenBase database products.
  
  In order to set up MySQL you will need to install it first. If you have not, I recommend using Aaron Faby's fantastic installer (http://www.serverlogistics.com). After installing MySQL you will need the correct JDBC driver, which can be downloaded from the MySQL website.
  
  From there, you will need to do the following, using the "Model:Switch Adaptor..." menu item:
  1) make sure your EOModel is using the JDBC connector
  2) enter the Username for the database you are connecting to
  3) enter the Password for the user/database you are connecting to
  4) enter the URL for your database (i.e. jdbc:mysql://localhost/my_database)
  5) enter the JDBC driver information (i.e. org.gjt.mm.mysql.Driver)
  
  I hope that information helps.
• MySQL
  2003-10-15 06:58:06  anonymous2 [View]
  
  
  What is the main reasoning for Openbase versus MySQL. I opened minded as to both - just wondering why you recommend it?
  
  Thanks
  
  PS - Instructions 4&5 are the two I did not have a clue how to input thanks.
• MySQL
  2004-08-31 02:21:13  BernhardGruber [View]
  
  
  mysql is not ACID.
• MySQL
  2003-10-15 08:50:31  Josh Paul | [View]
  
  
  (My personal opinion...)
  
  I've used a variety of databases, including MySQL and OpenBase. I've found OpenBase's support to be exceptional, as well as the administration tools. The company also uses WebObjects for it's online presence, so they know how both WO and OB interact in "real world" scenarios.
  
  I within the past two years, I have moved a WO project from OpenBase to MySQL and back again. I've found the performance of both to be similar (~50,000 transactions per day). I moved back to OB for two reasons:
  1) I prefer the OB administration tools
  2) OB offers an option to index Word, PDF, etc.
  
  The beauty of EOF is that I can move my project(s) from one database to another with little effort.