Forums

by Shameer >> Thu, 4 Sep 2003 3:29:36 GMT

1)We have 2 databases A and B. These two databases are independent of each other, ie they exists on different PCs and in different directories...

2) The point is we are not authorised to change database A which is running in the production. What we would like to do is to extract information from database A (without touching A at all), using the codes in database B. Would that be possible? The analogy in a non OODB view, would be to do a connection to another database. Is there other alternative other than using RV for this case?

3) To make things even clearer, using the example of the lessons that was conducted in course by you , it would mean that we would like to access your objects in your schema on your laptop using the schema we have written on our PC , without any coding from your side at all... Is that possible?

by allistar >> Thu, 4 Sep 2003 4:02:57 GMT

If there is an ODBC view on database A that exposes all classes and properties then you could use that ODBC view to extract data.

Without having the ability to make any changes to database A what you ask is quite tricky. Can you take an online backup of database A, copy it to your local machine and then modify it by writing data extract scripts or some other sort of communication?

It's hard to give a useful answer without knowing the capabililities of database A.

Regards,
Allistar.

------------------------------------------------------------------
Allistar Melville
Software Developer, Analyst allistar@silvermoon.co.nz
Auckland, NEW ZEALAND

Silvermoon Software
Specialising in JADE development and consulting
Visit us at: http://www.silvermoon.co.nz
*NEW* Simple web access to Jade at: www.silvermoon.co.nz/jhp.html ------------------------------------------------------------------

by johnmunro >> Thu, 4 Sep 2003 15:50:36 GMT

As far as I know there is no built-in Jade equivalent of a connection to another database, but there's no reason why you can't do it manually.

Assuming you can load code into database A, you could write a server app which listens on a TCP port and can process commands and return data from a client (ie another app running database B). So the app on database B would connect to database A using TCP/IP, send it a request for information, and get the results of the query back.

You could even go as far as sending database A a string which it compiles and runs as a method. If you did this then the app in database A would never need to be modified if you later needed to query on data other than that in the initial concept - you just send it a different method to run.

--
John Munro

Synergist Limited - Home of FileVision(TM)
The Bioscience Innovation Centre
Cowley Road, Cambridge, UK
CB4 0DS
Telephone: +44 (0) 1223 478200
Fax: +44 (0) 1223 477969
Email: john.munro@filevision.com
Web: http://www.filevision.com

The contents of this communication are confidential and are only intended to be read by the addressee. We apologize if you receive this communication in error and ask that you contact Synergist Limited immediately to arrange for its return. The use of any information contained in this communication by an unauthorized person is strictly prohibited. Synergist Limited cannot accept responsibility for the accuracy or completeness of this communication as it is being transmitted over a public network. If you suspect this message may have been intercepted or amended, please inform Synergist Limited.