Major 1.) Oracle 9i uses <type-mapping> <name>Oracle9i</name>
<!--
| Make sure that you have the Oracle 9i version of classes12.jar |
| or you will suffer --> The above comment should be updated. As part of our certification we have used the latest Oracle10g version of ojdbc14.jar as we had some failures with the Oracle 9i version of classes12.jar when running the cts with Oracle9i. |
2.) Oracle 10g, I used <type-mapping> <name>Oracle9i</name>
and didnt have any problems.
Still we should have a separate <type-mapping> <name>Oracle10g</name>
Or have a common <type-mapping> <name>Oracle</name> for all versions of oracle
3.) MS SQLServer 2005, I used <type-mapping><name>MS SQLSERVER2000</name>
and didnt have any problems
We should have a separate <type-mapping><name>MS SQLSERVER2005</name>
or a common one for all versions of MS SQLSERVER
4.) DB2 7.2 & 8.0 uses <type-mapping><name>DB2</name>
Looks fine.
5.) Sybase 12.5, I used <type-mapping><name>Sybase</name>
Looks fine
6.) Mysql 5.0, I used <type-mapping><name>mySQL</name>
Looks fine
7.) Postgresql 8.1, I used <type-mapping><name>PostgreSQL 8.0</name>
and didnt have any problems
We should have a separate one for <type-mapping><name>PostgreSQL 8.1</name>
Or a common on for all versions of postgresql
