Is it possible, using version 2.0 of XML-DBMS, to map an element type that can occur as child of many different element types, to one table? For example,...
Katarzyna Marszalek
km@...
Feb 3, 2003 6:58 pm
2706
This restriction does not exist. You can map b as a related class of both a1 and a2. Normally, there would be two different foreign key columns in the table ...
Remember the problem (bug) that XML-DBMS has where multiple classes can't use the same property table? This was what required the generated DTD to use (for...
... Yes, thank you, I got it working: I did not suspect that within a <Table...> element one can use a number of <ForeignKey...>s, with different names, and ...
Katarzyna Marszalek
km@...
Feb 3, 2003 9:59 pm
2709
Hi Ron, I have 2 questions: 1. How to store large XML documents (such as several megabytes) into database? By using DOM to represent XML doc inside XML-DBMS,...
Hi, I am using 1.1 code from CVS. I have a question regarding DBMSToDOM: If I have the following XML document: <?xml version="1.0" ?> <Orders> <SalesOrder...
... See the first three paragraphs of: http://groups.yahoo.com/group/xml-dbms/message/2664 Whether this will work for you depends on your DTD. If you have a...
... If your application is calling DBMSToDOM directly, you can call: retrieveDocument(String[], Object[][]) This allows you to specify multiple root tables and...
Hi, Anyone can help explain how to use filters in version 2 code. I read the filter.dtd (part are shown below), but still can not understand the exact meaning ...
Hi, I am trying to get XMLtoDBMS to work and have created a very simple xml document and map to test putting the information into a mysql database after...
I'm not a PERL wiz, but you do need the XML::LibXML library on your machine (see http://xmlsoft.org/). For other libraries you need, see the use statements at...
... RootFilter elements tell XML-DBMS where to start getting data. That is, they tell XML-DBMS to table to start from as well as what data to retrieve from...
Hi, I have been using XMLDBMS v2.0 now for a few weeks, and have found it pretty useful (apart from a few initial problems). But today I tried to pass in...
Thompson, Darren (LIT)
d.thompson@...
Feb 12, 2003 1:58 pm
2719
There isn't one yet. For information, you can look in the following places: 1) The version 1.0 documentation. Although the mapping language has changed...
Are you asking when the next version will be released? And when the docs will be written? As usual, I won't say -- partly because I work on XML-DBMS when I...
Are you using XML Spy? There have been problems opening the DTDs with XML Spy, but I have never been able to find out what the problem is. Note that there is a...
There was a bug in the code that handled IN predicates. This has now been fixed and checked in to the CVS tree. Be sure to use version 1.9, as version 1.10 has...
Thanks for the help Ron. Nah, just the usual setup hassles, but it is all working great now!! Thanks again, Darren ... From: Ronald Bourret...
Thompson, Darren (LIT)
d.thompson@...
Feb 13, 2003 9:43 am
2727
Many Thanks! As u say,I am using xmlspy to edit the DTD file,but it doesn't work. But I don't understand DTD,just schema,so I have to change it to schema. By...
... Unfortunately, I can't help you here. I played around with CVS for a couple of days and it finally started to work. I have no idea what I did right and...
i'm doing the project in xml with oracle8i and i need all the details of developing the project. Do send me all the details regarding connecting oracle8i with...
Do you want to use Oracle's own capabiliities? If so, they have two products that ship with Oracle 8i: XML SQL Utility for Java and the XSQL Servlet. For...
can anyone explain to me why and how OrderColumn works? In the Documentation: The (optional) OrderColumn element gives the name of the column that contains...
One of the problems of transferring XML data to a relational database is a mismatch in the two models. In XML, the order in which children appear in their...
we are interested in the mapping of DTDs to databases.We downloaded the dtd parser from Mr. Bourret's site.From that,we got the conversion of the dtd to...
See the XML-DBMS product. http://www.rpbourret.com/xmldbms/index.htm This product transfers data between XML documents and databases. One part of the product...