This discussion is archived
1 2 3 Previous Next 33 Replies Latest reply: Feb 26, 2013 9:37 AM by dvohra21 Go to original post RSS
  • 30. Re: jDeveloper: Database Type --> Java Type
    dvohra21 Oracle ACE
    Currently Being Moderated
    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
    dvohra21 Oracle ACE
    Currently Being Moderated
    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
    DanielFFM Newbie
    Currently Being Moderated
    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
    dvohra21 Oracle ACE
    Currently Being Moderated
    Open source MySQL would be a suitable alternative to open source PostgreSQL.
1 2 3 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points