Re: [h2] support of CONTAINS function

On 2018/09/17 8:46 AM, Dilan A wrote: does h2 database support Function? I'm getting following error  "CONTAINS" not found; SQL statement Is there is a way to resolve this? Which is supported by oracle

Re: [h2] Data conversion error converting without additional information

try posting the full stacktrace, that is normally pretty useful. It's hard to say why it sometimes works and sometime doesnt - I'm guessing that you have multiple copies of H2 in your classpath, which is probably also why the debugger is returning weird results. -- You received this message

Re: [h2] H2 1.4.197

On 2018/09/06 11:59 AM, bala ganesan wrote: An issue was discovered in H2 1.4.197. Insecure handling of permissions in the backup function allows attackers to read sensitive files (outside of their permissions) via a symlink to a fake database file. We do not regard that as a bug and do

Re: [h2] Re: Using H2 as embedded database in Junit tests

On 2018/08/31 10:10 AM, Johan Norén wrote: Oh yeah, missed that conversation. Pretty much what we want I guess. Thanks! Good to hear! Since this has come up more than once, if you come up with a good solution, please submit your improvements as a PR. Thanks, Noel. -- You received

Re: [h2] Using H2 as embedded database in Junit tests

On 2018/08/30 3:19 PM, Johan Norén wrote: Is there a way of today to take an in memory snapshot of the embedded database once we have created the tables and A very similar discussion here: https://groups.google.com/d/msg/h2-database/0J5ZHlxVptY/3kMe5XrXCAAJ -- You received this

Re: [h2] Prevent reordering of user defined function in where clause

On 2018/08/28 2:47 PM, dilaz03 wrote: How can I prevent reordering of conditions? Can I specify some cost for function? No. But you could try something like SELECT * FROM ( SELECT ... FROM table WHERE ) WHERE match(...) -- You received this message because you are subscribed to the

Re: [h2] CVE-2018-14335

See here https://github.com/h2database/h2database/issues/1294 On Wed, 22 Aug 2018 at 21:03, Joe Di Pol wrote: > Has there been an evaluation of > https://nvd.nist.gov/vuln/detail/CVE-2018-14335? > > Thanks, > > Joe > > -- > You received this message because you are subscribed to the Google

Re: [h2] Feature Request: Possibility to use here document with CSVWRITE

You are running against the grain here :-) Rather create a temporary table from the script command output, and use CSVWRITE on the temporary table. Than can just prefix your SQL command with CREATE LOCAL TEMPORARY TABLE MY_TEMP AS and then CSVWRITE(filename, 'SELECT * FROM MY_TEMP')

Re: [h2] Error: Unpexpected code path

Stacktrace? -- 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+unsubscr...@googlegroups.com. To post to this group, send email to

Re: [h2] Explanation of COMMIT after every SELECT

​ ​if auto-commit is set to true, which it normally is, there is a commit after every query/update/etc. But if nothing has changed the commit doesn't actually do anything, so no need to worry.​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To

Re: [h2] How to create alias like Mysql's IF function?

Unfortunately, creating an ALIAS will not work because IF is a keyword, and we don't allow keywords to be overriden by user defined functions. I suggest that you instead use CASE .. WHEN http://h2database.com/html/grammar.html#case_when

Re: [h2] Performance of large updates

On 2018/07/24 3:35 PM, Philipp Cornelius wrote: * More tables. Production DB is > 5GB. 5GB is really not that much data these days. Copy it to your local machine and... (1) Run EXPLAIN ANALYZE overnight on your machine. (2) If that still doesn't finish, try write a little program

Re: [h2] Automatic Mixed Mode with multiple application

http://h2database.com/html/features.html#auto_mixed_mode ​ ​All the machines need to be able to see​ the same files, so you need a shared folder somewhere -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop

Re: [h2] Performance of large updates

On 2018/07/20 3:38 PM, Philipp Cornelius wrote: One problem I have repeatedly faced is the performance for large updates. I have several tables with >100,000 rows and I've used EXPLAIN ANALYZE UPDATE ... and that, too, takes ages (I understand EXPLAIN ANALYZE is run before the update

