Invitation to connect on LinkedIn

LinkedIn I'd like to add you to my professional network on LinkedIn. - Prakash Prakash K Business Analyst, Human Resource Executive & Accountant at The Zigmainfosoft India Pvt. Ltd. Coimbatore Area, India Confirm that you know Prakash K https://www.linkedin.com/e/-ni462m-gr

Re : blocked with issue 311

Hi again, I began to modify some H2 code in order to make my use case work. The attached file is a patch file for org.h2.expression.SequenceValue. It seems to solve my problem fine but I don't know enough the architecture of the H2 engine to be sure it won't fail in some other situations. I ran

Re: Database corruption Options

> Did you measure that it's more efficient (if yes: what is the > difference on your system)? No i didn't measure it, i would remove it It's quite hard to replicate the pb, but I will do what you suggest, removing the bind to localhost, recreates the database with the new version and use the clos

Re: String compare with condition

Hi, This is quite a generic SQL question... If you ask this on StackOverflow.com, I guess you will have some good answers within a few minutes :-) Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email

Re: off-line download

Hi, > When I try to download these files, they appear to have no (or very > less) content. There simply was no documentation on the Google Group. (At some point there was, but then spam was added, so I disabled this feature). The documentation is on h2database.com. Regards, Thomas -- You recei

Re: Database corruption Options

Hi, > Well I use the localhost setting because I would think it's more > efficient. Did you measure that it's more efficient (if yes: what is the difference on your system)? >> - With which version of H2 was this database created? > 133 That means the database file was created using H2 version

Re: Encryption Database Question

Hi, > I would like to know is the h2 database encryption encrypt > everything Yes, everything is encrypted (except for the file name itself, and the file size). Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this gr

Re: Deleting many records from large table degrades performance

Hi, Could you create a reproducible test case? Please note that CPU usage alone isn't a good metric. 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-database@googlegroups.com. To unsubscri

Re: H2 Custom java functions vs. PostgreSQL ODBC client?

Hi, I don't see a reason currently why this shouldn't work, however I never tested it myself. Did you verify it works using the regular JDBC driver and mode? If not, could you try this first? Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Datab

Re: Website question

Hi, Thanks for reporting this problem! It should be fixed now - please tell me if not. The problem was, in navigation.js, mouseMove always returned false, instead of just when dragging. Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" g

blocked with issue 311

Hello, I am stuck with issue 311 (cf http://code.google.com/p/h2database/issues/detail?id=311#c4). Does anyone know a way to get around it when you don't access the database directly through JDBC but with hibernate instead ? Any help will be greatly appreciated. Regards Laurent R -- You recei

Re: Index on transactional temp table

Hi With MySQL we sometimes use temp tables to break up a complex query, especially when large subquery results are involved. For performance reasons, these temp tables need to have indices, but we don't want the running transaction to be committed. I'd also appreciate transaction save index creati

Re: Configuring dynamic url property from maven in a web app

In the end I opted for a resource filtering solution where maven substitutes a variable by passing it from the parent pom where it can be discovered at compile time. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send emai

Re: select statement problem

Thank you guys .. On Aug 11, 3:59 pm, IanP wrote: > On Aug 11, 4:26 pm, JavaGuy wrote: > > > > > > > Hi Ian, > > > Look at it this way: > > SELECT T1 FROM test2 where ID=3 executed on it's own won't work, since > > test2 doesn't have a column T1. > > > You're executing it as a nested statement,