Brilliant...thanks a million
Alex
Guy Rouillier wrote:
On 2/11/2010 4:58 AM, A Bosetti wrote:
The external database is provided by the customers and is made up of
several tables (about 20) and it comes in two different formats (both
formats are on Oracle), one that uses timestamps and the other one that
uses a string representation of datetime. (Oracle 7 didnt have
timestamps apparently)
Oracle 7??? That version of Oracle was released in 1992, and Oracle
ended support in 2000! That was 10 years ago. I'd suggest your
company not attempt to deal with databases 10 years past their
end-of-life.
One idea is to obtain the Oracle version early in your program. Pass
that version as a parameter to your SQL, and use an <if> condition to
do different things on the 3 columns that differ. I imagine your
options are extremely limited for Oracle 7, which means that
"timestamp as a string" will have to be your least common
denominator. So in the more recent version, do a to_char to convert
the timestamp into the same string format used by Oracle 7. Then your
output column type is always string, and you can map it to your POJO
field.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org
For additional commands, e-mail: user-java-h...@ibatis.apache.org
