[
https://issues.apache.org/jira/browse/OPENJPA-510?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tim McConnell reassigned OPENJPA-510:
-------------------------------------
Assignee: Tim McConnell
> ReverseMappingTool generates incorrect SQL for PostgreSQL if -fk = true
> -----------------------------------------------------------------------
>
> Key: OPENJPA-510
> URL: https://issues.apache.org/jira/browse/OPENJPA-510
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc
> Affects Versions: 1.1.0
> Environment: PostgreSQL
> Reporter: Michael Dick
> Assignee: Tim McConnell
>
> Opening on behalf of Tim Holloway per email to the OpenJPA mailing list.
> Synopsis: Invalid code is generated when internally-generated foreign
> key names are used and the ReverseMappingTool is run with the "-fk"
> option set to true.
> Description: If a constraint name is not explicitly defined, PostgreSQL
> v7 synthesizes constraint names in the form "$n", where n is numeric,
> viz:
> Table "public.bus_stops"
> Column | Type | Modifiers
> -------------------+-----------------------+------------------------
> stop_id | integer | not null
> street1_name | character varying(32) | not null
> street1_qualifier | character varying(11) |
> street1_block | integer |
> street2_name | character varying(32) |
> street2_qualifier | character varying(11) |
> street2_block | integer |
> longitude | numeric(16,8) | not null default 0.0
> latitude | numeric(16,8) | not null default 0.0
> elevation | numeric(16,8) | not null default 0.0
> description | text |
> sheltered | boolean | not null default false
> inbound | boolean | not null
> street1_type | character varying(8) | not null
> street2_type | character varying(8) | not null
> street1_direction | character varying(5) | not null
> street2_direction | character varying(5) | not null
> Indexes:
> "stop2_pkey" primary key, btree (stop_id)
> Foreign-key constraints:
> "$1" FOREIGN KEY (street1_direction) REFERENCES
> lk_street_directions(street_direction_id)
> "$2" FOREIGN KEY (street2_direction) REFERENCES
> lk_street_directions(street_direction_id)
> "fk_bus_stops_street1_type" FOREIGN KEY (street1_type) REFERENCES
> lk_street_types(street_type_id)
> "fk_bus_stops_street2_type" FOREIGN KEY (street2_type) REFERENCES
> lk_street_types(street_type_id)
> Consequences: Note the generated code for synthesized and explicit
> constraint names:
> /**
> * Auto-generated by:
> * org.apache.openjpa.jdbc.meta.ReverseMappingTool
> $AnnotatedCodeGenerator
> */
> @Entity
> @Table(schema="public", name="bus_stops")
> public class BusStops {
> @ManyToOne(fetch=FetchType.LAZY, cascade=CascadeType.MERGE)
> @JoinColumn(name="street1_direction", nullable=false)
> private LkStreetDirections 1; //<==== WRONG
> @OneToMany(targetEntity=com.mousetech.jta.persist.TripStops.class,
> mappedBy="1", cascade=CascadeType.MERGE)
> //VVVVV WRONG VVVV
> private Set<TripStops> 1Inverses = new HashSet<TripStops>();
> @ManyToOne(fetch=FetchType.LAZY, cascade=CascadeType.MERGE)
> @JoinColumn(name="street2_direction", nullable=false)
> private LkStreetDirections 2; //<==== WRONG
> @OneToMany(targetEntity=com.mousetech.jta.persist.RouteStops.class,
> mappedBy="2", cascade=CascadeType.MERGE)
> //VVVVV WRONG VVVV
> private Set<RouteStops> 22Inverses = new HashSet<RouteStops>();
> @Basic
> @Column(columnDefinition="text", length=2147483647)
> private String description;
> @Basic
> private double elevation;
> @ManyToOne(fetch=FetchType.LAZY, cascade=CascadeType.MERGE)
> @JoinColumn(name="street1_type", nullable=false)
> private LkStreetTypes fkBusStopsStreet1Type; //<==== CORRECT
> @ManyToOne(fetch=FetchType.LAZY, cascade=CascadeType.MERGE)
> @JoinColumn(name="street2_type", nullable=false)
> private LkStreetTypes fkBusStopsStreet2Type; //<==== CORRECT
> (remainder of code omitted as immaterial).
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
