Skip to content

Some issues with the Hibernate example #94

@lukaseder

Description

@lukaseder

I'm currently translating some of the Java/Hibernate examples to jOOQ and found a few issues that you may or may not want to address:

CustomerService::deleteCustomer fails when orders have OrderProduct entries:

This query here:

Query deleteReferencing = session.createQuery("delete from Order where customer_id = :id");

Will fail in case there are entries in order_products, which does not have ON DELETE CASCADE clauses on its foreign keys by default (I think). I'm not sure if this is desired here.

OrderService::deleteOrder fails because of wrong query:

This query here:

Query deleteReferencing = session.createQuery("delete from Order where order_id = :id");

Will fail because the Order entity doesn't have an order_id column. I think the intention here was to delete the record in order_products

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions