Last modified by John Huss on 2010/07/23 14:35

From version 1.1
edited by smmccraw
on 2007/07/08 09:43
Change comment: There is no comment for this version
To version 4.1
edited by David Holt
on 2008/05/12 19:07
Change comment: There is no comment for this version

Summary

Details

Page properties
Title
... ... @@ -1,1 +1,1 @@
1 -Programming__WebObjects-Database Compatibility and Comparisons-FrontBase
1 +Database Compatibility and Comparisons-FrontBase
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.smmccraw
1 +XWiki.dholt
Content
... ... @@ -1,11 +1,32 @@
1 1  FrontBase is now available for free. Please see the FrontBase website [[http://www.frontbase.com]] for details.
2 2  
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 +
3 3  A first experience with FrontBase, WO 5.3.1 and MacOSX 10.4.6
4 4  
5 5  Make sure you have the FrontBase jdbc connector accessible from your WebObjects applications. I placed mine in /Library/Java/Extensions/
6 6  Make sure that the FrontBasePlugIn.framework is located in /Library/Java/Frameworks
7 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//
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
9 9  
10 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 11  
... ... @@ -13,12 +13,10 @@
13 13  
14 14  In most cases the datatypes are exactly the same. Here are the FrontBase equivalents for common datatypes in MySQL that are different:
15 15  
16 -TEXT ~-~-> CLOB
37 +TEXT -> CLOB
17 17  
18 -DATETIME ~-~-> TIMESTAMP
39 +DATETIME -> TIMESTAMP
19 19  
20 -INT ~-~-> INTEGER
41 +INT -> INTEGER
21 21  
22 -MEDIUMBLOB ~-~-> BLOB
23 -
24 -Category:WebObjects
43 +MEDIUMBLOB -> BLOB