... <snip text="xml document" /> ... <snip text="map document" /> ... Yes. You need to define both a candidate key and a foreign key. For example, your current...
Ronald Bourret
rpbourret@...
Feb 1, 2002 1:05 pm
1949
Hi, I am tring to figure out how to make the sample Sales_rs2.map work for my database mysql. I tried the query as following. select Sales.CustNumber, ...
Kin Chan
kchan9@...
Feb 1, 2002 7:30 pm
1950
Hello I’m doing a research in mapping XML into database and vice versa. I read your benefit papers and I find many useful information .but 1’m looking for...
Hisham AbdAllah Manssor
hmanssor@...
Feb 2, 2002 3:46 am
1951
hi all, is it possible for me to use, instead of a database table, a stored procedure when creating my map file?. i was wondering how could i implement things...
Hi, All I'm using XML-DBMS Ver1.02 bundled with JBuilder5 an 6. But I'd like to suggest an improvement of DBMSToDOM.java. The processClassResultSet method call...
TAKAHASHI, Tomohiro
ttakahashi@...
Feb 4, 2002 4:12 am
1953
What happened when you used the sample map file? If it returned an exception stating that a column was not found, then the problem might be with the column...
Ronald Bourret
rpbourret@...
Feb 4, 2002 9:40 am
1954
1) Go to http://dblp.uni-trier.de/ and search on "XML". Most of the papers that explain how to map XML to databases were written in 1998 and 1999. 2) Go to...
Ronald Bourret
rpbourret@...
Feb 4, 2002 10:01 am
1955
Version 2.0 supports this with its filter language. You use a map file to specify how to map tables to XML and how to join tables. You then use a filter file...
Ronald Bourret
rpbourret@...
Feb 4, 2002 10:03 am
1956
Thanks. I took a quick look at the code and this looks like a good solution for databases like SQL Server that can only have one connection open at a time....
Ronald Bourret
rpbourret@...
Feb 4, 2002 10:13 am
1957
Hi, Ron ... I see. :-) It is too difficult to solve that problem. ... [snip] If you will do that, will we need Connection-Pooling class from point of...
TAKAHASHI, Tomohiro
ttakahashi@...
Feb 4, 2002 1:04 pm
1958
... Agreed. ... Yes. The 2.0 code includes simple connection and statement pooling. You can also use any DataSource that supports connection and statement...
rpbourret@...
Feb 4, 2002 1:09 pm
1959
After weeks working on the front end of our app, I'm back to working on the data acquisition portion and the first changed requirement to greet me was a call...
Gary Lawrence Murphy
garym@...
Feb 4, 2002 10:50 pm
1960
Since the attachements vanished, and they are small, here they are: ######################################################################## # Filename:...
Gary Lawrence Murphy
garym@...
Feb 5, 2002 4:35 am
1961
The short answer is that this seems reasonable. The long answer is that it's going to take some thought on exactly how to reorganize things, since it also...
Ronald Bourret
rpbourret@...
Feb 6, 2002 7:08 am
1962
Paul, Thanks!! I have solved to transfer the xml into database, when I upgrade my JDBC to 8.1.7. Now, I meet another question about xml element that is date...
... XML-DBMS automatically converts data from string format (in XML) to the data type used by the column in the database. Therefore, all you need to do is...
rpbourret@...
Feb 6, 2002 10:41 am
1964
<SNIP> ... This is being done. The GUI/Server stuff etc (i.e. the not absolutely core XD stuff) is being moved to net.xmlmiddleware. I have just got...
adam flinton
aflinton@...
Feb 6, 2002 12:30 pm
1965
... xml ... transfer ... data ... place ... want ... DateTimeFormats ... I have an xml like the following.............................. <Organization-News > ...
In a database, a date does not have a format. It is just a number. (I can't remember, but it might be the number of milliseconds since midnight on Jan 1,...
Ronald Bourret
rpbourret@...
Feb 7, 2002 7:29 am
1967
I can't solve the question, and it always has the same error message when I use Access database........................ java.sql.SQLException: Date/time value...
Well it's telling you the truth because the date formats aren't the same Your date: 1998/05/12 Expected Date yyyy/M/d Adam ... [Non-text portions of this...
adam flinton
aflinton@...
Feb 7, 2002 10:12 am
1969
... I think I have made the date according to the formats, but it still have the same error message. <XMLToDBMS Version="1.0"> <Options> <DateTimeFormats> ...
I want to have more understanding about MAP file, and I can set other type. Where can I get these reference ? Thanks!! [Non-text portions of this message have...
... a> Well it's telling you the truth because the date formats aren't a> the same Your date: 1998/05/12 Expected Date yyyy/M/d and it should be yyyy/MM/dd xx...
Dear All, I am just pottering about with the GUI / MapBuilder thing. What I would like to be able to do is to hook the mapbuilder up to a given db server & get...
adam flinton
aflinton@...
Feb 8, 2002 10:54 am
1974
... y> I have these question, because the map file is <Options> y> <DateTimeFormats> <Patterns Timestamp="MM.dd.yy"/> y> </DateTimeFormats> </Options> the the...
Perhaps what Yu Ching is encountering is the abiguity in Oracle datatypes; according to their online docs, Oracle has only one time-type, DATE, so when XMLDBMS...
I have an XML feed that gives us de-normalized data: <game id="x"> <event code="goal"> <player id="p1" name="x"/> </event> <team id="t1"> <player id="p1"...
I haven't found any example in the archives where ToPropertyTable is used with an ElementType that is a class, and since the only option to specify what...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
