Another thing; if i try updating or deleting a record on such table (but not the one in the example), i get:
Timeout trying to lock table. Caused by: org.h2.jdbc.JdbcSQLException: Row not found when trying to delete from index "PUBLIC.PUBLIC_DUMMY_SPATIAL_INDEX: Dne ponedeljek, 25. april 2016 16.35.11 UTC+2 je oseba Blaž Repnik napisala: > > Hey! > > I have a table into which i insert records with polygonal geometry. And > the problem is that some records do not show in the resultset when using > the spatial query (&& WKT_GEOM). I checked manually that the geometry of > the inserted features overlaps (actually the are completely within) the > query geometry. If i drop the spatial index and recreate it, i get the > missing records! > > I was not able to produce a working example on a simple table (my table > has about 30 columns). But this is what i do: > > First i insert the record with null geometry, then i update the geometry > column with "normal" geometry. So i guess the problem lies in updating the > spatial index? Any ideas? > > Also, i'm using the 191 version. > > Thanks! > -- 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 post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
