Hello, In the web service project I'm working on at the moment there's the potential for some large XML documents to be generated, say, up to 5MB. My role is...
You haven't really said what kind of documents you are using, but large documents I have heard of seem to fall into three categories: 1) Repeating data. For...
In the org.xmlmiddleware.xmldbms.datahandlers.DataHandlerBase, modify the select method as follows. (Code is not compiled or tested.) public ResultSet...
Hi Ron! I'm trying to publish some relational data to XML programatically (using sql-stmts). I'm using Transfer.retrieveDocument as you can see in the code ...
Hello, When you call Transfer in this way, you need to call setDatabaseProperties() before calling retrieveDocument. If I remember correctly, the reason is...
OK. That was some work. But it works now! Thanks very much once again. Your instructions have really been helpful! /Christian _____ Von: Ronald Bourret...
Dear sir, I am using TransferResultSet sample for generation of XML document.I want to associate an CSS style sheet with the generated XML document.How can I...
In the toXML method, the call to dbmsToDOM.retrieveDocument(rs) returns a DOM tree as the variable named doc. What you need to do is use the DOM API to add a...
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,...
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.
