> -----Original Message-----
> From: Bryan Pendleton [mailto:bryan.pendleton@...]
> Sent: 29 June 2001 21:04
> To: xml-dbms@yahoogroups.com
> Subject: RE: [xml-dbms] Log4J
>
>
> > as a general rule, I am a big fan of abstracting this sort
> of thing and
> letting
> > people swap modules in and out as they please. No matter
> how popular one
> > product is, you can always find somebody who thinks it's lousy and
> > swears by another product.
>
> These are wise words.
>

I prefer it too...however I know very little about log4j (though others
around me here @ work do as it's out std logger for our internal products).

> > That said, is there enough commonality among loggers that we
> > could hide them behind a simple interface like:
>
> Sure. I see absolutely nothing wrong with going through the exercise
> of defining exactly what it is that you need from a logging facility,
> then defining your own interface which describes those exact needs,
> then implementing that interface with some code which wraps around
> log4j and calls it to implement the functionality.
>
> Later, you could easily add other implementations which wrap your
> interface around other logging facilities.
>
> That's just common sense, and good engineering, and thus I never had
> any doubt that you guys would do exactly that :-)
>

Gee thanx <G>.

> From a detail point of view, though, I definitely recommend that you
> spend the time to read carefully through the log4j "short
> introduction"
> document (http://jakarta.apache.org/log4j/docs/manual.html),
> as well as
> the older and shorter version
> (http://www.javaworld.com/jw-11-2000/jw-1122-log4j.html)
> These guys have spent an immense amount of time thinking
> about this problem
> and working on it, and the log4j system is truly impressive.
>

I know & accept that they've done a good job.

> The hard part will be when you get down to defining your specific
> interface. Once you realize what log4j offers, my bet is that you will
> want to have most, if not all, of its features in your interface. For
> example, the Category hierarchy, the concept of priorities, and the
> ability to have multiple appenders with different layouts, is just so
> incredibly valuable that you will kick yourself if you skip
> those things.
>

My initial idea is to shove in Log4J such that I can get a grip on how it
works & what sort of interface would be required. The main "alternative"
implementation would be a simple System.out.println. i.e. if no logger was
defined in the properties file it would assume the System.out.println
implementation as that's the only one you could assume would be present.


> At that point, the question is whether you can find any other
> practical
> existing logging systems to evaluate so that you can decide whether
> your interface truly represents a least common denominator of the
> pluggable logging systems that you want to support.
>
> In practice, log4j is just so good that every other logging system out
> there (other than internal proprietary systems developed by companies
> such as my prior companies) has vanished, and everybody has
> universally
> switched to using log4j.
>
> OK, I'll climb off my "violent agreement with you" soapbox now.
>


I don't suppose you could look at helping with doing the logging bit?

I need to be able to wrap XD & to pull messages out of it & then take
actions based on those messages. The easiest example is if an error is
returned which shows that for some reason the message / xmlString has not
been committed in the DB (e.g. the ethernet cable has come out the back of
the DB server) then I would have to place the message onto a "Dead letter
Queue / topic" along with a message/note saying why it had failed & possibly
what action the administrator should take.

As an example you mentioned that you had placed logging code into the bit
where the prepared statements are executed. Could you send me that so that I
can look at it?



Adam

Hi,

I can't manage to map an inner class to a result set. All the examples I saw
suppose that the result set maps the outer class. Is there a way to solve
this problem?

Tangi

Hi,

Please Help me where to start xml-dbms and how to proceed
to learn more.

Awaiting for reply.

Thanks

Gerald



____________________________________________________________
Do You Yahoo!?
For regular News updates go to http://in.news.yahoo.com

Download the xmldbms101.zip at http://www.rpbourret.com/xmldbms/index.htm

unzip and follow the readme.html.

-------------------------------------

Laurent Foret

Service developpement

l.foret@...

www.korom.net



> -----Message d'origine-----
> De : Gerry [mailto:mglraj@...]
> Envoye : mardi 3 juillet 2001 13:07
> A : xml-dbms@yahoogroups.com
> Objet : [xml-dbms] Help me where to Start xml-dbms and how to proceed !!
>
>
> Hi,
>
> Please Help me where to start xml-dbms and how to proceed
> to learn more.
>
> Awaiting for reply.
>
> Thanks
>
> Gerald
>
>
>
> ____________________________________________________________
> Do You Yahoo!?
> For regular News updates go to http://in.news.yahoo.com
>
> To post a message, send it to: xml-dbms@yahoogroups.com
> To unsubscribe, send a blank message to:
> xml-dbms-unsubscribe@yahoogroups.com
> Or join the newsgroup at: news://news.barkto.com/homeless.xml.xml-dbms
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>

Hi
I have created an application that creates XML files based on an SQL
query to an Access 2k
database on one server and sends these files to an other server where
it is unpacked and
placed into another Access 2k database, the application works fine
but with every file I
send I get the following Message.

Message
org.xml.sax.SAXParseException: The root element is required in a well-
formed document.
         at org.apache.xerces.framework.XMLParser.reportError
(XMLParser.java:1056)
         at
org.apache.xerces.framework.XMLDocumentScanner.reportFatalXMLError
(XMLDocumentScanner.java:626)
         at
org.apache.xerces.framework.XMLDocumentScanner$XMLDeclDispatcher.endOf
Input(XMLDocumentScanner.java:842)
         at org.apache.xerces.framework.XMLDocumentScanner.endOfInput
(XMLDocumentScanner.java:418)
         at
org.apache.xerces.validators.common.XMLValidator.sendEndOfInputNotific
ations(XMLValidator.java:582)
         at
org.apache.xerces.readers.DefaultEntityHandler.changeReaders
(DefaultEntityHandler.java:1026)
         at org.apache.xerces.readers.XMLEntityReader.changeReaders
(XMLEntityReader.java:168)
         at org.apache.xerces.readers.UTF8Reader.changeReaders
(UTF8Reader.java:182)
         at org.apache.xerces.readers.UTF8Reader.lookingAtChar
(UTF8Reader.java:197)
         at
org.apache.xerces.framework.XMLDocumentScanner$XMLDeclDispatcher.dispa
tch(XMLDocumentScanner.java:742)
         at org.apache.xerces.framework.XMLDocumentScanner.parseSome
(XMLDocumentScanner.java:381)
         at org.apache.xerces.framework.XMLParser.parse
(XMLParser.java:948)
         at my_package.seat_tran.MyXMLGeneratorsender.sendRequest
(MyXMLGeneratorsender.java:158)
         at my_package.seat_tran.MyXMLGeneratorsender.toXML
(MyXMLGeneratorsender.java:82)
         at ControlsSend.doSomething(ControlsSend.java:115)
         at ControlsSend.myStarter(ControlsSend.java:158)
         at ControlsSend.run(ControlsSend.java:184)
         at java.lang.Thread.run(Thread.java:484)

I assume that this is not impacting on the running of the
application, as the application
works, but getting these messages can't be  normal and how do I stop
this - please help,
below are the map files.
Thanks
Asante

Application tools

Appache web server
Tomcat appliction server
XMLDBMS 1.0
Xecres parser
Access 2k

MapFile(Generating)

<?xml version="1.0" ?>
<!DOCTYPE XMLToDBMS SYSTEM "xmldbms.dtd">
<XMLToDBMS Version="1.0">
<Options>
</Options>
<Maps>
  <IgnoreRoot>
    <ElementType Name="Output"/>
       <PseudoRoot>
           <ElementType Name ="Seats"/>
              <CandidateKey Generate="No">
                     <Column Name="ProductID"/>
              </CandidateKey>
        </PseudoRoot>
  </IgnoreRoot>
  <ClassMap>
     <ElementType Name="Seats"/>
        <ToClassTable>
            <Table Name ="Result Set"/>
        </ToClassTable>
        <PropertyMap>
            <Attribute Name ="Product_ID_Front_Seat" MultiValued
= "No"/>
               <ToColumn>
                  <Column Name ="ProductID"/>
               </ToColumn>
         </PropertyMap>
         <PropertyMap>
             <ElementType Name ="Product_ID_Rear_Seat"/>
                <ToColumn>
                    <Column Name ="ProductID_Rear"/>
                </ToColumn>
         </PropertyMap>
         <PropertyMap>
             <ElementType Name ="Seat_Rank"/>
                <ToColumn>
                    <Column Name ="Rank"/>
                </ToColumn>
         </PropertyMap>
   </ClassMap>
  </Maps>
</XMLToDBMS>

MapFile(Recieving)

<?xml version="1.0" ?>
<!DOCTYPE XMLToDBMS SYSTEM "xmldbms.dtd">
<XMLToDBMS Version="1.0">
<Options>
</Options>
<Maps>
  <IgnoreRoot>
    <ElementType Name="Output"/>
       <PseudoRoot>
           <ElementType Name ="Seats"/>
              <CandidateKey Generate="No">
                     <Column Name="ProductID"/>
              </CandidateKey>
        </PseudoRoot>
  </IgnoreRoot>
  <ClassMap>
     <ElementType Name="Seats"/>
        <ToClassTable>
            <Table Name ="Internal_Order_Recieved"/>
        </ToClassTable>
        <PropertyMap>
            <Attribute Name ="Product_ID_Front_Seat" MultiValued
= "No"/>
               <ToColumn>
                  <Column Name ="ProductID"/>
               </ToColumn>
         </PropertyMap>
         <PropertyMap>
             <ElementType Name ="Product_ID_Rear_Seat"/>
                <ToColumn>
                    <Column Name ="ProductID_Rear"/>
                </ToColumn>
         </PropertyMap>
         <PropertyMap>
             <ElementType Name ="Seat_Rank"/>
                <ToColumn>
                    <Column Name ="Rank"/>
                </ToColumn>
         </PropertyMap>
   </ClassMap>
  </Maps>
</XMLToDBMS>

hi
i faced same problem when this file saved in a binary
format like when you save this xml file in wordpad.
try to save this xml file in notepad and run this
it will work

regards
venkat




--- nkab@... wrote:
> Hi
> I have created an application that creates XML files
> based on an SQL
> query to an Access 2k
> database on one server and sends these files to an
> other server where
> it is unpacked and
> placed into another Access 2k database, the
> application works fine
> but with every file I
> send I get the following Message.
>
> Message
> org.xml.sax.SAXParseException: The root element is
> required in a well-
> formed document.
>         at
> org.apache.xerces.framework.XMLParser.reportError
> (XMLParser.java:1056)
>         at
>
org.apache.xerces.framework.XMLDocumentScanner.reportFatalXMLError
> (XMLDocumentScanner.java:626)
>         at
>
org.apache.xerces.framework.XMLDocumentScanner$XMLDeclDispatcher.endOf
> Input(XMLDocumentScanner.java:842)
>         at
>
org.apache.xerces.framework.XMLDocumentScanner.endOfInput
> (XMLDocumentScanner.java:418)
>         at
>
org.apache.xerces.validators.common.XMLValidator.sendEndOfInputNotific
> ations(XMLValidator.java:582)
>         at
>
org.apache.xerces.readers.DefaultEntityHandler.changeReaders
> (DefaultEntityHandler.java:1026)
>         at
>
org.apache.xerces.readers.XMLEntityReader.changeReaders
> (XMLEntityReader.java:168)
>         at
> org.apache.xerces.readers.UTF8Reader.changeReaders
> (UTF8Reader.java:182)
>         at
> org.apache.xerces.readers.UTF8Reader.lookingAtChar
> (UTF8Reader.java:197)
>         at
>
org.apache.xerces.framework.XMLDocumentScanner$XMLDeclDispatcher.dispa
> tch(XMLDocumentScanner.java:742)
>         at
>
org.apache.xerces.framework.XMLDocumentScanner.parseSome
> (XMLDocumentScanner.java:381)
>         at
> org.apache.xerces.framework.XMLParser.parse
> (XMLParser.java:948)
>         at
>
my_package.seat_tran.MyXMLGeneratorsender.sendRequest
> (MyXMLGeneratorsender.java:158)
>         at
> my_package.seat_tran.MyXMLGeneratorsender.toXML
> (MyXMLGeneratorsender.java:82)
>         at
> ControlsSend.doSomething(ControlsSend.java:115)
>         at
> ControlsSend.myStarter(ControlsSend.java:158)
>         at ControlsSend.run(ControlsSend.java:184)
>         at java.lang.Thread.run(Thread.java:484)
>
> I assume that this is not impacting on the running
> of the
> application, as the application
> works, but getting these messages can't be  normal
> and how do I stop
> this - please help,
> below are the map files.
> Thanks
> Asante
>
> Application tools
>
> Appache web server
> Tomcat appliction server
> XMLDBMS 1.0
> Xecres parser
> Access 2k
>
> MapFile(Generating)
>
> <?xml version="1.0" ?>
> <!DOCTYPE XMLToDBMS SYSTEM "xmldbms.dtd">
> <XMLToDBMS Version="1.0">
> <Options>
> </Options>
> <Maps>
>  <IgnoreRoot>
>    <ElementType Name="Output"/>
>       <PseudoRoot>
>           <ElementType Name ="Seats"/>
>              <CandidateKey Generate="No">
>                     <Column Name="ProductID"/>
>              </CandidateKey>
>        </PseudoRoot>
>  </IgnoreRoot>
>  <ClassMap>
>     <ElementType Name="Seats"/>
>        <ToClassTable>
>            <Table Name ="Result Set"/>
>        </ToClassTable>
>        <PropertyMap>
>            <Attribute Name ="Product_ID_Front_Seat"
> MultiValued
> = "No"/>
>               <ToColumn>
>                  <Column Name ="ProductID"/>
>               </ToColumn>
>         </PropertyMap>
>         <PropertyMap>
>             <ElementType Name
> ="Product_ID_Rear_Seat"/>
>                <ToColumn>
>                    <Column Name ="ProductID_Rear"/>
>                </ToColumn>
>         </PropertyMap>
>         <PropertyMap>
>             <ElementType Name ="Seat_Rank"/>
>                <ToColumn>
>                    <Column Name ="Rank"/>
>                </ToColumn>
>         </PropertyMap>
>   </ClassMap>
>  </Maps>
> </XMLToDBMS>
>
> MapFile(Recieving)
>
> <?xml version="1.0" ?>
> <!DOCTYPE XMLToDBMS SYSTEM "xmldbms.dtd">
> <XMLToDBMS Version="1.0">
> <Options>
> </Options>
> <Maps>
>  <IgnoreRoot>
>    <ElementType Name="Output"/>
>       <PseudoRoot>
>           <ElementType Name ="Seats"/>
>              <CandidateKey Generate="No">
>                     <Column Name="ProductID"/>
>              </CandidateKey>
>        </PseudoRoot>
>  </IgnoreRoot>
>  <ClassMap>
>     <ElementType Name="Seats"/>
>        <ToClassTable>
>            <Table Name ="Internal_Order_Recieved"/>
>        </ToClassTable>
>        <PropertyMap>
>            <Attribute Name ="Product_ID_Front_Seat"
> MultiValued
> = "No"/>
>               <ToColumn>
>                  <Column Name ="ProductID"/>
>               </ToColumn>
>         </PropertyMap>
>         <PropertyMap>
>             <ElementType Name
> ="Product_ID_Rear_Seat"/>
>                <ToColumn>
>                    <Column Name ="ProductID_Rear"/>
>                </ToColumn>
>         </PropertyMap>
>         <PropertyMap>
>             <ElementType Name ="Seat_Rank"/>
>                <ToColumn>
>                    <Column Name ="Rank"/>
>                </ToColumn>
>         </PropertyMap>
>   </ClassMap>
>  </Maps>
> </XMLToDBMS>
>
>


=====
P.Venkatesh B.E(cse)
Software Engineer,
Magma Solutions Inc
323,warren avenue,fremont,USA
phone(off)510-623-3500 Ext 129
phone (res) 510-440-9941
URL:http://pvenkatesh.8m.com

__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/

Hi,

After having struggled a couple of days with the Transfer sample
application I finally admit that I need to ask for assistance. I am
fairly new with Java so I hope I can describe the symptoms clearly
enough.

1) Compilation

The complier gives the following warnings:


>[tkokko@rapu samples]$ javac -deprecation Transfer.java
>Transfer.java:16: warning: org.xml.sax.Parser in org.xml.sax has been
>deprecated
>import org.xml.sax.Parser;
                    ^
>Transfer.java:238: warning: org.xml.sax.Parser in org.xml.sax has
>been deprecated
>static Parser getSAXParser()
           ^
>2 warnings


2) Running - the programme gives a segmentation fault (no exceptions
reported)


