A modern programming language that makes developers happier.

kotlinlang

Screenshot 2023-11-30 at 21.04.13.png

I'd like to execute some raw sql to my db. I've been looking through the issues on the git repo, and have found some useful comments <https://github.com/JetBrains/Exposed/issues/118#issuecomment-308453023|here> and <https://github.com/JetBrains/Exposed/issues/118#issuecomment-437021659))|here>. But when I try to write the sql string, the compiler complains with the message `id, name or spec expected, got blah` . I don't understand why I'm getting this error. Can anyone help?

You can use the `exec` method within the transaction. Here is an example:
```transaction {
    exec("SELECT countrycodes.id FROM countrycodes") { rs ->
        while (rs.next()) {
            println(rs.getString("id"))
        }
    }
}```

Screenshot 2023-12-04 at 20.29.23.png

That still gives me the same error. Thanks though. :+1:

You have to pass a block as the second argument. Does it work if you copy the entire snippet?

I decided to revert to using jdbc, so I could make some progress. I'll bear that in mind when I try again. Thanks

<@U01SQK7JBLP>  An extra thought: `exec()` uses `@Language("sql")` on its `stmt` parameter to enable (generic sql) language injection for code assistance in the IDE.

Assuming that you're using IntelliJ, if you've configured the SQL dialect to match your datasource and you're confident that the SQL statement is valid for that dialect, then the error may be related to this bug: <https://youtrack.jetbrains.com/issue/KTIJ-24766/False-positive-id-name-or-spec-expected-got-in-javascript-language-injection-in-IntelliJ-Idea-Community|KTIJ-24766>

Thanks <@U053JQ6TZR9>, I'm am using Intellij. I am just getting started with connecting my database to my ktor server so am not really confident about much. I did have a search for the error message before posting here but nothing came up. Maybe this is indeed what I'm seeing, For the time being I'll stick with jdbc to get things up and running but will return to Exposed at some point and will bear this in mind also. :+1: