Wiki source code of EOF-Using EOF-Database Adaptors and Plugins
Last modified by Theodore Petrosky on 2013/05/03 09:11
Hide last authors
| author | version | line-number | content |
|---|---|---|---|
 |
3.1 | 1 | == PostgreSQL == |
| |
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 | |||
 |
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 | |||
| |
15.1 | 9 | step two is correct though!! |
| 10 | |||
| |
3.1 | 11 | === Step 1 === |
| |
1.1 | 12 | |
| |
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)... |
| |
1.1 | 14 | |
| |
17.1 | 15 | * PostgresqlPlugIn.framework ~-~-> /Library/Frameworks |
| 16 | * PostgresqlPlugInBundle.EOMPlugin ~-~-> /Developer/EOMBundles | ||
| |
1.1 | 17 | |
| |
3.1 | 18 | === Step 2 === |
| |
1.1 | 19 | |
| 20 | You should have the following Adaptor info set (in EOModeler) for your database after the above install: | ||
| 21 | |||
| |
3.1 | 22 | * Username: username |
| 23 | * Password: password | ||
| |
1.1 | 24 | * URL: jdbc:postgresql:~/~/localhost/yourDb |
| 25 | * Driver: org.postgresql.Driver | ||
| |
17.1 | 26 | * Plugin: PostgresqlPlugIn |
| |
1.1 | 27 | |
| |
17.1 | 28 | Note: case sensitive. |
| |
1.1 | 29 | |
| |
3.1 | 30 | === Step 3 === |
| |
1.1 | 31 | |
| 32 | Link the PostgresqlPlugIn.framework into your project. | ||
| 33 | |||
| |
3.1 | 34 | == MySQL == |
| |
1.1 | 35 | |
| |
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"]] |
| |
1.1 | 37 | |
| |
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/) |
| |
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 | ||
| |
17.1 | 43 | * Username: <my_database username> |
| 44 | * Password: <my_database password> | ||
| 45 | * URL: jdbc:mysql:~/~/localhost/<my_database> | ||
| |
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 | |||
| |
11.1 | 49 | {{info}} |
| |
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!! |
| |
9.1 | 51 | |
| |
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"]]. |
| |
11.1 | 53 | {{/info}} |
| 54 | |||
| |
3.1 | 55 | == OpenBase == |
| |
1.1 | 56 | |
| |
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: |
| |
1.1 | 58 | |
| 59 | jdbc:openbase:~/~/<host>/<DatabaseName> | ||
| 60 | |||
| 61 | The Driver should be set to: | ||
| 62 | |||
| |
3.1 | 63 | com.openbase.jdbc.ObDriver |
| |
1.1 | 64 | |
| 65 | Plugin should be left blank. | ||
| 66 | |||
| |
3.1 | 67 | == FrontBase == |
| |
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 | |||
| |
3.1 | 75 | == Oracle == |
| |
1.1 | 76 | |
| |
3.1 | 77 | == MSSQLServer == |
| |
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> | ||
| |
4.1 | 85 | * URL: jdbc:sqlserver:~/~/<Servername>:1433;DatabaseName=<;DB name> |
| 86 | * Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver | ||
| |
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 | |||
| |
3.1 | 91 | == FileMaker == |
| |
1.1 | 92 | |
| |
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"]]. |