Loading ...
Sorry, an error occurred while loading the content.

RE: Newbie Question

Expand Messages
  • Alex Lennon
    Many apologies - finger trouble. The previous message should have read: Hi all, I have a quick question if I may: I m new to XML, SQL and databases in general
    Message 1 of 8 , Jun 20, 2001
    • 0 Attachment
      Many apologies - finger trouble. The previous message should have read:


      Hi all,

      I have a quick question if I may:

      I'm new to XML, SQL and databases in general unfortunately. As a learning
      exercise I downloaded the XML-DBMS Java implementation a short while ago
      and am now happily inserting simple XML documents as records in a
      PostgreSQL database. So far so good...

      These XML documents are automatically generated and so simply inserting
      into the database is going to generate a lot of data over time. I'd like to
      be
      able to perform a query on the records currently in the table I am using and
      then (i) insert new records, (ii) update the timestamp on existing records.

      Is there a sensible/simple way I can model this in XML-DBMS or is there
      another toolset I might look at ? I'm keen to stay away from custom Java
      based implementations though....

      TIA for any input,

      Alex Lennon
    • Ronald Bourret
      ... If I understand you correctly, what you want to do is compare some data in an XML document with the data in the database. If the data is already in the
      Message 2 of 8 , Jun 20, 2001
      • 0 Attachment
        Alex Lennon wrote:

        > I'm new to XML, SQL and databases in general unfortunately. As a learning
        > exercise I downloaded the XML-DBMS Java implementation a short while ago
        > and am now happily inserting simple XML documents as records in a
        > PostgreSQL database. So far so good...
        >
        > These XML documents are automatically generated and so simply inserting
        > into the database is going to generate a lot of data over time. I'd like to
        > be
        > able to perform a query on the records currently in the table I am using and
        > then (i) insert new records, (ii) update the timestamp on existing records.

        If I understand you correctly, what you want to do is compare some data
        in an XML document with the data in the database. If the data is already
        in the database, you want to update the timestamp. If it is not in the
        database, you want to insert the data. Is this correct?

        If so, you can't do this with version 1.0, which is insert-only. This
        will be supported in 2.0, although the timestamp will need to be a piece
        of data in the XML document. That is, XML-DBMS does not (and will not)
        have a feature that specifically updates a timestamp column. The
        timestamp is treated like any other piece of data and must originate in
        the XML document.

        -- Ron

        > Is there a sensible/simple way I can model this in XML-DBMS or is there
        > another toolset I might look at ? I'm keen to stay away from custom Java
        > based implementations though....

        You might try the following (commercial) tools:

        ADO (Microsoft)
        HiT Allora (http://www.hitsw.com/dsheets/alloramidware.htm)
        DB/XML Transform (http://www.bdisystems.com/)

        I believe all of these support updates today.

        -- Ron
      • ialexand2003
        Hi, I am new to XMLtoDBMS, I have installed the perl version of the package, and to test it, copied in some of the sample code. I get the following error:-
        Message 3 of 8 , Apr 21, 2003
        • 0 Attachment
          Hi,

          I am new to XMLtoDBMS, I have installed the perl version of the
          package, and to test it, copied in some of the sample code. I get
          the following error:-

          Undefined subroutine &XML::XMLtoDBMS::MapFactory::XMLtoDBMS
          called at /u
          sr/local/lib/perl5/site_perl/5.6.0/XML/XMLtoDBMS.pm line 2807.

          I've noticed at least two other emails on this problem in the
          mailing list, but no replies.

          Is this a known bug that we should have been able to look up
          ourselves (if so, where?) or is it that the answer remains unknown,
          or is blindingly obvious? (not to me sadly ..)

          Any help would be appreciated.

          cheers

          Iain
        • pupus pupusmeneh
          ialexand2003 wrote: Hi, I am new to XMLtoDBMS, I have installed the perl version of the package, and to test it, copied in some of
          Message 4 of 8 , Apr 24, 2003
          • 0 Attachment
            ialexand2003 <iain.alexander@...> wrote:
            Hi,

            I am new to XMLtoDBMS, I have installed the perl version of the
            package, and to test it, copied in some of the sample code. I get
            the following error:-

            Undefined subroutine &XML::XMLtoDBMS::MapFactory::XMLtoDBMS
            called at /u
            sr/local/lib/perl5/site_perl/5.6.0/XML/XMLtoDBMS.pm line 2807.

            I've noticed at least two other emails on this problem in the
            mailing list, but no replies.

            Is this a known bug that we should have been able to look up
            ourselves (if so, where?) or is it that the answer remains unknown,
            or is blindingly obvious? (not to me sadly ..)

            Any help would be appreciated.

            cheers

            Iain


            I'm a newbie too

            i use XML-DBMS20 and have installed the java version.

            i'm trying to use the sample. i want to transform the order.xml data and put it in the mysql database. (i'm using php triad in windows of course) using

            my question is : do i still have to compile the transfer.java file?

            i have so many erorr, because i'm newbie in java too :-(

            i wish if anybody could help me especially about how to use the jdbc-odbc driver, use the parse, etc.

            any help would be appreciated

            thanks




            ---------------------------------
            Yahoo! Plus - For a better Internet experience


            [Non-text portions of this message have been removed]
          • Ronald Bourret
            Sorry not to have replied sooner. I ve written the author of the PERL version to see if he has any idea what is happening here. No guarantees on whether he
            Message 5 of 8 , Apr 24, 2003
            • 0 Attachment
              Sorry not to have replied sooner.

              I've written the author of the PERL version to see if he has any idea
              what is happening here. No guarantees on whether he will have time to
              track down this problem.

              -- Ron

              ialexand2003 wrote:
              >
              > Hi,
              >
              > I am new to XMLtoDBMS, I have installed the perl version of the
              > package, and to test it, copied in some of the sample code. I get
              > the following error:-
              >
              > Undefined subroutine &XML::XMLtoDBMS::MapFactory::XMLtoDBMS
              > called at /u
              > sr/local/lib/perl5/site_perl/5.6.0/XML/XMLtoDBMS.pm line 2807.
              >
              > I've noticed at least two other emails on this problem in the
              > mailing list, but no replies.
              >
              > Is this a known bug that we should have been able to look up
              > ourselves (if so, where?) or is it that the answer remains unknown,
              > or is blindingly obvious? (not to me sadly ..)
              >
              > Any help would be appreciated.
              >
              > cheers
              >
              > Iain
            • Ronald Bourret
              Just noticed something. I m almost 100% ignorant of PERL, but it looks like the MapFactory code is using the element type name as the subroutine name to
              Message 6 of 8 , Apr 24, 2003
              • 0 Attachment
                Just noticed something.

                I'm almost 100% ignorant of PERL, but it looks like the MapFactory code
                is using the element type name as the subroutine name to process the
                element. Now, the correct root element type for a map file is XMLToDBMS
                (capital "T") and this is also the name of the corresponding subroutine
                in the XMLToDBMS.pm file. The error below is looking for the subroutine
                XMLtoDBMS (lower case "t"), which makes me think that (a) PERL is case
                sensitive and (b) you are using XMLtoDBMS (lower case "t") in your map
                file. If so, change the name to use an upper case T and see if that
                works.

                By the way, this is a good example of why you should always validate
                your map files during development. XML-DBMS assumes that map files are
                valid and silently ignores errors and behaves in unpredictable ways if
                they are not. It leaves the choice of validation to the user, since this
                allows people to validate map files during development and optionally
                turn off validation in production code to get better performance.

                -- Ron

                ialexand2003 wrote:
                >
                > Hi,
                >
                > I am new to XMLtoDBMS, I have installed the perl version of the
                > package, and to test it, copied in some of the sample code. I get
                > the following error:-
                >
                > Undefined subroutine &XML::XMLtoDBMS::MapFactory::XMLtoDBMS
                > called at /u
                > sr/local/lib/perl5/site_perl/5.6.0/XML/XMLtoDBMS.pm line 2807.
                >
                > I've noticed at least two other emails on this problem in the
                > mailing list, but no replies.
                >
                > Is this a known bug that we should have been able to look up
                > ourselves (if so, where?) or is it that the answer remains unknown,
                > or is blindingly obvious? (not to me sadly ..)
              • Ronald Bourret
                ... No. Transfer.java is already compiled and Transfer.class is shipped in the xmldbms20.jar file. Therefore, you need to set your CLASSPATH to point to the
                Message 7 of 8 , Apr 24, 2003
                • 0 Attachment
                  pupus pupusmeneh wrote:
                  > I'm a newbie too
                  >
                  > i use XML-DBMS20 and have installed the java version.
                  >
                  > i'm trying to use the sample. i want to transform the order.xml data
                  > and put it in the mysql database. (i'm using php triad in windows
                  > of course) using
                  >
                  > my question is : do i still have to compile the transfer.java file?

                  No.

                  Transfer.java is already compiled and Transfer.class is shipped in the
                  xmldbms20.jar file. Therefore, you need to set your CLASSPATH to point
                  to the xmldbms20.jar file. For information about how to do this, see the
                  Java documentation.

                  -- Ron
                • ialexand2003
                  Yup, That was it. I changed XMLtoDBMS to XMLToDBMS and it all burst magically into life. Thanks Ron, Iain ... code ... the ... XMLToDBMS ... subroutine ...
                  Message 8 of 8 , Apr 29, 2003
                  • 0 Attachment
                    Yup, That was it.

                    I changed XMLtoDBMS to XMLToDBMS and it all burst magically into
                    life.

                    Thanks Ron,

                    Iain


                    --- In xml-dbms@yahoogroups.com, Ronald Bourret <rpbourret@r...>
                    wrote:
                    > Just noticed something.
                    >
                    > I'm almost 100% ignorant of PERL, but it looks like the MapFactory
                    code
                    > is using the element type name as the subroutine name to process
                    the
                    > element. Now, the correct root element type for a map file is
                    XMLToDBMS
                    > (capital "T") and this is also the name of the corresponding
                    subroutine
                    > in the XMLToDBMS.pm file. The error below is looking for the
                    subroutine
                    > XMLtoDBMS (lower case "t"), which makes me think that (a) PERL is
                    case
                    > sensitive and (b) you are using XMLtoDBMS (lower case "t") in your
                    map
                    > file. If so, change the name to use an upper case T and see if that
                    > works.
                    >
                    > By the way, this is a good example of why you should always
                    validate
                    > your map files during development. XML-DBMS assumes that map files
                    are
                    > valid and silently ignores errors and behaves in unpredictable
                    ways if
                    > they are not. It leaves the choice of validation to the user,
                    since this
                    > allows people to validate map files during development and
                    optionally
                    > turn off validation in production code to get better performance.
                    >
                    > -- Ron
                    >
                    > ialexand2003 wrote:
                    > >
                    > > Hi,
                    > >
                    > > I am new to XMLtoDBMS, I have installed the perl version of the
                    > > package, and to test it, copied in some of the sample code. I get
                    > > the following error:-
                    > >
                    > > Undefined subroutine
                    &XML::XMLtoDBMS::MapFactory::XMLtoDBMS
                    > > called at /u
                    > > sr/local/lib/perl5/site_perl/5.6.0/XML/XMLtoDBMS.pm line 2807.
                    > >
                    > > I've noticed at least two other emails on this problem in the
                    > > mailing list, but no replies.
                    > >
                    > > Is this a known bug that we should have been able to look up
                    > > ourselves (if so, where?) or is it that the answer remains
                    unknown,
                    > > or is blindingly obvious? (not to me sadly ..)
                  Your message has been successfully submitted and would be delivered to recipients shortly.