>[tkokko@rapu samples]$ java Transfer -todbms sales.map sales_in.xml
>Segmentation fault


3) Running through jdb - exception "lines" -table not found

>[tkokko@rapu samples]$ jdb Transfer -todbms sales.map sales_in.xml
>Initializing jdb...
> run
>run Transfer -todbms sales.map sales_in.xml
>
>VM Started: de.tudarmstadt.ito.xmldbms.InvalidMapException: Table not
>found: lines. Check that the table exists, that its name is spelled
>correctly, and that the case used in the map document exactly matches
>the case used in the database. This might be different from the case
>you used when creating the table.
>        at
>de.tudarmstadt.ito.xmldbms.Map.addColumnMetadata(Map.java:1774)
>        at
>de.tudarmstadt.ito.xmldbms.Map.getTableMetadata(Map.java:1613)
>        at
>de.tudarmstadt.ito.xmldbms.Map.initColumnMetadata(Map.java:236)
>        at
>de.tudarmstadt.ito.xmldbms.mapfactories.MapFactory_MapDocument.create>Map(MapFa\
ctory_MapDocument.java:339)
at >Transfer.createMap(Transfer.java:219)
>        at Transfer.toDBMS(Transfer.java:156)
>        at Transfer.main(Transfer.java:117)
>
>The application exited

