Re: H2 error when running.

Can you paste a stack trace of what error you are getting? And what URL are you using to connect to the database? Thanks, Ryan On 8/05/2013 1:54 PM, khang phamngoc wrote: I used H2DB for my project, well evrything seem good but 2 days ago when I'm using it, my computer shut down so when I

Re: performance issue with script query

There isn't a way to do that, but it wouldn't make any difference to the performance anyway. You could try using CSVWRITE to export the data http://h2database.com/html/functions.html#csvwrite On 2013-05-07 22:26, Anupama Pullela wrote: Hi, I am using 'SCRIPT TABLE tablename' to bacup tables

Re: H2 tcp remote rollbacks unexpectedly when running on Windows 7

That sounds like your client is timing out for some reason and disconnecting from the database. On 2013-05-07 18:07, Yanni Papadimitriou wrote: Hello, While running the H2 database in remote tcp mode over Windows (Windows 7 to be exact), I have noticed that it becomes unresponsive when

Re: H2 tcp remote rollbacks unexpectedly when running on Windows 7

Hello Noel, Thank you for following up on this. I thought of this possibility, but do you have any idea why this would happen only if the server resides on a Windows machine and doesn't happen when on a Linux machine? Client code is exactly the same no matter what OS hosts the h2 server

is the MVStore production ready

Hi, I'm looking for a java embedded key-value store with support for versioning. I've found the MVStore implementation and it seems to be exactly what I'm looking for. My question is, is it usable for production in the current version? Kind regards Thorsten -- You received this message

Re: java-level deadlock

Hi Ainimyoung, can you tell me what statements are executing on those connections, and what the table structure that the statements are querying looks like? Thanks. On 2013-05-05 04:33, Ainimyoung wrote: Hi Noel, Thanks for replying. The URL is jdbc:h2:tcp://ip:9092/db We've also tried

Re: H2 tcp remote rollbacks unexpectedly when running on Windows 7

It would be interesting to see the client-side logs to see if there anything useful about why the client disconnects. Otherwise, you could try doing a Wireshark or Microsoft-Network-Monitor trace of the connection, to see where and when the disconnect is initiated. On 2013-05-08 11:08, Yanni

Memory Usage Problem

Hi, I use H2 database as embedded database in memory. The queries processed by the database are quite large, as result my memory profiler tells me that the queryCache (Type org.h2.util.SamllLRUCache) member of an instance of org.h2.engine.Session consumes about 100 MB heap space. Is there a

Re: Memory Usage Problem

I could just tell you, but that would deprive you of discovering the excellent search feature on our website. On 2013-05-08 15:22, christoff.schm...@finaris.de wrote: Hi, I use H2 database as embedded database in memory. The queries processed by the database are quite large, as result my

Database IO Exeception on Network Share

Hi, We are using H2 in an environment where multiple vms access the database file over a windows network share using AUTO_SERVER=TRUE;AUTO_RECONNECT=TRUE to allow whichever vm can start the database to be the server. We are experiencing some stability issues which look like they are related

Re: Memory Usage Problem

I did so, but as i see it, that setting does not have any effect for in memory DBs as I use it. Cache Settings The database keeps most frequently used data in the main memory. The amount of memory used for caching can be changed using the setting CACHE_SIZE. This setting can be set in the

Re: Database IO Exeception on Network Share

Sorry, but no. Running things like databases on network shares is generally a bad idea. On Wednesday, 8 May 2013, wrote: Hi, We are using H2 in an environment where multiple vms access the database file over a windows network share using AUTO_SERVER=TRUE;AUTO_RECONNECT=TRUE to allow

Re: Memory Usage Problem

Hi, There is not just one cache. It's in another cache, the queryCache, not the regular row cache. See http://h2database.com/javadoc/org/h2/constant/DbSettings.html?highlight=queryCacheSizesearch=queryCache#QUERY_CACHE_SIZE However, I wonder what data is cached in the query cache. How large are

Re: Database IO Exeception on Network Share

Hi, H2 supports a pluggable file system: http://h2database.com/html/advanced.html#file_system If you want to make it work, I suggest you implement a file system implementation that can deal with the kind of file system problems you can run into. For example, the file system implementation could

Re: is the MVStore production ready

Hi, I don't expect any big changes, but I still consider it experimental, because the API might change, and because it is not fully tested (specially multi-threading). But depending on your use case it might already be good enough, specially if you have your own test cases to ensure the features

Dropbox and H2

Hi! I wonder if anyone has experience with using H2 database-files on a cloud-drive, for example on Dropbox? Is there known problems or difficulties? Best regards, Johan -- You received this message because you are subscribed to the Google Groups H2 Database group. To unsubscribe from this

Re: Dropbox and H2

Dropbox just syncs a folder on the local PC. So it depends on what you want to do with it? If you want to use it on more than 1 PC at a time it won't work (You'll just get conflicts). Otherwise it should work ok I think. ? I'm not sure how dropbox accesses in use files. But it might only sync