Hi tc,
thanks for your answer.
The situation is so: Our scheduler, written in java, need this field type because this field has microseconds. But, all tables are created under Smalltalk. So, I must find a Solution and is very simple. I have make a child class
AbtOracle8DatabaseManager subclass: #IfbAbtOracle8DatabaseManager
and overwritten the following class methode:
buildTypeDict
"Answer a newly constructed dictionary to map Oracle Internal datatypes returned by the
Oracle server to the appropriate Smalltalk field classes."
" AbtOracle8DatabaseManager
typeDict: nil;
typeDict: AbtOracle8DatabaseManager buildTypeDict. "
^( Dictionary new )
at: 1 put: AbtDatabaseVarCharField ; "VARCHAR2"
at: 2 put: IfbAbtOracle8DecimalField ; " Number "
at: 3 put: AbtDatabaseLongIntegerField ;
at: 4 put: AbtDatabaseDoubleFloatField ; " FLOAT"
at: 7 put: IfbAbtOracle8DecimalField ; " Number "
at: 8 put: AbtOracleLongField ; " LONG/LONG VARCHAR"
at: 9 put: AbtDatabaseVarCharField ; "VARCHAR"
at: 11 put: AbtDatabaseVarCharField ; "ROWID. These are treated as VARCHAR2 fields "
at: 12 put: IfbAbtOracleDateField ; "DATE"
at: 23 put: AbtOracleRawField ; "RAW"
at: 24 put: AbtOracleLongRawField ; " LONG RAW "
at: 96 put: AbtDatabaseFixedCharField ; "CHAR"
at: 187 put: IfbAbtOracleDateField;
" at: 105 put: AbtOracleMlsLabelField ; " " MLSLABEL "
" at: 111 put: AbtRefField;" " REF "
" at: 112 put: AbtCLOBField;" " CLOB "
" at: 113 put: abtBLOBField; " " BLOB"
yourself.
the bold marked code part is the TIMESTAMP field. We have under Smalltalk no problems, because the microseconds are trimmed in smalltalk and the tables for our Smalltalk parts and the tables for java parts are separated. Indeed, I must make two or three more changes, thats all. Although many thanks.
Best regards
Ralf
P.S. I hope, you can understand me, my english is not so good.