Re: [h2] view is slower than the actual query,Please help me on how to increase the performance of the view

2013-07-28 Thread Thomas Mueller
Hi, For performance questions, see http://h2database.com/html/performance.html Regards, Thomas On Thu, Jul 18, 2013 at 12:13 PM, Muzeer SK muzeer...@gmail.com wrote: view is slower than the actual query,Please help me on how to increase the performance of the view -- You received

[h2] view is slower than the actual query,Please help me on how to increase the performance of the view

2013-07-18 Thread Muzeer SK
view is slower than the actual query,Please help me on how to increase the performance of the view -- 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 h2-database

Please help me better understand the sync error...

2011-12-19 Thread Lizard Lizard
OK, so I've restarted the server, and I am trying to use the console to reconnect to my DB. Here's the connection string: jdbc:h2:tcp://192.168.1.101/file:C:\\users\\public\\varisk\\VaRiskDB And here's the error message; IO Exception: java.io.SyncFailedException: sync failed;

Re: Please help me better understand the sync error...

2011-12-19 Thread Thomas Mueller
Hi, The message java.io.SyncFailedException: sync failed is not generated by H2. It is generated by the file system / operating system when the database engine tries to flush the buffers. You will find out more if you use Google and search for java.io.SyncFailedException: sync failed I did that

Re: Please help me better understand the sync error...

2011-12-19 Thread Lizard Lizard
The disk WAS full when, I think, the original problem surface, but it's now about 50% free. On Mon, Dec 19, 2011 at 3:14 PM, Thomas Mueller thomas.tom.muel...@gmail.com wrote: Hi, The message java.io.SyncFailedException: sync failed is not generated by H2. It is generated by the file system /

Re: please help me

2009-12-10 Thread abdurrahim
I used sql : Backup to 'test.zip' but ı can not use test.zip whan can ı do or how can backup that ı can use On Dec 9, 12:46 am, Kerry Sainsbury ke...@fidelma.com wrote: Boy do I feel silly! On Tue, Dec 8, 2009 at 10:28 PM, lvr123 contact_goo...@parkingb.be wrote: From the documentation:

Re: please help me

2009-12-10 Thread Sergi Vladykin
Sql command 'BACKUP' does nothing else then simply zipping your database file. You should unzip it and use as usual. -- You received this message because you are subscribed to the Google Groups H2 Database group. To post to this group, send email to h2-datab...@googlegroups.com. To unsubscribe

Re: please help me

2009-12-10 Thread abdurrahim dagdelen
this is my connection public static Connection getConnection() { Connection con; try { Class.forName(org.h2.Driver); con = DriverManager.getConnection( + jdbc:h2:zip:C:/Program Files/ANET/WCMPYShield/data/test.zip!/test; +

Re: please help me

2009-12-10 Thread Thomas Mueller
#execute_String_String_String_boolean P.S. Please use a better subject line. Please help me is bad, it sounds like spam. Regards, Thomas -- You received this message because you are subscribed to the Google Groups H2 Database group. To post to this group, send email to h2-datab...@googlegroups.com

Re: please help me

2009-12-08 Thread lvr123
From the documentation: Databases in zip files are read-only. On Dec 7, 10:40 am, abdurrahim dagdelen adagdele...@gmail.com wrote: 12-07 11:37:13 database: opening zip:C:/Program Files/ANET/WCMPYShield/data/test.zip!/test (build 107) 12-07 11:37:13 index: open existing SYS rows: 0 12-07

Re: please help me

2009-12-07 Thread Kerry Sainsbury
Maybe your test.zip file is read-only? What does your connection string look like? On Mon, Dec 7, 2009 at 10:40 PM, abdurrahim dagdelen adagdele...@gmail.comwrote: 12-07 11:37:13 database: opening zip:C:/Program Files/ANET/WCMPYShield/data/test.zip!/test (build 107) 12-07 11:37:13 index: