[DDLUTILS-260] getValueAsString do not work correctly with oracle number(1)

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.0
• Component/s: Core - Oracle
• Labels: bool getValueAsString number oracle
• Environment: oracle 9i
• Assignee: Thomas Dudziak
• Reporter: ddwcyl
• Created: 02/Jun/10 12:07
• Updated: 02/Jun/10 12:07

Description

i use ddlutil to get insertSql for some tables .when the column type is number(1),SqlBulder.getValueAsString return's value is "ture",otherwise myvalue is "1",
it seems ddlutil think number(1) is bool. an other's issue is getValueAsString return's value is '123' when my value is 123.
i try fixed it in Oracle8Builder override getValueAsString,the code is
@Override
protected String getValueAsString(Column column, Object value) {
String result;
if (value == null)

{ return "NULL"; }

switch(column.getTypeCode())
{
//number(1) type
case Types.BIT:
if("true".equals(value.toString()))

{result = "1";}

else

{result="0";}

break;
case Types.INTEGER:
result = escapeStringValue(value.toString());
break;
case Types.NUMERIC:
result = escapeStringValue(value.toString());
break;
default:
result = super.getValueAsString(column, value);
}
return result;
}