Hello, Im trying to use XML-DBMS towards a PosgreSQL database, im using the PostgreSQL JDBC Driver and I get this error: java.sql.SQLException: Maximum number...
Well my basic web pages are constructed using HTML and I have been encorporating Javascript into this. I guess Javascript is the route to take! Im starting...
Ron, Sorry for my slow response. I had to roll out the last beta of a year long project this week. I took a look at Gary's build.xml file and decided to...
Ben Hall
bhall@...
Mar 2, 2002 3:39 pm
2044
Thank you for the help, I will use multi-colums in foreign key to solve this problem. szjungle...
Looks like I faced with stream input to longvarchar fields and I have two options: Use v2.0, or hack v1.0 -- my immediate question is "which is easier?" ...
... G> Looks like I faced with stream input to longvarchar fields and G> I have two options: Use v2.0, or hack v1.0 -- my immediate G> question is "which is...
... Since you've hacked v1.0 already, I'd have to say that is :) ... It's there -- just renamed. It's now called MapCompiler. I changed the name for several...
rpbourret@...
Mar 4, 2002 6:32 am
2048
... I like emails like this :) ... This should work. I remember doing it as a special case for someone before. I assume you did this in the method in...
rpbourret@...
Mar 4, 2002 6:36 am
2049
Hi my problem is to transfer data from xml to dbms *******xml********* <?xml version="1.0" encoding="UTF-8"?> <TUO> <MIO> <USATO> <anno>99</anno> </USATO> ...
another test ********map file********** <?xml version='1.0' ?> <!DOCTYPE XMLToDBMS SYSTEM "/home/bacchi/EXE/SO/xmldbms.dtd"> <XMLToDBMS Version="1.0"> ...
I have change the db in create table AUTO (marca varchar, modello varchar, codice integer); create table LISTINO (prezzo varchar, codice integer); create table...
... r> This should work. I remember doing it as a special case for r> someone before. I assume you did this in the method in r> Parameters that converts...
When I transfer the xml into database, I want to insert immediately the value into the column. examples: my database***************************************** ...
... You can try this, but I don't know if it will work. Supposedly, PostgreSQL doesn't have a limitation on the number of active statements, but I don't know...
Ronald Bourret
rpbourret@...
Mar 6, 2002 8:10 am
2056
... It's a bit long, but here it is. -- Ron Unpacking the source code ========================= Suppose you have installed XML-DBMS in the following directory:...
Ronald Bourret
rpbourret@...
Mar 6, 2002 9:23 am
2057
When you use an IgnoreRoot element, XML-DBMS ignores any children of that element that are not mapped using PseudoRoot. (These children must also be mapped...
Ronald Bourret
rpbourret@...
Mar 6, 2002 10:55 am
2058
... This is not possible in version 1.x. It is possible in version 2.0. Also, the map file below works only if LISTINO, COLORI, DISPO, etc. are nested beneath...
Ronald Bourret
rpbourret@...
Mar 6, 2002 10:58 am
2059
... Good point. Note that if the underlying column is not a LONGVARCHAR (for example, it is a VARCHAR), the driver must have the ability to convert from one...
Ronald Bourret
rpbourret@...
Mar 6, 2002 11:13 am
2060
UPLOAD_TIME is not in the XML document. Therefore, there is no data to transfer to the database. The best way to solve this is to write an INSERT trigger. This...
Ronald Bourret
rpbourret@...
Mar 6, 2002 11:18 am
2061
I got it working! To sum up and to the newbie like me out there that is having problems using XML-DMBS 1.01 with PostgreSQL A) Using the JDBC...
XML-DBMS version 1.x only allows one level of ignored root element. What this map means is that sometimes the XML document will have TUO as a root element...
Ronald Bourret
rpbourret@...
Mar 7, 2002 3:12 am
2063
thanks for your replay ... I must use only stable version for this progect..... ... with these change, all work but ... ..... ....sorry for confusion...( I'm...
... The structure of the XML document must match the structure of the database. Therefore, you must either transform the document (using XSLT) or transform the...
Ronald Bourret
rpbourret@...
Mar 7, 2002 7:35 am
2066
Thanks for reply and guidelines for solution I will test this two method Andrea...
I have problem with MapFactory_MapDocument constructor when I call "new MapFactory_MapDocument()" the program not work..it is blocked one method contains the...
I do not know what causes this. I cannot reproduce the problem here and there is nothing I can see that would cause the code to block. Note that the code you...
Ronald Bourret
rpbourret@...
Mar 12, 2002 12:19 pm
2069
... same result I have developed JMS application that receive a message ( xml String) and store the data into db. For receive message I build a Listener (...
I use JSP to bring values(mapFilename, key...) and call the Transfer.java. The key was set Object[] type in the Transfer.java. But I only bring key value that...
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.
