0 Replies Latest reply on Feb 22, 2002 6:57 AM by wimflam

    Problems with JBoss + Postgres + OIDs

    wimflam

      Some of you may have experienced problems with using OIDs in CMP with a Postgres 7.x database.

      It is possible to store binary objects, without too much trouble, but you will get an exception when you try to retrieve the object.

      The cause of the problem is the types that the postgres drivers are returning in the meta-data for OIDs.
      The same problem exists in Turbine, and more info can be found here:

      http://jakarta.apache.org/turbine/turbine-2/howto/postgres-howto.html

      In order to fix the problem for JBoss, you will need to patch the JDBC driver in the same way as described in the above page.

      Hope this info will save someone some work.