SQL Hibernate JPA | Java Community | Help. Code. Learn. | Page 1

stone pulsar May 25, 2023, 1:06 PM

#

I'm having a bit of a problem, I am trying to gather adresses with the same date from my database.
I have the following code:

try {
            String queryString = "SELECT a FROM Adres a JOIN Order o ON a.klantID = o.klantID WHERE o.orderDatum = :orderDatumParam";

            Query query = session.createQuery(queryString);
            query.setParameter("orderDatumParam", dateTime);
            adressen = (ArrayList<Adres>) query.getResultList();
        }

Now I get the following error:
java.lang.IllegalArgumentException: org.hibernate.query.sqm.InterpretationException: Error interpreting query [SELECT a FROM Adres a JOIN Order o ON a.klantID = o.klantID WHERE o.orderDatum = :orderDatumParam]; this may indicate a semantic (user query) problem or a bug in the parser [SELECT a FROM Adres a JOIN Order o ON a.klantID = o.klantID WHERE o.orderDatum = :orderDatumParam]
I can't figure out for the life of me, how to make this work.

eternal copperBOT May 25, 2023, 1:06 PM

#

⌛ This post has been reserved for your question.

Hey @stone pulsar! Please use /close or the Close Post button above when you're finished. Please remember to follow the help guidelines. This post will be automatically closed after 300 minutes of inactivity.

TIP: Narrow down your issue to simple and precise questions to maximize the chance that others will reply in here.

stone pulsar May 25, 2023, 1:08 PM

#

orderDatumParam is being supplied by the method

eternal copperBOT May 25, 2023, 3:04 PM

#

<@&765578700724371486>

Requested by Rowin ツ#2022

gritty delta May 25, 2023, 3:10 PM

#

I am not an sql expert but shouldnt it be something like
SELECT a.columnName FROM Adres a
maybe it cannot differentiate the a's otherwise?

stone pulsar May 25, 2023, 3:11 PM

#

Ive tried that too,

#

though I have found there was another problem that might be underlining this

#

Could not resolve entity reference : Order

#

Though I have literally checked everything inside my database and my persistance entity

#

#

gritty delta May 25, 2023, 3:13 PM

#

shouldnt it be JOIN Orders

stone pulsar May 25, 2023, 3:13 PM

#

#

#

It works with Klant and Adres when I simply use just the single

gritty delta May 25, 2023, 3:14 PM

#

Did you connect the ide to your db so it can resolve this?

stone pulsar May 25, 2023, 3:15 PM

#

I have

#

screenshot from the database table is from inside the db

#

            adressen = (ArrayList<Adres>) session.createQuery("SELECT a FROM Adres a").getResultList();

#

This is for example a query to simply get all the adresses

#

Which works perfectly fine

#

But once I'm trying to compare other values with different tables and columns I cant get it to work.

#

Ive had some fair amount of experience with SQL with C# and Linq

#

But in Java i just, cant lol

gritty delta May 25, 2023, 3:17 PM

#

I see, then it might be a plain sql query syntax problem, I am not good at those 😄

stone pulsar May 25, 2023, 3:17 PM

#

Bummer,

#

well thanks for trying anyway.

eternal copperBOT May 25, 2023, 3:17 PM

#

stone pulsar well thanks for trying anyway.

If you are finished with your post, please close it.
If you are not, please ignore this message.
Note that you will not be able to send further messages here after this post have been closed but you will be able to create new posts.

stone pulsar May 25, 2023, 3:17 PM

#

Hopefully someone else does

gritty delta May 25, 2023, 3:18 PM

#

but if you have JPA Repositories you could just do something similar just with the repo methods, no?

stone pulsar May 25, 2023, 3:18 PM

#

Im not sure what you mean exactly

gritty delta May 25, 2023, 3:18 PM

#

ok, give me a minute

#

What parameters do you use for the search? Date and klantID?

#