The "lines" table does exist in my "xmldbms" database.

>xmldbms=# \dt
>      List of relations
>    Name    | Type  | Owner
>------------+-------+--------
> customers  | table | tkokko
> lines      | table | tkokko
> parts      | table | tkokko
> sales      | table | tkokko
> xmldbmskey | table | tkokko
>(5 rows)
>
>xmldbms=#

My SQL software (PostgreSQL) seems to conver all the letters to lower
case, so I made them lower case in the sales.map file, too.

Also, when you "next" through the code in jdb control jumps from the
line (original source code, line 171, method toDBMS)

	 map = createMap(mapFilename, conn2);

directly to the finally block.

Before executing this line the local variables are:

>main[1] locals
>Method arguments:
>  mapFilename = "sales.map"
>  xmlFilename = "sales_in.xml"
>  url = "jdbc:postgresql:xmldbms"
>Local variables:
>  conn1 = instance of org.postgresql.jdbc2.Connection(id=266)
>  conn2 = instance of org.postgresql.jdbc2.Connection(id=267)
>  keyGenerator = instance of
>de.tudarmstadt.ito.xmldbms.helpers.KeyGeneratorImpl(id=268)
>main[1]

And the local variables in createMap method just before it returns
(line 237 in the original Transfer.java-source) are

