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

[XMLDBMS] Unparseable number: "SomeString"

Expand Messages
  • cafulnecky
    I am trying to retrieve data from tables that were populated using xmldbms. The Unparseable number exception is being thrown on a key column having a datatype
    Message 1 of 2 , Mar 26, 2004
    • 0 Attachment
      I am trying to retrieve data from tables that were populated using
      xmldbms. The Unparseable number exception is being thrown on a key
      column having a datatype of varchar(2). The filter looks like:

      <FilterSet Version="2.0"
      xmlns="http://www.xmlmiddleware.org/xmldbms/filters/v2">
      <Options>
      <Wrapper Name="Sessions" />
      </Options>
      <Filters>
      <Filter>
      <RootFilter>
      <Table Name="DMS_DATA_MINING_SESSION"/>
      <Where Condition="SESSION_ID>'1'"/>
      </RootFilter>
      </Filter>
      </Filters>
      </FilterSet>

      The portion of the map for this table looks like:

      <Table Name="DMS_DATA_MINING_SESSION">
      <Column Name="PARAM_SEQ" DataType="DECIMAL" Length="10"
      Nullable="No"/>
      <Column Name="SESSION_ID" DataType="DECIMAL" Length="14"
      Nullable="No"/>
      <Column Name="DS_ID" DataType="VARCHAR" Length="200" Nullable="No"/>


      <Column Name="USER_ID" DataType="VARCHAR" Length="100"
      Nullable="No"/>
      <Column Name="DMS_DATE" DataType="DATE" Nullable="No"/>
      <Column Name="COMMENTS" DataType="VARCHAR" Length="255"
      Nullable="Yes"/>
      <Column Name="DMS_TYPE" DataType="VARCHAR" Length="100"
      Nullable="Yes"/>
      <PrimaryKey Name="DMS_DATA_MINING_SESSION_PK">
      <UseColumn Name="DS_ID"/>
      <UseColumn Name="SESSION_ID"/>
      <UseColumn Name="PARAM_SEQ"/>
      </PrimaryKey>
      <ForeignKey Name="DMS_DATASOURCE_LIST_FK">
      <UseTable Name="DMS_DATASOURCE_LIST"/>
      <UseUniqueKey Name="DMS_DATASOURCE_LIST_PK"/>
      <UseColumn Name="DS_ID"/>
      </ForeignKey>
      </Table>

      Thanks,

      Charlie
    • Ronald Bourret
      It looks like your filter condition is invalid. Specifically, the following Condition attribute: will result in
      Message 2 of 2 , Mar 31, 2004
      • 0 Attachment
        It looks like your filter condition is invalid. Specifically, the
        following Condition attribute:

        <Where Condition="SESSION_ID>'1'"/>

        will result in the following WHERE clause:

        WHERE SESSION_ID>'1'

        But SESSION_ID is a DECIMAL column, so the right hand side of the
        comparison is parsed as a number. This doesn't work because '1' is a
        string. Try:

        <Where Condition="SESSION_ID>1"/>

        instead.

        -- Ron



        cafulnecky wrote:
        >
        > I am trying to retrieve data from tables that were populated using
        > xmldbms. The Unparseable number exception is being thrown on a key
        > column having a datatype of varchar(2). The filter looks like:
        >
        > <FilterSet Version="2.0"
        > xmlns="http://www.xmlmiddleware.org/xmldbms/filters/v2">
        > <Options>
        > <Wrapper Name="Sessions" />
        > </Options>
        > <Filters>
        > <Filter>
        > <RootFilter>
        > <Table Name="DMS_DATA_MINING_SESSION"/>
        > <Where Condition="SESSION_ID>'1'"/>
        > </RootFilter>
        > </Filter>
        > </Filters>
        > </FilterSet>
        >
        > The portion of the map for this table looks like:
        >
        > <Table Name="DMS_DATA_MINING_SESSION">
        > <Column Name="PARAM_SEQ" DataType="DECIMAL" Length="10"
        > Nullable="No"/>
        > <Column Name="SESSION_ID" DataType="DECIMAL" Length="14"
        > Nullable="No"/>
        > <Column Name="DS_ID" DataType="VARCHAR" Length="200" Nullable="No"/>
        >
        >
        > <Column Name="USER_ID" DataType="VARCHAR" Length="100"
        > Nullable="No"/>
        > <Column Name="DMS_DATE" DataType="DATE" Nullable="No"/>
        > <Column Name="COMMENTS" DataType="VARCHAR" Length="255"
        > Nullable="Yes"/>
        > <Column Name="DMS_TYPE" DataType="VARCHAR" Length="100"
        > Nullable="Yes"/>
        > <PrimaryKey Name="DMS_DATA_MINING_SESSION_PK">
        > <UseColumn Name="DS_ID"/>
        > <UseColumn Name="SESSION_ID"/>
        > <UseColumn Name="PARAM_SEQ"/>
        > </PrimaryKey>
        > <ForeignKey Name="DMS_DATASOURCE_LIST_FK">
        > <UseTable Name="DMS_DATASOURCE_LIST"/>
        > <UseUniqueKey Name="DMS_DATASOURCE_LIST_PK"/>
        > <UseColumn Name="DS_ID"/>
        > </ForeignKey>
        > </Table>
      Your message has been successfully submitted and would be delivered to recipients shortly.