or do you want to get all adresses that have a order date in common?

stone pulsar May 25, 2023, 3:21 PM

#

Correct

#

the latter

gritty delta May 25, 2023, 3:21 PM

#

So the date is a param from what I see that you provide?

stone pulsar May 25, 2023, 3:22 PM

#

Yes

gritty delta May 25, 2023, 3:25 PM

#

in JPA Repos you can define your own methods like
findById - this one is default

But JPA lets you define your own in an interface that extends from the JPA Repo
then you could do something like

Adress findByDate(Date date)
for this to work there has to be a field named date or what ever in Adress

#

Do you get the idea?

#

https://www.baeldung.com/spring-data-derived-queries

Baeldung

Derived Query Methods in Spring Data JPA Repositories | Baeldung

Explore the query derivation mechanism in Spring Data JPA.

fossil inlet May 25, 2023, 3:26 PM

#

gritty delta in JPA Repos you can define your own methods like findById - this one is default...

Are we in Spring?

gritty delta May 25, 2023, 3:27 PM

#

yeah, does this not work for you?

stone pulsar May 25, 2023, 3:27 PM

#

Im honestly not sure if im in Spring

#

Ive created a project with just Hibernate and JPA

fossil inlet May 25, 2023, 3:27 PM

#

Just use the JPA repository finaction as so
findOneByOrderId

#

Oh we're in just Hibernate and JPA

#

Thats... a bigger issue

stone pulsar May 25, 2023, 3:28 PM

#

Could I somehow just add the Spring package?

#

Or would this cause too much problems

gritty delta May 25, 2023, 3:29 PM

#

hmm not sure

fossil inlet May 25, 2023, 3:29 PM

#

Would cause too many problems

stone pulsar May 25, 2023, 3:29 PM

#

Bummer

fossil inlet May 25, 2023, 3:29 PM

#

Have you tried using Select * instead of Select a?

stone pulsar May 25, 2023, 3:29 PM

#

fossil inlet May 25, 2023, 3:30 PM

#

Hmm

stone pulsar May 25, 2023, 3:30 PM

#

The docs on JPA and Hibernate didnt imply I also had to use Spring

#

afaik

fossil inlet May 25, 2023, 3:30 PM

#

You don't, it's just the most common way people get Hibernate into their projects

stone pulsar May 25, 2023, 3:31 PM

#

I see

#

Though as I mentioned before,

#

it might also be a problem regarding the Order entity

fossil inlet May 25, 2023, 3:34 PM

#

stone pulsar

Haha! You just got it as well

#

Yeah you need to define an association between the entities

stone pulsar May 25, 2023, 3:34 PM

#

@Table(name = "Orders")
@Entity
public class Order {
    @Id
    private int orderID;
    @ManyToOne
    @JoinColumn(name = "klantID")
    private Klant klant;
    private Date orderDatum;
    private Date afleverDatum;
    private int isAfgeleverd;

}

#

This is what I got now

fossil inlet May 25, 2023, 3:35 PM

#

That should work, what happens if you try and run the query?

stone pulsar May 25, 2023, 3:36 PM

#

with these changes i got this in my query

#

fossil inlet May 25, 2023, 3:36 PM

#

Yep, you no longer need to define the on portion of the Join IIRC

#

The entity defines the join criteria itself.

gritty delta May 25, 2023, 3:37 PM

#

just klant should be used now, no?

stone pulsar May 25, 2023, 3:38 PM

#

            String queryString = "SELECT a FROM Adres a JOIN Order o ON Klant = Klant WHERE o.orderDatum = :orderDatumParam";

#

Like this?

fossil inlet May 25, 2023, 3:38 PM

#

Just remove the ON portion

#

So SELECT a FROM Adres a JOIN Order o WHERE o.orderDatam = :orderDatumParam

stone pulsar May 25, 2023, 3:39 PM

#

#

still seems to have problems with Order too