line 237 (Transfer.java)
return factory.createMap(new InputSource(getFileURL(mapFilename)));

>main[1] locals
>Method arguments:
>  mapFilename = "sales.map"
>  conn = instance of org.postgresql.jdbc2.Connection(id=267)
>Local variables:
>  factory = instance of
>de.tudarmstadt.ito.xmldbms.mapfactories.MapFactory_MapDocument(id=328)

It seems that something funny happens in execution of the line 237,
which results in an exception, and the control moves on to the finally
block in toDBMS method. However, when not running through the debugger
the programme just crashes and does not exit nicely with an exception
report.

I use the xerces.jar downloaded from apache
pages(Xerces-J-bin.1.4.1.zip) and postgreSQL with a jdbc driver
jdbc7.0-1.2.jar.

OK. I am very appreciative if someone can help, I'd really like to get
to use XML-DBMS.

Regards,

Teemu Kokkonen
teme70@...

The default XML output from JDOM XMLOutputter puts all attributes in
one line:

<MoveData  start_time="5.5" end_time="5000.5" speed="30" altitude="5"
initial_lat="10.142" initial_long="10.142" heading_lat="10.0"
heading_long="10.0"></MoveData>

I really want it print out as:

<MoveData
      start_time="5.5"
      end_time="5000.5"
      speed="30"
      altitude="5"
      initial_lat="10.142"
      initial_long="10.142"
      heading_lat="10.0"
      heading_long="10.0">
</MoveData>

Using JDOM v0.6 beta.
And writer code look like this:

FileWriter
    writer = new FileWriter("aba.xml");
XMLOutputter
    fmt = new XMLOutputter("    ", true);
fmt.setLineSeparator(System.getProperty("line.separator"));
fmt.setNewlines(true);
fmt.setExpandEmptyElements(true);
fmt.output(doc, writer);
writer.close();

Thanks!

Hi,
I am a new user of this package.
Can you mail me how can I get access to source code of your package.

Thanks,
Shachi.

Hi.

Just to let you know if someone will have any perl related XML-DBMS questions,
please, excuse delay in my responses untill July 14 when my vacation ends.

