Skip to Content
Last modified by Theodore Petrosky on 2013/05/03 09:11
Hide last authors
Pascal Robert 3.1 1 == PostgreSQL ==
smmccraw 1.1 2
3 These instructions are especially for those wanting to use PostgreSQL with primary keys of type serial.
4
5 (Valid as of 5th May 2005 for a Mac OS X development system with WO5.2.3 and PostgreSQL 7 or 8)
6
Theodore Petrosky 14.1 7 I don't think this is at all necessary in a new install today (5-1-2013) and the link below to hexdreams is not valid!
8
Theodore Petrosky 15.1 9 step two is correct though!!
10
Pascal Robert 3.1 11 === Step 1 ===
smmccraw 1.1 12
Theodore Petrosky 17.1 13 Obtain the following items from [[http:~~/~~/hexdreams.com/>>url:http://hexdreams.com/||shape="rect"]] placing their built products as suggested (but do check each item for bug fixes or notes)...
smmccraw 1.1 14
Theodore Petrosky 17.1 15 * PostgresqlPlugIn.framework ~-~-> /Library/Frameworks
16 * PostgresqlPlugInBundle.EOMPlugin ~-~-> /Developer/EOMBundles
smmccraw 1.1 17
Pascal Robert 3.1 18 === Step 2 ===
smmccraw 1.1 19
20 You should have the following Adaptor info set (in EOModeler) for your database after the above install:
21
Pascal Robert 3.1 22 * Username: username
23 * Password: password
smmccraw 1.1 24 * URL: jdbc:postgresql:~/~/localhost/yourDb
25 * Driver: org.postgresql.Driver
Theodore Petrosky 17.1 26 * Plugin: PostgresqlPlugIn
smmccraw 1.1 27
Theodore Petrosky 17.1 28 Note: case sensitive.
smmccraw 1.1 29
Pascal Robert 3.1 30 === Step 3 ===
smmccraw 1.1 31
32 Link the PostgresqlPlugIn.framework into your project.
33
Pascal Robert 3.1 34 == MySQL ==
smmccraw 1.1 35
Theodore Petrosky 17.1 36 From: [[http:~~/~~/www.macdevcenter.com/pub/a/mac/2003/09/26/webobjects.html?page=3>>url:http://www.macdevcenter.com/pub/a/mac/2003/09/26/webobjects.html?page=3||shape="rect"]]
smmccraw 1.1 37
Theodore Petrosky 17.1 38 ''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>>url:http://www.serverlogistics.com||shape="rect"]]). After installing MySQL you will need the correct JDBC driver, which can be downloaded from the MySQL website. (put it into /Library/Java/Extensions/)
smmccraw 1.1 39
40 From there, you will need to do the following, using the "Model:Switch Adaptor..." menu item:
41
42 * Use the JDBC connector
Theodore Petrosky 17.1 43 * Username: <my_database username>
44 * Password: <my_database password>
45 * URL: jdbc:mysql:~/~/localhost/<my_database>
smmccraw 1.1 46 * Driver (optional): com.mysql.jdbc.Driver (Note: in old MySQL versions it was org.gjt.mm.mysql.Driver)''
47 * PlugIn (optional): leave blank
48
Philippe Rabier 11.1 49 {{info}}
Theodore Petrosky 17.1 50 The MySQL plugin that ships with WebObjects 5.4.x won't work with ERXMigration. You should use the MySQLPlugIn that's part of Wonder so don't forget to include it!!
Pascal Robert 9.1 51
Theodore Petrosky 17.1 52 You will get also the benefits that the plugin handles automatically the LIMIT keyword in your requests when you set a NSRange or fetch limit in your [[ERXFetchSpecification>>url:http://jenkins.wocommunity.org/job/Wonder/lastSuccessfulBuild/javadoc/er/extensions/eof/ERXFetchSpecification.html||shape="rect"]].
Philippe Rabier 11.1 53 {{/info}}
54
Pascal Robert 3.1 55 == OpenBase ==
smmccraw 1.1 56
Theodore Petrosky 17.1 57 The [[OpenBase installer>>url:http://store.openbase.com/downloads.html||shape="rect"]] should install the JDBC driver. In EOModeller set the URL to:
smmccraw 1.1 58
59 jdbc:openbase:~/~/<host>/<DatabaseName>
60
61 The Driver should be set to:
62
Pascal Robert 3.1 63 com.openbase.jdbc.ObDriver
smmccraw 1.1 64
65 Plugin should be left blank.
66
Pascal Robert 3.1 67 == FrontBase ==
smmccraw 1.1 68
69 The OpenBase installer should install the JDBC driver. In EOModeller set the URL to:
70
71 jdbc:FrontBase:~/~/127.0.0.1/Tempo
72
73 Driver and plugin should be left blank.
74
Pascal Robert 3.1 75 == Oracle ==
smmccraw 1.1 76
Pascal Robert 3.1 77 == MSSQLServer ==
smmccraw 1.1 78
79 You will need the JDBC driver for SQL 2000 from Microsoft. A search for Microsoft SQL Server 2000 JDBC should give you the right link. You can untar the file and place the resulting .jar files in /Library/Java/Extensions.
80
81 In EOModeler use the following settings:
82
83 * UserName: <db username>
84 * Password: <db password>
John Huss 4.1 85 * URL: jdbc:sqlserver:~/~/<Servername>:1433;DatabaseName=<;DB name>
86 * Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
smmccraw 1.1 87 * PlugIn: MicrosoftPlugIn
88
89 If you neglect to specify the MicrosoftPlugIn it will let you connect to the database, but will show you tables that appear to be meta data instead of your actual data.
90
Pascal Robert 3.1 91 == FileMaker ==
smmccraw 1.1 92
Theodore Petrosky 17.1 93 360works makes a [[PlugIn for FileMaker>>url:http://www.360works.com/woof1/||shape="rect"]], which is now an [[open source project>>url:https://woof.dev.java.net/||shape="rect"]].