1 2 3 Previous Next 33 Replies Latest reply on Feb 26, 2013 5:37 PM by dvohra21 Go to original post
      • 30. Re: jDeveloper: Database Type --> Java Type
        Tested with PostgreSQL database and Oracle Database.

        Create same table in both databases.
        CREATE TABLE test(id integer NOT NULL);

        Select File|New. In New select Business Tier|EJB. Select Entities from Tables.Click on OK. In Persistence Unit click on Next. A persistence unit is not required to be created.In Type of Connection select Online Database Connection. In Database Connection Details click on Create a new database connection link.For Connection Type select Oracle (JDBC) for Oracle Database. A Connection Type for PostgreSQL is not available. Select Generic JDBC for PostgreSQL. Specify the other connection parameters. In Select Tables select the test table. In Specify Entity Details the field type is java.lang.Object for PostgreSQL and java.math.BigDecimal for Oracle database. The field type is not editable. Because PostgreSQL Connection Type is not provided and Generic JDBC is used the field mapping is not specific to the PostgreSQL database but a generic mapping to java.lang.Object is used.

        Edited by: dvohra16 on Feb 26, 2013 8:49 AM
        • 31. Re: jDeveloper: Database Type --> Java Type
          PostgreSQL JDBC is not supported for Entity mapping. Use one of the supported databases:
          Oracle, MySQL, SQLServer, DB2.
          • 32. Re: jDeveloper: Database Type --> Java Type
            Hm.. Is there any other way? Like Modules or something else special for postgresql?

            Or which alternative database would you suggest?
            • 33. Re: jDeveloper: Database Type --> Java Type
              Open source MySQL would be a suitable alternative to open source PostgreSQL.
              1 2 3 Previous Next