I can not generate Hibernate Mapping Files and POJOs from Database PostgreSQL?

Question

have created my tables and relationships in the database PostgreSQL, but when I want to generate Hibernate Mapping Files and POJOs, they are not generated

I applied all the appropriate steps to hibernate.cfg.xml generation and hibernate.reveng.xml

I think it's because the name tables and fields that I have in all uppercase, because I tested with another BD with the names of the tables in lower case and if it works normally, I show the script of my tables.

CREATE TABLE "public"."T_LNEA"(
 "ID_LNEA" Integer NOT NULL,
 "ID_CTGRIA" Integer NOT NULL,
 "DSCRPCION" Character varying(200)
)
WITH (OIDS=FALSE)
;

ALTER TABLE "public"."T_LNEA" ADD CONSTRAINT "PK_ID_LNEA" PRIMARY KEY ("ID_LNEA")
;

CREATE TABLE "public"."T_SUB_LNEA"(
 "ID_SUB_LNEA" Integer NOT NULL,
 "ID_LNEA" Integer NOT NULL,
 "DSCRPCION" Character varying(200)
)
WITH (OIDS=FALSE)
;

-- Add keys for table public.T_SUB_LNEA

ALTER TABLE "public"."T_SUB_LNEA" ADD CONSTRAINT "PK_ID_SUB_LNEA" PRIMARY KEY ("ID_SUB_LNEA")
;

CREATE TABLE "public"."T_CTGRIA"(
 "ID_CTGRIA" Integer NOT NULL,
 "DSCRPCION" Character varying(200)
)
WITH (OIDS=FALSE)
;

ALTER TABLE "public"."T_CTGRIA" ADD CONSTRAINT "PK_ID_CRITERIA" PRIMARY KEY ("ID_CTGRIA")
;

And an image that is loading the tables using the JBOS Tools.

enter image description here

But still I need support because I can not generate the POJOs.

Tony Gomez · Accepted Answer · 2016-04-18 00:06:40Z

4

In the File "hibernate.reveng.xml" has the following

  <schema-selection match-catalog="mybd" match-schema="mybd"/>

You have to delete the match-schema="mybd".

By default, when you use postgresql in hibernate, appears the match- schema , which does not happen in mysql , delete it and work , checked in Netbeans8.0

answered Apr 18, 2016 at 0:06

Tony Gomez

412 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Junior Hernando Huaman Flores · Accepted Answer · 2014-01-26 17:05:14Z

1

Hi, as said before, if I change the name of the table and its fields in lowercase, if generates POJOs, the question is why is not generated in capital letters .....

answered Jan 26, 2014 at 17:05

Junior Hernando Huaman Flores

1221 gold badge5 silver badges14 bronze badges

1 Comment

Hassen Ch. Over a year ago

MySQL has a problem with capital letters, it always causes errors

user2974805 · Accepted Answer · 2014-01-30 02:53:19Z

0

You solve it somehow does not recognize the table name in uppercase, but if you recognize the attributes of the table in uppercase, so rename the tables in lowercase temporarily after he change in the EJB annotations, at least it works somehow.

answered Jan 30, 2014 at 2:53

user2974805

331 silver badge7 bronze badges

Comments

mickmackusa · Accepted Answer · 2025-08-20 23:17:57Z

0

Une the reverse engineering tools provided by Hibernate. It depends on your IDE. For example with NetBeans this is how it is done: https://netbeans.apache.org/tutorial/main/kb/docs/web/hibernate-webapp/

edited Aug 20 at 23:17

mickmackusa♦

49.2k13 gold badges98 silver badges165 bronze badges

answered Jan 26, 2014 at 7:00

Hassen Ch.

1,8331 gold badge21 silver badges32 bronze badges

Collectives™ on Stack Overflow

I can not generate Hibernate Mapping Files and POJOs from Database PostgreSQL?

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related