Changes for page Database Compatibility and Comparisons-FrontBase
Last modified by John Huss on 2010/07/23 14:35
From version 4.1
edited by David Holt
on 2008/05/12 19:07
on 2008/05/12 19:07
Change comment:
There is no comment for this version
To version 2.1
edited by smmccraw
on 2007/07/08 09:43
on 2007/07/08 09:43
Change comment:
There is no comment for this version
Summary
-
Page properties (3 modified, 0 added, 0 removed)
Details
- Page properties
-
- Title
-
... ... @@ -1,1 +1,1 @@ 1 -Database Compatibility and Comparisons-FrontBase 1 +Programming__WebObjects-Database Compatibility and Comparisons-FrontBase - Author
-
... ... @@ -1,1 +1,1 @@ 1 -XWiki. dholt1 +XWiki.smmccraw - Content
-
... ... @@ -1,32 +1,11 @@ 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 - 24 24 A first experience with FrontBase, WO 5.3.1 and MacOSX 10.4.6 25 25 26 26 Make sure you have the FrontBase jdbc connector accessible from your WebObjects applications. I placed mine in /Library/Java/Extensions/ 27 27 Make sure that the FrontBasePlugIn.framework is located in /Library/Java/Frameworks 28 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. 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 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// 30 30 31 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 32 ... ... @@ -34,10 +34,12 @@ 34 34 35 35 In most cases the datatypes are exactly the same. Here are the FrontBase equivalents for common datatypes in MySQL that are different: 36 36 37 -TEXT -> CLOB 16 +TEXT ~-~-> CLOB 38 38 39 -DATETIME -> TIMESTAMP 18 +DATETIME ~-~-> TIMESTAMP 40 40 41 -INT -> INTEGER 20 +INT ~-~-> INTEGER 42 42 43 -MEDIUMBLOB -> BLOB 22 +MEDIUMBLOB ~-~-> BLOB 23 + 24 +Category:WebObjects