Uploaded image for project: 'JBoss Enterprise Application Platform 4 and 5'
  1. JBoss Enterprise Application Platform 4 and 5
  2. JBPAPP-178

Update standardjbosscmp-jdbc.xml to have type-mappings for all databases certified with the platform edition

    XMLWordPrintable

Details

    • Task
    • Resolution: Done
    • Major
    • 4.2.RC5
    • 4.2.RC5
    • System
    • None

    Description

      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

      Attachments

        Activity

          People

            olubyans@redhat.com Alexey Loubyansky
            rrajasek@redhat.com Rajesh Rajasekaran
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: