Start a new topic

Fix for broken schema filtering in H2

[This topic is migrated from our old forums. The original author name has been removed]

Hi, I just created an embedded H2 database to experiment with linked tables. When I tried to add a schema filter the debug window popped up with the following message: +[ERROR ExecutorRunner-pool-2-thread-48 B.?] Could not find filter column name 'Schema' in DataSet. Notify vendor as the database profile is in an inconsistent state.+ Googling the error message took me to the following forum post, which helped me fix the error: http://www.dbvis.com/forum/thread.jspa?threadID=2067 I opened h2.xml in the resources/profiles folder and located the following section:                                                                                ... First I tried to change the row to (note the lower case s) I figured that would work because of the row It didn't! I guess SetVar doesn't work that way... Then I tried to change it to Success! Schema filtering now works in my H2 database. You should fix this in the next release, if you haven't already! Side note: I like your profiles concept and how easy it was for me to fix this on my own! That's another point for DbVisualizer in my evaluation. Regards, Mikael

[This reply is migrated from our old forums.]

Re: Fix for broken schema filtering in H2
Hi Mikael, Thanks for the report. It is indeed a bug and will be fixed in then next maintenance version. Regards Roger
[This reply is migrated from our old forums.]

Re: Fix for broken schema filtering in H2
Hi Mikael, Just to inform you that this is now fixed in the 9.1.7 version. http://www.dbvis.com/download/ If you have further questions, please don't hesitate to contact us. Regards Roger