fossil inlet May 25, 2023, 3:40 PM

#

What does Adres look like?

stone pulsar May 25, 2023, 3:40 PM

#

NotLikeThis

#

#

Ah wait

fossil inlet May 25, 2023, 3:40 PM

#

In general you should avoid thinking about your Entities in Terms of SQL. They are the abstraction layer for it. Likewise our Query string isn't actually Raw SQL, but a HSQL String. So we're trying to navigate the relationship from the Object side

#

I mean the Adres.java

stone pulsar May 25, 2023, 3:40 PM

#

yeah I believe i still have to add the Foreign key stuff there as well

fossil inlet May 25, 2023, 3:40 PM

#

Yep

stone pulsar May 25, 2023, 3:41 PM

#

Though its weird because I can just grab the Adres alone

#

Or does it not care about the keys in that instance

fossil inlet May 25, 2023, 3:41 PM

#

Relationships in Hibernate are directional, so if you define a relationship on Order pointing to Adres, that doesn't mean you can instantly go from Adres to Order

#

Likewise Hibernate doesn't check the Database Schema (normally) so it doesn't see that Adres has a FK to Order (Assuming it does)

stone pulsar May 25, 2023, 3:42 PM

#

I see,

#

well this is a bit of unfortunate timing, but I still have some errors and Ive got to eat dinner.

#

So I'll be back in a few minutes im sorry

fossil inlet May 25, 2023, 3:44 PM

#

No worries, I'll be back in 45 minutes myself, since I have a 1:1 meeting in 15

stone pulsar May 25, 2023, 3:45 PM

#

Then it might be perfect timing 😅

stone pulsar May 25, 2023, 4:25 PM

#

i am back

fossil inlet May 25, 2023, 4:26 PM

#

I am not

stone pulsar May 25, 2023, 4:26 PM

#

The errors remain the same as the ones before

fossil inlet May 25, 2023, 4:26 PM

#

Did you add the Relationship in the Address

stone pulsar May 25, 2023, 4:27 PM

#

@Entity
@Table(name = "Adressen")
public class Adres {
    @Id
    private int adresID;
    @ManyToOne
    @JoinColumn(name = "klantID")
    private Klant klant;
    private String postcode;
    private String straatnaam;
    private String huisnummer;
    private String plaats;
    private String routeID;

fossil inlet May 25, 2023, 4:27 PM

#

And our Query String?

stone pulsar May 25, 2023, 4:27 PM

#

            String queryString = "SELECT a FROM Adres a JOIN Order o WHERE o.orderDatum = :orderDatumParam";

fossil inlet May 25, 2023, 4:27 PM

#

And the exception?

stone pulsar May 25, 2023, 4:28 PM

#

Error interpreting query [SELECT a FROM Adres a JOIN Order o WHERE o.orderDatum = :orderDatumParam];

#

Could not resolve entity reference : Order

fossil inlet May 25, 2023, 4:28 PM

#

Yes, Address doesn't have a reference to the Order

#

So you need to add that relationship

#

Or maybe, what does Klant look like?

stone pulsar May 25, 2023, 4:30 PM

#

@Entity
@Table(name = "Klanten")
public class Klant {
    @Id
    private int klantID;
    private String voornaam;
    private String achternaam;
    private String tussenvoegsel;
}

fossil inlet May 25, 2023, 4:30 PM

#

And so Adres really related to Order by going through Klant right?

stone pulsar May 25, 2023, 4:31 PM

#

Order is the connection between Adres and Klant

#

Adres will alway have a klant

#

but not always have a Order

#

Ill see if i can find our ERD real quick

fossil inlet May 25, 2023, 4:32 PM

#

So Klant is missing a relationship to Order and Address in its entity

#

Are you using IntelliJ Ultimate?

stone pulsar May 25, 2023, 4:33 PM

#

#

Its not fully up-to-date I just realised

stone pulsar May 25, 2023, 4:34 PM

#

fossil inlet Are you using IntelliJ Ultimate?

Not that Iam aware of

fossil inlet May 25, 2023, 4:35 PM

#

stone pulsar Not that Iam aware of

No worries, I just know that IntellliJ ultimate has a DB relationship generation thing

#

So we need to define the relationship of both in the Klant class as well

stone pulsar May 25, 2023, 4:36 PM

#

Is there something that ignores the actual relationship inside the DB for that? I know in EF C# there is such thing

#

I cant quite change the structure of the database

#

at least, not now.

#

Cant quite put my finger on what it was called again

fossil inlet May 25, 2023, 4:37 PM

#

Don't need to edit the database

stone pulsar May 25, 2023, 4:38 PM

#

Alright,

#

How would I go about that 😅

#

Head is in a bit of a twist now

fossil inlet May 25, 2023, 4:39 PM

#

With the Many-To-One, One-To-One, One-To-Many annotations

stone pulsar May 25, 2023, 4:40 PM

#

but both adres and order already have a relationship to klant no?

fossil inlet May 25, 2023, 4:40 PM

#

But Klant doesn't

stone pulsar May 25, 2023, 4:41 PM

#

Wont that mess up with the Entity if I'd add more variables?

fossil inlet May 25, 2023, 4:41 PM

#

Nope

#

As long as it's accurate

#