Nick Semenov.


[Non-text portions of this message have been removed]

Tangi Vass wrote:
>
> I can't manage to map an inner class to a result set. All the examples I saw
> suppose that the result set maps the outer class. Is there a way to solve
> this problem?

If I understand you correctly, this isn't supported.

I think what you want to do is pass a result set to DBMSToDOM that
applies to an element type mapped with a RelatedClass element. For
example, in the sales order sample data, you might like to pass a result
set that selected all line items with quantity greater than 10. This
would allow you to effectively do WHERE classes over child tables. Is
this correct?

The problem with this is that it gets extremely complex -- you would
have to pass a result set for each row in the parent table and DBMSToDOM
would have to figure out which result set applied to which row in the
parent table.

The long term solution to this sort of problem is a query language such
as XPath or XQuery. However, neither is going to be supported any time
soon.

-- Ron

If you downloaded the .zip file containing version 1.01, the source code
is in the src.zip file in the directory you installed XML-DBMS in.

You can get the 1.1 and 2.0 code from the XML-DBMS CVS tree on Source
Forge:

    http://sourceforge.net/cvs/?group_id=13613

-- Ron

Shachi Poddar wrote:
>
> Hi,
> I am a new user of this package.
> Can you mail me how can I get access to source code of your package.
>
> Thanks,
> Shachi.
>
> To post a message, send it to: xml-dbms@yahoogroups.com
> To unsubscribe, send a blank message to: xml-dbms-unsubscribe@yahoogroups.com
> Or join the newsgroup at: news://news.barkto.com/homeless.xml.xml-dbms
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

--
Ronald Bourret
Programming, Writing, and Training
XML, Databases, and Schemas
http://www.rpbourret.com

I looked through the Xerces code. It appears this error is returned when
there is no closing root element tag. Can you send an XML document that
causes this problem directly to me? Please attach it to the email so I
can look at it directly.

Strange that the application still works...

Thanks,

-- Ron

nkab@... wrote:
>
> Hi
> I have created an application that creates XML files based on an SQL
> query to an Access 2k
> database on one server and sends these files to an other server where
> it is unpacked and
> placed into another Access 2k database, the application works fine
> but with every file I
> send I get the following Message.
>
> Message
> org.xml.sax.SAXParseException: The root element is required in a well-
> formed document.
>         at org.apache.xerces.framework.XMLParser.reportError
> (XMLParser.java:1056)
>         at
> org.apache.xerces.framework.XMLDocumentScanner.reportFatalXMLError
> (XMLDocumentScanner.java:626)
>         at
> org.apache.xerces.framework.XMLDocumentScanner$XMLDeclDispatcher.endOf
> Input(XMLDocumentScanner.java:842)
>         at org.apache.xerces.framework.XMLDocumentScanner.endOfInput
> (XMLDocumentScanner.java:418)
>         at
> org.apache.xerces.validators.common.XMLValidator.sendEndOfInputNotific
> ations(XMLValidator.java:582)
>         at
> org.apache.xerces.readers.DefaultEntityHandler.changeReaders
> (DefaultEntityHandler.java:1026)
>         at org.apache.xerces.readers.XMLEntityReader.changeReaders
> (XMLEntityReader.java:168)
>         at org.apache.xerces.readers.UTF8Reader.changeReaders
> (UTF8Reader.java:182)
>         at org.apache.xerces.readers.UTF8Reader.lookingAtChar
> (UTF8Reader.java:197)
>         at
> org.apache.xerces.framework.XMLDocumentScanner$XMLDeclDispatcher.dispa
> tch(XMLDocumentScanner.java:742)
>         at org.apache.xerces.framework.XMLDocumentScanner.parseSome
> (XMLDocumentScanner.java:381)
>         at org.apache.xerces.framework.XMLParser.parse
> (XMLParser.java:948)
>         at my_package.seat_tran.MyXMLGeneratorsender.sendRequest
> (MyXMLGeneratorsender.java:158)
>         at my_package.seat_tran.MyXMLGeneratorsender.toXML
> (MyXMLGeneratorsender.java:82)
>         at ControlsSend.doSomething(ControlsSend.java:115)
>         at ControlsSend.myStarter(ControlsSend.java:158)
>         at ControlsSend.run(ControlsSend.java:184)
>         at java.lang.Thread.run(Thread.java:484)
>

Hi

I just joined the group and i wanted to know more
about xml-dbms

Baby

____________________________________________________________
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie

> I think what you want to do is pass a result set to DBMSToDOM that
> applies to an element type mapped with a RelatedClass element. For
> example, in the sales order sample data, you might like to pass a
result
> set that selected all line items with quantity greater than 10. This
> would allow you to effectively do WHERE classes over child tables.
Is
> this correct?

Yes, exactly.

> The problem with this is that it gets extremely complex -- you would
> have to pass a result set for each row in the parent table and
DBMSToDOM
> would have to figure out which result set applied to which row in
the
> parent table.

Maybe a solution could be to use temp views instead of a result set.

> The long term solution to this sort of problem is a query language
such
> as XPath or XQuery. However, neither is going to be supported any
time
> soon.

This would be great.

I've got another question: would it be possible to let defining a
class which wouldn't generate XML but could just be used for joining
two other classes? This situation often occurs when dealing with 3NF
databases.

Tangi

Changed email addreses.
nkab@... is now a.bremang@...
Sorry

