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!
Log in to post a comment.
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!