OraFAQ Forum: JDeveloper, Java & XML » transfer data via xml

Home » Developer & Programmer » JDeveloper, Java & XML » transfer data via xml (11g,windows7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

transfer data via xml [message #494537]

Tue, 15 February 2011 11:10

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

Report message to a moderator

Re: transfer data via xml [message #494543 is a reply to message #494537]

Tue, 15 February 2011 11:49

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Why do you not directly query the remore database?

Regards
Michel

Report message to a moderator

Re: transfer data via xml [message #494546 is a reply to message #494543]

Tue, 15 February 2011 12:04

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

Report message to a moderator

Re: transfer data via xml [message #494548 is a reply to message #494546]

Tue, 15 February 2011 12:11

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

Report message to a moderator

Re: transfer data via xml [message #494808 is a reply to message #494800]

Thu, 17 February 2011 03:34

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

This is not clear.

Regards
Michel

Report message to a moderator

Re: transfer data via xml [message #494815 is a reply to message #494808]

Thu, 17 February 2011 03:44

ocean9
Messages: 17
Registered: February 2011
Location: syria

Junior Member

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

regards
ocean9

Report message to a moderator

Re: transfer data via xml [message #494845 is a reply to message #494815]

Thu, 17 February 2011 05:05

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: transfer data via xml [message #495120 is a reply to message #494845]

Thu, 17 February 2011 13:57

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

Report message to a moderator

Re: transfer data via xml [message #495142 is a reply to message #495120]

Thu, 17 February 2011 14:32

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

XML is to database
as bicycle is to fish.

Report message to a moderator

Re: transfer data via xml [message #495145 is a reply to message #495142]

Thu, 17 February 2011 14:44

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 21:21:57 CST 2024