Hi
There are a number of useful links for information and the xmldbms tool set
@
http://www.rpbourret.com/xmldbms/index.htm

Dear all,

I have completed my WAP portal using wml & jsp and backend Oracle DB.
Now I have to convert my application into XML based one and it can
able to talk any kind DB environment.

My current application architecture is

WML & JSP files - Oracle DB

My requirement architecture is to be

WML & JSP file - XML layer - any kind of DB environment and any
platform.

hence kindly advise me in this regard how to do n start. Pls reply me
asap.

Tks in advance
Jowsaki

Hi

I understabd that XML_DBMS is a middleware for
transferring data between XML documents and relational
database. I wanted to know whether it involves JSP.

Thanks

Baby

____________________________________________________________
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie

> -----Original Message-----
> From: Baby Ashwin Gobin [mailto:ash_wing@...]
> Sent: 06 July 2001 13:18
> To: xml-dbms@yahoogroups.com
> Subject: [xml-dbms] (unknown)
>
>
> Hi
>
> I understabd that XML_DBMS is a middleware for
> transferring data between XML documents and relational
> database. I wanted to know whether it involves JSP.
>
>

It doesn't but (at least with version 1.1) you can use them with it.

I've run servlets on Tomcat, WebSphere & Weblogic using XD1.1

Adam

> -----Original Message-----
> From: jowsaki@... [mailto:jowsaki@...]
> Sent: 06 July 2001 13:01
> To: xml-dbms@yahoogroups.com
> Subject: [xml-dbms] XML data layer for my WAP application
>
>
> Dear all,
>
> I have completed my WAP portal using wml & jsp and backend Oracle DB.
> Now I have to convert my application into XML based one and it can
> able to talk any kind DB environment.
>
> My current application architecture is
>
> WML & JSP files - Oracle DB
>
> My requirement architecture is to be
>
> WML & JSP file - XML layer - any kind of DB environment and any
> platform.
>

Get the 1.1 code from CVS. It has support for XSLT & JMS & will happily run
as / within JSP/Servlets.


> hence kindly advise me in this regard how to do n start. Pls reply me
> asap.
>


Ron & I are just finishing up a couple of HTML Doc's detailing how to use
1.1. It's much easier & uses property files. It'll also cope with Strings
instead of XMLFiles, & can get files (e.g. XSLT or Mapfiles via a URL, local
file or even within a Jar.


Adam

1) The compilation warning is due to MapFactory_MapDocument using SAX
version 1.0, which is now deprecated. This will be fixed in 2.0, but
shouldn't cause segmentation faults.

2) I have no idea what might cause a segmentation fault. The only thing
I can suggest is to try a different Java VM (but first try the fix in
#3).

3) Not finding the lines table is due to XML-DBMS and the Postgres
driver interpretting the (vague) JDBC spec differently. See the
following bug report for details and a workaround:


http://sourceforge.net/tracker/?group_id=13613&atid=113613&func=detail&aid=40889\
6

-- Ron

teme70@... wrote:
>
> Hi,
>
> After having struggled a couple of days with the Transfer sample
> application I finally admit that I need to ask for assistance. I am
> fairly new with Java so I hope I can describe the symptoms clearly
> enough.
>
> 1) Compilation
>
> The complier gives the following warnings:
>
> >[tkokko@rapu samples]$ javac -deprecation Transfer.java
> >Transfer.java:16: warning: org.xml.sax.Parser in org.xml.sax has been
> >deprecated
> >import org.xml.sax.Parser;
>                    ^
> >Transfer.java:238: warning: org.xml.sax.Parser in org.xml.sax has
> >been deprecated
> >static Parser getSAXParser()
>           ^
> >2 warnings
>
> 2) Running - the programme gives a segmentation fault (no exceptions
> reported)
>
> >[tkokko@rapu samples]$ java Transfer -todbms sales.map sales_in.xml
> >Segmentation fault
>
> 3) Running through jdb - exception "lines" -table not found
>
> >[tkokko@rapu samples]$ jdb Transfer -todbms sales.map sales_in.xml
> >Initializing jdb...
> > run
> >run Transfer -todbms sales.map sales_in.xml
> >
> >VM Started: de.tudarmstadt.ito.xmldbms.InvalidMapException: Table not
> >found: lines. Check that the table exists, that its name is spelled
> >correctly, and that the case used in the map document exactly matches
> >the case used in the database. This might be different from the case
> >you used when creating the table.
> >        at
> >de.tudarmstadt.ito.xmldbms.Map.addColumnMetadata(Map.java:1774)
> >        at
> >de.tudarmstadt.ito.xmldbms.Map.getTableMetadata(Map.java:1613)
> >        at
> >de.tudarmstadt.ito.xmldbms.Map.initColumnMetadata(Map.java:236)
> >        at
>
>de.tudarmstadt.ito.xmldbms.mapfactories.MapFactory_MapDocument.create>Map(MapFa\
ctory_MapDocument.java:339)
> at >Transfer.createMap(Transfer.java:219)
> >        at Transfer.toDBMS(Transfer.java:156)
> >        at Transfer.main(Transfer.java:117)
> >
> >The application exited
>
> The "lines" table does exist in my "xmldbms" database.
>
> >xmldbms=# \dt
> >      List of relations
> >    Name    | Type  | Owner
> >------------+-------+--------
> > customers  | table | tkokko
> > lines      | table | tkokko
> > parts      | table | tkokko
> > sales      | table | tkokko
> > xmldbmskey | table | tkokko
> >(5 rows)
> >
> >xmldbms=#
>
> My SQL software (PostgreSQL) seems to conver all the letters to lower
> case, so I made them lower case in the sales.map file, too.
>
> Also, when you "next" through the code in jdb control jumps from the
> line (original source code, line 171, method toDBMS)
>
>         map = createMap(mapFilename, conn2);
>
> directly to the finally block.
>
> Before executing this line the local variables are:
>
> >main[1] locals
> >Method arguments:
> >  mapFilename = "sales.map"
> >  xmlFilename = "sales_in.xml"
> >  url = "jdbc:postgresql:xmldbms"
> >Local variables:
> >  conn1 = instance of org.postgresql.jdbc2.Connection(id=266)
> >  conn2 = instance of org.postgresql.jdbc2.Connection(id=267)
> >  keyGenerator = instance of
> >de.tudarmstadt.ito.xmldbms.helpers.KeyGeneratorImpl(id=268)
> >main[1]
>
> And the local variables in createMap method just before it returns
> (line 237 in the original Transfer.java-source) are
>
> line 237 (Transfer.java)
> return factory.createMap(new InputSource(getFileURL(mapFilename)));
>
> >main[1] locals
> >Method arguments:
> >  mapFilename = "sales.map"
> >  conn = instance of org.postgresql.jdbc2.Connection(id=267)
> >Local variables:
> >  factory = instance of
> >de.tudarmstadt.ito.xmldbms.mapfactories.MapFactory_MapDocument(id=328)
>
> It seems that something funny happens in execution of the line 237,
> which results in an exception, and the control moves on to the finally
> block in toDBMS method. However, when not running through the debugger
> the programme just crashes and does not exit nicely with an exception
> report.
>
> I use the xerces.jar downloaded from apache
> pages(Xerces-J-bin.1.4.1.zip) and postgreSQL with a jdbc driver
> jdbc7.0-1.2.jar.
>
> OK. I am very appreciative if someone can help, I'd really like to get
> to use XML-DBMS.
>
> Regards,
>
> Teemu Kokkonen
> teme70@...
>
> To post a message, send it to: xml-dbms@yahoogroups.com
> To unsubscribe, send a blank message to: xml-dbms-unsubscribe@yahoogroups.com
> Or join the newsgroup at: news://news.barkto.com/homeless.xml.xml-dbms
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

