Re: database 900 MB slow to open, is it normal?

for opening the connection I use: Class.forName(org.h2.Driver); Connection conn = DriverManager.getConnection(jdbc:h2:/mydir/myapp/mydb, sa, ); Should I remove the SHUTDOWN command sent to H2? Thanks for your help Best regards, Sylvain On Tue, Dec 8, 2009 at 8:25 AM, Mikkel Kamstrup

Re: database 900 MB slow to open, is it normal?

2009/12/8 Sylvain Pointeau sylvain.point...@gmail.com: for opening the connection I use: Class.forName(org.h2.Driver); Connection conn = DriverManager.getConnection(jdbc:h2:/mydir/myapp/mydb, sa, ); Ok, nothing funky in there as far as I can see. Should I remove the SHUTDOWN command sent

Re: H2 performance in sun solaris

2009/12/7 sam pio hiii...@gmail.com: Hi all,         we have an application which uses H2 as an embedded database.In that application we constantlly write into the db synchronizing. and we also query and update simultaneously. I find that the overall operation of my program is 4 times

Re: please help me

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

Feedback of Findbugs.

Hi, I am looking for something as an embedded Db and came across H2. It looks quite exciting and I started looking into it. I am yet to dive in details but decided to have a look at source code and as a habit of mine triggered FindBugs (1) on it. It reported some issues. Let me add this in no

Re: database 900 MB slow to open, is it normal?

Hi, I was wondering which can cause the slowness? Would you need anything to help to find which could be the issue? By the way I am just realizing that I forgot to mention something: I am using a SSD HD and I am under MacOSX 10.6.2. Does it matter? Best regards, Sylvain On Tue, Dec 8, 2009 at

Re: Opening existing DB in read-only mode may throw exception The database is read only [90097-123]

Thomas, Is this problem fixed and should one set read-only attributes for database files and/or it is sufficient to use ACCESS_MODE_DATA=R parameter? It is not clear whether to use both or not? Maxim. -- You received this message because you are subscribed to the Google Groups H2 Database

scriptella error with H2

Hello, i'm trying to migrate data from Derby to H2 using scriptella. For some reason, when trying to pass large data from Derby to H2, i get a strange error with scriptella when inserting values into H2 JDBC provider exception: Cannot initialize temprorary file storage The script causing

ChangeFileEncryption Error while renaming

Hi, I'm getting the following Exception when trying to run the following code: ChangeFileEncryption.execute(~, username, AES, oldPassword.toCharArray(), newPassword.toCharArray(), false); I'm getting the exception below: Error while renaming file C:\Documents and Settings\test\username. 0.log.db

Re: index usage

Hi, That's true, I didn't think about this case... Unfortunately, I will not have time to implement this right away. I will increase the priority of the feature request. Regards, Thomas -- You received this message because you are subscribed to the Google Groups H2 Database group. To post to

Re: Error in like operator - works with HSQL, Oracle, MySQL

Hey Thomas, My experimenting with H2 continues, so I've attached a patch that fixes this problem. In summary: - Changed CompareLike to escape any escape characters that aren't followed by wildcard characters - Added test SQL to testSimple.in.txt A patch is attached. Cheers Kerry PS: Let me

Re: Error in like operator - works with HSQL, Oracle, MySQL

I swear gmail sent the email below without my permission -- patch is now attached. Kerry On Wed, Dec 9, 2009 at 4:28 PM, Kerry Sainsbury ke...@fidelma.com wrote: Hey Thomas, My experimenting with H2 continues, so I've attached a patch that fixes this problem. In summary: - Changed

build test fails for org.h2.test.unit.TestCache

Hi, When I try to run build test against the SVN code it fails for org.h2.test.unit.TestCache with: [java] ERROR: FAIL java.lang.NoClassDefFoundError: org/apache/lucene/document/Fieldable java.lang.NoClassDefFoundError: org/apache/lucene/document/Fieldable ... and another test

Rollback failure

Hi Thomas, I've deployed the latest version of H2 and am encountering problems with rollback. I don't have a good test case, but here's the stack trace if it helps: Could not roll back Hibernate transaction; nested exception is org.hibernate.TransactionException: JDBC rollback failed

Re: Server side cursors

On Nov 22, 11:10 am, Thomas Mueller thomas.tom.muel...@gmail.com wrote: My application needs this because it reads from a long result set until certain conditions are met and reading the entire result is too slow. Why can't you set the condition in the query (maybe using a Java

H2 is returning strange results.

Hi there, I have the following table schema in my h2 database: CREATE TABLE STOCK_INFO ( CODEVARCHAR(4), REMARKS VARCHAR(20), PRICE_DATE DATE, LASTDECIMAL(9,2),

Re: Rollback failure

Hi, This doesn't sound good... Could you send me the database? Is this problem reproducible with a fresh database? Some more questions: - What is your database URL? - Did you use multiple connections? - With which version of H2 was this database created? You can find it out using: select

Re: checkout with Eclipse

Hi, within Eclipse web dynamic project type H2 is a Java project, not a web project. I don't plan to change that. Would this be possible? Sorry, what is the question? Regards, Thomas -- You received this message because you are subscribed to the Google Groups H2 Database group. To post