Re: [h2] Is the Maven build file obsolete?

On 2018/07/19 9:48 AM, 'Adrian A.' via H2 Database wrote: Is the Maven build file obsolete? It's not the primary build tool so it tends not to be kept quite as up to date, feel free to submit a patch :-) -- You received this message because you are subscribed to the Google Groups "H2

Re: [h2] Invalid value "null" for parameter "calendar" [90008-193]

On 2018/07/18 4:12 PM, 'Andreas Knees' via H2 Database wrote: when I execute PreparedStatement.setTimestamp(1, timestamp, null); I get the following Exception: Please log a bug for this in our bugtracker on github. -- You received this message because you are subscribed to the Google

Re: [h2] corrupt data base

On 2018/07/09 12:15 PM, 'Sven Eric Panitz' via H2 Database wrote: Okay I cloned the repository and I am willing to tweak the source code to ignore the errors. Anyone out there who can guide me a bit. Reading chunks gives the error. try making the loop at the top of readStoreHeader use the

Re: [h2] corrupt data base

If you are willing to build from source, you can sometimes tweak the source code to ignore certain errors and insert good values when it seems bad ones, in order to run the Recover tool. ​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To

Re: [h2] getCurrentVersion/openVersion from SQL.

Not at the moment, no ​ -- 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+unsubscr...@googlegroups.com. To post to this group, send email to

Re: [h2] MVStore and interrupts?

On 2018/06/28 9:59 AM, Dan wrote: I've been going down this road: https://github.com/h2database/h2database/issues/227 trying to figure out how to work around interrupts with MVStore. Everyone just says use 'retry' or don't interrupt... not interrupting is easier said than done with other

Re: [h2] Continuous DB corruption H2 1.3.176

On 2018/06/19 3:06 PM, Behroz Sikander wrote: What is your opinion on the following statement that I originally posted? "After digging into the corruption problem, we found that we use tcpAllowOthers and AUTO_SERVER=TRUE at the same time. Due to this reason, we have sometimes "server"

Re: [h2] Continuous DB corruption H2 1.3.176

On 2018/06/19 2:24 PM, Behroz Sikander wrote: A few questions: - When I recover my corrupted DB, and query the last row, I get Error: org.h2.jdbc.JdbcSQLException: IO Exception: "java.io.IOException: org.h2.jdbc.JdbcSQLException: IO Exception: ""Missing lob entry, block: 1225254""

Re: [h2] Continuous DB corruption H2 1.3.176

On 2018/06/18 9:09 PM, Behroz Sikander wrote: 2- Within my application we connect to the database using |jdbc:h2:tcp: where does the DB live? on some shared network drive somewhere? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To

Re: [h2] Connect/Disconnect/Close sequence printed out to System.out every few milliseconds

You have some other client somewhere that is trying to connect, discovering that H2 is not what it is expecting, disconnecting and trying again ​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving

Re: [h2] Re: Define a limit size for a table

you could do this in a trigger: http://h2database.com/html/features.html#triggers ​ -- 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

Re: [h2] Having creating index on BLOBs

Just make the column BINARY instead of BLOB ​ -- 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+unsubscr...@googlegroups.com. To post to this group,

Re: [h2] Re: Support for external Authentication

