Skip to Content
Version 4.1 by David Holt on 2008/05/12 19:07
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
David Holt 4.1 3 ----
4
5 **Useful SQL commands in FrontBase**
6
7 {{code value="sql"}}
8
9 // writes an ascii backup of your database
10 write all output(dir='/path/to/export/dir', type = 'FrontBase', content=true);
11
12 // creates a database from the exported files that results from the previous command
13 SCRIPT <path-to-export-directory>/schema.sql;
14
15 // to rename a table
16 alter table name Item to ItemArchive;
17
18 {{/code}}
19
20 If you don't use type='FrontBase', you end up losing precision on your timestamp columns, which can really suck.
21
22 ----
23
smmccraw 1.1 24 A first experience with FrontBase, WO 5.3.1 and MacOSX 10.4.6
25
26 Make sure you have the FrontBase jdbc connector accessible from your WebObjects applications. I placed mine in /Library/Java/Extensions/
27 Make sure that the FrontBasePlugIn.framework is located in /Library/Java/Frameworks
28 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.
Pascal Robert 3.1 29 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
smmccraw 1.1 30
31 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.
32
33 **Migration from MySQL**
34
35 In most cases the datatypes are exactly the same. Here are the FrontBase equivalents for common datatypes in MySQL that are different:
36
Pascal Robert 3.1 37 TEXT -> CLOB
smmccraw 1.1 38
Pascal Robert 3.1 39 DATETIME -> TIMESTAMP
smmccraw 1.1 40
Pascal Robert 3.1 41 INT -> INTEGER
smmccraw 1.1 42
Pascal Robert 3.1 43 MEDIUMBLOB -> BLOB