3 Replies Latest reply on Apr 11, 2007 11:12 PM by Mannamal-Oracle

    problem in loading float/double data to RDF data model

    571758
      Hello,
      I have a following problem, while I was loading data with TestNTriple2NDM Java class I was given following error:

      ID: 522 Error: java.sql.SQLException: ORA-13199: RDF:Error occurred

      It was not one error there was some kind of regularity in next errors. The IDs pointed to be the error with nTriple Data, which were converted from owl language rules. But the problem is in adding RDF rules with the float / double XMLS format:

      "1.00794"^^<http://www.w3.org/2001/XMLSchema#float>

      In this and other lines where the error has appeared, was defined a rule with this data format.

      I tried to add data with this kind to database, but it is producing the same error message :


      INSERT INTO rdf_data (id, triple) VALUES (1, SDO_RDF_TRIPLE_S('test', '<http://www.daml.org/2003/01/periodictable/PeriodicTable#N>', '<http://www.daml.org/2003/01/periodictable/PeriodicTable#atomicWeight>', '"14.0067"^^<http://www.w3.org/2001/XMLSchema#float>')) ;

      ORA-13199: RDF:Error occurred
      ORA-06512: przy "MDSYS.MD", line 1723
      ORA-06512: przy "MDSYS.MDERR", line 17
      ORA-06512: przy "MDSYS.SDO_RDF_TRIPLE_S", line 98

      What can I do to get rid of this error?
        • 1. Re: problem in loading float/double data to RDF data model
          563141
          Hi!

          Check info here Problems with date formats and decimal delimiters

          or just try to change dots "." for commas "," in float values:

          INSERT INTO rdf_data (id, triple) VALUES (1, SDO_RDF_TRIPLE_S('test', '<http://www.daml.org/2003/01/periodictable/PeriodicTable#N>', '<http://www.daml.org/2003/01/periodictable/PeriodicTable#atomicWeight>', '"14,0067"^^<http://www.w3.org/2001/XMLSchema#float>')) ;

          if this works then your locale expects you to provide float values with comma as decimal delimiter.

          Anton
          • 2. Re: problem in loading float/double data to RDF data model
            571758
            Thanks, I think the problem was in it. But is there a way to set local columns to float with "." instead of "," for example only specified tablespace? I'm trying to load rdf rules in NTriple form to Oracle RDF data type, but there is a problem with local settings. So the question is can I change database settings or should write ALTER SESSION command in the NTripleConverter Java class ?

            Thanks for answer.
            • 3. Re: problem in loading float/double data to RDF data model
              Mannamal-Oracle
              Are you wondering how to change the NLS settings during the batch load? I believe this can be done by setting it as an operating system environment variable - for example for linux/unix based systems it can be done as:

              %setenv NLS_LANG American

              More details are in the documentation Oracle® Database Globalization Support Guide 10g Release 2 (10.2) Part Number B14225-02. (chapter 3 has details on NLS_LANG).

              After setting the NLS_LANG variable the batch loader should work according to that setting.

              As the documentation describes the setting can also be altered by including ALTER SESSION in the Java class, but setting it as an environment variable should be easier.

              Melli