Skip to Content
Version 1.1 by smmccraw on 2007/07/08 09:43
Hide last authors
smmccraw 1.1 1 FrontBase is now available for free. Please see the FrontBase website [[http://www.frontbase.com]] for details.
2
3 A first experience with FrontBase, WO 5.3.1 and MacOSX 10.4.6
4
5 Make sure you have the FrontBase jdbc connector accessible from your WebObjects applications. I placed mine in /Library/Java/Extensions/
6 Make sure that the FrontBasePlugIn.framework is located in /Library/Java/Frameworks
7 Make sure that you have added the framework to your project or you will not be able to establish a connection to your database, even though you'll be able to see your database from EOModeler.
8 If you haven't yet assigned a User/Password combination to your database, you still must include User information in order for the connection to be established. Use //system to get started. The URL for basic connection is: jdbc:FrontBase:~/~/localhost/my_database_name//
9
10 The documentation available at the Frontbase site is very complete. The only gotcha was that I was left with the impression the framework was only necessary for WebObjects 4.5 and below. This is not the case, you have to install and include it for WO 5 projects too.
11
12 **Migration from MySQL**
13
14 In most cases the datatypes are exactly the same. Here are the FrontBase equivalents for common datatypes in MySQL that are different:
15
16 TEXT ~-~-> CLOB
17
18 DATETIME ~-~-> TIMESTAMP
19
20 INT ~-~-> INTEGER
21
22 MEDIUMBLOB ~-~-> BLOB
23
24 Category:WebObjects