Hi, I am trying to insert the contents of an XML file into an Oracle table using the Transfer program that comes with XMLDBMS V2 and am getting the following...
Hello, Try using the table name XFORM_NOTES instead of xform_notes. XML-DBMS treats all table and column names in the map file as quoted identifiers, so they...
Hi, I tried that and I still get the same error... Thanks for your help. Cheers, Scott. ... DBMS ... identifiers, ... the ... upper ... table ... getting the...
Hello, I believe I've found your problem. In your map document, you declare the xform_notes table as being in the prod database: <Database Name="prod"> But...
Thanks, that seems to have solved it! I am now talking to the database - getting a null error so I have still some more work to do but the error is an SQL one...
Hi, I have it working, the reasons I was getting a NULL error was that my XML file looked like: <?xml version="1.0" encoding="ISO-8859-1" ?> <note> ...
1) In case you missed it, the reason it wasn't working before was that you had mapped id as an attribute, but it was an element in your document. So if you...
Ahhh - silly mistake on my part, changed the id to an element and it worked. Again thanks. Next step is to read the data back from the database - any tips??!! ...
Hi, I have another problem... I am having trouble with the RetreiveDocumentbySQL method in the Transfer program. If I use the following I get mutiple records...
Hello, I see two potential problems: 1) The data type of the NOTE_ID column isn't really VARCHAR, as you've declared in the map document. (Your SQL statement...
Hi, I have checked the map and filter files and made sure everything matches. I have just re-done the table as all varchar's and it works but it seems to be...
Mismatched elements is due to this bug: http://groups.yahoo.com/group/xml-dbms/message/3632 Briefly, XML-DBMS accesses internal column information by column...
1. Table 1 contains two fields which link to records in Table 2...like this: Table 1 ... name item_1 item_2 Table 2 ... item_id item_name ...and I'd like to...
Hello, 1) With version 1.x, you can't do this at all. With version 2.0 alpha 3, you can almost do this. The problem is that what you want to do requires you to...
Hi, I have three linked tables much like the Orders / Customer / Items ... CREATE TABLE test_customer (customer_id INTEGER primary key, customer_name...
There are two problems with your filter document: 1) The document is not valid according to filters.dtd. The class that compiles filter documents assumes that...
Thanks, I tired your filter, which in fact was what I started with before I got lost on related tables, etc and it, after a fair pause, gives the following...
Could you post your map to the list or send it to me privately? The class cast exception while setting parameters makes me think that there is a problem with...
Cool! I'd never thought about this, but you've managed to put XML-DBMS into an infinite loop, which would explain the stack overflow error. To solve this,...
Thanks!! That seems to have fixed it and now it all works - again many many thanks for helping me. Cheers, Scott. ... DBMS ... error. To ... from the ... ...
Many thanks for your help, I've now got it working with the aid of XSLTs for the final step in adding constants etc. I now have a problem concerning importing...
Hi all Iam Santhosh Chiluka doing MTech 2nd year I have a minor project in this semester If you have any, please send me immediately Thank You Bye ... Do you...
Can you please give us more information about what kind of project you are looking for? For example, what field should the project be in? Is this theoretical...
Thank You for your reply As I have a minor project in my 3rd semester,I want to work on XML and Java interfaces or XML and DBMS interface. We have only one...
hi, i am fascinated by this XML-DBMS middleware.I want to see it work.so i have taken up the task of transferring data from an XML document to a Oracle 8i...
Hi, i had submitted the pst yesterday.But i didnt get a single reply,although there are a lots of people with experiance on this group.So i thought of sending...
Sorry about the late answer. I don't have time to test this right now, but either of the following should work: 1) a) Declare the primary key of the Authors...
hi, I want to transfer a test.xml file data to the database. I am trying to write a map file for a test.xml file. Q1. how do i Map the <ip> and <addr> element...
Hello, Sorry I never replied to your earlier messages. I was on vacation and have been busy with other projects. I assume you figured out the answers? 1) The...