Quick survey of current approaches reveals that unsurprisingly, this area is full of Enterprise Development Goodness (i.e. it's a complete mess). SQL Server uses the "authentication" and "authenticationScheme" connection properties.

Re: [h2] Support for external Authentication

On 2018/05/11 11:43 PM, AleVen wrote: To expose directly H2 databases to end users it would be great support for external authentication providers (like ldap,...) . grep for the DatabaseEventListener functionality. I imagine external auth could be added in the same way. -- You received this

Re: [h2] random used TCP Port ...can these used random ports definied in a port range?

Well for starters you should not be connecting to your DB from outside your DMZ. But, to answer your question, no, all of those ports are randomly selected from the available ports, and determined by the operating system. ​ -- You received this message because you are subscribed to the Google

Re: [h2] Do not return table name in result set

Um, that's some kind of ReadyAPI problem, we have nothing to do with returning XML result sets ​ -- 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

Re: [h2] Large delete from large table goes bonkers

​Probably Squirrel and your normal embedded program are using different versions of H2.​ ​ ​Make sure your have an index on TABLE1_T on PERSID​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving

Re: [h2] What is the CREATE LINKED TABLE password when using CIPHER=AES

createLinkedTable is trying to create a linked table back to itself? ​ -- 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+unsubscr...@googlegroups.com.

Re: [h2] Connection string for using MVStore

You are already using MVStore. If you want to use PageStore, the older storage engine, add ;MV_STORE=FALSE to your database URL -- 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,

Re: [h2] Database corrupt after computer power failure.

On 2018/05/02 10:48 AM, Mikael Nordenberg wrote: No offence Thomas, but after reading the source code for H2 when we investigated our problems, we decided to use a different database. To us, it seemed an overwhelming task to get that code in order to make it make it stable enough for our

Re: [h2] MVStore with custom sort order Comparator?

No, but you can create custom datatypes and supply your own comparison operation org.h2.mvstore.type.DataType#compare(Object, Object) ​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails

Re: [h2] Very slow execution times for SELECT-statements with lots of LEFT OUTER JOINs after updating on H2 version 1.4

On 2018/04/26 11:52 AM, 'Ivaylo Dobrikov' via H2 Database wrote: Do you know approximately when you will release a new (stable) version of H2 in which the optimisation that you made will be present? Probably in a couple of months -- You received this message because you are subscribed

Re: [h2] Re: DB Corrupt

On 2018/04/25 1:56 PM, Behroz Sikander wrote: Also, is there any documentation that I can use understand the following output: Other than reading the code, and the documentation like: http://h2database.com/html/architecture.html no, I'm afraid not > What I can do to figure out why it got

Re: [h2] Re: DB Corrupt

There is not much to say, your DB is corrupt, and unfortunately too corrupt for the Recover tool to be able to do much. Doing regular backups is the only real change you can make to protect against this. -- You received this message because you are subscribed to the Google Groups "H2

Re: [h2] H2 database connection pool issue

Most likely you are leaking connections, which means you are exceeding the max number of connections, which is why getConnection() in JdbcConnectionPool is looping and sleeping.​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe

Re: [h2] Version 1.4.197 is much slower then previous versions like 1.4.196

Unfortunately that does not tell me enough to be able to fix that. If you can build from source, perhaps you could bisect the problem down to a specific commit? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and

Re: [h2] Very slow execution times for SELECT-statements with lots of LEFT OUTER JOINs after updating on H2 version 1.4

Hi Thanks for the excellent test case. I note that most of the time is being spent in the planning phase of the query. I have just pushed a commit which makes 1.4 about twice as fast as it was before. You can build from source to try it out. It is, however, never going to be as fast as 1.3,

Re: [h2] MVMap similar to LinkedHashMap

you can use ceiingKey(K) to match on the first part of the search key.​ -- 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+unsubscr...@googlegroups.com.

Re: [h2] MVMap similar to LinkedHashMap

you could probably get the same effect by adding a sequentially increasing id to the end of the key​ -- 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

Re: [h2] MVMap similar to LinkedHashMap

No​ -- 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+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com.

Re: [h2] Version 1.4.197 is much slower then previous versions like 1.4.196

If you can generate a standalone test case, we can profile it -- 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+unsubscr...@googlegroups.com. To post

Re: [h2] Very slow execution times for SELECT-statements with lots of LEFT OUTER JOINs after updating on H2 version 1.4

EXPLAIN ANALYZE will show you what plan the db is executing, something in the planner is generating a worse plan now. Your best bet is to generate a standalone test case for us to look at. ​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To

Re: [h2] XA commit-unlockAll - Unexpected code path

In general the XA stuff is not well tested. The first thing would be to reduce it to a standalone test case.​ -- 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

Re: [h2] After upgrade to 1.4.97 from 1.4.96 produces the following exception : org.h2.jdbc.JdbcSQLException: Table "SYNONYMS" not found;

there is a bug (which is fixed on master) if you mix and match different versions client and server side. If you upgrade the client to 1.4.197, this problem should go away. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from

Re: [h2] Large H2 database

Also, I tried to examine the DB but it seems to be corrupted -- 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+unsubscr...@googlegroups.com. To post

Re: [h2] Very large database created during test

If you can create a standalone test, we could take a look at it. I run exactly the same kind of load (heavy write, heavy read) with no problem. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving

Re: [h2] Large H2 database

that was probably one of the temp table issues. I suggest you update to the latest version, but append MV_STORE=false to your URL to keep on using the old PageStore engine. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from

Re: [h2] Why is there no unit tests?

In general, we have the tests we want. You are welcome to submit more, but these are the ones we have found most useful in our project. ​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails

Re: [h2] Re: Stuck in read only

try setting a breakpoint in FilePathDisk#canWriteInternal and stepping through that to figure out where it is going wrong.​ -- 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

Re: [h2] how to implement TIMESTAMPADD for TIMESTAMP WITH TIME ZONE's?

you want the Function class​ and don't forget to add some unit tests - look for existing TIMESTAMPADD tests in *.sql files under the test/ foldef -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving

Re: [h2] Re: H2 and Java 9

submit a pull request?​ -- 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+unsubscr...@googlegroups.com. To post to this group, send email to

Re: [h2] Problem with new Datetrunc function conflicting with user defined function.

No, you should be able to load such a database, and then drop the user created alias​ SYSTEM aliases are always created first, then USER aliases are created as the DB is loaded, so the option only affects whether or not the USER alias in the DB is allowed to override the SYSTEM alias -- You

Re: [h2] Problem with new Datetrunc function conflicting with user defined function.

You could connect with the old version of H2, drop the alias, then reconnect with the newer version. Or you can use connect with this in your connection string BUILTIN_ALIAS_OVERRIDE=1 to allow you to temporarily override the system alias. -- You received this message because you are

Re: [h2] Re: H2 data cache priority

On 2018/03/23 2:56 PM, mansour n wrote: Hi Thank you for your response, if I understand you propose that we use "create memory table" ? I'm not sure to understand the difference between "memory" and "cached" table, the two are persistent and what is the limit when the doc says : "memory

Re: [h2] H2 data cache priority

No, we don't have per-table cache settings. http://h2database.com/html/features.html#cache_settings You can specify that certain tables always have their index in memory http://h2database.com/html/grammar.html#create_table -- You received this message because you are subscribed to the Google

Re: [h2] huge file size

mvstore still has some issues with sometimes generating overly large sizes. however, if you have open transactions that are not committed, that can keep file data alive longer than necessary. ​ also try importing data first, then creating the indexes after -- You received this message because

Re: [h2] "Restore from" for embedded mode?

Sorry, we don't have any kind of online restore function. For embedded mode, you need close connections and SHUTDOWN the database, copy the backup files back in place, and then re-open the connections. Which is entirely possible in embedded mode. ​ -- You received this message because you are

Re: [h2] "Restore from" for embedded mode?

the backup that BACKUP generates is just a SQL script that you can run with RUNSCRIPT​ :-) -- 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

