For example, WebObjects (www.webobjects.com) allows you to have multiple EOModels (Enterprise Object models) in a project, each EOModel can represent a different database and its tables (on different servers if you wish), even different vendor types (for example one could be a MySQL server and another could be Oracle or MS SQL Server). In the EOModeler application you can define "relationships" between tables (entities) in different models (server databases). In your java code, the relationships are accessed as properties of the entity classes (tables) and it is seamless to you that the data is in separate servers across the relationships.
-Kieran
________________________________________________________________
Dev Config = OS X 10.3.5 / Java 1.4.2_05 / WO 5.2.3 / XCode v1.5 / MySQL 4.0.20 / Connector-J 3.0.11
Deploy Config = OS X 10.3.5 Server / Java 1.4.2_05 / WO 5.2.3 / MySQL 4.0.20 / Connector-J 3.0.11
My Blog: http://webobjects.webhop.org/
On Dec 6, 2004, at 6:14 PM, Rakesh Gupta wrote:
When I am logged on to a particular mysql server, is it possible to
- Access table residing on a different mysqlserver? or
- To join tables between two databases residing on two different mysql servers (on two different H/W boxes or same H/W box).
Any Ideas????
I looked in the manual. It talks about accessing table in a different database but the same mysql server!
You can refer to a table within the current database as tbl name (within the current database), or as db name.tbl name to explicitly specify a database. You can refer to a column as col name, tbl name.col name, or db name.tbl name.col name. You need not specify a tbl name or db name.tbl name prefix for a column reference unless the reference would be ambiguous.
Thanks
Rakesh
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
