Databases
StackOverflow2013
Postsdbo
POUnexpected token in db2 sql query
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POUnexpected token in db2 sql query
    primarykey
    data
    text
    <p>This is my query:</p> <pre><code> "SELECT t FROM LeerkrachtEntity t WHERE t = (SELECT l.leerkracht FROM LesEntity l WHERE l.id = :lesId) AND t IN (SELECT k.teachers FROM KlasEntity k WHERE k.id = :klasId) AND t.id = :leerkrachtId" </code></pre> <p>This is what hibernate does:</p> <pre><code> Hibernate: /* SELECT t FROM LeerkrachtEntity t WHERE t = ( SELECT l.leerkracht FROM LesEntity l WHERE l.id = :lesId ) AND t IN ( SELECT k.teachers FROM KlasEntity k WHERE k.id = :klasId ) AND t.id = :leerkrachtId */ select leerkracht0_.person_id as person_i1_12_, leerkracht0_1_.email as email2_12_, leerkracht0_1_.familienaam as familien3_12_, leerkracht0_1_.voornaam as voornaam4_12_ from leerkracht leerkracht0_ inner join person leerkracht0_1_ on leerkracht0_.person_id=leerkracht0_1_.person_id where leerkracht0_.person_id=( select lesentity1_.person_id from les lesentity1_, leerkracht leerkracht2_ inner join person leerkracht2_1_ on leerkracht2_.person_id=leerkracht2_1_.person_id where lesentity1_.person_id=leerkracht2_.person_id and lesentity1_.les_id=? ) and ( leerkracht0_.person_id in ( select . from klas klasentity3_, leerkracht_klas teachers4_, leerkracht leerkracht5_ inner join person leerkracht5_1_ on leerkracht5_.person_id=leerkracht5_1_.person_id where klasentity3_.klas_id=teachers4_.klas_id and teachers4_.person_id=leerkracht5_.person_id and klasentity3_.klas_id=? ) ) and leerkracht0_.person_id=? </code></pre> <p>I get following error:</p> <pre><code> 16:48:27.475 ERROR o.h.e.jdbc.spi.SqlExceptionHelper - unexpected token: KLAS required: ) </code></pre> <p>I am trying to get a leerkrachtEntity where in the database 'lesId' and 'klasId' are connected. Please help me. I don't know what is wrong.</p> <hr> <p>When I use this part of the query, everything works.</p> <pre><code> "SELECT t FROM LeerkrachtEntity t WHERE t = (SELECT l.leerkracht FROM LesEntity l WHERE l.id = :lesId) AND t.id = :leerkrachtId" </code></pre> <p>It goes wrong here: </p> <pre><code> t IN (SELECT k.teachers FROM KlasEntity k WHERE k.id = :klasId) AND </code></pre>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USKen Vernaillen
    1. USKen Vernaillen
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload