Josh Jacob - 2009-02-10

Seeing this message going into MySQL:

-----
Incorrect decimal value: '' for column 'ROOM_USE_TYPE_ID' at row 1
-----

with this XML from Oracle:

-----
<dbtable name="customizable_type"  dbschema="GUIDE">
<tableinfo>
    <colinfo name="ID" type="NUMBER"  sqltype="2"  scale="0"  precision="38"  isNull="false" isPrimary="false"></colinfo>
    <colinfo name="NAME" type="VARCHAR2"  sqltype="12"  scale="0"  precision="50"  isNull="false" isPrimary="false"></colinfo>
    <colinfo name="CUSTOMIZER_USER_ID" type="NUMBER"  sqltype="2"  scale="0"  precision="38"  isNull="true" isPrimary="false"></colinfo>
    <colinfo name="SORT_ORDER" type="NUMBER"  sqltype="2"  scale="0"  precision="38"  isNull="false" isPrimary="false"></colinfo>
    <colinfo name="CLASS_TYPE" type="VARCHAR2"  sqltype="12"  scale="0"  precision="50"  isNull="false" isPrimary="false"></colinfo>
    <colinfo name="ROOM_USE_TYPE_ID" type="NUMBER"  sqltype="2"  scale="0"  precision="38"  isNull="true" isPrimary="false"></colinfo>
    <colinfo name="IS_DEFAULT" type="CHAR"  sqltype="1"  scale="0"  precision="1"  isNull="false" isPrimary="false"></colinfo>
    <colinfo name="IS_SHOW" type="CHAR"  sqltype="1"  scale="0"  precision="1"  isNull="false" isPrimary="false"></colinfo>
</tableinfo>
<rowset>
<row>
<column name="ID">123</column>
<column name="NAME">Test</column>
<column name="CUSTOMIZER_USER_ID">65</column>
<column name="SORT_ORDER">0</column>
<column name="CLASS_TYPE">RoomUse</column>
<column name="ROOM_USE_TYPE_ID" isnull="true">0</column>
<column name="IS_DEFAULT">0</column>
<column name="IS_SHOW">1</column>
</row>
-----

Not sure why it's either treating the number like a string or not recognizing the null value. Any suggestions on what to look at?

Thanks!