--
Ronald Bourret
Programming, Writing, and Training
XML, Databases, and Schemas
http://www.rpbourret.com

tangivass@... wrote:
> Maybe a solution could be to use temp views instead of a result set.

As long as you use named views, this would work, since SELECT statements
shouldn't discriminate between tables and views.

> I've got another question: would it be possible to let defining a
> class which wouldn't generate XML but could just be used for joining
> two other classes? This situation often occurs when dealing with 3NF
> databases.

Good point. I've wondered about this but haven't ever really thought too
deeply how it would work. I think that this can be solved by the
(misapplication) of inheritance:

A 2.0 feature is inheritance support. This would allow you to say that
class A' derives from class A. You can choose to store the data from A'
in the table for A' or in the tables for both A and A'. When you
generate XML from this, no element for the base class (A) is generated
-- only an element for the derived class (A').

To use this for many-to-many joins, you treat the join table as the base
class table and the remote table as the derived class table. This means
that no element is created for the join table, which is what you want.
Furthermore, I'm pretty sure that the code supports multiple inheritance
(in the sense of a single line of ancestors, not multiple parents), so
you could perform many-to-many-to-many-to-... joins if you want to.

This also points out something I hadn't thought of, which is that
multiple objects could share the same row in the base class table. This
makes inserts and deletes more difficult...

Note that, although inheritance is already included in the 2.0 mapping
language and map objects, it will be one of the later features added to
the transfer software due to complexity and lack of demand.

-- Ron

Dear friends,
I have developed an enterprise application.Now my next assignment is
to develop an xml based interface layer to the above application.I
give below my requirement as under.

My Enterprise Application
|
|
XML Interface Layer
|
|
Multiple Databases

Please can anyone explain me the procedures to how to approach the
above problem.

My application is for banking and shopping and i want to have common
interface layer in XML so that it can be easily pluged into any
leagacy database as well as any ERP solutions.

Please give your valuable sugesstions..

Jowsaki
India
Trinity Infosys

Dear friends,
I have developed an enterprise application.Now my next assignment is
to develop an xml based interface layer to the above application.I
give below my requirement as under.

My Enterprise Application
|
|
XML Interface Layer
|
|
Multiple Databases

Please can anyone explain me the procedures to how to approach the
above problem.

My application is for banking and shopping and i want to have common
interface layer in XML so that it can be easily pluged into any
leagacy database as well as any ERP solutions.

Please give your valuable sugesstions..

Jowsaki
India
Trinity Infosys

----Original Message Follows----
From: adam flinton <aflinton@...>
Reply-To: xml-dbms@yahoogroups.com
To: "'xml-dbms@yahoogroups.com'" <xml-dbms@yahoogroups.com>
Subject: RE: [xml-dbms] XML data layer for my WAP application
Date: Fri, 6 Jul 2001 13:38:53 +0100
MIME-Version: 1.0
Received: from [64.211.240.238] by hotmail.com (3.2) with ESMTP id
MHotMailBD0EFC7400734004311C40D3F0EE13E525; Fri, 06 Jul 2001 05:39:51 -0700
Received: from [10.1.4.53] by mu.egroups.com with NNFMP; 06 Jul 2001
12:39:00 -0000
Received: (EGP: mail-7_2_0); 6 Jul 2001 12:38:59 -0000
Received: (qmail 61093 invoked from network); 6 Jul 2001 12:38:58 -0000
Received: from unknown (10.1.10.142) by l7.egroups.com with QMQP; 6 Jul 2001
12:38:58 -0000
Received: from unknown (HELO cow.armature.com) (194.128.255.228) by mta3
with SMTP; 6 Jul 2001 12:38:58 -0000
Received: by mailhost.armature.com with Internet Mail Service (5.5.2653.19)
id <3MAMYGJZ>; Fri, 6 Jul 2001 13:38:56 +0100
From sentto-1643643-1252-994423139-k_kushwaha Fri, 06 Jul 2001 05:41:31
-0700
X-eGroups-Return:
sentto-1643643-1252-994423139-k_kushwaha=hotmail.com@returns.onelist.com
X-Sender: aflinton@...
X-Apparently-To: xml-dbms@yahoogroups.com
Message-ID: <753866CAB183D211883F0090271F46C205C5AA73@...>
X-Mailer: Internet Mail Service (5.5.2653.19)
Mailing-List: list xml-dbms@yahoogroups.com; contact
xml-dbms-owner@yahoogroups.com
Delivered-To: mailing list xml-dbms@yahoogroups.com
Precedence: bulk
List-Unsubscribe: <mailto:xml-dbms-unsubscribe@yahoogroups.com>



  > -----Original Message-----
  > From: jowsaki@... [mailto:jowsaki@...]
  > Sent: 06 July 2001 13:01
  > To: xml-dbms@yahoogroups.com
  > Subject: [xml-dbms] XML data layer for my WAP application
  >
  >
  > Dear all,
  >
  > I have completed my WAP portal using wml & jsp and backend Oracle DB.
  > Now I have to convert my application into XML based one and it can
  > able to talk any kind DB environment.
  >
  > My current application architecture is
  >
  > WML & JSP files - Oracle DB
  >
  > My requirement architecture is to be
  >
  > WML & JSP file - XML layer - any kind of DB environment and any
  > platform.
  >

Get the 1.1 code from CVS. It has support for XSLT & JMS & will happily run
as / within JSP/Servlets.


  > hence kindly advise me in this regard how to do n start. Pls reply me
  > asap.
  >


Ron & I are just finishing up a couple of HTML Doc's detailing how to use
1.1. It's much easier & uses property files. It'll also cope with Strings
instead of XMLFiles, & can get files (e.g. XSLT or Mapfiles via a URL, local
file or even within a Jar.


Adam

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Hi friends

Well i'm a newcomer and i would really appreciate it
if someone could help me. Well i've got to make a
portal(HTML code writer also included).
I have to study XML and JSP
I'd like to know whether XML-DBMS would be helpful.


Thanks
Baby


____________________________________________________________
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie

Baby Ashwin Gobin wrote:

> Well i'm a newcomer and i would really appreciate it
> if someone could help me. Well i've got to make a
> portal(HTML code writer also included).
> I have to study XML and JSP
> I'd like to know whether XML-DBMS would be helpful.

If you want to transfer data between an XML document and a database,
XML-DBMS would be helpful. This would probably relate to your task as
follows. Inside a JSP, you would call XML-DBMS to transfer data to an
XML document. You would then use XSLT to transform that XML document to
HTML.

-- Ron

Hi everybody,

this is my first e-mail message. First of all
congratulations to Ronald, all his colaborators and
all of you for the making of this wonderfull free
tool.

Everything works great but I have a problem.

I´m designing a XML based messaging system betwen two
applications. My DBMS is Oracle 8i.

Ok, so the problem is:

I´m trying to use Oracle autogenerated Primary Keys
(Sequences/Triggers) as reference keys in the
parent-child relationships for the database data
generated by xml-dbms.

With xml-dbms generated Primary Key values all works
great. But with oracle generated keys it doesnt work.

I´ve been taking a fast view to the code and it seems
that the problem is that DOMtoDBMS does not update the
Row object contents with the database content after
inserting the parent record.

Whithout this update it´s not posible to xml-dbms to
know if any automatism of the DBMS has updated the
value of the primary key of the parent object when
inserting the child object.

I´m working with Oracle but I guess the problem exists
with any DBMS whith an autonumeric Primary Key
functionality.

- I´m doing things right but xml-dbms does not support
what I´m trying to do or there is a way to do it?

- Can it (if needed) be fixied with an easy
modification?

- Has anybody made that modification?

I know thar reaccesing every record ( at least every
foreign key referenced record) after every insertion
can be time consuming (especialy over weak or
saturated communication lines) so a final
implementation of this functionality sould be
optionaly configurable and shold only query the
inserted row when it were foreign key referenced.

Thanks in advance.

Juanjo Garcia
Software Architect.


__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/

Is There  some way to transform resultset(java) to xml document with his own
dtd  ?

I found some classes of XMLSMBD, but I like to use some little different. I
was using com.ibm.xml.parser.DTD, .TXDocument,..  to do this. Is there
something similar in the new releases of IBM or SUN ?



Thanks in advancce,

Anahi

PSD: Thank you very much for http://java.sun.com/xml/tutorial_intro.html
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.