On Friday, July 19, 2019 at 5:13:09 PM UTC-4, Tim Fielder wrote: > On Friday, July 19, 2019 at 3:49:24 PM UTC-4, Noel Grandin wrote: >> >> >> The weird stack trace you are seeing in .197 is because you have a >> varchar column that you are querying against, but you are passing in a very >> large integer value, which tends to hit a rather unfortunate fallback path >> in our conversion code (which has been fixed in master). >> >> You would do better to write your query something like >> SELECT title, abstract FROM document WHERE docid = '0001179973' >> so that the comparison happens on a char basis, instead of having H2 >> trying to convert both sides to some integer type. >> >> In fact, that might fix your problem with .199 too >> > > Thanks. I'll try it when I get back to work on Monday and get back to > you. >
Wrapping all of the %s in my format strings with single quotes ' seems to have solved the problem, at least in .199 - haven't tested with .197. Thanks for the help. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/cdf79d98-d9a1-4554-a52e-a80ec7ad6887%40googlegroups.com.