Re: [h2] org.h2.jdbc.JdbcSQLException: Connection is broken: "java.net.BindException: Address already in use: connect: localhost:8092" [90067-196]

https://stackoverflow.com/questions/4708649/java-net-bindexception-address-already-in-use-when-trying-to-do-rapid-socke ​ -- 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

Re: [h2] compacting an embedded h2 database

http://h2database.com/html/features.html#compacting -- 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+unsubscr...@googlegroups.com. To post to this

Re: [h2] Re: Problem with TRACE_LEVEL_FILE option

that sounds like a bug, probably just something nobody has tried to do before -- 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

Re: [h2] MVStore - Check Unique Loops 1000s times per insert

I mean that nulls can sort either first or last, so there might be (I'm not sure) more checking required to see if it legitimate to exit the loop early​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop

Re: [h2] h2 Add/Subtract Interval in Oracle query

sorry, we don't support those oracle functions​ -- 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+unsubscr...@googlegroups.com. To post to this group,

Re: [h2] MVStore - Check Unique Loops 1000s times per insert

the patch looks reasonable, but it will need extra logic to cope with nullsFirst/nullsLast ​ Feel free to submit a PR -- 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

Re: [h2] MVStore - Check Unique Loops 1000s times per insert

I don't see any assumption there about the inserted values. ​Can't see any obvious reason why you'd see a high loop count there, though -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails

Re: [h2] H2 Database Connection

where did you find such a thing? h2 is still at org.h2 ​ -- 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+unsubscr...@googlegroups.com. To post to

Re: [h2] Next release?

sometime in the next couple of weeks​ -- 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+unsubscr...@googlegroups.com. To post to this group, send email

Re: [h2] Plans for extending encryption to support 256 bit keys?

On 2018/01/07 9:21 AM, Stanislav Yurin wrote: Just wanted to ask before putting efforts in - are there any specific reasons not to use Java 7/8 encryption facilities? We support back to Java7, so as long as the facilities are available there, go for it. -- You received this message

Re: [h2] ALL should be added to the list of reserved keyword.

thanks, fixed in trunk -- 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+unsubscr...@googlegroups.com. To post to this group, send email to

Re: [h2] Enrypting H2 database

nope, I just use it direct​ -- 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+unsubscr...@googlegroups.com. To post to this group, send email to

Re: [h2] Enrypting H2 database

Works fine for me in production, but you have to quite careful, if you do something wrong you just get weird exceptions, not anything particularly useful.​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop

Re: [h2] MVStore problem with interrupts

I debug MVStore frequently and I have never seen this behaviour.​ But maybe something about your specific environment is triggering an issue? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving

Re: [h2] Re: With LOCK_MODE=0, log file still has hundreds of locks

LOCK_MODE=0 is not something we have a lot of test coverage for, so I only know that is works for normal cases.​ You're more than welcome to submit patches to fix your specific use-case. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To

Re: [h2] Re: With LOCK_MODE=0, log file still has hundreds of locks

Yup, it should disable all locking.​ Why this is happening for you I don't know. -- 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

Re: [h2] Re: With LOCK_MODE=0, log file still has hundreds of locks

what you are seeing is just the locking we do during startup.​ -- 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+unsubscr...@googlegroups.com. To post

Re: [h2] Re: With LOCK_MODE=0, log file still has hundreds of locks

On 4 January 2018 at 02:22, Patrick H wrote: > Constructor, public Database(ConnectionInfo ci, String cipher) where all > the URL options are parsed never parses for the 'LOCK_MODE' option. Thus > never changes the default value for Database.lockMode which is >

Re: [h2] Re: With LOCK_MODE=0, log file still has hundreds of locks

On 4 January 2018 at 02:48, Patrick H wrote: > > Why would you want to unlock something when it wasn't locked? > > > Because updateMeta will lock it, and we don't want to unlock it if it was previously locked. -- You received this message because you are subscribed to the

Re: [h2] H2 server and SecurityManager

try taking a thread dump to see where it is stuck​ -- 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+unsubscr...@googlegroups.com. To post to this

Re: [h2] Using user defined functions with joins

On 2017/12/31 5:05 AM, singularsyn...@gmail.com wrote: The H2 docs say: "A function that returns a result set can be used like a table." Have a look at the FunctionMultiReturn test class where we test this case, perhaps you are not populating the result set correctly. -- You received

Re: [h2] Re: USE INDEX confusion with joins, v1.4.195

awesome thanks (the mailing list is better, easier to find a license statement later on when you contribute again :-)​ -- 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

Re: [h2] Re: USE INDEX confusion with joins, v1.4.195

looks good thanks! can I get a license statement (unless you've done this in past?) as explained here: http://h2database.com/html/build.html#providing_patches ​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and

Re: [h2] Re: USE INDEX confusion with joins, v1.4.195

that sounds like an improvement, would you like to submit a PR? Perhaps with a test-case? the TestOptimisations class has a bunch of tests for this kind of thing. ​ -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group

Re: [h2] Re: Error 50200-192 if delete from table after upgrading from 1.3.176 to 1.4.192

Short of debugging it itself, your best bet is to do dump before the upgrade, and a restore to a fresh db after. -- 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

Re: [h2] Often TCP server is not running

try using more aggressive trace options: http://h2database.com/html/features.html#trace_options -- 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

Re: [h2] Can I access H2's MVStore API in a plugin serializer?

On 2017/12/21 11:42 AM, Matthew Phillips wrote: The serializer would need therefore to potentially access the H2 MVStore while reading an object, calling back 'up' the stack as it were to read parent object(s). This strikes me as an unexpected thing to do, and I wonder if H2 would have a

Re: [h2] Android support has been dropped since 1.4.195

you're welcome to submit a fix - it's only used in one place​ -- 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+unsubscr...@googlegroups.com. To post

Re: [h2] BUG: FILE_READ('TestFILe.txt', 'UTF8') doesn't release file lock.

ah, ok. I have pushed an attempted fix to master, please try it out if you are able to. -- 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

Re: [h2] LINK_SCHEMA reports 90080 error when table/view with the same name exists in different schemes.

thank you very much for that, pushed change -- 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+unsubscr...@googlegroups.com. To post to this group, send

Re: [h2] BUG: FILE_READ('TestFILe.txt', 'UTF8') doesn't release file lock.

are you trying to read a file that is currently being written to? Because that is the only way I can currently see that we would fail to close the file, which is definitely a bug, but I'd like to be sure I'm fixing the bug that you are seeing. -- You received this message because you are

Re: [h2] H2 1.4.196 java-level deadlock

Do you possibly have a test case for this? I can fix it (I think), but I'd really like to add a test case.​ Note to self: the bug is probably in Command.executeUpdate where for multithreaded=false, it needs to lock the session and then the database object -- You received this message because

Re: [h2] Error reading H2 temp files for the ALIAS run by my multiple users , for version 1.3

you can control the temp directory using the -Djava.io.tmpdir= command line option -- 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

Re: [h2] Add NATURAL (LEFT | RIGHT ) JOIN support.

please submit a pull request on github​ -- 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+unsubscr...@googlegroups.com. To post to this group, send

Re: [h2] Re: DB growing just by reading LOBs

By the time getResultSet() returns a ResultSet object, a transaction is normally completed, and all rows are buffered on the client side. So there is no copy-on-write type logic necessary for normal rows. However Blobs are different. For LOBs we just send the client a kind of pointer in the

Re: [h2] Add NATURAL (LEFT | RIGHT ) JOIN support.

I think mean NATURAL LEFT OUTER and NATURAL RIGHT OUTER ? Because the default (AFAIK) is an INNER join. In which case those are the Parser changes, yes, but you'd need to set up the join condition properly as well. ​ -- You received this message because you are subscribed to the Google Groups

Re: [h2] Re: DB growing just by reading LOBs

On 2017/12/07 1:37 PM, Silvio wrote: Does that mean that you allow reading the resultset AFTER the transaction completes? I was assuming the transaction Of course. Under most conditions (ie. with setAutoCommit==true), the transaction is complete and closed before the ResultSet is even

Re: [h2] Re: DB growing just by reading LOBs

On 2017/12/07 12:20 PM, Silvio wrote: When all open LOBs are transferred to the client side of the connection when the transaction is closed they can still be read by the application afterwards. The only noticeable difference in behavior would be a potential performance hit and memory

<    1   2   3   4   5   6   7   8   9   10   >