Room and Kotlin - getting "Each bind variable in the query must have a matching method parameter."

Question

I am getting this error:

error: Each bind variable in the query must have a matching method parameter. Cannot find method parameters for :network.
error: Unused parameter: arg0

when trying Room and Kotlin like this:

@Dao
interface TokenDefinitionDao {

    @Query("SELECT * FROM token_descriptors WHERE network LIKE :network")
    fun getAllForNetwork(network: String?): List<TokenDescriptor>

    @Delete
    fun delete(token: TokenDescriptor)
}

But I am passing and using this parameter. Anyone sees what the problem is or can point me to working examples of using Room with Kotlin?

score 5 · Accepted Answer · answered Nov 07 '17 at 18:20

5

Try to change "network" param to "arg0"

@Query("SELECT * FROM token_descriptors WHERE network LIKE :arg0")

In newer versions of kotlin and room this issue was fixed!

answered Nov 07 '17 at 18:20

Fredy Mederos

2,506
15
13

Encountered this issue even when not using Kotlin anywhere project. This solved it – user3118604 Mar 12 '18 at 15:34
Facing the same issue with Java when my dao is in a module and database class in application. Room v2.2.5 – Ivo Pavlik Jul 18 '20 at 07:26

0wl · Answer 2 · 2017-12-07T17:36:33.267

4

To avoid that problem you have to use kotlin-kapt plugin in your build.gradle.

...

apply plugin: 'kotlin-android'
apply plugin: 'kotlin-kapt'

...

android {
...
}

btw, ensure that you're using kotlin 1.2.0+

edited Dec 07 '17 at 17:36

answered Jun 21 '17 at 19:15

0wl

836
8
19

I am getting: Error:Could not find org.jetbrains.kotlin:kotlin-gradle-plugin:1.1.3-eap-85. Searched in the following locations: – Mladen Rakonjac Jul 13 '17 at 15:54
@MladenRakonjac I've updated my answer. Check it please. – 0wl Dec 07 '17 at 17:37
Turns out I was missing the 'kotlin-kapt' apply plugin. Everything worked fine until this query issue, amusingly. – Danedo Jan 30 '18 at 00:03

Room and Kotlin - getting "Each bind variable in the query must have a matching method parameter."

2 Answers2