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

[xml-dbms] error when using Transfer sample

Expand Messages
  • chennl
    when I type the following in the command line: java Transfer -todbms document.map document_in.xml I get the following error:
    Message 1 of 4 , Mar 19, 2000
      when I type the following in the command line:
      java Transfer -todbms document.map document_in.xml
      I get the following error:
      de.tudarmstadt.ito.xmldbms.KeyException: [Microsoft][ODBC Microsoft
      Access driver] Microsoft Jet can't find input table or query
      'XMLDBMSKey'.Make sure if it exists,and its name is spelled correctly.
      at de.tudarmstadt.ito.xmldbms.helpers.KeyGeneratorImpl.initialize
      (KeyGen
      eratorImpl.java:120)
      at Transfer.toDBMS(Transfer.java:120)
      at Transfer.main(Transfer.java, Compiled Code)
    • chennl
      when I type the following in the command line: java Transfer -todbms document.map document_in.xml I get the following error:
      Message 2 of 4 , Mar 19, 2000
        when I type the following in the command line:
        java Transfer -todbms document.map document_in.xml
        I get the following error:
        de.tudarmstadt.ito.xmldbms.KeyException: [Microsoft][ODBC Microsoft
        Access driver] Microsoft Jet can't find input table or query
        'XMLDBMSKey'.Make sure if it exists,and its name is spelled correctly.
        at de.tudarmstadt.ito.xmldbms.helpers.KeyGeneratorImpl.initialize
        (KeyGen
        eratorImpl.java:120)
        at Transfer.toDBMS(Transfer.java:120)
        at Transfer.main(Transfer.java, Compiled Code)

        Thank you!
      • Ronald Bourret
        ... XML-DBMS uses key values to identify data in the database. When transferring data to the database, XML-DBMS has two choices. It can either generate key
        Message 3 of 4 , Mar 21, 2000
          >when I type the following in the command line:
          >java Transfer -todbms document.map document_in.xml
          >I get the following error:
          >de.tudarmstadt.ito.xmldbms.KeyException: [Microsoft][ODBC Microsoft
          >Access driver] Microsoft Jet can't find input table or query
          >'XMLDBMSKey'.Make sure if it exists,and its name is spelled correctly.
          > at de.tudarmstadt.ito.xmldbms.helpers.KeyGeneratorImpl.initialize
          >(KeyGen
          >eratorImpl.java:120)
          > at Transfer.toDBMS(Transfer.java:120)
          > at Transfer.main(Transfer.java, Compiled Code)

          XML-DBMS uses key values to identify data in the database. When transferring
          data to the database, XML-DBMS has two choices. It can either generate key
          values itself, or it can use element or attribute values as key values. The
          mapping document tells XML-DBMS whether to generate key values or use
          element/attribute values.

          (document.map shows how to tell XML-DBMS to generate key values. sales.map
          shows how to tell XML-DBMS to use element and attribute values as keys.)

          When the map tells XML-DBMS to generate key values, the calling application
          must provide an object that implements the KeyGenerator interface. XML-DBMS
          calls this object to actually generate the key values. The default
          implementation of this interface is KeyGeneratorImpl, which is used by the
          Transfer sample application. KeyGeneratorImpl generates key values based on
          a number stored in the XMLDBMSKey table.

          Thus, if you use the Transfer sample application with the document.map
          sample mapping document, you need to have an XMLDBMSKey table in your
          database. Furthermore, it must have a single row, containing the value 0.
          For more information, see the documentation for
          de.tudarmstadt.ito.xmldbms.helpers.KeyGeneratorImpl and section 4.0
          (Transferring Data to the Database) of the readme.html file.

          Hope this helps,

          -- Ron Bourret
          ______________________________________________________
        • Sachin Khungar
          There are two classes that you have used in the Transfer sample XMLParser & XMLDocument both of which are part of oracle.xml.parser package so can you specify
          Message 4 of 4 , Mar 30, 2000
            There are two classes that you have used in the Transfer sample XMLParser
            & XMLDocument both of which are part of oracle.xml.parser package so can
            you specify where can i get this package & since i am not using oracle
            database at the backend, i am actually using PrimeBase database so do i
            have to make any more changes for using the Transfer Application.

            ------------------------------------------------------------------------------
            Sachin Khungar
            M.C.A VI Sem
            Dept of Computer Science
            University of Pune
            E-mail:u97133@...
            ------------------------------------------------------------------------------
            Just a Thought:--
            ------------------
            The harder your path to success more Beautiful shall be your
            glory.
            ------------------------------------------------------------------------------
          Your message has been successfully submitted and would be delivered to recipients shortly.