Dear all! I'm trying to publish some relational data from Oracle to XML (using XML-DBMS ver. 2 alpha 3). While the publishing worked fine with MS Access, I get...
3603
kalyan subbu
kalyan678
Nov 29, 2004 5:13 am
Hi Christian Dreier Thsi is Kalyan. I am new xml working with xml xslt--project (designing reports for j2ee application). i don't no how fetch data from the...
3604
christian3er
Nov 29, 2004 8:50 am
write the appropriate files (mapping, filter - see info below), use the delivered property file (parser.props) and use the following command: java...
3605
Ronald Bourret
xmldbms
Nov 29, 2004 9:04 pm
An empty output file usually occurs when the SELECT statement constructed by XML-DBMS does not return any results. (If something really goes wrong, an...
3606
Christian Dreier
christian3er
Nov 30, 2004 2:40 pm
Publishing with Oracle works now! I've tried your program and found out that everything works fine (with both select-statements). After that I knew that there...
3614
holger.schimanski@...
Dec 1, 2004 9:36 am
If I call storeDocument(...) more than one time on a Transfer object myTransfer, does myTransfer.storeDocument(...) reuse the connection, making a new...
3615
tpriyambodo
Dec 1, 2004 1:21 pm
First I intoduce my self. I am a research student from Indonesia. Thanks for this incredible tool XMLDBMS I use XML DBMS to generate table in ORACLE 9i. I...
3616
Christian Dreier
christian3er
Dec 2, 2004 10:27 am
Dear all! During the update process I get the errormessage java.sql.SQLException: [xmldbmx] "Primary Key Value not supplied for UPDATE". The filter file...
3617
tpriyambodo
Dec 3, 2004 2:22 am
Is there any solutions? because I use oracle that treated empty string as null. So if we have <GENDER><MAN/><GENDER> or <GENDER><WOMAN/><GENDER> We can not see...
3618
Ronald Bourret
xmldbms
Dec 3, 2004 6:26 am
The workaround is to store a single space in the database instead of an empty string. While this is technically incorrect -- an existing single space will...
3619
Ronald Bourret
xmldbms
Dec 3, 2004 6:46 am
Just to be clear. This fix is for version 2.0 alpha 3. If you are using version 1.x, let me know. It will require a similar fix. -- Ron ... [code snipped]...
3620
Ronald Bourret
xmldbms
Dec 3, 2004 6:54 am
Unfortunately, XML-DBMS does not currently support database defaults. This is a bug and is not easy to fix. There are two workarounds I can think of: 1) Add...
3621
Ronald Bourret
xmldbms
Dec 3, 2004 7:24 am
You need to specify the elements / attributes that are mapped to the primary key in your action document as items to be udpated. In your case, this means...
3622
Ronald Bourret
xmldbms
Dec 3, 2004 7:39 am
It reuses the connection. That is, the Transfer object holds the connection open and does not return it to the pool. The reason for this is so it can reuse...
3623
tpriyambodo
Dec 5, 2004 12:51 pm
Thanks Ron for all the answer. I think I must change XML and DTD ( I dont have enough understanding of Java). Or I will use MySQL that can define empty string...
3624
Christian Dreier
christian3er
Dec 15, 2004 2:49 pm
Dear all! I have some questions about publishing relational data to XML using SELECT statements (and RetrieveDocumentBySQL) and Deletes. 1) Is it possible to...
3625
Ronald Bourret
xmldbms
Dec 21, 2004 7:32 am
... You are correct about the behavior you are seeing. Note that it doesn't make sense to use RetrieveDocumentBySQL with a filter file containing root filters....
3626
Christian Dreier
christian3er
Dec 21, 2004 10:52 am
Hello! First of all I want to thank Ronald for his support!! As discussed in message 3625, I still have problems with Integer and Varchar data types. I'm using...
3627
Ranjan K. Baisak
ranjanbaisak
Dec 22, 2004 9:54 am
May be I have given wrong subject line for this post. In my map file, one mapping for column is <PropertyMap> <ElementType Name="content"/> <ToColumn...
3628
Ranjan K. Baisak
ranjanbaisak
Dec 22, 2004 10:07 am
May be I have given wrong subject line for this post. In my map file, one mapping for column is <PropertyMap> <ElementType Name="content"/> <ToColumn...
3629
Ranjan K. Baisak
ranjanbaisak
Dec 23, 2004 5:36 am
Test Mail __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around ...
3630
Asoke Bhattacharyya
bka_k
Dec 23, 2004 6:44 am
Worked "Ranjan K. Baisak" <ranjanbaisak@...> wrote:Test Mail __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo!...
3631
Ronald Bourret
xmldbms
Dec 30, 2004 6:47 am
Hello! I hope your holidays were good. Back to business now... You are probably correct that the order of columns is getting switched around and that this is...
3632
Ronald Bourret
xmldbms
Jan 7, 2005 8:22 am
Christian -- Thanks for sending me your files. I duplicated your problem here and found the problem. The version of Transfer in the alpha 3 release does not...
3633
Christian Dreier
christian3er
Jan 7, 2005 11:46 am
Hi Ron! I’ve done the changes and it’s working fine now. No more problems so far... Thank you very much! /Christian _____ Von: Ronald Bourret...
3634
krishna mohan
geniuskittu
Jan 10, 2005 10:48 am
Hi dudes, Yeah !! i am new to this group. Can any one explain me to how to install xml-dbms on linux fedora core 2 platform, running MySql Database. Thanks for...
3635
Ronald Bourret
xmldbms
Jan 10, 2005 5:31 pm
If you haven't already done so, download version 2.0 alpha 3 from: http://www.rpbourret.com/xmldbms/index.htm To install, follow the instructions in section 2...
3636
Amol Nerkar
vnamol
Jan 17, 2005 2:20 pm
I ran XMLDBMS sample code GenerateMap.java but I am getting the following exception I am using xerecs-1_4_4 parser and have already set the ODBC connection...
3637
Ronald Bourret
xmldbms
Jan 17, 2005 8:04 pm
The most likely cause is that you have not specified a classpath when you run GenerateMap. Unless you have set this separately, Java cannot find the Parser...
3638
jan.wollny@...
bernd_wollny
Jan 19, 2005 12:15 pm
Hi, where can i get a complete example to use retrieveDocument() per api using DBMSToDOM? something like the orders example in the samples directory... In...
