Re: [h2] Continuous Increase in H2 db size after dropping and loading same data repeatedly

On 2013-08-21 07:56, Thomas Mueller wrote: Hi, I suspect if you read mailing list messages from a mobile device you miss preformatted contents... I posted the head and tail of the .sql file in my previous post Well, I think you didn't post the content of the transaction

[h2] java.io.FileNotFoundException: h2errors.txt exception

Hi, We are see following exeption in our log file, it seems these are happening during insert/update time. Please let me know if anyone has experience the same and was able to get rid of it. Any pointers or help would be much appreciated. org.h2.message.DbException: IO Exception:

Re: [h2] java.io.FileNotFoundException: h2errors.txt exception

Looks like something went wrong when a connection was opened, and H2 tried to log the exception, but failed because the filesystem is read-only. If you don't want H2 to write things to the filesystem, you should probably tweak your trace settings. See here:

Re: [h2] Continuous Increase in H2 db size after dropping and loading same data repeatedly

Hi Noel, I've always used http://h2-database.66688.n3.nabble.com/ to post to the newsgroup before: from that interface my messages appeared to be ok. I simply was not aware that there were this kind of issues. From now on I'm going to write directly from google groups. About the

Re: [h2] In-Memory Database and TCP Server Queries

That was exactly what I was looking for! Thanks, Derek Thanks, Derek On Wed, Aug 21, 2013 at 1:43 AM, Thomas Mueller thomas.tom.muel...@gmail.com wrote: Hi, What you could try is replace debuggingDatabaseSleep(30) with org.h2.tools.Server.startWebServer(conn). Regards, Thomas On

Re: [h2] java.io.FileNotFoundException: h2errors.txt exception

Hi, Yes, you are using quite an old version of H2 (about 2 years old). Also, did you set the property h2.logAllErrors? If yes, I suggest to disable it. This should solve the problem as well. Regards, Thomas On Wed, Aug 21, 2013 at 3:39 PM, Noel Grandin noelgran...@gmail.com wrote: Looks

[h2] How to query whether a table exists?

I found a post at http://h2-database.66688.n3.nabble.com/Best-practice-Test-for-existence-of-table-etc-td4024451.html which said that the correct method was: select count(*) from information_schema.tables where table_name = ? However, I cannot get any results in doing such a search if I

Re: [h2] How to query whether a table exists?

works for me. you want IS NOT NULL, IS NULL instead of = null This is what I did SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'FILE_RESOURCE' SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'FILE_RESOURCE';