2 t   ! " # $% & ' ( )*+ , - . /01  23 4 56 7 89 2:;<= > ?@AB $C $DEFG ?H I JK 2L M 2N OP 2QR ST 8U V W XYZ [\ $. ]^_ `ab F> Fc $de J> Jf $ghi Nj ]klmn R>o 2p qr st suv [w [xyz{|}~  $>    log Lorg/apache/commons/logging/Log; HSQL_ADAPTERLjava/lang/String; ConstantValueORACLE_ADAPTERPOSTGRES_ADAPTERCOMMASPACEINSERT LEFTPARENTH RIGHTPARENTH SEMICOLON DOUBLEQUOTE SINGLEQUOTEVALUESNULL UNDERSCORETO_DATE_FUNCTIONXML_SCHEMA_DATATYPESDEFAULT_TABLE_NAME_MAX_LENGTHI()VCodeLineNumberTableLocalVariableTablethis9Lorg/ecoinformatics/datamanager/database/DatabaseAdapter;getTableNameMaxLength()IgetLegalDBTableName&(Ljava/lang/String;)Ljava/lang/String;entityNameLengthlegalNameLengthifirstCharacterC entityNametableNameMaxLength legalNamebadChars[CgoodChar StackMapTable6assignDbFieldNames8(Lorg/ecoinformatics/datamanager/parser/AttributeList;)V mangledName attribute1Lorg/ecoinformatics/datamanager/parser/Attribute; attributeNamelegalDbFieldName foundName quotedName attributeList5Lorg/ecoinformatics/datamanager/parser/AttributeList;list2[Lorg/ecoinformatics/datamanager/parser/Attribute; usedNamesLjava/util/TreeMap;sizeLocalVariableTypeTable9Ljava/util/TreeMap;!1 generateDDL[(Lorg/ecoinformatics/datamanager/parser/AttributeList;Ljava/lang/String;)Ljava/lang/String; tableName ddlString ExceptionsgenerateDropTableSQL sqlStringgenerateInsertSQLm(Lorg/ecoinformatics/datamanager/parser/AttributeList;Ljava/lang/String;Ljava/util/Vector;)Ljava/lang/String; formatStringfloatObjLjava/lang/Float;floatNumF integerObjLjava/lang/Integer; integerNumeLjava/lang/Exception;dataTypeobjLjava/lang/Object;value missingValues[Ljava/lang/String;isMissingValueZname attributeTypedomain.Lorg/ecoinformatics/datamanager/parser/Domain; oneRowDataLjava/util/Vector;NULLValueCounterhasValueCountersqlAttributePartLjava/lang/StringBuffer; sqlDataPartfirstAttributeBhgetAttributeTypeE(Lorg/ecoinformatics/datamanager/parser/Attribute;)Ljava/lang/String;getAttributeTypeFromStorageTypeW(Lorg/ecoinformatics/datamanager/parser/Attribute;Ljava/lang/String;)Ljava/lang/String; typeSystem textValue storageType3Lorg/ecoinformatics/datamanager/parser/StorageType; storageTypesLjava/util/ArrayList; classNameJLjava/util/ArrayList;vgetCountingRowNumberSQLgetDataTypeMap()Ljava/util/Map;typeMapLjava/util/Map;getLegalDbFieldName((Ljava/lang/String;[Ljava/lang/String;)Z missValue missValuesmangleFieldName originalName stringBuffer mapDataTypeparseAttributeListI(Lorg/ecoinformatics/datamanager/parser/AttributeList;)Ljava/lang/String; fieldName dbDataType attributeSqltransformDatetimedatetimeStringtransformFormatStringemlFormatStringtransformSelectionSQLANSISQLescapeSpecialCharacterInDataspecialdata specialArrayescape SourceFileDatabaseAdapter.java  to_timestamp x*http://www.w3.org/2001/XMLSchema-datatypes x7org/ecoinformatics/datamanager/database/DatabaseAdapter      java/lang/StringBuilder_   java/util/TreeMap   java/lang/String  " java/sql/SQLExceptionEThe attribute list is null and couldn't generate insert sql statement  >The the data is null and couldn't generte insert sql statementjava/lang/StringBuffer INSERT INTO  (AThe attributes is null and couldn't generate insert sql statement   (Attribute list contains a null attribute    , datetime 4org/ecoinformatics/datamanager/parser/DateTimeDomain    ') uvdatetime value expression=  string FLOATjava/lang/Float  java/lang/Integer  java/lang/Exception!Error determining numeric value:  Horg/ecoinformatics/datamanager/database/DataNotMatchingMetadataException Data value '$' is NOT the expected data type of ';    1org/ecoinformatics/datamanager/parser/StorageType  intlongshortintegerfloatdoublerealdatenaturalwhole _Prime'No attribute definition found in entity Attribute Name: DB Field Name : dbDataType :    java/lang/Object HSQLAdapter OracleAdapterPostgresAdapternull3org/ecoinformatics/datamanager/parser/AttributeList/org/ecoinformatics/datamanager/parser/Attribute,org/ecoinformatics/datamanager/parser/Domainjava/util/Vectorjava/util/ArrayListjava/util/Iteratorlengthjava/lang/Mathmin(II)I substring(II)Ljava/lang/String;replace(CC)Ljava/lang/String;charAt(I)Cjava/lang/CharacterisDigit(C)Zappend-(Ljava/lang/String;)Ljava/lang/StringBuilder;toString()Ljava/lang/String; getAttributes4()[Lorg/ecoinformatics/datamanager/parser/Attribute;getNameget&(Ljava/lang/Object;)Ljava/lang/Object;put8(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object;setDBFieldName(Ljava/lang/String;)VisEmpty()Z,(Ljava/lang/String;)Ljava/lang/StringBuffer; elementAt(I)Ljava/lang/Object;trimequals(Ljava/lang/Object;)ZgetMissingValueCode()[Ljava/lang/String;getDBFieldName getDomain0()Lorg/ecoinformatics/datamanager/parser/Domain;equalsIgnoreCase(Ljava/lang/String;)ZgetFormatStringorg/apache/commons/logging/Logdebug(Ljava/lang/Object;)V floatValue()F(F)Ljava/lang/StringBuffer;intValue(I)Ljava/lang/StringBuffer; getMessageerrorgetStorageTypeArray()Ljava/util/ArrayList;iterator()Ljava/util/Iterator;hasNextnext()Ljava/lang/Object; getTextValue getTypeSystem toLowerCasecontains(Ljava/lang/CharSequence;)Z replaceAll8(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String;%org/apache/commons/logging/LogFactorygetLog3(Ljava/lang/Class;)Lorg/apache/commons/logging/Log;!t uvwxyz{xy|}xy~xy4xy(xy&xy)xy>xyVxyxy=xy*xyxyxxyyC***6S T  d u<M Y UY-UY.UY/UY,UY(UY)UYUN_6**6 6* M,A6-,-4 M, 6 Y,M,Buvw;x?zC{I|Q}Y]grx\ IQ`xx;b?^Y" +MYN,66s,2::*:-:  *:  :-: -WY:  J !(0;@HLWZc~z Hx !d(]x0Ux;Jx ~x w {  M& 0QN- *xxGM,  xx+:66+ Y !- -" Y#!$Y%:$Y%:&'W('W,'W)'W('W*'W('W)'W+:   Y+! 6 6 6    - ,: :  :-.  2: Y/!0:*162:*3: 4'W4'W'W5:6789:*::*;:*<:*'W)'W='W'W='W4'W='W'W='W>'W?Y@ABC.)*<:='W'W='W*D:E. FYG:H8IWJYK:L6MWO:?YOPQRYYST=U6  >'W>'WV'WA'WA:UXN~_ ",5>FNU]emu}   !"#%' (*+",*/2096C7M:U=]?e@oAwCDEGIJKMNOPTUVWXY `cd)e0f8g;iFjMkUuXnZokptoyqvy }~Mx)0FMZJx x xx9q xx 5>j P M  a #/.BK  RW "N++W:X:YZ[:\:.]:..zC7 CNh^7!_7`7 a7 aN:b7 c7 dN e7 67 6NCN-a7567+f7!C7d7 g7 hN-" ).5DKZdnt RKx5x) """x x  ) `';<L+ R+MY UY-UY.UY/UY:UY@UY[UY]UN_66-,-4 M,15 ? J P >8RRxPx1!584>,/++,66,2:+.> *  ') ,2$Hx!$44x42 [$Y+iM,j'W,A1 35 x   E +M$Y%N,, Yk!*+l,666,2: Y/!:2: *3: * D:  -4'W- 'W-('W- 'W6?YmB?Yn B?Yo pBF-AjIJ LN U%W)Y,[6\<^A`KeRfYgahipnqut|uvwyz{[~z <RxY x ax i} x /  ),R ) v6+x6+xGM,  xxRY=SM=N++,662,2:+q+Y-rL+.   !'0JPH'#x6RRx H Ex;/! s?<