Exposed does not work with just-released H2Database (1.4.199) #530
Comments
|
Fast investigation (through h2 changelog) shows that their change default behavior of driver in place of case-sensitivity for identifiers), as a workaround, you could add |
|
Or add DATABASE_TO_UPPER=false; |
|
I got a similar error when using insertIgnore: This appears when upgrading from exposed 0.13.3 to 0.13.4 |
|
@StefanHUB , could you please check the latest (0.13.6) version? |
|
@Tapac , sorry for being so late - unfortunatelly it still fails. Exception is exactly the same. |
|
Can anybody edit the gs wiki https://github.com/JetBrains/Exposed/wiki/Getting-Started with this replay in order not newbies got bad impressions (I know it is not H2 issue, but still we need to make ppl happy 😄)
|
|
@mhewedy , thank you for your advice. Wiki page was updated. |
#558 H2 dependency 1.4.197 is vulnerable to remote code execution (CVE-2018-10054)
|
Unfortunatelly 1.14.1 does not solve my issue. As said above the error happens when a The And it does not contain Users.ID, which causes the error in getRaw(). The insertIgnore() is: Maybe I am using exposed wrong?! |
|
@StefanHUB, thank you for a report, I will check a case with insertIgnore as there were changes in H2 related to it. Could you specify which mode do you use with H2 - default, MySQL, other? |
|
@Tapac MySQL 5.7 with default mode (i.e. nothing specified) |
|
@StefanHUB Oh, you have a problem with MySQL? I think (based on an issue title) that you use H2 in MySQL mode and have problem with it. |
|
@Tapac Yes, that's true. Sorry for that. Close this one and create a new one? |
|
@StefanHUB, yes, please add table mapping, insertIgnore code and Mysql jdbc driver version. |
|
Hi All, new to Kotlin Exposed. Having a similar type of error is not in record set. MySQL database is not able to save throws an error stating Generated SQL Please can anyone suggest me about this issue or point to wiki or example. |
The latest version of Exposed (0.13.5) seems to work fine with the previous version of H2Database (1.4.198), but if I upgrade to the recently-released version of H2Database (1.4.199) the same exact Exposed code fails to work. I cannot determine if this is a bug in H2Database or Exposed. Here's the test I run (based on Exposed example code) that previously worked fine:
@Test fun `can do simple database ops outside of module`() { Database.connect("jdbc:h2:mem:test;MODE=MySQL;DB_CLOSE_DELAY=-1", driver = "org.h2.Driver") transaction { SchemaUtils.create( Cities, Users ) val saintPetersburgId = Cities.insert { it[name] = "St. Petersburg" } get Cities.id val munichId = Cities.insert { it[name] = "Munich" } get Cities.id Cities.insert { it[name] = "Prague" } Users.insert { it[id] = "andrey" it[name] = "Andrey" it[cityId] = saintPetersburgId } Users.insert { it[id] = "sergey" it[name] = "Sergey" it[cityId] = munichId } Users.insert { it[id] = "eugene" it[name] = "Eugene" it[cityId] = munichId } Users.insert { it[id] = "alex" it[name] = "Alex" it[cityId] = null } Users.insert { it[id] = "smth" it[name] = "Something" it[cityId] = null } Users.update({ Users.id eq "alex" }) { it[name] = "Alexey" } Users.deleteWhere { Users.name like "%thing" } println("All cities:") for (city in Cities.selectAll()) { println("${city[Cities.id]}: ${city[Cities.name]}") } println("Manual join:") (Users innerJoin Cities).slice( Users.name, Cities.name ).select { (Users.id.eq("andrey") or Users.name.eq("Sergey")) and Users.id.eq("sergey") and Users.cityId.eq( Cities.id ) }.forEach { println("${it[Users.name]} lives in ${it[Cities.name]}") } println("Join with foreign key:") (Users innerJoin Cities).slice( Users.name, Users.cityId, Cities.name ) .select { Cities.name.eq("St. Petersburg") or Users.cityId.isNull() }.forEach { if (it[Users.cityId] != null) { println("${it[Users.name]} lives in ${it[Cities.name]}") } else { println("${it[Users.name]} lives nowhere") } } println("Functions and group by:") ((Cities innerJoin Users).slice( Cities.name, Users.id.count()).selectAll().groupBy( Cities.name )).forEach { val cityName = it[Cities.name] val userCount = it[Users.id.count()] if (userCount > 0) { println("$userCount user(s) live(s) in $cityName") } else { println("Nobody lives in $cityName") } } SchemaUtils.drop( Users, Cities ) } }And this is the error that I now see:
The text was updated successfully, but these errors were encountered: