Home » Developer & Programmer » JDeveloper, Java & XML » transfer data via xml (11g,windows7)
transfer data via xml [message #494537] Tue, 15 February 2011 11:10 Go to next message
ocean9
Messages: 17
Registered: February 2011
Location: syria
Junior Member

Hi experts
I have two separate databases, I want to send XML file contains a query from one to the other , that read query and return results to a first via XML file
Please help me how to do this or where to start

Regards
ocean9
Re: transfer data via xml [message #494543 is a reply to message #494537] Tue, 15 February 2011 11:49 Go to previous messageGo to next message
Michel Cadot
Messages: 67920
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why do you not directly query the remore database?

Regards
Michel
Re: transfer data via xml [message #494546 is a reply to message #494543] Tue, 15 February 2011 12:04 Go to previous messageGo to next message
ocean9
Messages: 17
Registered: February 2011
Location: syria
Junior Member

Hi Michel
I need to do this by using XML
So please help me if you can

Regards
ocean9
Re: transfer data via xml [message #494548 is a reply to message #494546] Tue, 15 February 2011 12:11 Go to previous messageGo to next message
Michel Cadot
Messages: 67920
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why? Your purpose is to execute the query in remote database isn't it?

Regards
Michel

[Updated on: Tue, 15 February 2011 12:11]

Report message to a moderator

Re: transfer data via xml [message #494800 is a reply to message #494548] Thu, 17 February 2011 03:05 Go to previous messageGo to next message
ocean9
Messages: 17
Registered: February 2011
Location: syria
Junior Member

I really want is to transfer data between separate databases across xml files
Do your book or project that may help me in this??

Second:
work with external files for database or prefer to add a field xmlType and I deal with ?

Regards
ocean9
Re: transfer data via xml [message #494808 is a reply to message #494800] Thu, 17 February 2011 03:34 Go to previous messageGo to next message
Michel Cadot
Messages: 67920
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is not clear.

Regards
Michel
Re: transfer data via xml [message #494815 is a reply to message #494808] Thu, 17 February 2011 03:44 Go to previous messageGo to next message
ocean9
Messages: 17
Registered: February 2011
Location: syria
Junior Member

What do you think about resolving this issue
I wish to clarify

regards
ocean9
Re: transfer data via xml [message #494845 is a reply to message #494815] Thu, 17 February 2011 05:05 Go to previous messageGo to next message
Michel Cadot
Messages: 67920
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think nothing as I don't understand what you have and what you want.
More, I don't see where the database is involved in " I want to send XML file contains a query from one to the other , that read query and return results to a first via XML file".
For me, all these are part of a program not of the database(s).

The sentence "is to transfer data between separate databases across xml files" is for me meaningless: you transfer file across servers not across databases.

Explain in DETAILS, step by step what you want to achieve.

Regards
Michel
Re: transfer data via xml [message #495120 is a reply to message #494845] Thu, 17 February 2011 13:57 Go to previous messageGo to next message
ocean9
Messages: 17
Registered: February 2011
Location: syria
Junior Member

Hi Michael
I started to read and learn about XML databases
So I will start working for myself but I have a query
In general: Is it better to deal with database external xml files or should be included within a XMLtype column??

Regards
ocean9
Re: transfer data via xml [message #495142 is a reply to message #495120] Thu, 17 February 2011 14:32 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
XML is to database
as bicycle is to fish.
Re: transfer data via xml [message #495145 is a reply to message #495142] Thu, 17 February 2011 14:44 Go to previous message
Michel Cadot
Messages: 67920
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
In general: Is it better to deal with database external xml files or should be included within a XMLtype column??

In general, it depends on what you want to do.
In general, it is better to NOT use XML.

Regards
Michel
Previous Topic: concatenate strings to print/display vertically
Next Topic: java.lang.NoClassDefFoundError: oracle/jdbc/driver/OracleDriver
Goto Forum:
  


Current Time: Tue Jul 27 15:36:10 CDT 2021