   String queryString = "SELECT a FROM Adres a JOIN Klant k JOIN Order o WHERE o.orderDatum = :orderDatumParam"

Since we're really doing

order.getKlant().getAdres()

After the SQL gets the Order

stone pulsar May 25, 2023, 4:45 PM

#

Ive done a bit of googline

#

but I dont think this is it

#

    @ManyToMany
    @JoinTable(
            name = "Klant_Adres",
            joinColumns = @JoinColumn(name = "klantID"),
            inverseJoinColumns = @JoinColumn(name = "adresID")
    )
    private ArrayList<Adres> adressen;
    @ManyToMany
    @JoinTable(
            name = "Klant_Order",
            joinColumns = @JoinColumn(name = "klantID"),
            inverseJoinColumns = @JoinColumn(name = "orderID")
    )
    private ArrayList<Order> orders;

fossil inlet May 25, 2023, 4:47 PM

#

Since you put ManyToOne on your Order/Adres, I'd assume Klant has a OneToMany to Order/Adres

#

Meaning one Klant has many orders, and many addresses

stone pulsar May 25, 2023, 4:47 PM

#

Klant only has an ID

#

@Entity
@Table(name = "Klanten")
public class Klant {
    @Id
    private int klantID;
    private String voornaam;
    private String achternaam;
    private String tussenvoegsel;
}

fossil inlet May 25, 2023, 4:51 PM

#

Think of the Join Table between Klant and Order, what does it look like?

klantID | orderID
1       | 2          // 1:1 if one and two cannot appear any more

1       | 3
1       | 4          // 1 to Many from Klant's Perspective

1       | 2
3       | 2          // Many to One from Klant's Perspective

1       | 2
1       | 3
2       | 3           // Many to Many

stone pulsar May 25, 2023, 4:51 PM

#

hmh

fossil inlet May 25, 2023, 4:53 PM

#

If you're going to use an ORM, it's also good to think about Data Modeling in terms of the Java Code.

If Order only can link to one Klant, and one Klant can link to a List of Orders, then @OneToMany on Klant, and @ManyToOne on Orders is correct.

stone pulsar May 25, 2023, 4:54 PM

#

A Klant can have multiple orderes but one adres

fossil inlet May 25, 2023, 4:54 PM

#

And Adres can only have one Klant? If so then it's a One to One for both of them

stone pulsar May 25, 2023, 4:55 PM

#

Yes

#

but there can be multiple orders on one adres

#

if that makes sense

fossil inlet May 25, 2023, 4:55 PM

#

Does Adres have a FK to Orders? Or is that through the FK to Klant with has the relationship to Orders?

stone pulsar May 25, 2023, 4:55 PM

#

different order, same adres, different delivery date

#

The latter

fossil inlet May 25, 2023, 5:00 PM

#

I'll remove some fields, but this is roughly what you want then.

// Adres.java
@Entity
@Table("adres)
class Adres {
   @Id
   private int adresId;
   @OneToOne(column = "klantID")
   private Klant klant;
}
// Klant.java
@Entity
@Table("klant")
class Klant {
   @Id
   private int klantId;
   @OneToOne(column = "klantID")
   private Adres adres;
   @OneToMany
   private List<Order> orders; // Use List in this context!!!
}
// Order.java
@Entity
@Table("order")
class Order {
   @Id
   private int orderId;
   @ManyToOne
   @JoinColumn(name = "klantID")
   private Klant klant
}

With the query String being

String queryString = "SELECT a FROM Adres a JOIN Klant k JOIN Order o WHERE o.orderDatum = :orderDatumParam"

#

Regarding the note about List, in general when dealing with Abstractions in Java, you want to return the lowest abstraction you care about, especially in a context where a library is doing lifting, we choose List instead of Collection in this context, just for clarity in that we're dealing with a List, likewise you could also say Set if you wanted the Java code to ensure uniqueness.

stone pulsar May 25, 2023, 5:05 PM

#

That OneToOne line doesnt seem to be recognized

#

   @OneToOne(column = "klantID")

fossil inlet May 25, 2023, 5:06 PM

#

Column name might be wrong, or not required, not entirely positive

#

The main thing was getting the relationships right.

stone pulsar May 25, 2023, 5:06 PM

#

It doesnt seem to have a problem with it being empty

#

Well theres still an error

#

but a different one

#

so thats a start

fossil inlet May 25, 2023, 5:06 PM

#

Ooo

stone pulsar May 25, 2023, 5:06 PM

#

Use of @OneToMany or @ManyToMany targeting an unmapped class: Klant.orders[Order]

fossil inlet May 25, 2023, 5:07 PM

#

Did you put the JoinColumn in Order?

stone pulsar May 25, 2023, 5:07 PM

#

that one was already there

#

Ive put it like youve shown

fossil inlet May 25, 2023, 5:09 PM

#

@OneToMany(mappedBy="klant") swap the One to Many in Klant for that

stone pulsar May 25, 2023, 5:10 PM

#

Unknown mappedBy in: Klant.adres, referenced property unknown: Adres.klantID

#

oh wait

#

I forgot to change the query

#

holdon

#

Unknown mappedBy in: Klant.adres, referenced property unknown: Adres.klantID

#

still

fossil inlet May 25, 2023, 5:14 PM

#

Is the column name correct?

stone pulsar May 25, 2023, 5:14 PM

#

in Klant?

fossil inlet May 25, 2023, 5:15 PM

#

Yes

#

Or is there additional connections that need to be made first?

stone pulsar May 25, 2023, 5:16 PM

#

    @OneToMany(mappedBy="klantID")
    private ArrayList<Order> orders;

fossil inlet May 25, 2023, 5:16 PM

#

Swap to List<Order>

#

And in the Database are there additional tables we need to traverse?

stone pulsar May 25, 2023, 5:17 PM

#

These are the only 3 tables

fossil inlet May 25, 2023, 5:17 PM

#

This table doesn't exist?

stone pulsar May 25, 2023, 5:18 PM

#

Thats Adressen

#

as I mentioned before, its not fully up to date

#

😅

#

Adressen holds Adres

#

Orders hold Order

#

Klanten holds Klant

fossil inlet May 25, 2023, 5:19 PM

#

What are the Columns for Klant and Adres again? Can you screenshot them?

stone pulsar May 25, 2023, 5:19 PM

#

#

#

Adres
Klant

fossil inlet May 25, 2023, 5:20 PM

#

Swap to @OneToOne(mappedBy = "adres") in Klant

#

Try that

stone pulsar May 25, 2023, 5:21 PM

#

Unknown mappedBy in: Klant.adres, referenced property unknown: Adres.klantIDD

#

oh wait

#

Changed the wrong one sorry

#

@Entity
@Table(name = "Klanten")
public class Klant {
    @Id
    private int klantID;
    @OneToOne(mappedBy = "adres")
    private Adres adres;
    @OneToMany(mappedBy="klantID")
    private List<Order> orders;
    private String voornaam;
    private String achternaam;
    private String tussenvoegsel;
}

#

Unknown mappedBy in: Klant.adres, referenced property unknown: Adres.adres

fossil inlet May 25, 2023, 5:23 PM

#

@OneToMany(mappedBy="klantID") should be @OneToMany(mappedBy="order")

#

Or wait

#

Maybe it's id?

#

It's probably just whatever you're calling the id column of the object.

stone pulsar May 25, 2023, 5:24 PM

#

Ill try that because it gave the same error

fossil inlet May 25, 2023, 5:24 PM

#

Mapping the relationships are really brutal in ORMs, but normally you do it once, and then don't touch it again.

stone pulsar May 25, 2023, 5:25 PM

#

Referenced property not a (One|Many)ToOne: Adres.adresID in mappedBy of Klant.adres

fossil inlet May 25, 2023, 5:25 PM

#

Swap back to klantID? It should be the name of the FK column

#

Sorry it's even harder when I don't have the schema in front of me kekw

stone pulsar May 25, 2023, 5:26 PM

#

Yeah no i understand lol

#

which one do you mean again

#

the OneToMany?

fossil inlet May 25, 2023, 5:27 PM

#

On both probably

#

And what is the current Query String?

stone pulsar May 25, 2023, 5:28 PM

#

public class Klant {
    @Id
    private int klantID;
    @OneToOne(mappedBy = "klantID")
    private Adres adres;
    @OneToMany(mappedBy= "klantID")
    private List<Order> orders;
    private String voornaam;
    private String achternaam;
    private String tussenvoegsel;
}

#

            String queryString = "SELECT a FROM Adres a JOIN Klant k JOIN Order o WHERE o.orderDatum = :orderDatumParam";

fossil inlet May 25, 2023, 5:30 PM

#

Looks good to me

#

Still getting that exception?

stone pulsar May 25, 2023, 5:30 PM

#

yup

#

Unknown mappedBy in: Klant.adres, referenced property unknown: Adres.klantID

fossil inlet May 25, 2023, 5:32 PM

#

// Adres.java
@Entity
@Table("adres)
class Adres {
   @Id
   private int adresId;
   @OneToOne
   @JoinColumn(name = "klantID")
   private Klant klant;
}

Maybe that?

stone pulsar May 25, 2023, 5:34 PM

#

Sadly no

#

Im really sorry im putting you through this 😅

fossil inlet May 25, 2023, 5:34 PM

#

No worries.

#

public class Klant {
    @Id
    private int klantID;
    @OneToOne(mappedBy = "klant")
    private Adres adres;
    @OneToMany(mappedBy= "klantID")
    private List<Order> orders;
    private String voornaam;
    private String achternaam;
    private String tussenvoegsel;
}

Tack on that as well maybe?

stone pulsar May 25, 2023, 5:35 PM

#

Use of @OneToMany or @ManyToMany targeting an unmapped class: Klant.orders[Order]

fossil inlet May 25, 2023, 5:37 PM

#

    @OneToMany(mappedBy= "klant")
    private List<Order> orders;

In Adres maybe?

stone pulsar May 25, 2023, 5:38 PM

#

same one

fossil inlet May 25, 2023, 5:39 PM

#

Honestly I'm stumped. Do some more googling, read some docs. I'm sorry d:

stone pulsar May 25, 2023, 5:44 PM

#

Ill do some googling, thanks anyway!

eternal copperBOT May 25, 2023, 5:44 PM

#

stone pulsar Ill do some googling, thanks anyway!

If you are finished with your post, please close it.
If you are not, please ignore this message.
Note that you will not be able to send further messages here after this post have been closed but you will be able to create new posts.

stone pulsar May 25, 2023, 7:19 PM

#

Oh,my,lord

#

Im just stupid

#

Though its not fully fixed

#

        try {
            // Create the SessionFactory from hibernate.cfg.xml
            sessionFactory = new Configuration()
                    .configure()
                    .addAnnotatedClass(Klant.class)
                    .addAnnotatedClass(Adres.class)
                    .addAnnotatedClass(Order.class)
                    .buildSessionFactory();
        }
        catch (Throwable ex) {
            System.err.println("Failed to create sessionFactory object: " + ex);
            throw new ExceptionInInitializerError(ex);
        }

#

I never added Order.class.....

#

Now, sadly that wasnt everything

#

Unable to determine TableReference (Klanten) for Order.klant.adres.orders.{fk-target}

fossil inlet May 25, 2023, 7:23 PM

#

Is your table on Klant.java Correct?

#

Also yeah I never would have seen this, since Spring does all this configuration for you. So good catch

stone pulsar May 25, 2023, 7:25 PM

#

I remembered something from my EF adventures, this usally had a context builder which is roughly the same as this sessionFactory

#

Buy yeah Klant seems fine

#

Changing the OneToMany and OneToOne to klantID gives back a familiar error again

#

Unknown mappedBy in: Klant.adres, referenced property unknown: Adres.klantID

fossil inlet May 25, 2023, 7:27 PM

#

I mean the @Table annotation on Klant

stone pulsar May 25, 2023, 7:28 PM

#

Yup

fossil inlet May 25, 2023, 7:28 PM

#

Well, more fiddling required

stone pulsar May 25, 2023, 7:28 PM

#

Sadly

fossil inlet May 25, 2023, 7:29 PM

#

Try tossing some @JoinColumn in different places

eternal copperBOT May 26, 2023, 12:40 AM

#

💤 Post marked as dormant

This post has been inactive for over 300 minutes, thus, it has been archived.
If your question was not answered yet, feel free to re-open this post or create a new one.

stone pulsar May 26, 2023, 11:07 AM

#

Well

#

I think ive managed the relatioships

#

but now i am at this point:
jakarta.persistence.PersistenceException: Converting org.hibernate.exception.SQLGrammarException to JPA PersistenceException : JDBC exception executing SQL [select k1_0.klantID,k1_0.achternaam,a1_0.adresID,a1_0.huisnummer,k2_0.klantID,k2_0.achternaam,k2_0.adresID,k2_0.tussenvoegsel,k2_0.voornaam,a1_0.plaats,a1_0.postcode,a1_0.routeID,a1_0.straatnaam,k1_0.tussenvoegsel,k1_0.voornaam from Klanten k1_0 left join Adressen a1_0 on a1_0.adresID=k1_0.adresID left join Klanten k2_0 on k2_0.klantID=a1_0.klantID where k1_0.klantID=?] at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:165) at org.hibernate.query.spi.AbstractSelectionQuery.list(AbstractSelectionQuery.java:374) at org.hibernate.query.sqm.internal.QuerySqmImpl.list(QuerySqmImpl.java:986) at org.hibernate.query.Query.getResultList(Query.java:94)

fossil inlet May 26, 2023, 3:38 PM

#

stone pulsar but now i am at this point: ``jakarta.persistence.PersistenceException: Converti...

Maybe try the result as a list? I doubt that will work, but it would be interesting if it's returning a list

stone pulsar May 26, 2023, 5:31 PM

#

I’ll try that

#SQL Hibernate JPA